To get the most out of this book
by Karl Pover, Stephen Redmond, Barry Harmsen, Miguel Angel Garcia
QlikView: Advanced Data Visualization
- QlikView: Advanced Data Visualization
- Table of Contents
- QlikView: Advanced Data Visualization
- Contributors
- Preface
- 1. Performance Tuning and Scalability
- Reviewing basic performance tuning techniques
- Generating test data
- Understanding how QlikView stores its data
- Strategies to reduce the data size and improve performance
- Testing chart performance for different load options
- Optimizing chart calculation times
- The QlikView calculation engine
- Using Direct Discovery
- Testing scalability with JMeter
- Running an example execution
- Summary
- 2. QlikView Data Modeling
- Reviewing basic data modeling
- Dimensional data modeling
- Differentiating between facts and dimensions
- Understanding the grain
- Understanding star schemas
- Summing with facts
- Discovering more about facts
- Dealing with nulls in fact tables in QlikView
- Designing dimension tables
- Defining Kimball's four-step dimensional design process
- Learning some useful reusable dimension methods
- Creating dimensional facts
- Handling slowly changing dimensions
- Dealing with multiple fact tables in one model
- Drilling across with document chaining
- Summary
- 3. Best Practices for Loading Data
- Reviewing data loading concepts
- Understanding why you should use an ETL approach
- Using an ETL approach to create QVD data layers
- Mastering loading techniques
- Using QlikView Expressor for ETL
- Summary
- 4. Advanced Expressions
- Reviewing basic concepts
- Understanding Dollar-sign Expansion
- Using advanced Set Analysis
- Calculating vertically
- Summary
- 5. Advanced Scripting
- Reviewing the basic concepts
- Counting records
- Loading data quickly
- Applying variables and the Dollar-sign Expansion in the script
- Using control structures
- Examining advanced Table File Wizard options
- Looking at data from different directions
- Reusing code
- Summary
- 6. What's New in QlikView 12?
- 7. Styling Up
- 8. Building Dashboards
- User types
- Applying the DAR principle to Airline Operations
- Creating the Analysis sheet
- Creating the new Dashboard sheet
- Creating the Reports sheet
- Other charts
- Summary
- 9. Advanced Data Transformation
- 10. Security
- 11. Data Visualization Strategy
- 12. Sales Perspective
- 13. Financial Perspective
- 14. Marketing Perspective
- 15. Working Capital Perspective
- 16. Operations Perspective
- 17. Human Resources
- 18. Fact Sheets
- 19. Balanced Scorecard
- 20. Troubleshooting Analysis
- 21. Mastering Qlik Sense Data Visualization
- Index
To use this book, you primarily need the QlikView Desktop software. With regards to computer requirements, you will need a PC with at least Windows XP (or better), 2 GB of hard disk space, and 2 GB of RAM. A 64-bit machine is required if you want to use QlikView 12 or a higher version, and is the recommended environment for this book and QlikView development in general. If you prefer to use a 32-bit machine, you can install QlikView 11 instead.
For best understanding, a general knowledge of BI and its terminology is required. Basic understanding of databases and SQL is preferred, but not compulsory for this book.
You can download the example code files for this book from your account at http://www.packtpub.com. If you purchased this book elsewhere, you can visit http://www.packtpub.com/support and register to have the files emailed directly to you.
You can download the code files by following these steps:
- Log in or register at http://www.packtpub.com.
- Select the SUPPORT tab.
- Click on Code Downloads & Errata.
- Enter the name of the book in the Search box and follow the on-screen instructions.
Once the file is downloaded, please make sure that you unzip or extract the folder using the latest version of:
- WinRAR / 7-Zip for Windows
- Zipeg / iZip / UnRarX for Mac
- 7-Zip / PeaZip for Linux
The code bundle for the book is also hosted on GitHub https://github.com/PacktPublishing/QlikView-Advanced-Data-Visualization. We also have other code bundles from our rich catalog of books and videos available at https://github.com/PacktPublishing/. Check them out!
There are a number of text conventions used throughout this book.
CodeInText: Indicates code words in text, database table names, folder names, filenames, file extensions, pathnames, dummy URLs, user input, and Twitter handles. For example; "In the QVScriptGenTool_0_7 64BitAnalyzer folder there is a ZIP file called FolderTemplate.zip."
A block of code is set as follows:
Sales:Load * INLINE [Country, SalesUSA, 1000UK, 940Japan, 543];
When we wish to draw your attention to a particular part of a code block, the relevant lines or items are set in bold:
Sales: Load * INLINE [ Country, Sales USA, 1000 UK, 940 Japan, 543 ];
Any command-line input or output is written as follows:
C:Program FilesQlikViewqv.exe
New terms and important words are shown in bold. Words that you see on the screen, for example, in menus or dialog boxes, appear in the text like this: "Click on the Execution tab."
-
No Comment