Description |
1 online resource (1 volume) : illustrations. |
|
text file |
Series |
Professional expertise distilled
|
|
Professional expertise distilled.
|
Note |
Includes index. |
Contents |
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 |
Summary |
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-memory analytics. |
Local Note |
eBooks on EBSCOhost EBSCO eBook Subscription Academic Collection - North America |
Subject |
Management information systems.
|
|
Management information systems. |
|
Business intelligence -- Computer programs.
|
|
Business intelligence. |
|
Computer programs. |
Genre/Form |
Electronic books.
|
|
Electronic books.
|
Added Title |
Unleash the power of QlikView and Qlik Sense to make optimum use of data for Business Intelligence |
Other Form: |
Print version: Redmond, Stephen Mastering QlikView Birmingham : Packt Publishing,c2014 9781782173298 |
ISBN |
9781782173304 |
|
1782173307 |
|
9781782173298 |
|
1782173293 |
|
9781782173298 |
|