05473nam 2200709Ia 450 991081670350332120200520144314.01-283-96107-51-84968-607-6(CKB)2670000000308675(EBL)1085220(OCoLC)825076954(SSID)ssj0000813020(PQKBManifestationID)12333476(PQKBTitleCode)TC0000813020(PQKBWorkID)10767914(PQKB)10483064(Au-PeEL)EBL1085220(CaPaEBR)ebr10632721(CaONFJC)MIL427357(PPN)228032156(OCoLC)ocn825076954 (FR-PaCSA)88850876(CaSebORM)9781849686068(MiAaPQ)EBC1085220(DE-B1597)695581(DE-B1597)9781849686075(EXLCZ)99267000000030867520121222d2012 uy 0engurunu|||||txtccrQlikView 11 for developers develop business intelligence applications with QlikView 11 /Miguel Garcia, Barry Harmsen1st editionBirminghan, UK Packt Pub.20121 online resource (534 p.)Professional expertise distilledIncludes index.1-84968-606-8 Cover; Copyright; Credits; About the Authors; Acknowledgements; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Meet QlikView; What is QlikView?; How does QlikView differ from traditional BI?; Associative user experience; Technology; Adoption path; Exploring data with QlikView; Getting QlikView; Navigating the document; Slicing and dicing your data; List-boxes; Selections in charts; Search; Bookmarking selections; Undoing selections; Changing the view; Cyclic Groups; Drill down Groups; Containers; But wait, there's more!The technology and components behind QlikView The way the data flows; When QlikView use expands; Create content; Reload, publish, and distribute content; Consume content; Meet HighCloud Airlines; Summary; Chapter 2: Seeing is Believing; What is a SiB?; Preparing the workspace; Setting up the folder structure; Creating the QlikView document; Creating the app; The requirements; Constructing the data model; What is a data model?; Loading the fact table; Playing with listboxes; Associating additional tables; Creating the dashboard tab; Creating and positioning the filters and user controlsNumber of flights over time One chart and multiple analyses with cyclic expressions; Adding a time drill-down group; Top 10 routes; Summary; Chapter 3: Data Sources; Using ODBC and OLE DB drivers; Installing the drivers; Accessing custom data sources; Third-party custom connectors; Reading table files; Extracting data-two hands-on examples; Extracting data from MS Access; Configuring the driver; Creating the OLE DB connection string; Querying the database; Reloading the script; The resulting data model; Loading a table file; Specifying the file attributes; The transformation stepRefining the input table The resulting script; QVD and QVX files; QVD files; QVX files; Loading an Inline table; Summary; Chapter 4: Data Modeling; Dimensional data modeling; Back in the day; Relational databases and ER modeling; Dimensional modeling; The star schema; The snowflake schema; Creating the dimensional model; Dimensional models in QlikView; The associative data model; Guidelines for table associations; How associations are created; Avoiding data model conflicts; The Table Viewer window; Table information; Field information; Table preview; Table viewer menu; SummaryChapter 5: Styling Up Design requirements; The Document Properties window; The Sheet Properties dialog; Setting the object properties; Caption colors and style; Changing the caption colors; Setting the caption font; Setting the content font; Setting the global font; Propagating the object appearance; Setting the default Sheet Object Style; Hiding captions; Working with list boxes; Adding list boxes; The List Box Properties dialog; The General tab; The Expressions tab; The Sort tab; The Presentation tab; The Number tab; The Font tab; The Layout tab; The Caption tab; The Multi BoxThe Current Selections BoxIt will be a step-by-step tutorial that will discuss best practices. The book is structured in such a way that it can be read both from start to end or can be dipped into. If you are a developer who is looking to learn a fast and easy way to learn to develop your business intelligence apps with QlikView, then this book is for you. If you are a power-user in a QlikView environment, then you will find quicker ways of working with QlikView. You should know the basics of business intelligence before you pick up this book. This book covers QlikView Desktop Personal Edition. Deployments to QlikViewBusiness intelligenceSoftwareApplication softwareBusiness intelligenceApplication software.005.758García Miguel1112118Harmsen Barry1631082MiAaPQMiAaPQMiAaPQBOOK9910816703503321QlikView 11 for developers3969704UNINA