028 3824 5819 traincert@tdt-tanduc.com
Tiếng ViệtEnglish

Mastering QlikView

Mastering QlikView

QlikView and its new sister product, Qlik Sense, are the leading tools for BI and data discovery. They both feature the ability to consolidate relevant data from multiple sources into a single application, an associative data model to allow you to explore the data the way your brain works, and state-of-the-art visualizations, dashboards, analysis, and reports.

The course starts by reviewing the best performance-tuning techniques and then advances to help you discover strategies to improve performance and test scalability with JMeter. You will also learn dimensional data modeling and creating best-practice ETL techniques using the QlikView script and QlikView's graphical ETL tool, Expressor. Following this, you will deploy QlikView Governance Dashboard to import multiple data sources and view all the information in a single location. Finally, you will learn why virtualization is important and what are the best practices for virtualization in QlikView.

  • Learn performance-tuning techniques to tackle the challenges associated with scalability
  • Use and apply the most effective data models to find answers to your biggest business questions
  • Get to know the best practices for data loading and understand QVDs to implement an ETL approach
  • Discover a range of techniques to manage metadata including the QlikView Governance Dashboard
  • Write great scripts to load data in different ways
  • Visualize data using a set of analytical and advanced charting techniques

Module 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

Module 2: QlikView Data Modeling

·         Reviewing basic data modeling

·         Dimensional data modeling

·         Handling slowly changing dimensions

·         Dealing with multiple fact tables in one model

·         Drilling across with document chaining

·         Summary

Module 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


Module 4: Data Governance

·         Reviewing basic concepts of data governance

·         Establishing descriptive metadata

·         Extracting metadata

·         Deploying the QlikView Governance Dashboard

·         Summary

Module 5: Advanced Expressions

·         Reviewing basic concepts

·         Understanding Dollar-sign Expansion

·         Using advanced Set Analysis

·         Calculating vertically

·         Summary

Module 6: 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

Module 7: Visualizing Data

·         Reviewing the history of data visualization

·         Understanding the audience

·         Designing effective visualizations

KH 2
KH 3
KH 5