QlikView Your BusinessBook Cover

An expert guide to Business Discovery with QlikView and Qlik Sense

QlikView Your Business shows you how to build dynamic, best-of-breed data visualizations using the QlikView toolset. This full-color, step-by-step guide walks you through the basics of using the tools, then dives deep to provide expert advice on complex implementation techniques and solutions. Coverage includes both QlikView and Qlik Sense, with a focus on the process of developing analytic applications. You will learn how to analyze your data, determine the appropriate solution, define the data model, and develop the load script and user interface for a complete analytic solution implemented in QlikView, Qlik Sense, or both. The companion website provides sample data sets, scripts, and visualizations that support chapter examples.

Data visualization helps unlock the stories within the data, making it easier to see and make sense of complex data points. Many visualization tools are complex and require advanced training, but QlikView’s toolset was specifically designed for speed and ease of use. This book gets you up and running quickly, using QlikView and Qlik Sense to deliver timely and relevant results.

  • Develop solutions to analyze sales, profitability, and inventory
  • Understand the business scenarios relevant to each solution
  • Understand best practices for data modeling
  • Learn advanced techniques in data aggregation and chart development

This book goes beyond the basics to illustrate little-known features and techniques for getting the most out of the toolset, supporting the needs of the business analysts who use it, as well as the developers who support it.

Pre-order the book on Amazon with a 33% Discount!

Detailed Review of the Book Contents

After the introductory Part I, the next part of the book (Part II) begins from covering the basics of QlikView analytics, using the most popular Sales Analysis application as an example. In this part, you will learn:

  • Commonly used metrics and KPIs for Sales Analysis
  • Simple Data Modeling techniques:
  • understanding the difference between the transaction-driven data models (Entity-Relation models) and analytical data models (Star Schema and Snowflake)
  • Simple Scripting techniques that enable transforming and arranging your data in a Star Schema:
  • Loading data from databases and text files
  • Simple techniques for avoiding synthetic keys and circular references.
  • Joining tables
  • Calculating derived fields and conditional flags.Sales Dashboard
  • Simple Visualization techniques that can be used in Sales Analysis:
  • Working with Sheets and Sheet objects
  • List Box and Multi Box
  • Text Object and Line/Arrow Object
  • Search Object and Current Selections Box
  • Simple Charts – Bar, Line, Pie, Straight Table and Pivot Table
  • Dimension and Expression Groups, Fast Type Change
  • Three forms of Conditional aggregation – using the IF() function, or multiplying by a conditional flag, or using basic Set Analysis
  • Introduction to simple Set Analysis
  • Building executive dashboards

At the end of Part II, the readers will have developed a full-fledged Sales Analysis dashboard with a number of simple analytical and reporting sheets. Then, Part III introduces more advanced techniques using Profitability Analysis as an example:

  • Common business challenges and commonly used metrics for Profitability Analysis.
  • Intermediate Data Modeling techniques:
  • Introducing two main techniques for managing multiple fact tables:
  • Link Table data model
  • Concatenated Fact data model
  • Working with Slowly Changing Dimensions
  • Intermediate Scripting techniques:
  • Working with QVD files
  • Building a multi-tier data architecture
  • Using variables in a load script
  • Using script control statements – IF statements, FOR loops, declaring and calling subroutines
  • Building and using a library of common routines
  • Troubleshooting and debugging QlikView load scripts
  • Loading and transforming complex spreadsheets
  • Building a Link Table data model949559 c10 f016 Waterfall Chart
  • Intermediate Visualization techniques for Profitability Analysis:
  • Calculating various levels of profitability
  • Using variables in the UI:
  • Using variables in for what-if analysis
  • Using variables to store and retrieve expressions
  • Using variables to store and retrieve color definitions
  • Visualizing components of costs and profits:949559 c10 f034 Changes in Sales and Discounts
  • Waterfall charts,
  • Normalized and non-normalized Mekko charts,
  • Using Synthetic dimensions
  • Visualizing Correlations between Sales and Profits
  • Combo charts
  • Scatter charts
  • Visualizing change in a scatter chart
  • How to develop a Whale Tail 949559 c10 f035 The Whale Tail Chartchart.
  • Developing Heatmaps
  • Deep dive into Advanced Set Analysis:
  • Using Dollar-sign expansions in Set Modifiers
  • Set Operators
  • Using Dates in Set Analysis
  • Understanding Simple and Advanced Search in Set Analysis
  • Using Containers to arrange multiple charts on a sheet

At the end of Part III, the readers will have developed a fully functional profitability analysis dashboard with multiple fact tables loaded into a Link Table model and with advanced visualizations including a what-if analysis, waterfall, scatter, mekko, and many other advanced charts. Then, Part IV takes the level of sophistication up another notch, introducing the advanced techniques that are commonly used for Inventory Analysis:

  • Understanding commonly used metrics and KPIs for Inventory Analysis:
  • Days on Hand and Annual turn
  • Inventory Aging
  • Understanding the impact of Lead Time and Minimum Order Quantity
  • Advanced Data Modeling techniques used in Inventory Analysis:
  • Calculating running balances
  • Working with Concatenated Fact data models
  • Restoring missing associations
  • Using generic link tables and generic keys
  • Considerations about using Link Tables versus Concatenated Facts
  • Advanced Date handling with the As Of Date table
  • Advanced Scripting techniques:949559 c15 f020 Trellis Chart by Size and Color
  • Generating the Aging data using Peek() and Previous()
  • Using the IntervalMatch load
  • Building the Concatenated Fact table
  • Propagating missing attributes to all slices of the concatenated fact.
  • Restoring missing associations using generic link tables.
  • A Set Analysis alternative to using generic link tables.
  • Building the As Of Date table
  • Generating Chart Expressions in the script:
  • Assigning expressions to variables manually
  • Storing, loading, and generating expressions using external text files.949559 c15 f043 Complete Inventory Analysis Dashboard
  • Advanced Visualization techniques:
  •  Using Advanced Aggregation function AGGR() for inventory calculations
  • Developing Histograms
  • Visualizing parts of totals and subtotals using grid charts, waterfall charts and trellis charts.
  • Bucket Analysis
  • Advanced uses of AGGR() and Set Analysis
  • Comparative analysis using Alternate States
  • Advanced features of Straight Tables – gauges, mini charts, images, and URLs.
  • Advanced navigation features with Buttons, Actions, and Triggers.

Lastly, Part V offers a detailed introduction to Qlik Sense. While it doesn’t get to the same level of advanced features as the previous parts, the step-by-step tutorial in this part allows the reader to learn how to develop a complete Qlik Sense dashboard:

  • Loading data in Qlik Sense:
  • Using Quick Data Load and using Data Load Editor
  • Introducing Data Connections949559 c20 f035 The Area Map, before and after zooming in
  • Loading Data From QlikView into Qlik Sense
  • Introducing derived fields
  • Using developer tools: Data Model Viewer and the Debug Panel.
  • Developing Qlik Sense visualizations:
  • Building standard charts – bar, line, pie, and more.
  • Introducing the Library of Master Items
  • Gauge, Text and image chart and the KPI object.949559 c20 f039 Two Point Maps
  • Building the Sales Analysis dashboard in Qlik Sense
  • Working with selections in Qlik Sense
  • Storytelling
  • Geo Mapping
  • Integrating Extensions in Qlik Sense

With more than 700 pages of basic-to-advanced technical content, QlikView Your Business is your essential guide to better data analysis with QlikView and Qlik Sense.

Leave a Reply

Your email address will not be published. Required fields are marked *