Preview QlikView Tutorials: Beginner To Advanced

Back

promo video

Basics of QlikView

FAQ 1

2 Why To Choose This Course

3 introduction

4 QlikView Installation

5 SQL Server Installation

6 Restore Database in SQl Server

7 Navigating Qlikview

8 Create Document Using Wizard

9 Assignment 1 Member cover

2 Data modeling in QlikView

1 What is Associative Model

2 Fact Dimension

3 Star SnowFlake Schema

4 What is Star Fact Dimension

5 Star Schema

6 Synthetic Keys

7 What SnowFlake

8 SnowFlake Schema

9 Synthetic Key and Your Model

10 Circular Reference

11 Link Table in Your Model Part 1

12 Link Table in Your Model Part 2

Circular Reference Resources

link table notes

Product Sales Sample Tables

Synthetic Keys and Your Data Model

What-is-Synthetic-Keys

3 Coding Joins in the Script

Inner Join

Inner Join Resources

Dim Insurance Members

Fact Insurance Members Claims

Left Join

Left Join Resources

Dim Insurance Members

Fact Employer Contributions

Outer Join

Outer Join Resources

Dim Insurance Members User Supplied

Fact Member Cover User Supplied

4 Scripting the ETL (Extract Transform Load)

1 What is ETL

2 QVD File

3 ETL 1 SQL and Inline Load

ETL 1.1

ETL 1.2

ETL 1.3

ETL 1.4

ETL 2.1 Loading From Disparate Data Sources

ETL 2.1

ETL 2.1 Notes

Geo Location

Inventory+Analytics

Sales Budgets

Sale Type

ETL 2.2 Loading From Disparate Data Sources

ETL 2.2

ETL 3.1 Incremental Load

ETL 3.1

Incremental Load Steps

ETL 3.2 Incremental Load

ETL 3.2

5 Develop Your First Dashboard

1 Getting Started

2 Basic aggr() Function

3 Adding Filter and Current Selection Object

4 Combo Chart and Calculated Dimension

5 Combo Chart and Object Cloning

6 Dimension Limiting and Aggregation Scope

7 Coding Conditional Colours

8 Pivot Table 8

Adding Filter And Current Selection Object Resources

Basic Aggr() Function Resources

6 Preparation for Your Enterprise Solution Development

1 Visualization Best Practises

2 Initial Data Model Load Incl. Mapping Load

3 Initial Data Model Load Incl. Concatenated Load

4 Initial Data Model Load Incl. Reduced Load

Concatenated Load Notes

Mapping Load Notes

7 KPI

What is KPI 1

2 Coding A Simple KPI

3 Coding KPI With Calculation

8 Explore and Develop Charts

1 Straight Table And Mini Chart

2 Straight Table With Drilldown And Cyclic Groups

3 Line Chart With Dual Axis

4 Bar Chart With Classed Data

5 Bar Chart Becomes A Combo Chart

6 Guage Chart

7 Butterfly Chart 1

8 Butterfly Chart 2

9 Scatter Chart

Scatter+chart+notes

drill+down+cyclic+groups+notes

9 Implement SCD Type 2 in Colution

Interval Match Function

Container Object

Currency Price History

Interval Match Notes

10 Code Set Analysis

1 What is Set Analysis

2 Coding KPI 1

3 Coding KPI 2

4 Set Analysis Using Dates

Set Analysis Notes

11 Variables

1 Getting Started With Variable

2 Naming Standard Variables Notes

3 Handling Complex String Expression In Variables

4 Using A Variable For Conditional Coloring Of Charts

5 What If Analysis

Getting Started With Variables Notes

Naming Standard Variables Notes

What if Analysis Notes

12 Calculated Dimension and Conditional Objects

1 How to Create a Calculated Dimension

2 Ranking Dimension With Aggregation Function 1

AGGR() Function 1 Notes

3 Ranking Dimension With Aggregation Function 1

4 Conditional Objects and Triggers

5 Conditional Dimension

6 Conditional Expression

Conditional Dimension Notes

AGGR() Function 1 Notes

13 Alternate State

1 Getting Started With Alternate State

2 Alternate State Set Analysis

Preview - QlikView Tutorials: Beginner To Advanced