6. What's New in QlikView 12?
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
If QlikView 12 is your first entry into the world of Qlik then you might be tempted to skip this chapter. However, we highly recommend that, even as a new developer you, at least read the What is new in the Qlik product portfolio? section.
We will start with a look at some of the most important changes in QlikView 12. Although QlikView 12 Desktop is the main focus of this book, we will also discuss the changes and improvements in QlikView 12 Server and Publisher.
Next, we will take a look at the broader picture and see how the Qlik product portfolio has changed in the past few years. We will learn what these new products do and how they might fit into your Qlik deployment.
To summarize, in this chapter we will specifically look at:
- What is new in QlikView 12?
- What is new in the Qlik product portfolio?
- How do the products in the Qlik product portfolio fit together?
.How is QlikView 12 different from QlikView 11?
Apart from a restyled application icon, at first glance QlikView 12 looks remarkably similar to its predecessor. Under the hood, however, many improvements and fixes have been realized, and in this section we will take a high level view at some of those changes.
The main difference compared to previous versions is that the underlying engine of QlikView has been replaced with the updated QIX Engine 2.0. This is the same engine that powers the other products in the Qlik portfolio (Qlik Sense Enterprise and the Qlik Analytics Platform, discussed later). Besides performance improvements over the previous version, this common engine makes it easier to share data models between QlikView and the other Qlik products, notably Qlik Sense. The shared code base of the engine also ensures that future investments that Qlik does in features, performance, security, and connectivity can be easily back ported to QlikView.
-
No Comment