Mastering QlikView

Unleash the power of QlikView and Qlik Sense to make optimum use of data for Business Intelligence

About This Book

• Learn the best ways to load data to optimize the QlikView experience
• Display data in a way that is easy to understand for most number of users
• Discover advanced expressions and scripting techniques with lots of code and screenshots

Who This Book Is For

If you are a business application developer or a system analyst who has learned QlikView and Qlik Sense and now want to take your learning to a higher level, then this book is for you.

It is assumed that you are aware of the fundamentals of QlikView and have working knowledge of development and in-memory analytics.

What You Will Learn

• Tune your Qlik applications and review basic performance-tuning 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

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 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
Chapter 2: QlikView Data Modeling
Chapter 3: Best Practices for Loading Data
Chapter 4: Data Governance
Chapter 5: Advanced Expressions
Chapter 6: Advanced Scripting
Chapter 7: Visualizing Data