arrow_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