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

QlikView Essentials

QlikView Essentials

This guide demonstrates just how easy it is to get started with QlikView and create your own BI application. Featuring an introduction to its core features before exploring how to load data and model it, you’ll soon become more confident that you can take full advantage of QlikView’s capabilities. You will also learn how to use QVD files with QlikView – and how they offer a simpler way of handling data.

After digging deeper into data handling, as you learn how to use mapping tables and create a master calendar, you’ll then find out how to get the most from QlikView’s visualization features – vital if you are to use your data insights effectively. From accessible and user friendly dashboards to strategies and best practices for subjecting data to further analysis, you can be confident that you’ll be prepared to get the most out of your data with QlikView.

With details on how to finally secure your application and deploy it for a successful integration in your organization, QlikView Essentials underlines exactly why QlikView is becoming more and more popular for businesses that understand the value of data.

  • Learn the complete QlikView workflow – from loading data, to visualization and analytics
  • Learn how to Load data from different sources, including QVD files and how to optimize data models for accuracy and precision
  • Discover solutions to common data modeling problems, so you can respond quickly to changing situations
  • Create accessible dashboards and quality data visualizations to share insights effectively
  • Learn how to deploy your BI application for optimal availability

Module 1: QlikView Fundamentals

·         QlikView components

·         QlikView installation

·         Getting started

·         The development life cycle of QlikView implementations

·         QlikView development setup

·         Summary

Module 2: Extract, Transform, and Load

·         Configuring settings

·         Scripting essentials

·         Connecting to the database

·         Summary

Module 3: Optimizing Your Data Model

·         Mapping table essentials

·         Mapping load – Territory table

·         Concatenation

·         Joins

·         Reviewing the final data model

·         Summary

Module 4: Data Modeling Challenges

·         Crosstable essentials

·         Loading EmployeeSalesTarget.xlsx

·         Link table

·         Variables in QlikView

·         Master calendar

·         The IntervalMatch function

·         QlikView Data Files (QVD)

·         Optimized load – reading QVD

·         Best practices of data modeling

·         Summary

Module 5: Creating Dashboards

·         Dashboarding essentials

·         Getting started

·         Sheet objects

·         Creating a multi-tab application

·         Creating a bar chart

·         Creating a text object

·         Creating a scatter chart

·         The story of two tables

·         Dimension limits

·         Some important functions

·         Summary

Module 6: Comparative Analysis

·         Set Analysis essentials

·         Using Set Analysis

·         Alternate States

·         What-If Analysis

·         The last step

·         Summary

Module 7: Securing Your Application

·         Section Access essentials

·         Implementing Section Access

·         Summary

Module 8: Application Deployment

·         QlikView architecture essentials

·         Client Access Licenses (CALs)

·         QlikView application deployment

·         QlikView server structure

·         Summary

KH 2
KH 3
KH 5