The Complete QlikView Boot Camp

The Complete QlikView Boot Camp, available at $174.99, has an average rating of 4.48, with 114 lectures, 16 quizzes, based on 6808 reviews, and has 29749 subscribers.

You will learn about 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) This course is ideal for individuals who are Anyone that wants to learn QlikView from scratch and get productive at work quickly or Supplement your learning towards certification or Analytics Prоfеѕѕiоnаlѕ or Developers looking to supplement what they already know about QlikView or BI/ETL/DW Professionals or Prоjесt Managers or Job seekers looking to answer tough interview questions (e.g Describe the Symbol Table Types ?) or Tеѕting Prоfеѕѕiоnаlѕ or Buѕinеѕѕ аnd Rероrting рrоfеѕѕiоnаlѕ or Grаduаtеѕ building a career in data Visualisation & Anаlуѕiѕ or Business Analysts or QlikSense Developers and Users (supplement your skills with QlikView skills such as Set Analysis) It is particularly useful for Anyone that wants to learn QlikView from scratch and get productive at work quickly or Supplement your learning towards certification or Analytics Prоfеѕѕiоnаlѕ or Developers looking to supplement what they already know about QlikView or BI/ETL/DW Professionals or Prоjесt Managers or Job seekers looking to answer tough interview questions (e.g Describe the Symbol Table Types ?) or Tеѕting Prоfеѕѕiоnаlѕ or Buѕinеѕѕ аnd Rероrting рrоfеѕѕiоnаlѕ or Grаduаtеѕ building a career in data Visualisation & Anаlуѕiѕ or Business Analysts or QlikSense Developers and Users (supplement your skills with QlikView skills such as Set Analysis).

Enroll now: The Complete QlikView Boot Camp

Summary

Title: The Complete QlikView Boot Camp

Price: $174.99

Average Rating: 4.48

Number of Lectures: 114

Number of Quizzes: 16

Number of Published Lectures: 114

Number of Published Quizzes: 16

Number of Curriculum Items: 130

Number of Published Curriculum Objects: 130

Original Price: $199.99

Quality Status: approved

Status: Live

What You Will 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)

Who Should Attend

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)

Target Audiences

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)

A warm welcome to you.

If you have found yourself in a situation where you need or want to learn QlikViewfor 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 datathat 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 Developerit’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

Course Curriculum

Chapter 1: Your QlikView Journey Begins Here

Lecture 1: Course Introduction

Lecture 2: Download And Install QlikView Personal Edition Software (See resources link)

Lecture 3: Download And Install SQL Server Express

Lecture 4: How To Get Your Project Data From Dropbox

Lecture 5: Quick Tips And Links

Lecture 6: Navigating The QlikView Desktop

Lecture 7: Create Document Content Using Wizards

Lecture 8: Mission Assignment #1 If You Choose To Accept It

Chapter 2: Data Modelling In QlikView

Lecture 1: Introduction to the Associative Model

Lecture 2: The Star Schema

Lecture 3: The Snowflake Schema

Lecture 4: Mission Assignment #2 If You Choose To Accept It

Lecture 5: The Synthetic Key And Your Model

Lecture 6: Circular Reference (Loops) Break Your Model

Lecture 7: Link Table(s) In Your Model – Part 1

Lecture 8: Link Tables(s) In Your Model – Part 2

Lecture 9: Mission Assignment #3 If You Choose To Accept It

Chapter 3: Coding Joins In The Script

Lecture 1: The Inner Join

Lecture 2: The Left Join

Lecture 3: The Right Join

Lecture 4: The Outer Join

Lecture 5: Mission Assignment #4 If You Choose To Accept It

Lecture 6: Mission #4 Solution Explanation

Chapter 4: Scripting The ETL (Extract, Transform, Load)

Lecture 1: What IS ETL Exactly ?

Lecture 2: ETL-1 SQL And The Inline Load (Part 1)

