FreeTutorials us master datawarehouse concepts step by step from scratch

FreeTutorials us master datawarehouse concepts step by step from scratch

Name	[FreeTutorials.us] master-datawarehouse-concepts-step-by-step-from-scratch	DOWNLOAD Copy Link
Total Size	1.1 GB
Total Files	139
Hash	B21611F7C8ACF29606E5E76865946665BAD21A3F

/01 Introduction/
001 Welcome Thank you for learning the Data Warehouse concepts with me.mp4	26.8 MB
/02 Brief about the Data warehouse/
002 Is Data Warehouse still relevant in the age of Big Data.mp4	18.6 MB
003 Why do we need a Data Warehouse.mp4	11.1 MB
004 What is a Data Warehouse.mp4	18.0 MB
005 Chareterstics of a Data Warehouse.mp4	19.3 MB
/quizzes/
001 Test your understanding on what is a Data Warehouse.html	4.4 KB
/03 Business Intelligence/
006 What is Business Intelligence.mp4	17.6 MB
007 Business Intelligence -Extended Explanation.mp4	9.2 MB
008 Uses of Business Intelligence.mp4	17.2 MB
009 Tools used for in Business Intelligence.mp4	14.4 MB
/quizzes/
002 Test your understanding on Business Intelligence.html	3.9 KB
/04 Data Warehouse Architectures/
010 Enterprise Architecture or Centralized Architecture.mp4	9.7 MB
011 Federated Architecture.mp4	6.8 MB
012 Multi-Tired Architecture.mp4	7.6 MB
013 Components of a Data Warehouse.mp4	8.4 MB
014 Purpose of a Staging Area in Data Warehouse Architecture - Part 1.mp4	10.2 MB
015 Purpose of a Staging Area in Data Warehouse Architecture - Part 2.mp4	8.8 MB
016 Advantages of Traditional warehouse.mp4	5.6 MB
017 Limitations of Traditional Data Warehouses.mp4	12.3 MB
/quizzes/
003 Test your understanding on DWH Architectures.html	2.1 KB
/05 ODS - Operational Data Store/
018 What is ODS.mp4	8.4 MB
019 Define ODS.mp4	15.1 MB
020 Features and Benefits of ODS.mp4	5.2 MB
021 Differences between ODSDWH OLTP OLAP DSS.mp4	12.8 MB
/quizzes/
004 Test your understanding on ODS Concepts.html	3.4 KB
/06 OLAP/
022 OLAP Overview.mp4	10.8 MB
023 OLTP Vs OLAP - Part 1_U.mp4	9.2 MB
024 OLTP Vs OLAP - Part 2.mp4	11.8 MB
025 OLAP Architecture - MOLAP.mp4	11.9 MB
026 ROLAP.mp4	7.7 MB
027 HOLAP.mp4	5.3 MB
028 DOLAP.mp4	4.2 MB
/06 OLAP/quizzes/
005 Test your understanding on OLAP.html	3.6 KB
/07 Data Mart/
029 What is a Data Mart.mp4	4.3 MB
030 Fundamental Difference between DWH and DM.mp4	2.1 MB
031 029 Advantages of a Data Mart_U.mp4	7.0 MB
032 030 Charecteristics of a Data Mart_U.mp4	8.2 MB
033 Disadvantages of a Data Mart.mp4	8.2 MB
034 Mistakes and MisConceptions of a Data Mart.mp4	6.4 MB
/quizzes/
006 Test your understanding on Data marts.html	3.5 KB
/08 Metadata/
035 Overview of Metadata.mp4	6.4 MB
036 Benefits of Metadata.mp4	5.1 MB
037 Types of Metadata.mp4	14.3 MB
038 Projects on Metadata.mp4	14.9 MB
039 Best Practices for Metadata Setup.mp4	3.6 MB
040 Best Practices for Metadata Setup.mp4	3.9 MB
041 Summary.mp4	9.5 MB
/08 Metadata/quizzes/
007 Test your understanding on Metadata.html	3.2 KB
/09 Data Modeling/
042 What is Data Modeling.mp4	5.6 MB
043 Data Modeling Techniques.mp4	10.6 MB
/10 Entity Relational Data Model/
044 ER - Entity Relation Data Model.mp4	8.3 MB
045 ER Data Model - What is Entity.mp4	4.2 MB
046 ER Data Model - Types of Entities - Part 1.mp4	8.3 MB
047 ER Data Model - Types of Entities - Part 2.mp4	4.3 MB
048 ER Data Model - Attributes.mp4	4.2 MB
049 ER Data Model - Types of Attributes.mp4	7.9 MB
050 ER Data Model - Entity-Set and Keys.mp4	5.9 MB
051 ER Data Model - Identifier.mp4	3.9 MB
052 ER Data Model - Relationship.mp4	3.1 MB
053 ER Data Model - Notation.mp4	5.4 MB
054 ER Data Model - Logical Data Model.mp4	3.8 MB
055 ER Data Model - Moving from Logical Data Model to Physical Data Model.mp4	5.0 MB
056 ER Data Model - Differences between CDM LDM and PDM.mp4	7.0 MB
057 ER Data Model - Disadvantages.mp4	7.2 MB
/quizzes/
008 Test your understanding on ER Models.html	3.9 KB
/11 Dimensional Model/
058 What is Dimension Modelling.mp4	10.6 MB
059 Benefits of Dimensional Modelling.mp4	4.0 MB
060 What is a Dimension.mp4	5.8 MB
061 What is a Fact.mp4	4.5 MB
062 Additive Facts.mp4	4.3 MB
063 Semi Additive Facts.mp4	5.5 MB
064 Non-Additive Facts.mp4	3.4 MB
065 FactLess Facts.mp4	5.5 MB
066 What is a Surrogate key.mp4	7.3 MB
067 Star Schema.mp4	10.4 MB
068 SnowFlake Schema.mp4	7.6 MB
069 Galaxy Schema or Fact Constellation Schema.mp4	5.7 MB
070 Differences between Star Schema and SnowFlake Schema.mp4	12.0 MB
071 Conformed Dimension.mp4	12.5 MB
072 Junk Dimension.mp4	6.4 MB
073 Degenerate Dimension.mp4	8.3 MB
074 Slowly Changing Dimensions - Intro and Example Creation.mp4	74.1 MB
075 Slowly Changing Dimensions - Type 1 2 and 3.mp4	40.6 MB
076 Slowly Changing Dimensions - Summary.mp4	9.5 MB
077 Step by Step approach to set up the Dimensional Model using a retail case study.mp4	15.4 MB
078 ER Model Vs Dimensional Model.mp4	15.4 MB
/quizzes/
009 Test your understanding on Dimensional Model.html	8.0 KB
/12 DWH Indexes/
079 What is an Index.mp4	4.5 MB
080 Bitmap Index.mp4	7.6 MB
081 B-Tree index.mp4	4.0 MB
082 Bitmap Index Vs B Tree Index.mp4	7.2 MB
/quizzes/
010 Test your understanding on DWH Indexes.html	4.3 KB
/13 Data Integration and ETL/
083 What is Data Integration.mp4	22.8 MB
084 What is ETL.mp4	9.3 MB
085 Common Questions and Summary.mp4	6.7 MB
/quizzes/
011 Test your understanding on Data Integration.html	4.5 KB
/14 ETL Vs ELT/
086 ETL - Explained.mp4	14.1 MB
087 ELT - Explained.mp4	11.9 MB
088 ETL Vs ELT.mp4	5.2 MB
/15 ETL - Extraction Transformation Loading/
089 Build Vs Buy.mp4	20.8 MB
090 ETL Tools for Data Warehouses.mp4	3.8 MB
091 Extraction Methods in Data Warehouses.mp4	9.6 MB
/quizzes/
012 Test your understanding on ETL.html	3.9 KB
/16 Typical Roles In DWH Project/
092 Project Sponsor.mp4	10.5 MB
093 Project Manager.mp4	3.5 MB
094 Functional Analyst or Business Analyst.mp4	5.7 MB
095 SME - Subject Matter Expert.mp4	20.3 MB
096 DW BI Architect.mp4	6.9 MB
097 Data Modeler.mp4	16.2 MB
098 DWH Tech Admin.mp4	2.7 MB
099 ETL Developers.mp4	4.3 MB
100 BI OLAP Developers.mp4	3.4 MB
101 ETL TestersQA Group.mp4	4.2 MB
102 DB UNIX Network Admins.mp4	2.1 MB
103 Data Architect Data Warehouse Architect BI Architect and Solution Architect.mp4	19.5 MB
104 Final Note about the Roles.mp4	4.2 MB
/.../097 Data Modeler/
Roles-and-Responsibilities-of-a-Data-Modeler.docx	16.4 KB
/quizzes/
013 Test your understanding on different roles in DWH.html	5.5 KB
/17 DWBIETL Implemetation Approach/
105 Different phases in DWBIETL Implementation Approach.mp4	3.5 MB
106 Knowledge Capture Sessions.mp4	8.7 MB
107 Requirements.mp4	20.3 MB
108 Architecture phases.mp4	10.5 MB
109 Data ModelDatabase.mp4	3.5 MB
110 ETL Phase.mp4	6.3 MB
111 Data Access Phase.mp4	5.4 MB
112 Data Access Types - Selection.mp4	4.0 MB
113 Data Access Types - Drilling Down.mp4	3.7 MB
114 Data Access Types - Exception Reporting.mp4	2.8 MB
115 Data Access Types - Calculations.mp4	4.8 MB
116 Data Access Types - Graphics and Visualization.mp4	2.7 MB
117 Data Access Types -Data Entry Options.mp4	4.7 MB
118 Data Access Types - Customization.mp4	2.3 MB
119 Data Access Types - WebBased Reporting.mp4	2.0 MB
120 Data Access Types - BroadCasting.mp4	4.0 MB
121 Deploy.mp4	4.0 MB
122 Iterative Approach.mp4	8.2 MB
/18 Retired Lectures/
123 ETL Vs ELT.mp4	4.8 MB
/
FreeTutorials.us.html	0.1 KB
[FreeTutorials.us].txt	0.1 KB
Total files 139