QlikView Training in Kuala Lumpur, Malaysia

This course provides an in-depth understanding of QlikView, a leading data visualization and business intelligence (BI) tool. Participants will learn how to create interactive dashboards, develop data models, and optimize data transformation processes. The course covers QlikView architecture, scripting, data loading, visualization techniques, and performance tuning to help businesses make data-driven decisions.

Introduction to QlikView & Data Extraction

• Introduction to QlikView and its BI capabilities
• Installation & Setup of QlikView Desktop
• Understanding QlikView's associative data model
• Connecting to various data sources (Excel, SQL, etc.)
• Data extraction and transformation basics

Data Modeling & Scripting

• Data modeling best practices (Star Schema vs. Snowflake Schema)
• Loading & transforming data using QlikView script
• Using JOINs, Concatenation, Mapping Load, and ApplyMap()
• Creating synthetic keys & avoiding circular references
• Introduction to Set Analysis for advanced calculations

Creating Dashboards & Visualization Techniques

• Building effective dashboards and reports
• Working with list boxes, charts, tables, and gauges
• Using Variables, Expressions, and Aggregations
• Implementing drill-down and cyclic groups
• Formatting and customizing visualizations

Advanced QlikView Scripting & Security

• Advanced scripting techniques (Loops, If Conditions, and Functions)
• Implementing QlikView Section Access for security
• Data reduction strategies (Row-level and Column-level security)
• Creating QlikView Extensions (Custom objects)

Performance Optimization & Deployment

• Optimizing QlikView applications for speed and efficiency
• Using Incremental Load & Binary Load
• QlikView Server and Publisher Overview
• Deploying QlikView applications on Access Point
• Best practices for dashboard performance tuning