Cargando…
Mastering QlikView : unleash the power of QlikView and Qlik Sense to make optimum use of data for Business Intelligence /
If you are a business application developer or a system analyst who has learned QlikView and Qlik Sense and now want to take your learning to a higher level, then this book is for you. It is assumed that you are aware of the fundamentals of QlikView and have working knowledge of development and in-m...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham, UK :
Packt Publishing,
[2014]
|
| Colección: | Professional expertise distilled.
|
| Temas: | |
| Acceso en línea: | Texto completo Texto completo |
Tabla de Contenidos:
- Cover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; 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 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 the Kimball 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.