How do the products in the Qlik product portfolio fit together?
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
We have seen that the Qlik product portfolio has expanded significantly in the past few years. At the time of QlikView 11 for Developers, there was only QlikView. Nowadays there is a complete range of products and add-ons.
The following diagram gives a high-level overview of how all the products fit together. The base is QlikView and the QAP, both of these use the same QIX Engine. The QAP underpins Qlik Sense Enterprise, which adds a frontend client and collaboration features. NPrinting can be used for static reporting on either QlikView or Qlik Sense. The Qlik Web Connectors, Rest Connector, and DataMarket let both QlikView and Qlik Sense ingest external, web-based data. Geographical analysis in both QlikView and Qlik Sense can be done with the Qlik GeoAnalytics add-on.
-
No Comment