Book Image

Mastering QlikView Data Visualization

By : Karl Pover
Book Image

Mastering QlikView Data Visualization

By: Karl Pover

Overview of this book

Just because you know how to swing a hammer doesn't mean you know how to build a house. Now that you've learned how to use QlikView, it's time to learn how to develop meaningful QlikView applications that deliver what your business users need. You will explore the requirements and the data from several business departments in order to deliver the most amazing analysis and data visualizations. In doing so, you will practice using advanced QlikView functions, chart object property options, and extensions to solve real-world challenges.

Related Content you might be interested in

Current Title:

Small book image
Mastering QlikView Data Visualization
Karl Pover
Apr, 2016 | 294 pages
No titles found
Table of Contents (18 chapters)
Mastering QlikView Data Visualization
Mastering QlikView Data Visualization
Credits
Credits
About the Author
About the Author
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
Data Visualization Strategy
Data Visualization Strategy
Data exploration, visualization, and discovery
Data teams and roles
Agile development
QlikView Deployment Framework
Summary
2
Sales Perspective
Sales Perspective
Sales perspective data model
Customer stratification.
Customer churn
QlikView extensions and the cycle plot
Governance – design template
Summary
3
Financial Perspective
Financial Perspective
Financial perspective data model
AsOfCalendar
Income statement
Balance sheet
Cash flow statement
Summary
4
Marketing Perspective
Marketing Perspective
Marketing data model
Customer profiling
Summary
5
Working Capital Perspective
Working Capital Perspective
Working capital data model
Rotation and average days
Working capital breakdown
Summary
6
Operations Perspective
Operations Perspective
Operations data model
On-Time and In-Full
Planning in QlikView with KliqPlan
Summary
7
Human Resources
Human Resources
Human resources data model
Personnel productivity
Personnel productivity breakdown
Personal behavior analysis
Summary
8
Fact Sheets
Fact Sheets
Customer fact sheet consolidated data model
Customer Fact sheet Agile design
Customer Fact sheet advanced components
Customizing the QlikView User Experience
Summary
9
Balanced Scorecard
Balanced Scorecard
The Balanced Scorecard method
The Balanced Scorecard consolidated data model
The Balanced Scorecard information dashboard design
Creating the filter pane bubble
Measuring success with XmR charts
Summary
10
Troubleshooting Analysis
Troubleshooting Analysis
Troubleshooting preparation and resources
Reporting issues
Common QlikView application issues
Summary
11
Mastering Qlik Sense Data Visualization
Mastering Qlik Sense Data Visualization
Qlik Sense and QlikView developers
Visualization extension examples for cross-selling
Plan to master Qlik Sense data visualization
Summary
Index
Index

Sales perspective data model

Our company sells gadgets to customers throughout the United States and our sales perspective data model is based on data from an ERP system. The following figure shows the data model that we are going to work with throughout this chapter:

Exercise 2.1

With the following steps, let's migrate the sales perspective container from the book's exercise files to where we've installed QDF on our computers and start to explore the data together:

  1. In the Ch. 2 folder of the book's exercise files, copy the container called 1001.Sales_Perspective to the QDF folder that is located on your computer. By default, the QDF folder will be C:\Qlik\SourceDate.

  2. In the QDF folder, open the VariableEditor Shortcut in the 0.Administration container.

  3. Click Container Map Editor. If the button hangs, then enable the Open Databases in Read and Write mode in the Setting tab of the Edit Script window and try again.

  4. In the container map table, go to the empty line after 99.Shared_Folders, and under...

Previous Section
End of Section 2
Next Section