1. Introduction to QlikView and business intelligence
-
Understanding Business Intelligence (BI) concepts, their importance, and the role of data analysis in organizations.
-
Introduction to QlikView, its unique features, architecture, and components.
-
Comparing QlikView to traditional BI tools and other BI tools.
-
Overview of QlikView file types (.qvw, .qvd, .qvs).
2. Data loading and scripting
-
Connecting to Data Sources: Establishing connections to various data sources like databases (ODBC/OLE DB), Excel files, delimited files, XML files, and web files.
-
QlikView Scripting: Understanding the QlikView scripting language for data extraction, transformation, and loading.
-
Script Editor Features: Using the Script Editor to write, edit, debug, and manage scripts, including menus, commands, and options like commenting, indenting, and syntax checks.
-
Loading Techniques: Exploring different load types: inline load, resident load, binary load, mapping load, and incremental load.
-
Advanced Scripting: Working with script-level functions, expressions, variables, and parameters.
-
QVD Files: Understanding QVD file format, its uses for optimized data storage, and creating/managing QVDs.
3. Data modeling and transformation
-
Data Warehousing Concepts: Understanding OLTP vs. OLAP, data warehouse architecture (staging, dimensions, facts), and schemas (star and snowflake).
-
Dimensional Modeling: Designing data models using dimensional modeling principles.
-
Data Transformation: Performing basic and advanced data transformations like renaming fields, applying script expressions, handling null values, changing date formats, concatenating tables, and resolving synthetic keys and circular references.
-
Table Viewer: Understanding and using the Table Viewer to visualize data model structure and relationships.
-
Master Calendar: Creating a master calendar for time-based analysis.
4. QlikView development and user interface design
-
Sheet Objects: Creating and working with various sheet objects: list boxes, table boxes, multiboxes, input boxes, text objects, buttons, and charts.
-
Chart Types and Properties: Designing different types of charts (bar, pie, line, pivot, straight, gauge, radar, Mekko, block, funnel, scatter, grid, mini) and customizing their properties.
-
Dashboard Design: Creating interactive dashboards, implementing layout, and applying design best practices for user-centered workflows.
-
Expressions and Calculations: Working with chart-level and script-level functions and expressions.
-
Set Analysis: Understanding and applying Set Analysis for advanced filtering and calculations.
5. QlikView server and administration
-
QlikView Server Architecture and Configuration: Understanding QlikView Server architecture, installation, configuration, and management.
-
QlikView Management Console (QMC): Using QMC for managing documents, tasks, users, and licenses.
-
QlikView Publisher: Understanding the Publisher's role in distributing documents, scheduling reloads, and handling looping and reduction.
-
Security Management: Implementing QlikView security features, including Section Access for data reduction, authentication, authorization, and managing user access.
-
Deployment and Administration: Deploying applications, managing licenses, and performing server administration tasks.
6. Advanced topics and best practices
-
Performance Tuning: Optimizing data models, scripting, and applications for better performance.
-
Troubleshooting: Identifying and resolving common issues in QlikView applications.
-
Integration: Exploring integration with other tools and platforms (e.g., QlikView with Big Data Hadoop).
-
Real-Time Projects and Case Studies: Working on practical projects to apply learned skills and solve real-world BI challenges.