Course Description

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.

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.

When you have passed all of the course tests then you can qualify for the Awari Certificate that is a graded certificate showcasing your level of achievement ranging from Completed to Distinction  level.

Here's the facts ...

  1. Recorded in 1080p HD (Scalable to all devices and resolutions)
  2. HD Sound 
  3. With Closed Captions [CC]
  4. 14 Project assignments for you to practice what you have learned
  5. Over 160 test questions to test your skills
  6. Safe & Secure payment through PayPal or Credit Card 

Checkout the introduction video, if you like what you see then don't wait ! Invest just $9.99 (yes you read this correctly, just $9.99 no catches and life time access to the course !!) in your career and get a head start with the latest QlikView (12)  plus a money back guarantee , nothing to lose, right ?

I am looking forward to helping you gain new skills during this course.

Best

Paul

Lead Instructor @

Data Analyst , Qlik Dev, SQL Dev

Awari School of Analytics : Paul Scotchford

Hello and Welcome,My name is Paul Scotchford and I am thrilled that you are reading this.As well as my normal consulting work in Australian business and govt teach I here at the Awari School of Analytics. There are 3 very distinct technology specialisations I work with and these are the QlikView, QlikSense and SQL Server for delivering Data Analytics and Visualisations.QlikView and QlikSenseProfessionally I have been delivering QlikView  solutions to business and government users for the past 5 years and QlikSense since it first released in 2014. Qlik delivers these products to the market and is an industry leader in the BI and Analytics world.SQL ServerI have been delivering data analytics with the SQL Server (Tech Stack) for more than 14 years as this technology (in my humble opinion) is the best Relational Database and Data Warehouse (Mart) product on the market and will continue to be well into the future.SummaryBecause of my passion and experience working with these technologies in the real-world you can be assured that you will be getting first class training from my courses here on Awari School of Analytics.I am super stoked and looking forward to sharing my ongoing experience and passion for data analytics with you. Looking forward to seeing you in one of my courses soon.KindlyPaul

