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

Stephen Redmond

1 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
Mapt Subscription
FREE
$29.99/m after trial
eBook
$25.20
RRP $35.99
Print + eBook
$59.99
RRP $59.99
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$0.00
$25.20
$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.
 
  • 5,000+ eBooks & Videos
  • 50+ 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 1 reviews

Read More Reviews