| Description |
1 online resource (787 pages) |
| Series |
Learning Path
|
|
Learning path.
|
| Bibliography |
Includes bibliographical references and index. |
| Contents |
Cover; Title Page; Copyright; About Packt; Contributors; Table of Contents; Preface; Chapter 1: Performance Tuning and Scalability; Reviewing basic performance tuning techniques; Removing unneeded data; Reducing the number of rows; Reducing the number of columns; Replacing text keys with numbers; Resolving synthetic keys; Reviewing the basics; Generating test data; Generating dimension values; Generating fact table rows; Understanding how QlikView stores its data; A great primer; Looking at things from a simple level; Exporting the memory statistics for a document. |
|
Strategies to reduce the data size and improve performanceOptimizing field values and keys; Optimizing data by removing keys using ApplyMap; Optimizing performance by removing keys by joining tables; Optimizing memory by removing low cardinality fields; Testing chart performance for different load options; Turning the cache off; Examining the chart calculation time for different scenarios; Optimizing performance by creating counter fields; Optimizing performance by combining fact tables?; Optimizing your numbers; Optimizing chart calculation times; The QlikView calculation engine. |
|
Creating flags for well-known conditionsSorting for well-known conditions; Using Direct Discovery; Direct Discovery restrictions; Direct Discovery syntax; Looking at an example Direct Query; Testing scalability with JMeter; Obtaining the scalability tools; Installing JMeter; Installing the scalability tools; About the scalability tools; Running an example execution; Summary; Chapter 2: QlikView Data Modeling; Reviewing basic data modeling; Associating data; Automatically associating tables; Understanding synthetic keys; Creating composite keys. |
|
Realizing that facts are calculated at the level of their tableJoining data; Understanding Join and Keep; Concatenating rows; Reviewing Concatenate; Mapping data with ApplyMap; Reviewing the basic functionality of ApplyMap; Mapping numbers; Dimensional data modeling; Differentiating between facts and dimensions; Understanding the grain; Understanding star schemas; Summing with facts; Discovering more about facts; Transaction fact tables; Periodic snapshot fact tables; Factless fact tables; Dealing with nulls in fact tables in QlikView; Designing dimension tables. |
|
Denormalizing dimensions and conformed dimensionsUnderstanding surrogate keys; Dealing with missing or late arriving dimension values; Defining Kimball's four-step dimensional design process; Selecting the business process; Declaring the grain; Identifying the dimensions; Identifying the facts; Learning some useful reusable dimension methods; Creating a calendar dimension; Unwrapping hierarchies; Creating parent associations with HierarchyBelongsTo; Creating dimensional facts; Handling slowly changing dimensions; Taking the most recently changed record using FirstSortedValue. |
| Note |
Using IntervalMatch with SCDs. |
| Summary |
QlikView is one of the most flexible and powerful business intelligence platforms around, and if you want to transform data into insights, it is one of the best options you have at hand. Use this Learning Path, to explore the many features of QlikView to realize the potential of your data and present it as impactful and engaging visualizations. |
| Local Note |
eBooks on EBSCOhost EBSCO eBook Subscription Academic Collection - North America |
| Subject |
Information visualization.
|
|
Business intelligence -- Computer programs.
|
|
Visual analytics.
|
|
REFERENCE -- Questions & Answers. |
|
COMPUTERS -- Data Visualization. |
|
Information visualization |
|
Visual analytics |
| Added Author |
Harmsen, Barry.
|
|
Redmond, Stephen.
|
|
Pover, Karl.
|
| Other Form: |
Print version: García, Miguel Ángel. QlikView: Advanced Data Visualization. Birmingham : Packt Publishing Ltd, ©2018 9781789955996 |
| ISBN |
1789954177 |
|
9781789954173 (electronic bk.) |
|