Course curriculum

  • 1

    Chapter 1 : Your QlikView Journey Begins Here

    • Lecture 1 - Course introduction

    • Lecture 2 - Download and install QlikView (free software)

      FREE PREVIEW

    • Lecture 3 - Download & Install SQL Server Express 2014

    • Lecture 4 - How to connect to Dropbox, Download SQL Db and restore

    • Note - Your Sample Data For This Chapter is @ The Below Link

    • Lecture 5 - Quick Tips & General Tips

    • Lecture 6 - Navigating the QV Desktop

    • Lecture 7 - Create Document content with wizards

    • Lecture 8 - Project Assignment # 1 (Incl. Solution)

    • Chapter 1 - Knowledge Test
  • 2

    Chapter 2 : The Associative Data Model

    • Note - Your Sample Data For This Chapter is @ The Below Link

    • Lecture 9 - Introduction To The Associative Data Model

    • Lecture 10 - The Star Schema

    • Lecture 11 - The Snowflake Schema

    • Lecture 12 - Project Assignment #2 (Incl. Solution)

    • Lecture 13 - The Synthetic Key And Your Model

    • Lecture 14 - Circular Reference (Loops) Break Your Model

    • Lecture 15 - Link Table(s) In Your Model - Part 1

    • Lecture 16 - Link Tables(s) In Your Model - Part 2

    • Lecture 17 - Project Assignment #3 (Incl. Solution)

    • Chapter 2 - Knowledge Test
  • 3

    Chapter 3 : Coding Joins Via The Load Script

    • Note - Your Sample Data For This Chapter is @ The Below Link

    • Lecture 18 - The Inner Join Explained & Coded

      FREE PREVIEW

    • Lecture 19 - The Left Join Explained & Coded

    • Lecture 20 - The Right Join Explained & Coded

    • Lecture 21 - The Outer Join Explained & Coded

    • Lecture 22 - Project Assignment # 4

    • Lecture 23 - Solution To Project Assignment #4

    • Chapter 3 - Knowledge Test
  • 4

    Chapter 4 : ETL Scripting For Data Extraction

    • Note - Your Sample Data For This Chapter Is @ The Below Link

    • Lecture 24 - What is ETL Exactly ?

    • Lecture 25 - ETL-1 SQL And The Inline Load (Part 1)

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

    • Lecture 27 - ETL-1 SQL And The Inline Load (Part 3)

    • Lecture 28 -ETL-1 SQL And The Inline Load (Part 4)

    • Lecture 29 - ETL-2 Loading From Disparate Data Sources (Part 1)

    • Lecture 30 - ETL-2 Loading From Disparate Data Sources (Part 2)

    • Lecture 31 - ETL-3 The Incremental Load (Part 1)

    • Lecture 32 - ETL-3 The Incremental Load (Part 2)

    • Lecture 33 - ETL-4 The Slowly Changing Dimension (SCD)

    • Lecture 34 - Project Assignment #5

      FREE PREVIEW

    • Lecture 35 - Solution To Project Assignment #5

    • Chapter 4 - Knowledge Test
  • 5

    Chapter 5 : Create Your First Dashboard Solution

    • Note - Your Sample Data For This Chapter is @ The Below Link

    • Lecture 36 - Getting Started

      FREE PREVIEW

    • Lecture 37 - Basic Aggregations Overview

    • Lecture 38 - Adding Filters & Current Selections Object

    • Lecture 39 - The Combo Chart & Calculated Dimensions

    • Lecture 40 - The Combo Chart & Object Cloning

    • Lecture 41 - Dimension Limiting & Aggregation Scope

    • Lecture 42 - Coding Conditional Colours

    • Lecture 43 - The Pivot Table

    • Lecture 44 - Project Assignment #6

    • Lecture 45 - Solution To Project Assignment #6

    • Chapter 5 - Knowledge Test
  • 6

    Chapter 6 : Preparation For Your Enterprise Solution Build

    • Lecture 46 - Visualisation Best Practices

    • Lecture 47 - Initial Data Model Load Incl. Mapping Load

    • Lecture 48 - Initial Data Model Load Incl. Concatenated Load

    • Lecture 49 - Initial Data Model Load Incl. Reduced Data Load

    • Chapter 6 - Knowledge Test
  • 7

    Chapter 7 : Coding KPI's

    • Lecture 50 - A Conversation Around Metrics & kPI's

    • Lecture 51 - Coding A Simple KPI

      FREE PREVIEW

    • Lecture 52 - Coding a KPI With A Calculation

    • Lecture 53 - Project Assignment #7

    • Lecture 54 - Solution To Project Assignment #7

    • Chapter 7 - Knowledge Test
  • 8

    Chapter 8 : Creating Charts For Data Visualisation

    • Lecture 55 - The Straight Table And The Mini Chart (Sparkline)

    • Lecture 56 - The Straight Table With Drill Down & Cyclic Groups

    • Lecture 57 - The Line Chart With Dual Axes

    • Lecture 58 - The Bar Chart & Classed Data

    • Lecture 59 - The Bar Chart Becomes A Combo Chart

    • Lecture 60 - The Gauge Chart

    • Lecture 61 -The Butterfly Chart (aka Tornado Chart) Part 1

    • Lecture 62 - The Butterfly Chart (aka Tornado Chart) Part 2

    • Lecture 63 - The Scatter (plot) Chart

    • Lecture 64 - Project Assignment #8

      FREE PREVIEW

    • Lecture 65 - Solution To Project Assignment #8

    • Chapter 8 - Knowledge Test
  • 9

    Chapter 9 : Implement The Slowly Changing Dimension Within Our Solution

    • Lecture 66 - The IntervalMatch() Function

    • Lecture 67 - Exploiting The Container Object

    • Lecture 68 - Project Assignment #9

    • Lecture 69 - Solution To Project Assignment #9

    • Chapter 9 - Knowledge Test

    • Your feedback matters, please partake in this very short survey to help improve this course.
  • 10

    Chapter 10 : Understanding How Set Analysis Works

    • Lecture 70 - What Is Set Analysis ?

    • Lecture 71 - Coding KPI's (Part 1)

    • Lecture 72 - Coding KPI's (Part 2)

    • Lecture 73 - Dates, Set Analysis and Charting

    • Lecture 74 - Date Spans In Set Analysis e.g. MTD with MonthStart()

    • Lecture 75 - Date Spans In Set Analysis & The Dual() Function

    • Lecture 76 - Embedding Multiple Functions Inside Set Analysis

    • Lecture 77 - Project Assignment #10

    • Lecture 78 - Solution To Project Assignment #10

    • Chapter 10 - Knowledge Test
  • 11

    Chapter 11 : The Magic Of Variables

    • Lecture 79 - Getting Started With Variables

    • Lecture 80 - A Conversation Around Naming Standards Of Variables

    • Lecture 81 - Handling Complex String Expressions In Variables

    • Lecture 82 - Using A Variable For Conditional Colouring In The Chart

    • Lecture 83 - How To Do What If Analysis

    • Lecture 84 - Project Assignment #11

    • Lecture 85 - Solution To Project Assignment #11

    • Chapter 11 - Knowledge Test
  • 12

    Chapter 12 : Calculated Dimensions and Conditionals

    • Note - Your Sample Data For This Chapter is @ The Below Link

    • Lecture 86 - How To Create A Calculated Dimension

    • Lecture 87 - A Ranking Dimension With Aggr() Function (Part 1)

    • Lecture 88 - A Ranking Dimension With Aggr() Function (Part 2)

    • Lecture 89 - Getting Started With Conditional Objects & Triggers

    • Lecture 90 - Hide & Display Objects

    • Lecture 91 - Conditional Dimensions & Sheet Triggers

    • Lecture 92 - Conditional Expressions

    • Lecture 93 - Project Assignment #12

    • Lecture 94 - Solution To Project Assignment #12

    • Chapter 12 - Knowledge Test
  • 13

    Chapter 13 : Alternate States

    • Lecture 95 - Getting Started With Alternate States

    • Lecture 96 - Implementing Alternate States - Set Analysis

    • Lecture 97 - Implementing Alternate States - Aggr()

    • Lecture 98 - Project Assignment #13

    • Lecture 99 - Solution To Project Assignment #13

    • Chapter 13 - Knowledge Test
  • 14

    Chapter 14 : Securing Your Document

    • Lecture 100 - Introduction & Basic Security Options

    • Lecture 101 - Applying Section Access To The Document

    • Lecture 102 - Project Assignment #14

    • Lecture 103 - Solution To Project Assignment #14

    • Chapter 14 - Knowledge Test
  • 15

    Chapter 15 : A Conversation About Document Tuning

    • Lecture 104 - Getting Started

    • Lecture 105 - The Model Exposed

    • Lecture 106 - The Optimised Load

    • Lecture 107 - Script & Expression Tuning Tips

    • Chapter 15 - Knowledge Test
  • 16

    Chapter 16 : Introducing More QlikView Features

    • Note - Your Sample Data For This Chapter is @ The Below Link

    • Lecture 108 - Convert A Cross Table Into A Straight Table

    • Lecture 109 - Using Bookmarks To Save Your Discoveries

    • Lecture 110 - Code A Script To Create A Master Calendar From Scratch

    • Lecture 111 - Using Autonumber() To Create Unique ID's

    • Lecture 112 - Project Assignment #15

    • Lecture 113 - Solution To Project Assignment #15

    • Chapter 16 - Knowledge Test

Reviews

Why not grab QlikSense training as well to complement your Qlik skills, and a free course in SQL query code development.

  • Free

    FreeThe Hitch Hikers Guide to Writing SQL Queries

    Enroll Free

  • $9.99

    $9.99Practical QlikSense Business Analyst Training

    Buy Now