QlikView : Advanced Data Visualization : Discover Deeper Insights with Qlikview by Building Your Own Rich Analytical Applications from Scratch /: Advanced Data Visualization : Discover Deeper Insights with Qlikview by Building Your Own Rich Analytical Applications from Scratch. (2018)
- Record Type:
- Book
- Title:
- QlikView : Advanced Data Visualization : Discover Deeper Insights with Qlikview by Building Your Own Rich Analytical Applications from Scratch /: Advanced Data Visualization : Discover Deeper Insights with Qlikview by Building Your Own Rich Analytical Applications from Scratch. (2018)
- Main Title:
- QlikView : Advanced Data Visualization : Discover Deeper Insights with Qlikview by Building Your Own Rich Analytical Applications from Scratch
- Further Information:
- Note: Miguel Ángel García, Barry Harmsen, Stephen Redmond, Karl Pover.
- Other Names:
- García, Miguel Ángel
Harmsen, Barry
Redmond, Stephen
Pover, Karl - 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;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. … (more)
- Publisher Details:
- Birmingham : Packt Publishing Ltd
- Publication Date:
- 2018
- Extent:
- 1 online resource (787 pages)
- Subjects:
- 001.4/226
Information visualization
Business intelligence -- Computer programs
Visual analytics
REFERENCE -- Questions & Answers
COMPUTERS -- Data Visualization
Information visualization
Visual analytics
Electronic books - Languages:
- English
- ISBNs:
- 1789954177
9781789954173 - Notes:
- Note: Includes bibliographical references and index.
Note: Print version record. - Access Rights:
- Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
- Access Usage:
- Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.
- View Content:
- Available online (eLD content is only available in our Reading Rooms) ↗
- Physical Locations:
- British Library HMNTS - ELD.DS.378918
- Ingest File:
- 02_361.xml