QlikView essentials want to solve your business intelligence headaches? Learn how QlikView can help, and discover a powerful yet accessible BI solution that lets you harness your data
Want to solve your Business Intelligence headaches? Learn how QlikView can help, and discover a powerful yet accessible BI solution that lets you harness your data About This Book Design interactive dashboards using QlikView to share sharp BI insights Discover how to create effective data models to...
Otros Autores: | |
---|---|
Formato: | Libro electrónico |
Idioma: | Inglés |
Publicado: |
Birmingham :
Packt Publishing
2016.
|
Edición: | 1st edition |
Colección: | Professional expertise distilled.
|
Materias: | |
Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009630197606719 |
Tabla de Contenidos:
- Cover; Copyright; Credits; About the Author; About the Reviewer; www.PacktPub.com; Table of Contents; Preface; Chapter 1: QlikView Essentials; QlikView components; QlikView installation; Getting started; The development life cycle of QlikView implementations; About Adventure Works; User requirements; Analyze data model/data sources; Star schema and snow flake schema; QlikView development setup; Summary; Chapter 2: Extract, Transform, and Load; Configuring settings; Scripting essentials; Connecting to the database; Loading the OrderHeader Table; Loading the OrderDetail table
- Creating fields in the Order tableLoading the Customer table; Loading the Product table; Resolving the synthetic keys; How to resolve synthetic keys; Removing synthetic keys between the Product and Order Detail tables; Loading the ProductSubCategory table; Loading data from text and Excel files; Loading the ProductCategory table; Loading Employee.xlsx; Circular reference and loosely coupled tables; Circular reference; Loosely coupled tables; Resolving circular reference; Loading the SalesTerritory and Shipment tables; Loading an Inline table; The Qualify statement; Loading the Shippers table
- A word about resident load and ExistsFinding the sales person; Using If statements in the script; Including files using the Include statement; More on Table Viewer; Time to review your data model so far; Summary; Chapter 3: Optimizing Your Data Model; Mapping table essentials; Mapping load - Territory table; Mapping load - Product Category and ProductSubcategory tables; Mapping load - ProductSubcategory table; Mapping load - CountryRegion_Inline; Concatenation; Concatenation example; Automatic Concatenation; NoConcatenate; Forced concatenation; Joins; Join Orders and Order Detail
- Left join SalesPersonAggregating data; Concatenating the new Employees table; Reviewing the final data model; Summary; Chapter 4: Data Modeling Challenges; Crosstable essentials; Loading EmployeeSalesTarget.xlsx; Link table; Link table essentials; Creating a link table; Variables in QlikView; Using variables to set the file path; Master calendar; The IntervalMatch function; QlikView Data Files (QVD); Creating QVD files for our data model; Optimized load - reading QVD; Reading QVD files; Best practices of data modeling; Summary; Chapter 5: Creating Dashboards; Dashboarding essentials
- Getting startedAssociative experience; Binary load; Exploring menu items; Sheet objects; Creating a multi-tab application; The dashboard sheet; Creating list boxes for other fields; Options to copy and paste objects; Placing a logo on the dashboard sheet; Creating a bar chart; Expression Overview; Creating a text object; Creating a scatter chart; The story of two tables; Creating a straight table; Enhancing your tables; Groups; Creating a drill-down group; Creating a cyclic group; Creating a pivot table; Dimension limits; Interactivity using text objects; Some more charts; Line charts
- Combo charts