QlikView 11 for developers develop business intelligence applications with QlikView 11
It 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 Qlik...
| Main Author: | |
|---|---|
| Other Authors: | |
| Format: | eBook |
| Language: | Inglés |
| Published: |
Birminghan, UK :
Packt Pub
2012.
|
| Edition: | 1st edition |
| Series: | Professional expertise distilled
|
| Subjects: | |
| See on Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009628859306719 |
Table of Contents:
- 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 controls
- Number 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
- Refining 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
- Chapter 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
- The Current Selections Box
