Hands-On Dashboard Development with QlikView

Hands-On Dashboard Development with QlikView

by Abhishek Agarwal
Released March 2019
Publisher(s): Packt Publishing
ISBN: 9781838646110

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

A step-by-step approach to building stunning dashboards with QlikView

Key Features

  • Perform effective storytelling through interactive dashboards built with QlikView
  • Create different types of visualizations from a variety of data sources
  • Includes tips, tricks, and best practices to perform effective Business Intelligence using QlikView

Book Description

QlikView is one of the market leaders when it comes to building effective Business Intelligence solutions. This book will show how you can leverage its power to build your own dashboards to tell your own data story.

The book starts with showing you how to connect your data to QlikView and create your own QlikView application. You will learn how to add data from multiple sources, create a data model by joining data, and then review it on the front end. You will work with QlikView components such as charts, list boxes, input boxes, and text objects to create stunning visualizations that help give actionable business insights. You will also learn how to perform analysis on your data in QlikView and master the various types of security measures to be taken in QlikView.

By the end of this book, you will have all the essential knowledge required for insightful data storytelling and creating useful BI dashboards using QlikView.

What you will learn

  • Learn to use the latest and newest features of QlikView
  • Connect QlikView to various data sources, such as databases and websites
  • Create a fully featured data model without circular references
  • Display your data in maps, charts, and text across multiple sheets
  • Apply set analysis to your data in QlikView expressions
  • Secure your data based on the various audience types

Who this book is for

This book is best suited for BI professionals, data analysts and budding QlikView developers who wish to build effective dashboards using QlikView. Some basic understanding of the data visualization concepts and Business Intelligence is required.

Table of contents

  1. Title Page
  2. Copyright and Credits
    1. Hands-On Dashboard Development with QlikView
  3. About Packt
    1. Why subscribe?
    2. Packt.com
  4. Contributor
    1. About the author
    2. Packt is searching for authors like you
  5. Preface
    1. Who this book is for
    2. What this book covers
    3. To get the most out of this book
      1. Download the example code files
      2. Download the color images
      3. Conventions used
    4. Get in touch
      1. Reviews
  6. Getting Started with QlikView
    1. Prerequisites
    2. Installing QlikView
      1. Exploring QlikView
    3. Creating a document
      1. Saving the document
    4. Important terminologies in QlikView
      1. QlikView selections
      2. QlikView architecture
      3. Exploring data in QlikView
    5. Summary
  7. Getting Data in QlikView and Creating Your First App
    1. Setting up the structure
    2. Creating an app
    3. Importing data from Excel
      1. Reviewing the data
    4. Understanding facts and dimensions
      1. Dimensions and measures
      2. Best practices for dimensions and facts
    5. Understanding list boxes
      1. Selections in list boxes
    6. Creating new tabs
    7. Adding filters to the app
    8. Summary
  8. Creating Data Models
    1. Creating a star schema
      1. Implementing the star schema
    2. Getting data from databases
      1. Getting data from QVD files
    3. Analyzing the resulting model
      1. Information density
      2. Subset ratio
      3. Tags
    4. Creating a QVD file
    5. Summary
  9. Components in QlikView
    1. List boxes
      1. Layout of columns
      2. Ordering of data
      3. Showing frequency of values
    2. QlikView charts
      1. Changing the chart type
    3. Multi boxes
      1. Properties of multi box
    4. Bookmarks
      1. Properties of bookmarks
    5. Input boxes
    6. Text objects
    7. Summary
  10. Building a Dashboard
    1. Adding KPIs
    2. Adding charts
      1. Block chart
      2. Scatter chart
      3. Pivot table chart
    3. Adding dynamic chart displays
      1. Auto-minimize
    4. Different types of expressions
      1. Group expressions
      2. Drill-down expressions
    5. Containers
    6. Buttons
    7. Summary
  11. Set Analysis
    1. The basics of set analysis
      1. What set analysis means
      2. Set analysis syntax structure
    2. Assignment operators
      1. Assignment operators in action
    3. Set operators
      1. Set operators in action
    4. Element functions
      1. Element functions in action
    5. Summary
  12. Adding Security
    1. Security scripts
      1. Best practices for enabling a security script
    2. Understanding various types of securities
    3. Configuring security
    4. Advanced security
    5. Troubleshooting issues in QlikView
    6. Summary
  13. Other Books You May Enjoy
    1. Leave a review - let other readers know what you think

Product information

  • Title: Hands-On Dashboard Development with QlikView
  • Author(s): Abhishek Agarwal
  • Release date: March 2019
  • Publisher(s): Packt Publishing
  • ISBN: 9781838646110