Book description
Unleash the power of QlikView and Qlik Sense to make optimum use of data for Business Intelligence
In Detail
QlikView and its new sister product, Qlik Sense, are the leading tools for BI and data discovery. They both feature the ability to consolidate relevant data from multiple sources into a single application, an associative data model to allow you to explore the data the way your brain works, and stateoftheart visualizations, dashboards, analysis, and reports.
The book starts by reviewing the best performancetuning techniques and then advances to help you discover strategies to improve performance and test scalability with JMeter. You will also learn dimensional data modeling and creating bestpractice ETL techniques using the QlikView script and QlikView's graphical ETL tool, Expressor. Following this, you will deploy QlikView Governance Dashboard to import multiple data sources and view all the information in a single location. Finally, you will learn why virtualization is important and what are the best practices for virtualization in QlikView.
What You Will Learn
 Tune your Qlik applications and review basic performancetuning techniques for scalability
 Model your data correctly using industry best approaches
 Get to know the best practices for data loading and understand QVDs to implement an ETL approach
 Discover a range of techniques to manage metadata including the QlikView Governance Dashboard
 Use advanced expression techniques to get the right answers
 Write great scripts to load data in different ways
 Visualize data using a set of analytical and advanced charting techniques
Publisher resources
Table of contents

Mastering QlikView
 Table of Contents
 Mastering QlikView
 Credits
 About the Author
 About the Reviewers
 www.PacktPub.com
 Preface

1. Performance Tuning and Scalability
 Reviewing basic performance tuning techniques
 Generating test data
 Understanding how QlikView stores its data
 Strategies to reduce the data size and improve performance
 Testing chart performance for different load options
 Optimizing chart calculation times
 The QlikView calculation engine
 Using Direct Discovery
 Testing scalability with JMeter
 Running an example execution
 Summary

2. QlikView Data Modeling
 Reviewing basic data modeling

Dimensional data modeling
 Differentiating between facts and dimensions
 Understanding the grain
 Understanding star schemas
 Summing with facts
 Discovering more about facts
 Dealing with nulls in fact tables in QlikView
 Designing dimension tables
 Defining Kimball's fourstep dimensional design process
 Learning some useful reusable dimension methods
 Creating dimensional facts
 Handling slowly changing dimensions
 Dealing with multiple fact tables in one model
 Drilling across with document chaining
 Summary

3. Best Practices for Loading Data
 Reviewing data loading concepts
 Understanding why you should use an ETL approach
 Using an ETL approach to create QVD data layers
 Mastering loading techniques
 Using QlikView Expressor for ETL
 Summary

4. Data Governance
 Reviewing basic concepts of data governance
 Establishing descriptive metadata
 Extracting metadata
 Deploying the QlikView Governance Dashboard
 Summary

5. Advanced Expressions
 Reviewing basic concepts
 Understanding Dollarsign Expansion
 Using advanced Set Analysis
 Calculating vertically
 Summary

6. Advanced Scripting
 Reviewing the basic concepts
 Counting records
 Loading data quickly
 Applying variables and the Dollarsign Expansion in the script
 Using control structures
 Examining advanced Table File Wizard options
 Looking at data from different directions
 Reusing code
 Summary

7. Visualizing Data
 Reviewing the history of data visualization
 Understanding the audience
 Designing effective visualizations
 Summary
 Index
Product information
 Title: Mastering QlikView
 Author(s):
 Release date: November 2014
 Publisher(s): Packt Publishing
 ISBN: 9781782173298
You might also like
book
The GuruBook
The GuruBook is an inspiring collection of 45 articles and interviews with wellknown thought leaders and …
book
Python Data Cleaning Cookbook
Discover how to describe your data in detail, identify data issues, and find out how to …
book
Statistical Rethinking, 2nd Edition
Statistical Rethinking: A Bayesian Course with Examples in R and Stan builds your knowledge of and …
book
Architecting DataIntensive Applications
Architect and design dataintensive applications and, in the process, learn how to collect, process, store, govern, …