Mastering QlikView

  • 4h 38m
  • Stephen Redmond
  • Packt Publishing
  • 2014

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.

About the Author

Stephen Redmond is the CTO and Qlik Luminary at CapricornVentis (capventis.com)—a QlikView Elite Partner. He is the author of several books, including QlikView for Developers Cookbook and QlikView Server and Publisher, both published by Packt Publishing. He is also the author of the popular DevLogixseries for SalesLogix developers. In 2006, after many years of working with CRM systems, reporting and analysis solutions, and data integration, Stephen started working with QlikView. Since then, CapricornVentis has become QlikView's top partner in the UK and Ireland territories, and with Stephen as the head of the team, they have implemented QlikView in a wide variety of enterprise and large-business customers across a wide range of sectors, from public sector to financial services to large retailers. In 2014, Stephen was awarded the Luminary status by Qlik in recognition of his product advocacy. He regularly contributes to online forums, including the Qlik Community. His QlikView blog is at qliktips.com, and you can follow him on Twitter at @stephencredmond where he tweets about QlikView, BI, data visualization, technology in general, and occasionally, on marathon running.

In this Book

  • Performance Tuning and Scalability
  • QlikView Data Modeling
  • Best Practices for Loading Data
  • Data Governance
  • Advanced Expressions
  • Advanced Scripting
  • Visualizing Data