Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Advanced Qlik Sense for Data Analysis and Visualization
Rating: 4.5 out of 5(16 ratings)
83 students

Advanced Qlik Sense for Data Analysis and Visualization

Boost your Qlik Sense proficiency with this advanced course and explore its powerful business intelligence capabilities
Created bySimon Sez IT
Last updated 2/2023
English
English [Auto],

What you'll learn

  • Use system and user-defined variables effectively
  • Use a variable’s input to create dynamic dimensions and measures
  • Maximize the dynamic loading feature to import data from diverse sources in numerous ways
  • Write powerful and elegant scripts and subroutines
  • Make the most of Qlik Sense’s conditional functions, including Match and Pick and to work with the values the functions return
  • Use the Alternate States feature to create and compare visualizations
  • Use Cascading Style Sheets (CSS) to design highly customized visualizations and dashboards
  • Use geo-analytics and spatial functions to work with location-based data
  • Layer components with functions such as the Bubble, Line, Area, Heatmap, and Geodata Layers
  • Transform data with Qlik’s toolbox of analytical functions to perform geometric, aggregating, route-based, and look-up operations.

Course content

3 sections • 17 lectures • 2h 17m total length

  • Course Introduction2:14

    Explore advanced Qlik Sense for data analysis and visualization, introducing variables, dynamic loading, script functions, and visualization techniques with alternate states, css customization, and geoanalytics practicals.

  • WATCH ME: Essential Information for a Successful Training Experience2:11

    Watch this video to learn essential logistics, including downloadable exercises and instructor files, how to unzip and access files, adjust playback in high definition, and the optional course review.

  • DOWNLOAD ME: Course Exercise Files0:23
  • DOWNLOAD ME: Course Demo Files0:23
  • Introduction to Variables11:14

    Explore how variables in Qlik Sense hold fixed or dynamic values, define via the variables dialog or data load editor, and are used across apps with set and let prefixes.

  • Uses of Variables11:42

    Explore using variables and a variable input control to make dynamic bar chart dimensions, and create a top-n table with a slider for product subcategories by sales.

  • Dynamic Loading Part 111:41

    Discover dynamic loading in Qlik Sense: import multiple folder files with wildcards and apply incremental loading strategies, including append only, insert only, and insert update delete, plus QVD storage.

  • Dynamic Loading Part 212:06

    Learn how to apply insert and update incremental loading in Qlik Sense, using a MySQL source and ODBC connection to store in a QVD and update 808 records to 1010.

  • Script Files & Sub-routines11:18

    Learn to streamline data prep in Qlik Sense with external script files and subroutines, using include and must include, inline and resident loads, and reusable code.

  • Advanced Script Functions11:43

    Explore advanced script functions in Qlik Sense, including match, pick, mix match, and wild match, and apply them in the data load editor to create dynamic measures and filtered results.

  • Section Quiz

Requirements

  • Basic to intermediate knowledge of Qlik Sense is needed as this is an advanced course
  • An understanding of data analytics
  • Access to Qlik Sense software (not essential, but recommended)

Description

**This course includes downloadable instructor files and exercise files to work with and follow along.**


Reviewers have called Qlik Sense “the most advanced and powerful BI software on the market.” This course builds upon the basic groundwork we covered in our beginners’ course, allowing students to explore the application’s more sophisticated data analysis and visualization capabilities. Here is your chance to get hands-on experience with Qlik’s higher-level data modeling, analytics, reporting, and chart- and script-level functions.


This is a comprehensive course that will guide you to putting Qlik Sense’s Business Intelligence (BI) and data discovery methodologies to work in real-world use cases.


Join our expert instructor and delve more deeply into this flexible and feature-rich application and the many ways it can help you make best sense of your data.


The course includes access to practice exercises and downloadable data files to work with.


This course covers:

  • How to use system and user-defined variables effectively

  • How to use a variable’s input to create dynamic dimensions and measures

  • To maximize the dynamic loading feature to import data from diverse sources in numerous ways

  • To write powerful and elegant scripts and subroutines

  • How to make the most of Qlik Sense’s conditional functions, including Match and Pick and to work with the values the functions return.

  • How to use the Alternate States feature to create and compare visualizations

  • To use Cascading Style Sheets (CSS) to design highly customized visualizations and dashboards

  • To use geo-analytics and spatial functions to work with location-based data

  • How to layer components with functions such as the Bubble, Line, Area, Heatmap, and Geodata Layers.

  • To transform data with Qlik’s toolbox of analytical functions to perform geometric, aggregating, route-based, and look-up operations.


This course includes:

  1. 2+ hours of video tutorials

  2. 14 individual video lectures

  3. Course and exercise files to follow along

  4. Certificate of completion

Who this course is for:

  • Users who have a foundation in Qlik Sense and seeking to advance their skills
  • Data Scientists and Data Analysts
  • Those who are looking to use Qlik Sense for data analysis
  • Anyone interested in data visualization and business intelligence

Report abuse