UD182 | 31F3713B6595AF12EC12DBE0124EE95C72656F94

UD182

Name	UD182	DOWNLOAD Copy Link
Total Size	4.0 GB
Total Files	126
Hash	31F3713B6595AF12EC12DBE0124EE95C72656F94

/01 Your QlikView Journey Begins Here/
001 Course Introduction.mp4	32.8 MB
001 HowToViewIn1080pAlways.docx	34.9 KB
002 Download And Install QlikView Personal Edition Software.mp4	23.0 MB
003 Download And Install SQL Server Express.mp4	126.3 MB
004 How To Get Your Project Data From Dropbox.mp4	126.6 MB
005 Quick Tips And Links.mp4	36.0 MB
006 Navigating The QlikView Desktop.mp4	44.8 MB
007 Create Document Content Using Wizards.mp4	36.2 MB
008 Mission Assignment 1 If You Choose To Accept It.mp4	33.4 MB
external-assets-links.txt	0.5 KB
/02 Data Modelling In QlikView/
009 Introduction to the Associative Model.mp4	78.1 MB
009 RigidSnowflakeModel.PNG	40.8 KB
009 RigidStarSchemaModel.PNG	24.6 KB
010 The Star Schema.mp4	61.3 MB
011 The Snowflake Schema.mp4	55.5 MB
012 Mission Assignment 2 If You Choose To Accept It.mp4	43.6 MB
013 The Synthetic Key And Your Model.mp4	49.9 MB
013 What-is-Synthetic-Keys.pdf	32.2 KB
014 Circular Reference (Loops) Break Your Model.mp4	63.5 MB
015 Link Table(s) In Your Model - Part 1.mp4	54.4 MB
016 Link Tables(s) In Your Model - Part 2.mp4	22.9 MB
017 Mission Assignment 3 If You Choose To Accept It.mp4	52.3 MB
external-assets-links.txt	0.2 KB
/03 Coding Joins In The Script/
018 The Inner Join.mp4	61.7 MB
019 The Left Join.mp4	39.2 MB
020 The Right Join.mp4	40.0 MB
021 The Outer Join.mp4	50.6 MB
022 Mission Assignment 4 If You Choose To Accept It.mp4	41.2 MB
023 Mission 4 Solution Explanation.mp4	22.6 MB
external-assets-links.txt	0.2 KB
/04 Scripting The ETL (Extract Transform Load)/
024 What IS ETL Exactly.mp4	77.2 MB
025 ETL-1 SQL And The Inline Load (Part 1).mp4	46.2 MB
026 ETL-1 SQL And The Inline Load (Part 2).mp4	25.1 MB
027 ETL-1 SQL And The Inline Load (Part 3).mp4	18.8 MB
028 ETL-1 SQL And The Inline Load (Part 4).mp4	23.5 MB
029 ETL-2 Loading From Disparate Data Sources (Part 1).mp4	50.5 MB
030 ETL-2 Loading From Disparate Data Sources (Part 2).mp4	23.0 MB
031 ETL-3 The Incremental Load (Part 1).mp4	61.5 MB
032 ETL-3 The Incremental Load (Part 2).mp4	19.6 MB
033 ETL-4 The Slowly Changing Dimension (SCD).mp4	132.9 MB
034 Mission Assignment 5 If You Choose To Accept It.mp4	18.0 MB
035 Mission 5 Solution Explanation.mp4	18.8 MB
external-assets-links.txt	0.2 KB
/05 Develop Your First Dashboard/
036 Getting Started.mp4	48.5 MB
037 Basic Aggregations Overview.mp4	55.4 MB
038 Adding Filters Current Selections Object.mp4	27.2 MB
039 The Combo Chart Calculated Dimensions.mp4	25.0 MB
040 The Combo Chart Object Cloning.mp4	23.1 MB
041 Dimension Limiting Aggregation Scope.mp4	26.1 MB
042 Coding Conditional Colours.mp4	22.3 MB
043 The Pivot Table.mp4	23.8 MB
044 Mission 6 If You Choose To Accept It.mp4	24.3 MB
045 Mission 6 Solution Explanation.mp4	19.8 MB
external-assets-links.txt	0.2 KB
/06 Preparation For Your Enterprise Solution Development/
046 Visualisation Best Practices.mp4	186.8 MB
047 Initial Data Model Load Incl. Mapping Load.mp4	52.8 MB
048 Initial Data Model Load Incl. Concatenated Load.mp4	20.8 MB
049 Initial Data Model Load Incl. Reduced Data Load.mp4	17.5 MB
external-assets-links.txt	0.1 KB
/07 The KPI/
050 A Conversation Around Metrics KPIs.mp4	34.2 MB
051 Coding A Simple KPI.mp4	19.8 MB
052 Coding a KPI With A Calculation.mp4	11.4 MB
053 Mission Assignment 7 If You Choose To Accept It.mp4	15.1 MB
054 Mission 7 Solution Explanation.mp4	16.2 MB
/08 Explore And Develop Charts/
055 The Straight Table And The Mini Chart.mp4	34.6 MB
056 The Straight Table With Drill Down Cyclic Groups.mp4	23.8 MB
057 The Line Chart With Dual Axes.mp4	32.0 MB
058 The Bar Chart Classed Data.mp4	20.6 MB
059 The Bar Chart Becomes A Combo Chart.mp4	22.4 MB
060 The Gauge Chart.mp4	34.7 MB
061 The Butterfly Chart (aka Tornado Chart) Part 1.mp4	26.3 MB
062 The Butterfly Chart (aka Tornado Chart) Part 2.mp4	31.5 MB
063 The Scatter Chart.mp4	36.0 MB
064 Mission Assignment 8 If You Choose To Accept It.mp4	22.9 MB
065 Mission 8 Solution Explanation.mp4	21.6 MB
/09 Implement An SCD Type 2 In Our Solution/
066 The IntervalMatch() Function.mp4	37.7 MB
067 Exploiting The Container Object.mp4	29.5 MB
068 Mission Assignment 9 If You Choose To Accept It.mp4	17.9 MB
069 Mission 9 Solution Explanation.mp4	16.3 MB
/10 Understand And Code Set Analysis/
070 What Is Set Analysis.mp4	58.0 MB
071 Coding KPIs (Part 1).mp4	27.4 MB
072 Coding KPIs (Part 2).mp4	24.1 MB
073 Dates Set Analysis and Charting.mp4	31.8 MB
074 Date Spans In Set Analysis e.g. MTD with MonthStart().mp4	21.7 MB
075 Date Spans In Set Analysis The Dual() Function.mp4	24.3 MB
076 Embedding Multiple Functions Inside Set Analysis.mp4	37.7 MB
077 Mission Assignment 10 If You Choose To Accept It.mp4	17.3 MB
078 Mission 10 Solution Explanation.mp4	17.9 MB
/11 The Magic Of Variables/
079 Getting Started With Variables.mp4	35.1 MB
080 A Conversation Around Naming Standards Of Variables.mp4	22.9 MB
081 Handling Complex String Expressions In Variables.mp4	27.8 MB
082 Using A Variable For Conditional Colouring In The Chart.mp4	24.8 MB
083 How To Do What If Analysis.mp4	34.9 MB
084 Mission Assignment 11 If You Choose To Accept It.mp4	18.9 MB
085 Mission 11 Solution Explanation.mp4	19.7 MB
/12 The Calculated Dimension Conditional Objects/
086 How To Create A Calculated Dimension.mp4	45.1 MB
087 A Ranking Dimension With Aggr() Function (Part 1).mp4	25.6 MB
088 A Ranking Dimension With Aggr() Function (Part 2).mp4	25.3 MB
089 Getting Started With Conditional Objects Triggers.mp4	22.4 MB
090 Hide Display Objects.mp4	32.1 MB
091 Conditional Dimensions Sheet Triggers.mp4	30.1 MB
092 Conditional Expressions.mp4	23.5 MB
093 Mission Assignment 12 If You Choose To Accept It.mp4	24.1 MB
094 Mission 12 Solution Explanation.mp4	22.7 MB
external-assets-links.txt	0.1 KB
/13 Alternate States Comparative Analysis/
095 Getting Started With Alternate States.mp4	79.2 MB
096 Implementing Alternate States - Set Analysis.mp4	28.2 MB
097 Implementing Alternate States - Aggr().mp4	10.2 MB
098 Mission Assignment 13 If You Choose To Accept It.mp4	19.9 MB
099 Mission 13 Solution Explanation.mp4	13.4 MB
/14 Securing Your Document/
100 Introduction Basic Security Options.mp4	58.9 MB
101 Applying Section Access To The Document.mp4	32.6 MB
102 Mission Assignment 14 If You Choose To Accept It.mp4	15.7 MB
103 Mission 14 Solution Explanation.mp4	9.0 MB
/15 A Conversation About Document Tuning/
104 Getting Started.mp4	64.1 MB
105 The Model Exposed.mp4	16.4 MB
106 The Optimised Load.mp4	38.7 MB
107 Script Expression Tuning Tips.mp4	31.2 MB
/16 Introducing More QlikView Features/
108 Convert A Cross Table Into A Straight Table.mp4	27.3 MB
109 Using Bookmarks To Save Your Discoveries.mp4	28.9 MB
110 Code A Script To Create A Master Calendar From Scratch.mp4	31.8 MB
111 Using Autonumber() To Create Unique IDs.mp4	20.4 MB
112 Mission Assignment 15 If You Choose To Accept It.mp4	13.2 MB
113 Mission 15 Solution Explanation.mp4	6.6 MB
114 How to get a quiz based award certificate.html	1.9 KB
external-assets-links.txt	0.3 KB
Total files 126