8411  Reviews star_rate star_rate star_rate star_rate star_half

Qlik Sense: Building Data Models

This Building Data Models with Qlik Sense training class teaches attendees how to load data from common sources such as spreadsheets, relational databases, CSV files, and other forms of structured...

Read More
By Request
Contact Us For Pricing
Duration 3 days
Course Code QLIK-102
Available Formats Classroom

Overview

This Building Data Models with Qlik Sense training class teaches attendees how to load data from common sources such as spreadsheets, relational databases, CSV files, and other forms of structured data. After the data is loaded, participants learn advanced data modeling techniques applying business conditions to ensure the proper development of calculations.

Skills Gained

  • Introduce new users to Qlik
  • Connect to various data sources such as OLE DB and other file types of data
  • Develop a Data Model with multiple tables of data
  • Handle various scenarios when dealing with Synthetic Keys
  • Streamline the Data Model to create a efficiencies

Prerequisites

Students must have familiarity with tables and relationships using primary and foreign keys.  Basic knowledge of SQL query writing (or higher) is preferred.

Course Details

Training Materials

All Qlik training students receive documentation for the detailed exercises they complete in the class and sample solutions.

Software Requirements

A modern browser (i.e., Chrome, Edge, Firefox) to access the environment.  Having a dual monitor is recommended but not required. 

Data Modeling Introduction

  • Describe the components of a Qlik Sense app
  • State the Qlik Sense deployment options and their components
  • Describe a relational database management system
  • Explain different data modeling structures
  • Understand the Qlik Sense platform
  • Explain how to create a new app
  • Navigate the Data load editor

Loading in Data

  • Explain the different connection types in Qlik Sense
  • Create a load and selection statement
  • Apply comments
  • Compare data structures
  • Use the Data model viewer
  • Load data from Excel spreadsheets and text files
  • Create data connections to folders of file locations
  • Use the Select Data tool to generate the script

Resolving Potential Data Modeling Issues

  • Describe what synthetic keys and synthetic tables are
  • Solve synthetic keys
  • Explain key fields
  • Explain Count and Sum
  • Describe circular references
  • Explain loosely coupled tables
  • Leverage Qualify and Unqualify
  • Use transformation functions in the script

How to Generate Data

  • Create new fields in a table
  • Explain the Where clause
  • Use Resident Load
  • Explain composite keys
  • Explain how Qlik Sense uses dates and times
  • Discuss how to use AutoGenerate
  • Create a master calendar

Managing and Combining Tables

  • Explain the mapping tables concept
  • Identify when to use mapping tables
  • Identify areas to clean up in the data model
  • Use preceding loads within the script
  • Joining tables
  • Explain concatenation
  • Describe the concatenation types

Advanced Data Modeling Challenges

  • Describe why and how to aggregate data in the script
  • Identify Crosstable data
  • Explain how to create scripts to load Crosstable data
  • Explain the use of Link tables
  • Explain data specification
  • Describe how to implement a data classification approach in Qlik Sense

Debugging and Developing in Qlik

  • Explain how to use script variables
  • Describe the use of Let and Set statements
  • Explain the use of dollar-sign expansion
  • Load data using external scripts with Include
  • Control the flow of script execution
  • Explain how to debug a data load

Finish Line

  • Define and use set analysis and its components
  • Draw upon basic and advanced expression calculations
  • Add Master items
  • Create data islands and review their usage
  • Leverage QVD files
  • Discuss performance tuning
  • Explore the impacts of appropriate document design
  • Review best practices

Conclusion

Read Less

Schedule

Upcoming Course Dates

There are currently no scheduled dates for this course. If you are interested in this course, contact us with the form below.

Contact Information

FAQ

Does the course schedule include a Lunchbreak?

Classes typically include a 1-hour lunch break around midday. However, the exact break times and duration can vary depending on the specific class. Your instructor will provide detailed information at the start of the course.

What languages are used to deliver training?

Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.

What does GTR stand for?

GTR stands for Guaranteed to Run; if you see a course with this status, it means this event is confirmed to run. View our GTR page to see our full list of Guaranteed to Run courses.

Does Ascendient Learning deliver group training?

Yes, we provide training for groups, individuals and private on sites. View our group training page for more information.

What does vendor-authorized training mean?

As a vendor-authorized training partner, we offer a curriculum that our partners have vetted. We use the same course materials and facilitate the same labs as our vendor-delivered training. These courses are considered the gold standard and, as such, are priced accordingly.

Is the training too basic, or will you go deep into technology?

It depends on your requirements, your role in your company, and your depth of knowledge. The good news about many of our learning paths, you can start from the fundamentals to highly specialized training.

How up-to-date are your courses and support materials?

We continuously work with our vendors to evaluate and refresh course material to reflect the latest training courses and best practices.

Are your instructors seasoned trainers who have deep knowledge of the training topic?

Ascendient Learning instructors have an average of 27 years of practical IT experience and have also served as consultants for an average of 15 years. To stay current, instructors spend at least 25 percent of their time learning new, emerging technologies and courses.

Do you provide hands-on training and exercises in an actual lab environment?

Lab access is dependent on the vendor and the type of training you sign up for. However, many of our top vendors will provide lab access to students to test and practice. The course description will specify lab access.

Will you customize the training for our company’s specific needs and goals?

We will work with you to identify training needs and areas of growth.  We offer a variety of training methods, such as private group training, on-site of your choice, and virtually. We provide courses and certifications that are aligned with your business goals.

How do I get started with certification?

Getting started on a certification pathway depends on your goals and the vendor you choose to get certified in. Many vendors offer entry-level IT certification to advanced IT certification that can boost your career. To get access to certification vouchers and discounts, please contact info@ascendientlearning.com.

Will I get access to content after I complete a course?

You will get access to the PDF of course books and guides, but access to the recording and slides will depend on the vendor and type of training you receive.

How do I request a W9 for Ascendient Learning?

View our filing status and how to request a W9.

Reviews

ExitCertified gave a great course on AWS that covered all of the basics in depth with good lab materials.

my experince was great from the day i regetered to the actuall day of the class.

Good Course. We covered a lot of material in a short amount of time. This course had useful labs that built upon each other.

Topics, material and specially instructor (Graham Godfrey) was beyond my expectations.

the course is good, covers many aspects, wish the lab is a little bit more in depth