Business Intelligence With QlikView - 0 To Full Sales App
4.2 (160 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,032 students enrolled

Business Intelligence With QlikView - 0 To Full Sales App

Learn To Read, Analyze and Visualize Your Data By Following Step by Step Guide in Building QlikView Sales Application
4.2 (160 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,032 students enrolled
Created by Vjekoslav Levacic
Last updated 3/2015
English [Auto-generated]
Current price: $16.99 Original price: $24.99 Discount: 32% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2.5 hours on-demand video
  • 4 articles
  • 7 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • How to build application to analyze sales data and other business data in efficient way
  • Use graphs, charts and pivot tables to represent your sales and business data
  • What constitutes a well designed and easy to use application
  • How to load, clean and prepare data for visualization
  • Best practices in building QlikView applications
  • Use of QlikView scripting language for building data model
  • Learn how QlikView works behind the scene
  • Basic knowledge of MS Excel

QlikView is profoundly different than any other Business Intelligence tool so no wonder Qlik is one of the fastest growing companies on the market and job demands for developers are high with salaries reaching up to $100,000.

After completing this course you will be able to:

  1. Build QlikView application that analyzes sales data provided in the course
  2. Get the experience with real-life business data that companies analyze
  3. Learn general concepts of data analysis and Business Intelligence
  4. Analyze business data from external data sources
  5. Replace Excel on all projects related to data analysis and visualization
  6. Learn to properly visualize data by using various charting technique

What you need to know before starting with QlikView

It's important to learn how to work with QlikView. Through QlikView's Expense Management application, I show you how users can be taught to use QlikView to detect exorbitant spending in a company and perform detailed data analysis. Since QlikView is data driven, and it reacts to anything you select, by understanding selections and associations, you will work more efficiently with the tool.

What kind of application are we building in a course

We create Shoe Sales application from scratch. This is an imaginary scenario where we analyze shoe sales business across USA. We have stores in cities where shoes are sold, so we need to focus on what are we selling, for how much, how profitable we are and if we are losing money on certain sales.

All the sample data will be provided in the course and as a bonus, I show you how to use website called Mockaroo to build any data mockups. You can even use Mockaroo for other data analysis projects, or for demonstration purposes.

What development and visualization concepts we cover in course

This course is about development and visualization. You will get insights into modeling practices, learn to use scripts for loading, cleaning, joining and preparing data for visualizations. We cover topics like table naming, concatenation, symbolic links, building artificial keys, table joins, and various scripting functions.

Specific courses are provided for specific visualization techniques like straight or pivot tables, search boxes, list boxes, selections, line and bar charts and design of KPIs - a key metric users should focus on first.

It is a course developed to put you on feet with QlikView without which you might be tapping in a dark or just do the things wrong way - a complete course to build a complete QlikView application!

What's new: I will start adding my own consulting experience with the tool and how I used it in practice.

Who this course is for:
  • You work with data on a daily basis
  • You require better visualization and presentation of data
  • You have patterns in data you want to discover and analyse
  • You want to learn more about data modelling and visualization
  • You are evaluating QlikView as an alternative to traditional reporting tools
  • You need to combine data from multiple sources
Course content
Expand all 37 lectures 02:37:59
+ Course Introduction
1 lecture 02:26

At the beginning of course, we explain what we are about to learn.

Preview 02:26
+ Getting Started with QlikView Personal Edition
2 lectures 04:40

In this lecture you will learn how to download and install QlikView Personal Edition. You will learn about the Qlik company and their major products used for personal data analysis.

Installing QlikView Personal Edition

In this lecture we will go through the application creation wizard and create the very first QlikView application. A simple sales application will be built from the sample data included with the installation. This will be your first introduction to working with QlikView.

Creating Your First Sales Application By Using Simple Wizard
+ Learn How to Use QlikView Effectively and Find Patterns in Data
3 lectures 16:47

The way our brain makes the associations so does QlikView. This is a core concept to any QlikView application and it will be explained here in detail. You will learn what the associated data means - the power of green - and what makes QlikView better in comparison to traditional top-to-bottom data analysis tools. A comparison to MS Excel will be done on the movies, film directors and actor analysis.

Preview 05:14

State and selections are important since data in QlikView changes as we make the selections. Through the Movies database application we will learn how to work with data selection and state navigation.

Application State and Selections - How Selections Affect What You See

We will go over full example - Expense Management application. We will learn what makes the application easy and logical to use, basic design principles and how users can work with QlikView to identify hidden costs in the company, from alarming KPI-s to the detection of detailed transactional data that led to exorbitant costs and exceeding budget.

What Makes Applications Great - Expense Management Analysis
+ Starting with Sales Analysis of Shoe Sales Business
2 lectures 14:10

This is an introduction to the Shoe Sales Application, inspired by QlikView's own shoe sales example application. We will explain what we will learn and explain what can be learned in the process.

Preview 02:28

Recognizing data sources, building data model and visualizing that data are three steps to application building. We will go over explaining importance of good data sources, explain star schema design of the data model, how fact and dimension tables in traditional Business Intelligence tool are represented in QlikView. Shoe Sales application is built from various Excel and CSV files, like shoe sales data, shoe categories, stores etc. We explain how that data is integrated into QlikView model. Basics to table linking, script editor are explained and sheet objects, as a core concept related to building visualizations.

Full Cycle of Modelling, Development and Visualization Explained
+ Loading Data and Building Data Model for Shoe Sales Application
6 lectures 39:11

This lecture wraps all the data needed to build the example Shoe Sales QlikView application

Data needed for Shoe Sales Application

We are not providing real shoe sales data, but we are generating an example from a website called Mockaroo. Since understanding data is important, I have added a chapter to learn how one is generated. Mockaroo can be used for any kind of data emulation for many different purposes.

Mocking the Sales Data with Mockaroo

We will learn how to load Excel files into Shoe Sales application by using the QlikView script editor. We will be interacting between changing script and checking the data model. Load statements will be explained.

Loading Sales and Product Data from Microsoft Excel

In this lecture we explain how to load data from CSV file. We also explain what is automatic concatenation of tables, how to avoid them, and how QlikView links tables that have more than one common field.

Loading Store Data from CSV file and Concatenations

We continue with explaining loading of inline data. We also explain the concept of forced data concatenation, where different tables are concatenated into one. Resident tables are introduced and concept is explain on the inline data loaded. Explained how drop table works.

Loading Product Information From Inline Data and Data Manipulation

Scripting functions are used for creating connection keys, repairing and cleaning data, creating new dimensions, changing field value and used extensively in the ETL process. We will explain scripting and operations in this chapter on our Shoe Sales Application.You will also learn how to use QlikView help guides efficiently.

Scripting Functions
+ Joining Data From Various Sources in Shoe Sales Application
3 lectures 17:34

We are demonstrating four types of joins - inner join, left join, right join and outer join. A new sample application is created to demonstrate the functionality.

Introduction to Connecting the Data through Table Joins

In this lecture we use the knowledge about joining tables and connect data to build a proper model. We will show various concepts to join the tables, proper naming of keys, what to do in scenario where multiple keys are shared with a common table and learn how to drop fields from loaded tables.

Connecting the Shoe Sales Data

Some final touch to the data model is to add variables. We use variables for easier code maintenance, and in our scenario to set the boundaries for cost calculation of shoes sold.

Wrapping up our Data Model
+ Visualizing Sales Data in Shoe Sales Application
9 lectures 21:23

By changing some general application properties we can make the application look better and more readable. We explore changing the background picture, font size and general look and feel of sheet objects.

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
4 lectures 18:41
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
3 lectures 13:50
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
4 lectures 09:17
Using Variables to Better Separate Problematic Sales Margins
Showing and Hiding Sheet Objects by Using Separate List Box
Final remarks
Get The Final Application