|
|
001 Bookmarks.mp4
|
MP4
|
34.1 MB
|
|
|
001 Bookmarks_en.vtt
|
VTT
|
6.8 KB
|
|
|
001 Course Outro.mp4
|
MP4
|
40.7 MB
|
|
|
001 Course Outro_en.vtt
|
VTT
|
2.6 KB
|
|
|
001 Intro to the Course.mp4
|
MP4
|
70.2 MB
|
|
|
001 Intro to the Course_en.vtt
|
VTT
|
5.1 KB
|
|
|
001 Section 2 intro.mp4
|
MP4
|
32 MB
|
|
|
001 Section 2 intro_en.vtt
|
VTT
|
2.5 KB
|
|
|
001 Section 3 Intro.mp4
|
MP4
|
28.6 MB
|
|
|
001 Section 3 Intro_en.vtt
|
VTT
|
2.4 KB
|
|
|
001 Section 4 Intro.mp4
|
MP4
|
34.7 MB
|
|
|
001 Section 4 Intro_en.vtt
|
VTT
|
2.7 KB
|
|
|
001 Section 5 intro.mp4
|
MP4
|
26.1 MB
|
|
|
001 Section 5 intro_en.vtt
|
VTT
|
2.2 KB
|
|
|
001 Section 6 Intro.mp4
|
MP4
|
20.4 MB
|
|
|
001 Section 6 Intro_en.vtt
|
VTT
|
1.8 KB
|
|
|
002 Intro to the script editor.mp4
|
MP4
|
49 MB
|
|
|
002 Intro to the script editor_en.vtt
|
VTT
|
14.1 KB
|
|
|
002 Intro to variables.mp4
|
MP4
|
36.2 MB
|
|
|
002 Intro to variables_en.vtt
|
VTT
|
8.3 KB
|
|
|
002 Introduction.mp4
|
MP4
|
44 MB
|
|
|
002 Introduction_en.vtt
|
VTT
|
2.3 KB
|
|
|
002 Loading our first dataset using the qlik associative engine.mp4
|
MP4
|
57.9 MB
|
|
|
002 Loading our first dataset using the qlik associative engine_en.vtt
|
VTT
|
11.5 KB
|
|
|
002 Loading start up data set.mp4
|
MP4
|
39.3 MB
|
|
|
002 Loading start up data set_en.vtt
|
VTT
|
7.9 KB
|
|
|
002 New section data load.mp4
|
MP4
|
63 MB
|
|
|
002 New section data load_en.vtt
|
VTT
|
11.6 KB
|
|
|
002 Story Telling using Qlik's inbuilt story mode.mp4
|
MP4
|
44.8 MB
|
|
|
002 Story Telling using Qlik's inbuilt story mode_en.vtt
|
VTT
|
9.6 KB
|
|
|
003 Checking our data and creating the data model.mp4
|
MP4
|
13.4 MB
|
|
|
003 Checking our data and creating the data model_en.vtt
|
VTT
|
3.1 KB
|
|
|
003 Data model transformation using Mapping function.mp4
|
MP4
|
54.1 MB
|
|
|
003 Data model transformation using Mapping function_en.vtt
|
VTT
|
11 KB
|
|
|
003 Loading data using the script editor.mp4
|
MP4
|
40.6 MB
|
|
|
003 Loading data using the script editor_en.vtt
|
VTT
|
10.2 KB
|
|
|
003 Magic of buttons. How to automatize your dashboard.mp4
|
MP4
|
44.2 MB
|
|
|
003 Magic of buttons. How to automatize your dashboard_en.vtt
|
VTT
|
8.9 KB
|
|
|
003 QVD viewer. What are they and why you should use them.mp4
|
MP4
|
37.4 MB
|
|
|
003 QVD viewer. What are they and why you should use them_en.vtt
|
VTT
|
8 KB
|
|
|
003 Setting up our free QlikSense business account.mp4
|
MP4
|
24.5 MB
|
|
|
003 Setting up our free QlikSense business account_en.vtt
|
VTT
|
1.9 KB
|
|
|
003 Using variables to load file paths.mp4
|
MP4
|
33.3 MB
|
|
|
003 Using variables to load file paths_en.vtt
|
VTT
|
6.3 KB
|
|
|
004 Change Qlik themes and default colors.mp4
|
MP4
|
15.1 MB
|
|
|
004 Change Qlik themes and default colors_en.vtt
|
VTT
|
3 KB
|
|
|
004 Embed links to external websites directly in your dashboard.mp4
|
MP4
|
11.6 MB
|
|
|
004 Embed links to external websites directly in your dashboard_en.vtt
|
VTT
|
2.3 KB
|
|
|
004 Inline load How to load manual data.mp4
|
MP4
|
12.6 MB
|
|
|
004 Inline load How to load manual data_en.vtt
|
VTT
|
3.5 KB
|
|
|
004 Intro to the Qlik Console.mp4
|
MP4
|
32.7 MB
|
|
|
004 Intro to the Qlik Console_en.vtt
|
VTT
|
2.6 KB
|
|
|
004 Loading entire Measures using variables.mp4
|
MP4
|
21.8 MB
|
|
|
004 Loading entire Measures using variables_en.vtt
|
VTT
|
5.2 KB
|
|
|
004 What are dimensions and measures.mp4
|
MP4
|
16.6 MB
|
|
|
004 What are dimensions and measures_en.vtt
|
VTT
|
3.6 KB
|
|
|
004 What are synthetic keys.mp4
|
MP4
|
29 MB
|
|
|
004 What are synthetic keys_en.vtt
|
VTT
|
7.7 KB
|
|
|
005 Data transformation using MapSubstring function.mp4
|
MP4
|
27.3 MB
|
|
|
005 Data transformation using MapSubstring function_en.vtt
|
VTT
|
5.4 KB
|
|
|
005 How to hide & Show charts based on needs.mp4
|
MP4
|
52.6 MB
|
|
|
005 How to hide & Show charts based on needs_en.vtt
|
VTT
|
8.1 KB
|
|
|
005 How to incorporate variables inside Set Expressions.mp4
|
MP4
|
26.8 MB
|
|
|
005 How to incorporate variables inside Set Expressions_en.vtt
|
VTT
|
5.6 KB
|
|
|
005 How to navigate the Qlik Sense Hub.mp4
|
MP4
|
52.4 MB
|
|
|
005 How to navigate the Qlik Sense Hub_en.vtt
|
VTT
|
4.5 KB
|
|
|
005 Overview of the sheet.mp4
|
MP4
|
58.6 MB
|
|
|
005 Overview of the sheet_en.vtt
|
VTT
|
15.2 KB
|
|
|
005 Resources to elevate your dashboards by using the right color scheme.mp4
|
MP4
|
31.7 MB
|
|
|
005 Resources to elevate your dashboards by using the right color scheme_en.vtt
|
VTT
|
6.5 KB
|
|
|
005 What are circular references.mp4
|
MP4
|
34 MB
|
|
|
005 What are circular references_en.vtt
|
VTT
|
9 KB
|
|
|
006 Building a cool, interactive target startup selector dashboard.mp4
|
MP4
|
98.6 MB
|
|
|
006 Building a cool, interactive target startup selector dashboard_en.vtt
|
VTT
|
17.1 KB
|
|
|
006 Building our first dashboard - Part 1.mp4
|
MP4
|
53.6 MB
|
|
|
006 Building our first dashboard - Part 1_en.vtt
|
VTT
|
11.3 KB
|
|
|
006 Data segmentation using IF & Interval Match.mp4
|
MP4
|
72.2 MB
|
|
|
006 Data segmentation using IF & Interval Match_en.vtt
|
VTT
|
13.6 KB
|
|
|
006 Joining tables.mp4
|
MP4
|
44.3 MB
|
|
|
006 Joining tables_en.vtt
|
VTT
|
10.7 KB
|
|
|
006 Simplifying Date functions using variables.mp4
|
MP4
|
33.2 MB
|
|
|
006 Simplifying Date functions using variables_en.vtt
|
VTT
|
6.9 KB
|
|
|
007 Building our first dashboard - Part 2.mp4
|
MP4
|
41.8 MB
|
|
|
007 Building our first dashboard - Part 2_en.vtt
|
VTT
|
8 KB
|
|
|
007 Conditional load.mp4
|
MP4
|
48.5 MB
|
|
|
007 Conditional load_en.vtt
|
VTT
|
9.9 KB
|
|
|
007 Resident Loads & Group By.mp4
|
MP4
|
38.3 MB
|
|
|
007 Resident Loads & Group By_en.vtt
|
VTT
|
7.8 KB
|
|
|
007 Variables inside a variable aka Variable inception YTD inside Variables.mp4
|
MP4
|
68.7 MB
|
|
|
007 Variables inside a variable aka Variable inception YTD inside Variables_en.vtt
|
VTT
|
16.4 KB
|
|
|
008 Creating Master Measures.mp4
|
MP4
|
58.2 MB
|
|
|
008 Creating Master Measures_en.vtt
|
VTT
|
12.2 KB
|
|
|
008 Data classification using Class & Match function.mp4
|
MP4
|
34 MB
|
|
|
008 Data classification using Class & Match function_en.vtt
|
VTT
|
6.3 KB
|
|
|
008 Intro to Set expressions Part 1.mp4
|
MP4
|
32.1 MB
|
|
|
008 Intro to Set expressions Part 1_en.vtt
|
VTT
|
11.1 KB
|
|
|
008 Variable input Assign values to variables interactively in the dashboard.mp4
|
MP4
|
54.4 MB
|
|
|
008 Variable input Assign values to variables interactively in the dashboard_en.vtt
|
VTT
|
9.9 KB
|
|
|
009 Basic Master Calendar.mp4
|
MP4
|
81.9 MB
|
|
|
009 Basic Master Calendar_en.vtt
|
VTT
|
17.1 KB
|
|
|
009 Creating KPI charts & filters.mp4
|
MP4
|
66.1 MB
|
|
|
009 Creating KPI charts & filters_en.vtt
|
VTT
|
13.6 KB
|
|
|
009 Dashboard completion & Assigning field selections to variables.mp4
|
MP4
|
44.9 MB
|
|
|
009 Dashboard completion & Assigning field selections to variables_en.vtt
|
VTT
|
8.9 KB
|
|
|
009 Set expressions - Part 2.mp4
|
MP4
|
60.9 MB
|
|
|
009 Set expressions - Part 2_en.vtt
|
VTT
|
15.1 KB
|
|
|
010 Advanced Date Set expressions & calendar Flags.mp4
|
MP4
|
53.8 MB
|
|
|
010 Advanced Date Set expressions & calendar Flags_en.vtt
|
VTT
|
11 KB
|
|
|
010 Concatenating tables.mp4
|
MP4
|
35.7 MB
|
|
|
010 Concatenating tables_en.vtt
|
VTT
|
8.1 KB
|
|
|
010 How to create a What-IF Scenario analysis dashboard.mp4
|
MP4
|
72.8 MB
|
|
|
010 How to create a What-IF Scenario analysis dashboard_en.vtt
|
VTT
|
11.7 KB
|
|
|
010 Pimping our scatter plot with more features.mp4
|
MP4
|
44.4 MB
|
|
|
010 Pimping our scatter plot with more features_en.vtt
|
VTT
|
9 KB
|
|
|
011 Creating a new sheet and building our dashboard with a new focus.mp4
|
MP4
|
47.1 MB
|
|
|
011 Creating a new sheet and building our dashboard with a new focus_en.vtt
|
VTT
|
9.9 KB
|
|
|
011 How to create a side by side comparative analysis charts using Alternate States.mp4
|
MP4
|
61 MB
|
|
|
011 How to create a side by side comparative analysis charts using Alternate States_en.vtt
|
VTT
|
12.5 KB
|
|
|
011 Putting it together in our KPI dashboard.mp4
|
MP4
|
75.5 MB
|
|
|
011 Putting it together in our KPI dashboard_en.vtt
|
VTT
|
16.5 KB
|
|
|
011 Year on Year comparison Chart.mp4
|
MP4
|
21.7 MB
|
|
|
011 Year on Year comparison Chart_en.vtt
|
VTT
|
3.7 KB
|
|
|
012 Adding Distribution charts to the Dashboard.mp4
|
MP4
|
30.3 MB
|
|
|
012 Adding Distribution charts to the Dashboard_en.vtt
|
VTT
|
5.5 KB
|
|
|
012 Creating a Tree Map and more features.mp4
|
MP4
|
32.3 MB
|
|
|
012 Creating a Tree Map and more features_en.vtt
|
VTT
|
6.2 KB
|
|
|
012 Dashboard contd.mp4
|
MP4
|
34.3 MB
|
|
|
012 Dashboard contd_en.vtt
|
VTT
|
5.2 KB
|
|
|
013 Creating a combo chart.mp4
|
MP4
|
48.8 MB
|
|
|
013 Creating a combo chart_en.vtt
|
VTT
|
10.1 KB
|
|
|
013 Growth % & conditional coloring - Dashboard part 3.mp4
|
MP4
|
33.3 MB
|
|
|
013 Growth % & conditional coloring - Dashboard part 3_en.vtt
|
VTT
|
6.6 KB
|
|
|
013 intro to the Aggregate function.mp4
|
MP4
|
22.6 MB
|
|
|
013 intro to the Aggregate function_en.vtt
|
VTT
|
7 KB
|
|
|
014 Adding maps to the dashboard.mp4
|
MP4
|
96.8 MB
|
|
|
014 Adding maps to the dashboard_en.vtt
|
VTT
|
16.9 KB
|
|
|
014 Advanced calculations using AGGR, Rank & IF.mp4
|
MP4
|
69.5 MB
|
|
|
014 Advanced calculations using AGGR, Rank & IF_en.vtt
|
VTT
|
12.5 KB
|
|
|
014 Pivot Table.mp4
|
MP4
|
45.8 MB
|
|
|
014 Pivot Table_en.vtt
|
VTT
|
8.5 KB
|
|
|
015 Advanced calculations using Aggr & First Sorted Value.mp4
|
MP4
|
45.1 MB
|
|
|
015 Advanced calculations using Aggr & First Sorted Value_en.vtt
|
VTT
|
9.1 KB
|
|
|
015 Extra chapter on set expression Identifiers. $ vs 1 vs 1-$.mp4
|
MP4
|
25.6 MB
|
|
|
015 Extra chapter on set expression Identifiers. $ vs 1 vs 1-$_en.vtt
|
VTT
|
7.4 KB
|
|
|
016 Adding Load messages to your script editor for easy debug.mp4
|
MP4
|
64.6 MB
|
|
|
016 Adding Load messages to your script editor for easy debug_en.vtt
|
VTT
|
7.8 KB
|
|
|
016 Intro to elemental functions Possible() & Exclude().mp4
|
MP4
|
12.6 MB
|
|
|
016 Intro to elemental functions Possible() & Exclude()_en.vtt
|
VTT
|
4.7 KB
|
|
|
017 Using the exclude function E() in our dashboard.mp4
|
MP4
|
48.7 MB
|
|
|
017 Using the exclude function E() in our dashboard_en.vtt
|
VTT
|
11.3 KB
|
|
|
018 Using the Possible function P() in our dashboard.mp4
|
MP4
|
28.4 MB
|
|
|
018 Using the Possible function P() in our dashboard_en.vtt
|
VTT
|
8 KB
|
|
|
019 Putting it all together in the dashboard Part - 1.mp4
|
MP4
|
59.4 MB
|
|
|
019 Putting it all together in the dashboard Part - 1_en.vtt
|
VTT
|
11.8 KB
|
|
|
020 Putting it all together in the dashboard- Part 2.mp4
|
MP4
|
47.3 MB
|
|
|
020 Putting it all together in the dashboard- Part 2_en.vtt
|
VTT
|
7.6 KB
|
|
|
021 Basics of Running Total and Running Percentage.mp4
|
MP4
|
52.2 MB
|
|
|
021 Basics of Running Total and Running Percentage_en.vtt
|
VTT
|
10.6 KB
|
|
|
022 8020 Pareto Analysis chart.mp4
|
MP4
|
56.8 MB
|
|
|
022 8020 Pareto Analysis chart_en.vtt
|
VTT
|
12 KB
|
|
|
023 Pareto analysis or ABC analysis using Sorted AGGR function.mp4
|
MP4
|
95.7 MB
|
|
|
023 Pareto analysis or ABC analysis using Sorted AGGR function_en.vtt
|
VTT
|
18.6 KB
|
|
|
024 Completing our dashboard.mp4
|
MP4
|
45.6 MB
|
|
|
024 Completing our dashboard_en.vtt
|
VTT
|
7.7 KB
|
|
|
025 Completing our dashboard Part -2 . Fine tuning our ABC analysis chart.mp4
|
MP4
|
48.5 MB
|
|
|
025 Completing our dashboard Part -2 . Fine tuning our ABC analysis chart_en.vtt
|
VTT
|
8.7 KB
|
|
|
026 How to create SparkLines.mp4
|
MP4
|
50.9 MB
|
|
|
026 How to create SparkLines_en.vtt
|
VTT
|
5.9 KB
|
|
|
027 Total vs {1} vs All.mp4
|
MP4
|
34.9 MB
|
|
|
027 Total vs {1} vs All_en.vtt
|
VTT
|
6.1 KB
|
|
|
028 When to use a canonical calendar.mp4
|
MP4
|
27.8 MB
|
|
|
028 When to use a canonical calendar_en.vtt
|
VTT
|
7.4 KB
|
|
|
029 Building the Canonical calendar.mp4
|
MP4
|
94.5 MB
|
|
|
029 Building the Canonical calendar_en.vtt
|
VTT
|
20 KB
|
|
|
030 MUST Watch!!! Caveat to using the Canonical Calendar. Be careful!.mp4
|
MP4
|
29.6 MB
|
|
|
030 MUST Watch!!! Caveat to using the Canonical Calendar. Be careful!_en.vtt
|
VTT
|
6.2 KB
|
|
|
40501064-Module-4-part-2-Canonical-calendar-version-Amazon-sales-analysis.qvf
|
QVF
|
4.5 MB
|
|
|
40501068-Module-4-part-2-Canonical-calendar-version-Amazon-sales-analysis.qvf
|
QVF
|
4.5 MB
|
|
|
AZ VC's startup fund.xlsx
|
XLSX
|
2.3 MB
|
|
|
Amazon sales 2019 -2020.xlsx
|
XLSX
|
3.8 MB
|
|
|
Amazon sales 2020 -2022.xlsx
|
XLSX
|
5.6 MB
|
|
|
Bonus Resources.txt
|
TXT
|
409.6 B
|
|
|
Customerinfo.xlsx
|
XLSX
|
74.2 KB
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
|
|
Module 4 - Amazon sales analysis app.qvf
|
QVF
|
2.8 MB
|
|
|
Module 4 part 2-Canonical calendar version Amazon sales analysis.qvf
|
QVF
|
4.5 MB
|
|
|
Module 5 [Variables tutorial version ] Amazon sales analysis.qvf
|
QVF
|
2.8 MB
|
|
|
Module 6 - Dashboard magic.qvf
|
QVF
|
416 KB
|
|
|
Our first Dashboard.qvf
|
QVF
|
704 KB
|
|
|
Product_info.xlsx
|
XLSX
|
32.3 KB
|
|
|
SalesData_oatsdrink_company.xlsx
|
XLSX
|
1.5 MB
|
|
|
Sales_geo_key.xlsx
|
XLSX
|
79.9 KB
|
|
|
Targets.xlsx
|
XLSX
|
9.7 KB
|
|
|
shippers.xlsx
|
XLSX
|
9.5 KB
|
