Business Intelligence With QlikView - 0 To Full Sales App
- 2.5 hours on-demand video
- 4 articles
- 7 downloadable resources
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Get your team access to 4,000+ top Udemy courses anytime, anywhere.Try Udemy for Business
- 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:
- Build QlikView application that analyzes sales data provided in the course
- Get the experience with real-life business data that companies analyze
- Learn general concepts of data analysis and Business Intelligence
- Analyze business data from external data sources
- Replace Excel on all projects related to data analysis and visualization
- 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.
- 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
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.
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.
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.
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.
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.
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.
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.
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.
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.