Duration
QlikSense Analytics Development
2 days
What you'll learn
- Take the first steps to becoming a data visualisation engineer
- Identify KPI's,metrics and dimensions from your business requirements
- Design and build data visualisations and enhance them with extensions
- Understand the associative model and how to load data to it
- Resolve data integrity and modelling issues
- Code expressions for metrics and dimensions
Introduction
- Business Planning
- Getting started with QlikSense
- Download , Install & Register QlikSense
- The Language
- Metrics and KPI's what are they?
Budgeting and KPI (goal) setting
- Where to find everything ?
- Introduction to navigating the QlikSense hub
- QlikSense overview
- Dimensions and Measures, what are they?
- Create your first application (App)
- The first data load
- Import and load data
- Data modelling 101 in QlikSense
- Create a Pivot table
- Using the pivot table for data review
- Creating charts and expression sorts
- How to create and use a KPI object
- Year and month filter objects
Data Science For Sales Performance
- Loading new sales data to the model
- Review and check the sales data
- Learn about Master Items and start using count()
- Basic expressions for calculating measures
- Changing the scope using conditional expressions
- How to Visualise Correlation
- Lateral thinking
- Adding more features to the Pivot table
- Think you're an expert yet ?
- Geo Analysis
- Maps and other items
Inventory Analytics
- Loading data and how to fix synthetic keys and circular references
- Loading data and how to fix circular references
- Creating a straight table and hierarchical drill down dimensions
- Creating KPI objects and coding measures
- Creating combo charts and a conversation about coding Set Analysis
- Dimensions and other ideas
- A conversation about coding Set Analysis
Online Customer Sales Analytics
- Overview the tons of new stuff in this section
- Make a new model and merge like file structures
- How to discretize data for analysis (Market Segmentation)
- What of banding,discretization,bucketization
- What is the Lookup() function ?
- Data islands and loads
- Start creating our visualizations with discretized data (Market Segmentation)
- Using Sum(), Aggr() and TOTAL for advanced counting explained
- Surface and test the advanced counting
- Bringing it all together on a dashboard sheet
- Enhance the dashboard sheet with mapping
Payroll Analytics and Pareto analysis
- Introducing Payroll with some cool new functions
- Create a data analysis review sheet
- Combining functions the RowNo(), Above() and RangeSum() for 80/20 analysis
- How to do 80/20 analysis
Profit and Loss including the magic of variables
- Lets explore another example of a compound key
- Keys quickly
- What is a variable and how do we use them in QlikSense
- The magic of variables
- Setting variables with date functions
- Using variables in Set Analysis
- Replacing simple expressions with expression variables
- Embed conditional formatting expressions in variables
Step Up Your Visualization
- Alternate States
- Customizing Dashboards with CSS
- Control Chart
- Process Control Charts in Qlik Sense
Programme scope, delivery arrangements and suitability are confirmed during enquiry.