Course Introduction
  • Course Overview and Objectives
Getting Started with QlikView Personal Edition
  • Installing QlikView Personal Edition
  • Creating Your First Sales Application By Using Simple Wizard
Learn How to Use QlikView Effectively and Find Patterns in Data
  • Data Discovery Through Association
  • Application State and Selections - How Selections Affect What You See
  • What Makes Applications Great - Expense Management Analysis
Starting with Sales Analysis of Shoe Sales Business
  • Overview of Application We Are Building - Shoe Sales Application
  • Full Cycle of Modelling, Development and Visualization Explained
Loading Data and Building Data Model for Shoe Sales Application
  • Data needed for Shoe Sales Application
  • Mocking the Sales Data with Mockaroo
  • Loading Sales and Product Data from Microsoft Excel
  • Loading Store Data from CSV file and Concatenations
  • Loading Product Information From Inline Data and Data Manipulation
  • Scripting Functions
Joining Data From Various Sources in Shoe Sales Application
  • Introduction to Connecting the Data through Table Joins
  • Connecting the Shoe Sales Data
  • Wrapping up our Data Model
Visualizing Sales Data in Shoe Sales Application
  • Preparing Application Layout, Look and Feel to Adapt it To Your Company
  • Current Selection and Multi Box
  • Making Selections by Using List Boxes To Show Product List And Categories
  • How to Quickly Search All Data you Load by Using Search Boxes
  • CONSULTANT ADVICE : How I use Search Boxes in Practice
  • Using Buttons to Link Actions
  • Using Sheets To Better Separate Application Story
  • Using Table Boxes to Display your Raw Table Data
  • CONSULTANT ADVICE : Why You Should Always Have Table Boxes
Pivot Tables and Straight Tables
  • Creating Pivot Tables - Most Powerful Tool to Better Data Insight
  • Using Linear Gauge to Visualize Sales Margins
  • Creating Straight Tables To Show All Data
  • Grouping Tables Into Container to Better Organize Layout
Graphs and Charts in Shoe Sales Application
  • Creating Bar Charts to Show Sales By Category
  • Creating Line Charts To Visualize Revenue by Month/Year
  • Displaying KPIs to Quickly See Data You Need to Focus On
Wrapping up Application and Optimizing Look and Feel
  • Using Variables to Better Separate Problematic Sales Margins
  • Showing and Hiding Sheet Objects by Using Separate List Box
  • Final remarks
  • Get The Final Application