QlikView Course Details

What is QlikView?

Advantages of QlikView:

1. Unique Features Compared to Traditional BI Tools
2. Basics of Complete Dataware Housing

QlikView Products

• Desktop
• Server
• Publisher
• Access Point

Roles Involved

• Developer
• Designer
• Administrator

Deployment Process

• Standalone
• Server
• Publisher

Introduction to Data and Scripting

• Relational Databases
• Dimensional Data Structures
• Comparing Data Models to QlikView Data Model
• Data Structures in QlikView
• Data Source Files
• The QWT Primary Data Source
• The QWT Secondary Data Files
• Explanation of Edit Script
• Loading Data from the Database
• Script Generation
• Comments in the Script
• Script Debugging
• Structuring the Script
• Creating Tabs in the Script

Basic Data Model and Table Viewer

• The Table Viewer
• The System Table
• Explanation of Document Properties

Basic Data Transformation

• Load Data from Multiple Data Sources
• Renaming a Field
• Script Expressions
• Loading an XML File
• Renaming Fields Using the Qualify Statement
• Key Fields
• Loading Generic Tables
• Including Images and Media Content
• Loading a Field into a Table Multiple Times
• Using a Record Counter on Key Fields
• Loading Cross Tables and Info Tables
• Handling Null Values
• Changing Date Formats
• Changing Metadata
• Complete Discussion about Concatenation
• Resolving Synthetic Keys
• Resolving Loops
• Preparing QVD Files
• Performing Incremental Loads
• Optimization Techniques at Script Level

1. Implementing Data Modeling, Visualization, and Reporting
2. Creating QVD Files in QlikView Desktop
3. Steps of Transformation
4. Data and BI Visualization with QlikView
5. Creating Different Types of Charts and Integrating them in the Dashboard for Analysis
6. Reading Data from Various Tables
7. QlikView Set Analysis and How to Implement it
8. Chart-Level and Script-Level Qlik Functions
9. QlikView Security and Access Points
10. Developing a Real-Time Project using QlikView
11. Preparing for QlikView Developer Certification.