image
The Ultimate Drawing Course Beginner to Advanced...
$179
$79
image
User Experience Design Essentials - Adobe XD UI UX...
$179
$79
Total:
$659

Description

Please note, some of the resources in this course are located on Dropbox or GitHub, hence you will need to use the supplied URL to download files e.g. Software
A warm welcome to you.
If you have found yourself in a situation where you need or want to learn
QlikView
for your job or a career move and do not have the budget to spend thousands for training or you are frustrated with disorganised video clips all over the internet, then this course is definitely for you.
This course is also available via Udemy For Business (UFB)
.
Once you have completed this course you can hit the ground running at work when your team leaders , users, managers want you to deliver an analytics solution fast.
This course is packed with
sample data
that you can
download
,
project assignments and quizzes
for you to practice and test your new skills and what's more you don't need to do 2 separate courses for
Designer
or 
Developer
it's all here in the one course and I am adding new content frequently which means you have
life time access
to a rich source of information and tuition that will never get out of date.
What's more, this course has been recorded in
1080p HD
 , 
HD Sound
and features 
Closed Captions [CC]
.
Do you like what you see so far ?  
Then don't wait, enrol in this course and get a head start with the latest version(12) 
QlikView
, and with a
30 day money back guarantee
 , nothing to lose, right ?
I am looking forward to helping you gain new skills during this course.
Paul
Data Analyst and Visualisation Engineer
Who this course is for:
Anyone that wants to learn QlikView from scratch and get productive at work quickly
Supplement your learning towards certification
Analytics Prоfеѕѕiоnаlѕ
Developers looking to supplement what they already know about QlikView
BI/ETL/DW Professionals
Prоjесt Managers
Job seekers looking to answer tough interview questions (e.g Describe the Symbol Table Types ?)
Tеѕting Prоfеѕѕiоnаlѕ
Buѕinеѕѕ аnd Rероrting рrоfеѕѕiоnаlѕ
Grаduаtеѕ building a career in data Visualisation & Anаlуѕiѕ
Business Analysts
QlikSense Developers and Users (supplement your skills with QlikView skills such as Set Analysis)

What you'll learn

Handle interview questions with ease

Start developing solutions for your company as soon as you have finished this course

Receive an achievement based certificate. This is based on your test results so you can show the world your skill levels

Understand and apply Associative Data Modelling concepts

Learn about different Model Schema types

Learn to code Joins & understand how they work

Learn how the Associative Data Model is stored internally

Learn how to load and connect to different data sources (e.g. SQL, Web )

Code Scripts for ETL data processing

Learn to code calculations using Set Analysis

How to code What-If analysis

14 Assignment projects for hands on practice, followed by Quizzes testing your knowledge

Learn charting best practices

Learn about advanced calculation functions like Aggr() , Rank() , IntervalMatch()

Create Charts such as Gauges, Pie, Bar, Combo, Line, Tornado, Heat Maps, Scatter

Learn performance tuning for charts and scripting

Add actions and conditions to charts and other objects

Apply many of your new skills to QlikSense e.g. Modelling, Set Analysis

Over 150 Quiz test questions for you to check your learning progress

Real world sample data available for download and analysis

Install QlikView 12 (and SQLServer express if you want to connect to sample SQL databases)

Requirements

  • You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
  • No previous design experience is needed.
  • No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures
