Mastering QlikView

Let QlikView help you uncover game-changing BI data insights with this advanced QlikView guide, designed for a world that demands better Business Intelligence

Mastering QlikView

This ebook is included in a Mapt subscription
Stephen Redmond

4 customer reviews
Let QlikView help you uncover game-changing BI data insights with this advanced QlikView guide, designed for a world that demands better Business Intelligence
$0.00
$35.99
$59.99
$29.99p/m after trial
RRP $35.99
RRP $59.99
Subscription
eBook
Print + eBook
Start 30 Day Trial
Subscribe and access every Packt eBook & Video.
 
  • 4,000+ eBooks & Videos
  • 40+ New titles a month
  • 1 Free eBook/Video to keep every month
Start Free Trial
 
Preview in Mapt

Book Details

ISBN 139781782173298
Paperback422 pages

Book Description

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 state-of-the-art visualizations, dashboards, analysis, and reports.

The book starts by reviewing the best performance-tuning 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 best-practice 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.

Table of Contents

Chapter 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
Chapter 2: QlikView Data Modeling
Reviewing basic data modeling
Dimensional data modeling
Handling slowly changing dimensions
Dealing with multiple fact tables in one model
Drilling across with document chaining
Summary
Chapter 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
Chapter 4: Data Governance
Reviewing basic concepts of data governance
Establishing descriptive metadata
Extracting metadata
Deploying the QlikView Governance Dashboard
Summary
Chapter 5: Advanced Expressions
Reviewing basic concepts
Understanding Dollar-sign Expansion
Using advanced Set Analysis
Calculating vertically
Summary
Chapter 6: Advanced Scripting
Reviewing the basic concepts
Counting records
Loading data quickly
Applying variables and the Dollar-sign Expansion in the script
Using control structures
Examining advanced Table File Wizard options
Looking at data from different directions
Reusing code
Summary
Chapter 7: Visualizing Data
Reviewing the history of data visualization
Understanding the audience
Designing effective visualizations
Summary

What You Will Learn

  • Learn performance-tuning techniques to tackle the challenges associated with scalability
  • Use and apply the most effective data models to find answers to your biggest business questions
  • 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
  • Write great scripts to load data in different ways
  • Visualize data using a set of analytical and advanced charting techniques

Authors

Table of Contents

Chapter 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
Chapter 2: QlikView Data Modeling
Reviewing basic data modeling
Dimensional data modeling
Handling slowly changing dimensions
Dealing with multiple fact tables in one model
Drilling across with document chaining
Summary
Chapter 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
Chapter 4: Data Governance
Reviewing basic concepts of data governance
Establishing descriptive metadata
Extracting metadata
Deploying the QlikView Governance Dashboard
Summary
Chapter 5: Advanced Expressions
Reviewing basic concepts
Understanding Dollar-sign Expansion
Using advanced Set Analysis
Calculating vertically
Summary
Chapter 6: Advanced Scripting
Reviewing the basic concepts
Counting records
Loading data quickly
Applying variables and the Dollar-sign Expansion in the script
Using control structures
Examining advanced Table File Wizard options
Looking at data from different directions
Reusing code
Summary
Chapter 7: Visualizing Data
Reviewing the history of data visualization
Understanding the audience
Designing effective visualizations
Summary

Book Details

ISBN 139781782173298
Paperback422 pages
Read More
From 4 reviews

Read More Reviews