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.4 (40 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
404 students enrolled
$19
$25
24% off
Take This Course
  • Lectures 37
  • Length 2.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 3/2015 English

Course Description

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.

What are the requirements?

  • Basic knowledge of MS Excel

What am I going to get from this course?

  • 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

What is the target audience?

  • 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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Course Introduction
02:26

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

Section 2: Getting Started with QlikView Personal Edition
02:10

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.

02:30

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.

Section 3: Learn How to Use QlikView Effectively and Find Patterns in Data
05:14

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.

05:54

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.

05:39

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.

Section 4: Starting with Sales Analysis of Shoe Sales Business
02:28

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.

11:42

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.

Section 5: Loading Data and Building Data Model for Shoe Sales Application
Article

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

04:33

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.

08:45

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.

06:56

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.

08:34

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.

09:34

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.

Section 6: Joining Data From Various Sources in Shoe Sales Application
06:38

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.

08:13

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.

02:43

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.

Section 7: Visualizing Sales Data in Shoe Sales Application
03:39

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.

Current Selection and Multi Box
02:01
Making Selections by Using List Boxes To Show Product List And Categories
05:34
How to Quickly Search All Data you Load by Using Search Boxes
01:47
CONSULTANT ADVICE : How I use Search Boxes in Practice
Article
Using Buttons to Link Actions
01:57
Using Sheets To Better Separate Application Story
02:04
Using Table Boxes to Display your Raw Table Data
03:10
CONSULTANT ADVICE : Why You Should Always Have Table Boxes
Article
Section 8: Pivot Tables and Straight Tables
Creating Pivot Tables - Most Powerful Tool to Better Data Insight
10:08
Using Linear Gauge to Visualize Sales Margins
03:47
Creating Straight Tables To Show All Data
02:31
Grouping Tables Into Container to Better Organize Layout
02:15
Section 9: Graphs and Charts in Shoe Sales Application
Creating Bar Charts to Show Sales By Category
03:00
Creating Line Charts To Visualize Revenue by Month/Year
04:30
Displaying KPIs to Quickly See Data You Need to Focus On
06:20
Section 10: Wrapping up Application and Optimizing Look and Feel
Using Variables to Better Separate Problematic Sales Margins
02:24
Showing and Hiding Sheet Objects by Using Separate List Box
05:14
Final remarks
01:22
Get The Final Application
Article

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Vjekoslav Levacic, QlikView Certified Designer and Developer

I am consultant and software developer at Adacta, one of the largest business software integrator and Enterprise Resource Planning implementer in Southeast Europe.

As a certified QlikView designer and developer who worked on implementations across multitude of manufacturing, distribution and retail industries I have great experience in solving real-life clients problems with QlikView.

I worked on numerous implementations where as a part of sales process QlikView's power is demonstrated in only three days and clients get their specific business problems solved.

I also work with Microsoft Dynamics AX 2012, one of the best ERP in the world, so my students can benefit from the expertise I have in implementing and consulting on business software.

Ready to start learning?
Take This Course