
Explore how Qliksense differs from Qlikview, harness its associative engine for interactive exploration, and learn to load data, create dashboards, and use smart search, snapshots, and cloud features.
Load data from files or databases into qliksense with the data load editor, then manage associations and create dimensions and measures via the data manager and data model viewer.
Learn how to load data into Qliksense by connecting to a data source, adding data from a file or web source, and creating associations in the data manager for analysis.
Create and edit associations between tables, load data via the data manager and data load editor, then explore the data model and define measures and dimensions.
Explore building sheets and visualizations in Qliksense, grouping related charts like combo charts, gauges, key performance indicators, pie charts, treemaps, and waterfalls, using measures and dimensions, filters, and master items.
Design sheets with a defined audience and purpose, start with high-level KPI overviews, place KPIs at the top, keep elements minimal, and use purposeful color coding.
Build six sheets in a QlikSense app to visualize key insights: a KBI dashboard, performance monitoring, customer segment sales, product category sales, shipments, and orders and returns.
Create a shipments sheet in QlikSense that combines a combo chart of shipments by ship mode and shipment cost, and calculates days to ship from ship date and order date.
Create Qlik Sense sheet with kpis for sales count and amount, a scatterplot of sales vs margin by customer segment, and a line chart and treemap of sales by segment.
Build a performance monitoring sheet with a pivot table, measures for total sales and count, and five gauge meters comparing 2012 sales per manager against min and max thresholds.
Build a dashboard with two combo charts comparing sales and orders, include a line chart with a secondary axis, money formatting, and growth-rate metrics for sales and profit.
Create data stories in Qliksense by capturing snapshots from visualizations into a snapshot library, then embed sheets and publish insights as pdf or powerpoint.
Develop a data story for a sales meeting to analyze decreasing profit growth and explore profitable customer segments and product categories to boost profitability with KPI snapshots.
Learn the essentials of QlikSense through this step-by-step tutorial. This course takes you through the basics of QlikSense, how to integrate your application with different data sources, manage data, build visualizations and sheets and share your insights with visual Data Stories!
..Learn to build a QlikSense App from scratch!
..Learn some of the most common mistakes made when building building sheets and visualizations..
..Forget about reports and presentations, learn more about Data Storytelling
The course contains training materials, where you can practice, apply your knowledge and build an app from scratch. The training materials are provided in an Excel file that you can download to your computer. Each module also ends with a short quiz and there is a final quiz at the end of the course.
After completion of this course, you will receive a certificate of completion.
Good luck and hope you enjoy the course.
Pre-requisites:
Basic knowledge of Business Intelligence and Visualization.
Some experience with Visualization tools would be helpful, but not required.
Course content:
The course consists of the following modules:
Introduction, Installation and Setup
Data Loading - Basic Concepts (Data Load Editor, Data Manager, Data Model Viewer)
Data Loading - Exercise 1-2
Sheet Visualizations - Visualizations
Sheet Visualizations - Expressions and variables
Sheet Visualizations - Best practices sheet design
Sheet Visualizations - Exercise 1-10
Data Storytelling - Presenting Insights
Data Storytelling - Publishing
Data Storytelling - Exercise 1-2
Final Quiz
Who should follow this course?
Students that want to learn the basics of QlikSense
Business Analysts and Designers who are already familiar with other visualization tools and want to learn QlikSense.
Managers considering using QlikSense within their organization.