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
• 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; 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.
• 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.