Course content

Getting Started

Course: 23 Minutes

• Course Introduction
• QlikView Introduction
• Installing QlikView
• Exploring the Interface and Customization
• Configuring User and Document Settings

Adding Objects

Course: 44 Minutes

• Connecting to a Data Source
• Consolidating Multiple Sources
• Creating a Table Box
• Creating a List Box and Multibox
• Creating an Input Box
• Adding the Statistics Box
• Creating Other Objects
• Using the Current Selections Window and Object
• Adding and Using a Search Object
• Sorting and Filtering Data

Managing Sheets

Course: 25 Minutes

• Managing Sheets
• Aligning and Managing Items on Sheets
• Configuring Sheet Properties
• Creating and Using Bookmarks
• Exporting Data

Creating Charts and Tables

Course: 39 Minutes

• Creating a Quick Chart
• Creating a Time Chart
• Creating a Statistics Chart
• Managing Chart Properties
• Creating a Pivot Table
• Using a Pivot Table

Practice: Using QlikView

Course: 10 Minutes

• Exercise: Using QlikView to View BI Data

QlikView Data Model

Course: 1 Hour, 19 Minutes

• Course Introduction
• Data Modeling in QlikView
• Using QlikView Script Editor
• Using QlikView Table Viewer
• Joining and Linking Tables
• Table Concatenation
• Synthetic Keys and Synthetic Tables
• Circular References
• Optimized QVD Loads
• Mapping Loads
• Entity Relationship Diagrams
• Transactional Table

Dimensional Modeling

Course: 1 Hour, 16 Minutes

• What is Dimensional Modeling
• Dimension Table
• Fact Table
• Null Values
• Displaying Null Values
• Manipulating Null Values
• Normalizing and Denormalizing Dimensions
• Conformed Dimensions
• Surrogate Keys
• Dimensional Design Process

Practice: QlikView Data Modeling Best Practices

Course: 4 Minutes

• Exercise: QlikView Data Modeling

QlikView Properties

Course: 29 Minutes

• Course Introduction
• QlikView Trigger on Sheet Level
• QlikView Macros
• QlikView Document Properties
• QlikView Object Properties

Practice: Using Macros and Triggers

Course: 6 Minutes

• Exercise: Use QlikView Macros and Triggers

Extract, Transform, and Load (ETL)

Course: 38 Minutes

• Course Introduction
• Extract, Transform, and Load (ETL)
• Extracting Data Using QlikView
• Transforming Data Using QlikView
• Loading Data Using QlikView
• Third-party ETL in QlikView
• Qlik Datamarket for QlikView

Data Governance

Course: 59 Minutes

• Concepts of Data Governance
• Implement Data Governance
• Data Governance Dashboard
• Managing Profiles
• What is Metadata?
• Add Descriptive Metadata to Field Names
• Add Tags and Comments to Fields
• Extracting Metadata
• Metadata Management

Practice: Using QlikView to Perform ETL and Implement Data Governance

Course: 8 Minutes

• Exercise: Use QlikView for ETL and Data Governance

QlikView Dashboards

Course: 39 Minutes

• Course Introduction
• Creating Dashboards
• Dashboard Functionality
• Dashboard, Analysis, and Reporting (DAR)
• Alternate and Inherited States
• Comparative Analysis

Practice: Using QlikView to Create a Dashboard

Course: 7 Minutes

• Exercise: Use QlikView to Create a Dashboard

Scripting

Course: 58 Minutes

• Course Introduction
• Scripting Best Practices
• Scripting in QlikView
• Table Files Wizard
• Script Logging
• TOTAL Qualifier
• Aggregate Functions
• Conditional Functions
• Operators

Designing

Course: 25 Minutes

• Designing Effective Visualizations
• Affordances
• Visualization and Analysis
• User-centered Designs

Security

Course: 40 Minutes

• Securing Your Application
• Section Access
• Access Control
• Hidden Script
• Types of Security
• Inherited Access Restrictions
• Encryption

Practice: Using QlikView

Course: 9 Minutes

• Exercise: Use Scripting in QlikView

Application Deployment

Course: 1 Hour, 7 Minutes

• Course Introduction
• Install Qlik Deployment Framework (QDF)
• Use Qlik Deployment Framework (QDF)
• QlikView Development Life Cycle
• QlikView Publisher
• QlikView Set Analysis
• Client Access Licenses (CALS)
• CAL Types
• QlikView Architecture
• QlikView Resource Usage

Performance and Scalability

Course: 43 Minutes

• Performance Tuning Techniques
• Test Data
• QlikView Data Storage
• Improving Performance
• Direct Discovery
• Load Testing with JMeter
• QlikView Scalability
• Scaling by Data and Users
• Scaling Applications and Application Design

Practice: Using QlikView

Course: 6 Minutes

• Exercise: Use QlikView to Deploy your Application

QlikView Server

Course: 1 Hour, 1 Minute

• Course Introduction
• Installing QlikView Server
• Single and Multiple Server Nodes
• Types of QlikView Servers
• Server Architecture
• Services and Reload Engine
• QlikView Logs
• Documents, Tasks and Distribution
• Platform Security - Authentication
• Platform Security - Authorization

Practice: Using QlikView Server

Course: 6 Minutes

• Exercise: Use QlikView Server

Get started with QlikView!

✔️ Master the tools to create powerful visualizations and dashboards.
✔️ Learn how to effectively analyze and present data for a wide range of business applications.
✔️ Test your knowledge after each chapter with targeted tests and practical assignments.
✔️ Receive a certificate of participation upon successful completion of the course.

Order your course now and discover how QlikView can help you deliver self-service BI solutions that make a difference!