fbpx

Download Training Directory (2021) Download Now

20
May 2021

Data Analytics Using Qlik Sense For Beginners (Live Stream)

Course Information

Start Date20 May 2021, Thursday
End Date21 May 2021, Friday
Time9.30am to 4.30pm
VenueOnline via Zoom
Fee$990 (excluding GST)
ContactRoshini | 6720 3333 | training.aventis@gmail.com
Register Now
Get Group Quote
LIVE Stream

Introduction

Qlik Sense is a complete data analytics platform that sets the benchmark for a new generation of analytics. With its one-of-a-kind associative analytics engine, sophisticated AI, and high-performance cloud platform, you can empower everyone in your organization to make better decisions daily, creating a truly data-driven enterprise.

Qlik Sense is built on the same QIX Associative Data Indexing engine as QlikView, but Qlik Sense offers a simplified user interface, drag-and-drop visualizations, and the ability to load data without manually editing scripts. Qlik Sense is designed from the ground up for self serve BI on a variety of devices. With Sense, users will be able to develop directly on the server instead of having to manage a single file among multiple developers. You can even develop full Qlik Sense applications on an iPad or tablet. Sense’s responsive design means that a single application will resize itself on your phone, tablet or laptop without having to develop specific UIs for each form factor. The best part; Qlik Sense uses the same data that QlikView does. You will be able to leverage all of your existing load scripts and data aggregations immediately.

Course Highlights
  • Explore Qlik Sense & learn how to navigate it
  • Gain an overview of data visualisation
  • Learn how to connect to data sources using Qlik Sense
  • Learn the best practices to data modelling
  • Create visualisations and dashboards using Qlik Sense
  • Learn how to publish and schedule reports
Target Audience
  • Professionals looking to leverage Qlik Sense for their organisations
  • Professionals who work with data
Prerequisite

Participants are required to have a basic understanding of data analytics. Two monitors/devices are recommended for this training.

Course Outline
  • Introduction to Qlik Sense
    1. Importance of business intelligence and data analytics
    2. Data visualization & Qlik Sense
    3. How Qlik Sense varies from Qlik View?
    4. Qlik Sense server architecture
    5. Qlik Sense licensing model
    6. Qlik Sense components

 

  • Data Warehousing and Data Modelling
    1. OLTP vs OLAP
    2. ER vs dimensional modelling
    3. Normalized vs denormalized database
    4. Types of schemas (Star vs Snowflake)
    5. Database tables Joining
    6. Data modelling best practices In Qlik Sense

 

  • Qlik Sense Navigation and Data Import
    1. Navigating in the user interface
    2. Data load editor
    3. Data Model viewer
    4. Interacting with the user interface
    5. Extracting data from databases, data files and web files
    6. Loading data with the data load script
    7. Data Connections (SQL server, CSV, Excel)
    8. Various types of data loads

 

  • Dashboard Creation in Qlik Sense
    1. Selections in a visualization
    2. Creation of charts (bar chart, pie chart, pareto chart etc.)
    3. Dimension and measures
    4. Chart properties
    5. Slicing and dicing of data
    6. Expressions, functions, and variables
    7. Master items
    8. Bookmarks
    9. Export data

 

  • Data Modelling in Qlik Sense
    1. Creating star and snowflake schemas
    2. Use of joins, keeps, concatenate, etc.
    3. Understanding QVD layered architecture
    4. Working on synthetic keys and circular references.
    5. Master calendar

 

  • Advanced Calculation and Set Analysis
    1. Dollar sign expansion
    2. Working with variables
    3. What is set analysis?
    4. Advanced functions
    5. Examples and hands-on set analysis expressions

 

  • Publishing reports and scheduling the report refreshes
    1. Publish the reports into stream
    2. Apps, objects, streams and tasks
    3. Create a report refresh scheduling
    4. Best practices in Qliksense development life cycle
Qlik Sense Trainer: Sahil Goyal

Sahil is a seasoned data analytics entrepreneur, trainer, consultant, and content creator. He is passionate about data and showing business owners how to add intelligence to their business. He has trained globally 500+ professionals on Microsoft PowerBI, Tableau, Pentaho, Microsoft Business Intelligence, SQL Server, Informatica.

Sahil has been working globally for over 7 years in multiple contexts (consulting, freelancing, and contracting) in countries (India, USA, Malaysia, South Africa), which has added professional value and experience to his career. He is highly motivated, warm, and genuinely wants to see his clients realize their growth opportunities and understand their data with interactive visualizations, scalable solutions ready for the future.