Lecture 3: ETL-1 SQL And The Inline Load (Part 2)

Lecture 4: ETL-1 SQL And The Inline Load (Part 3)

Lecture 5: ETL-1 SQL And The Inline Load (Part 4)

Lecture 6: ETL-2 Loading From Disparate Data Sources (Part 1)

Lecture 7: ETL-2 Loading From Disparate Data Sources (Part 2)

Lecture 8: ETL-3 The Incremental Load (Part 1)

Lecture 9: ETL-3 The Incremental Load (Part 2)

Lecture 10: ETL-4 The Slowly Changing Dimension (SCD)

Lecture 11: Mission Assignment #5 If You Choose To Accept It

Lecture 12: Mission #5 Solution Explanation

Chapter 5: Develop Your First Dashboard

Lecture 1: Getting Started

Lecture 2: Basic Aggregations Overview

Lecture 3: Adding Filters & Current Selections Object

Lecture 4: The Combo Chart & Calculated Dimensions

Lecture 5: The Combo Chart & Object Cloning

Lecture 6: Dimension Limiting & Aggregation Scope

Lecture 7: Coding Conditional Colours

Lecture 8: The Pivot Table

Lecture 9: Mission #6 If You Choose To Accept It

Lecture 10: Mission #6 Solution Explanation

Chapter 6: Preparation For Your Enterprise Solution Development

Lecture 1: Visualisation Best Practices

Lecture 2: Initial Data Model Load Incl. Mapping Load

Lecture 3: Initial Data Model Load Incl. Concatenated Load

Lecture 4: Initial Data Model Load Incl. Reduced Data Load

Chapter 7: The KPI

Lecture 1: A Conversation Around Metrics & KPI's

Lecture 2: Coding A Simple KPI

Lecture 3: Coding a KPI With A Calculation

Lecture 4: Mission Assignment #7 If You Choose To Accept It

Lecture 5: Mission #7 Solution Explanation

Chapter 8: Explore And Develop Charts

Lecture 1: The Straight Table And The Mini Chart

Lecture 2: The Straight Table With Drill Down & Cyclic Groups

Lecture 3: The Line Chart With Dual Axes

Lecture 4: The Bar Chart & Classed Data

Lecture 5: The Bar Chart Becomes A Combo Chart

Lecture 6: The Gauge Chart

Lecture 7: The Butterfly Chart (aka Tornado Chart) Part 1

Lecture 8: The Butterfly Chart (aka Tornado Chart) Part 2

Lecture 9: The Scatter Chart

Lecture 10: Mission Assignment #8 If You Choose To Accept It

Lecture 11: Mission #8 Solution Explanation

Chapter 9: Implement An SCD Type 2 In Our Solution

Lecture 1: The IntervalMatch() Function

Lecture 2: Exploiting The Container Object

Lecture 3: Mission Assignment #9 If You Choose To Accept It

Lecture 4: Mission #9 Solution Explanation

Chapter 10: Understand And Code Set Analysis

Lecture 1: What Is Set Analysis ?

Lecture 2: Coding KPI's (Part 1)

Lecture 3: Coding KPI's (Part 2)

Lecture 4: Dates, Set Analysis and Charting

Lecture 5: Date Spans In Set Analysis e.g. MTD with MonthStart()

Lecture 6: Date Spans In Set Analysis & The Dual() Function

Lecture 7: Embedding Multiple Functions Inside Set Analysis

Lecture 8: Mission Assignment #10 If You Choose To Accept It

Lecture 9: Mission #10 Solution Explanation

Chapter 11: The Magic Of Variables

Lecture 1: Getting Started With Variables

Instructors

Paul Scotchford
Data Analyst and Qlik Development Specialist @ awari

Rating Distribution

1 stars: 69 votes
2 stars: 89 votes
3 stars: 572 votes
4 stars: 2412 votes
5 stars: 3666 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu