Training

The Basics of Data Modeling and Reporting with Qlik

Business intelligence tools like Qlik can make day-to-day work much easier. In this two-day course, you can find out how to use the Qlik data analytics platform to automate reporting quickly and efficiently, and to carry out complex data analysis at the push of a button.

Your benefits

Discover key methods and philosophies of data modeling. Also learn how to connect different data sources and prepare these efficiently for analysis and reporting purposes. 
Get to know the basic functions of Qlik and learn about the principles of setting up reports and data analysis.

Contents & Key Learnings

Basic principles of data modeling 

  • Data types and formats 
  • Relationships and cardinalities 
  • Structuring data 
  • Designing data models 

The basics of Qlik Sense 

  • Launch, settings, options 
  • Overview of operational features 

Accessing and transforming data 

  • Data imports from Access, Excel, and text files 
  • Handling queries 
  • Performing data cleansing 

Developing data models 

  • Planning data models 
  • Creating and managing relationships in data models 
  • Creating calculations and aggregations using Qlik script syntax 
  • Developing scenarios with parameters 

Creating dashboards 

  • Design features and principles of analyses 
  • Visualization elements in report design 
  • Creating dashboards from data models 
  • Using filter elements in analyses 
  • Using set analysis and visualization formulas in analyses

Format & Execution

  • Classroom 
  • Presentation, discussion, application, exercises, transfer 

Audience

This course is ideal for anyone who would like to use Qlik as a main tool for analytics and reporting with no prior experience of the platform.