LEADER 05355nam 2200661Ia 450 001 9910786440303321 005 20200520144314.0 010 $a1-283-96107-5 010 $a1-84968-607-6 035 $a(CKB)2670000000308675 035 $a(EBL)1085220 035 $a(OCoLC)825076954 035 $a(SSID)ssj0000813020 035 $a(PQKBManifestationID)12333476 035 $a(PQKBTitleCode)TC0000813020 035 $a(PQKBWorkID)10767914 035 $a(PQKB)10483064 035 $a(Au-PeEL)EBL1085220 035 $a(CaPaEBR)ebr10632721 035 $a(CaONFJC)MIL427357 035 $a(CaSebORM)9781849686068 035 $a(MiAaPQ)EBC1085220 035 $a(PPN)228032156 035 $a(EXLCZ)992670000000308675 100 $a20121222d2012 uy 0 101 0 $aeng 135 $aurunu||||| 181 $ctxt 182 $cc 183 $acr 200 10$aQlikView 11 for developers$b[electronic resource] $edevelop business intelligence applications with QlikView 11 /$fMiguel Garcia, Barry Harmsen 205 $a1st edition 210 $aBirminghan, UK $cPackt Pub.$d2012 215 $a1 online resource (534 p.) 225 1 $aProfessional expertise distilled 300 $aIncludes index. 311 $a1-84968-606-8 327 $aCover; 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! 327 $aThe 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 controls 327 $aNumber 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 step 327 $aRefining 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; Summary 327 $aChapter 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 Box 327 $aThe Current Selections Box 330 $aIt 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 QlikView 606 $aBusiness intelligence$vSoftware 606 $aApplication software 615 0$aBusiness intelligence 615 0$aApplication software. 676 $a005.758 700 $aGarci?a$b Miguel$01112118 701 $aHarmsen$b Barry$01544659 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910786440303321 996 $aQlikView 11 for developers$93799064 997 $aUNINA