Expand All Sections
1-Your QlikView Journey Begins Here
9
1.1-Course Introduction
1.2-Download And Install QlikView Personal Edition Software (See resources link)
1.3-Download And Install SQL Server Express
1.4-Get Your Data from Dropbox and Restore the Insurance Database
1.5-Features Available During Lecture Playback
1.6-Navigating The QlikView Desktop
1.7-Create Document Content Using Wizards
1.8-Homework Assignment 1.1
1.9-Test Yourself
2-Data Modelling In QlikView
10
2.1-Introduction to the Associative Model
2.2-The Star Schema
2.3-The Snowflake Schema
2.4-Homework Assignment 2.1
2.5-The Synthetic Key And Your Model
2.6-Circular Reference (Loops) Break Your Model
2.7-Link Table(s) In Your Model - Part 1
2.8-Link Tables(s) In Your Model - Part 2
2.9-Homework Assignment 2.2
2.10-Test Yourself
3-Coding Joins In The Script
7
3.1-The Inner Join
3.2-The Left Join
3.3-The Right Join
3.4-The Outer Join
3.5-Homework Assignment 3.1
3.6-Homework Assignment 3.1 Solution
3.7-Test Yourself
4-Scripting The ETL (Extract, Transform, Load)
13
4.1-What IS ETL Exactly ?
4.2-ETL-1 SQL And The Inline Load (Part 1)
4.3-ETL-1 SQL And The Inline Load (Part 2)
4.4-ETL-1 SQL And The Inline Load (Part 3)
4.5-ETL-1 SQL And The Inline Load (Part 4)
4.6-ETL-2 Loading From Disparate Data Sources (Part 1)
4.7-ETL-2 Loading From Disparate Data Sources (Part 2)
4.8-ETL-3 The Incremental Load (Part 1)
4.9-ETL-3 The Incremental Load (Part 2)
4.10-ETL-4 The Slowly Changing Dimension (SCD)
4.11-Homework Assignment 4.1
4.12-Homework Assignment 4.1 Solution
4.13-Test Yourself
5-Develop Your First Dashboard
11
5.1-Introduction to What's Ahead
5.2-QlikView Basic Aggregations
5.3-Create Filters and a Current Selections Box
5.4-The Combo Chart with Calculated Dimensions
5.5-The Combo Chart with Object Cloning
5.6-Dimension Limiting with Aggregation Scope
5.7-Conditional Colour Coding
5.8-The Pivot Table
5.9-Homework Assignment 5.1
5.10-Homework Assignment 5.1 Solution
5.11-Test Yourself
6-Preparation For Your Enterprise Solution Development
5
6.1-Data Visualization Best Practice
6.2-Initial Data Model Load Incl. Mapping Load
6.3-Initial Data Model Load Incl. Concatenated Load
6.4-Initial Data Model Load Incl. Reduced Data Load
6.5-Test Yourself
7-The KPI
6
7.1-All About Metrics & KPI's
7.2-How to Code a Simple KPI
7.3-Coding the KPI to Show Difference in Value
7.4-Homework Assignment 7.1
7.5-Homework Assignment 7.1 Solution
7.6-Test Yourself
8-Explore And Develop Charts
12
8.1-The Straight Table And The Mini Chart
8.2-Adding Drill Down & Cyclic Groups to the Straight Table
8.3-The Line Chart With Dual Axes
8.4-The Bar Chart with Classed (Discretized) Data
8.5-Converting the Bar Chart to a Combo Chart
8.6-How to Utilize a Gauge Chart
8.7-How to Make a Butterfly Chart (aka Tornado Chart) Part 1
8.8-How to Make a Butterfly Chart (aka Tornado Chart) Part 2
8.9-The Scatter Chart
8.10-Homework Assignment 8.1
8.11-Homework Assignment 8.1 Solution
8.12-Test Yourself
9-Implement An SCD Type 2 In Our Solution
5
9.1-How the IntervalMatch() Function Helps With Time Series Data
9.2-Exploiting The Container Object
9.3-Homework Assignment 9.1
9.4-Homework Assignment 9.1 Solution
9.5-A Quick Quiz
10-Understand And Code Set Analysis
10
10.1-Set Analysis an Overview (Primer)
10.2-Code a KPI Set Expression (Part 1)
10.3-Code a KPI Set Expression (Part 2)
10.4-Using Date Based Set Expressions In Charts
10.5-Spanning Date Ranges In Set Expressions Using Date Functions
10.6-Simple Set Expression for YTD Line Charts
10.7-Create a Set Expression to Compute Rolling 3 Month Sales
10.8-Homework Assignment 10.1
10.9-Homework Assignment 10.1 Solution
10.10-Test Yourself
11-The Magic Of Variables
8
11.1-Getting Started With Variables
11.2-Defining Naming Standards for Variables
11.3-Handling Punctuated String Expressions In Variables
11.4-Conditional Colouring Expression Variables for Charts
11.5-Constructing a What-If Tool for Our Users
11.6-Homework Assignment 11.1
11.7-Homework Assignment 11.1 Solution
11.8-Test Yourself
12-The Calculated Dimension & Conditional Objects
10
12.1-Calculated Dimensions Control Chart Dimensionality
12.2-Ranking a Dimension Utilizing the Aggr() Function (Part 1)
12.3-Ranking a Dimension Utilizing the Aggr() Function (Part 2)
12.4-Getting Started With Conditional Objects & Triggers
12.5-Hiding & Displaying Document Objects
12.6-Conditional Dimensions & Sheet Triggers
12.7-Conditional Expressions
12.8-Homework Assignment 12.1
12.9-Homework Assignment 12.1 Solution
12.10-Test Yourself
13-Alternate States & Comparative Analysis
6
13.1-Getting Started With Alternate States
13.2-Implementing Alternate States - Set Analysis
13.3-Implementing Alternate States - In the Aggr() Function
13.4-Homework Assignment 13.1
13.5-Homework Assignment 13.1 Solution
13.6-Test Yourself
14-How to Secure Your Document
5
14.1-Introduction & Basic Security Options
14.2-How to Implement Section Access in The Document
14.3-Homework Assignment 14.1
14.4-Homework Assignment 14.1 Solution
14.5-Test Yourself
15-A Conversation About Document Tuning
5
15.1-Getting Started With Data Model Statistics
15.2-The Model Exposed at the Symbol Level
15.3-The Optimized Load
15.4-Tips for Tuning Scripts & Expressions
15.5-Test Yourself
16-Introducing More QlikView Features
8
16.1-How to Make a Straight Table From a Cross Table
16.2-Using Bookmarks To Save Your Discovery and Insight
16.3-How to code a Master Calendar script
16.4-Using Autonumber() To Create Unique ID's
16.5-Homework Assignment 16.1
16.6-Homework Assignment 16.1 Solution
16.7-Test Yourself
16.8-How to request your Quiz based Training Certificate