Data PRO or Pay-Per-Course

Pick a plan that right's for you!

Pay per course or a flat monthly subscription with no contracts. Become a Data PRO and get access to all data engineering, analytics and data science courses.
Explore Data PRO

Course curriculum

  • 1
    Introduction
  • 2
    Getting Started
  • 3
    Loading Data into a QV App
  • 4
    Exploring Data using the UI
  • 5
    Transforming Data in Load Scripts
  • 6
    Effectively presenting data
  • 7
    Advanced Load Transformations
  • 8
    Appendix
  • You, this course and us.
  • Understanding a Qlikview Document The In-Memory Data Model Installing the Qlikview Desktop Client QV Introduction Document
  • Loading data from a CSV file Loading data from a Database Avoiding Synthetic Keys Removing Circular References
  • List Boxes are like Select DISTINCT Table boxes are for Selecting columns Selection interactions in QV Summarizing data with Chart Boxes Data Types in QV : The Dual Format Representation
  • Adding calculated fields in the load script Using a variable in the load script Joining tables in memory The Keep keyword Loading data from in-memory tables Inline loads
  • Some useful dashboard elements Grouped Fields Highlighting with Color The total keyword Using Set analysis to override selections
  • Mapping Loads Generic Load
  • MySQL Installation

Course Description

What will I learn?

  • Build Qlikview apps end-to-end from loading to visualization
  • Transform data using Joins and Keep
  • Visualize data with Charts, Drill downs and Triggers
  • Load data from sources like CSVs and Databases
  • Run queries using List boxes and Chart boxes


About the course

  • Qlikview: One tool to Transform, Summarize and Visualize Data 
  • A Qlikview app is like an in-memory database. The interactive nature of Qlikview allows you to explore and iterate very quickly to develop an intuitive feel for your data.


What's Covered

  • The Qlikview In-memory data model
  • Use List boxes, Table boxes and Chart boxes to query data
  • Load data into a QV app from CSV and Databases, avoiding Synthetic keys and Circular references
  • Transform and adding new fields in a Load script
  • Transform tables with Join, Keep
  • Effectively present your insights using elements like charts, drill downs, triggers. 
  • Nested aggregations in charts
  • Generic Loads, Mapping Loads, Crosstable  


Who should take the course?

  • Yep! Data professionals who want a handy tool to play with and explore data
  • Yep! Business professionals who prefer interactive environments to heavy duty programming 


Pre-requisites & Requirements

  • Basic understanding of SQL is assumed

Become a Data PRO

Subscribe to Data PRO plan and get access to all the courses.

Get started now