Tutorialsplanet NET Udemy Data Warehouse Concepts Basic to Advanced concepts

Tutorialsplanet NET Udemy Data Warehouse Concepts Basic to Advanced concepts

Name	[Tutorialsplanet.NET] Udemy - Data Warehouse Concepts Basic to Advanced concepts	DOWNLOAD Copy Link
Total Size	1.1 GB
Total Files	248
Hash	1F11DDB153590B3796FED90890C1B17CD4390F02

/1. Introduction/
1. Welcome! Thank you for learning the Data Warehouse concepts with me!.mp4	26.8 MB
1. Welcome! Thank you for learning the Data Warehouse concepts with me!.srt	8.5 KB
/10. Entity Relational Data Model/
1. ER - (Entity Relation) Data Model.mp4	8.3 MB
1. ER - (Entity Relation) Data Model.srt	3.8 KB
10. ER Data Model - Notation.mp4	5.4 MB
10. ER Data Model - Notation.srt	3.1 KB
11. ER Data Model - Logical Data Model.mp4	3.8 MB
11. ER Data Model - Logical Data Model.srt	1.8 KB
12. ER Data Model - Moving from Logical Data Model to Physical Data Model.mp4	5.0 MB
12. ER Data Model - Moving from Logical Data Model to Physical Data Model.srt	3.2 KB
13. ER Data Model - Differences between CDM, LDM and PDM.mp4	7.0 MB
13. ER Data Model - Differences between CDM, LDM and PDM.srt	4.7 KB
14. ER Data Model - Disadvantages.mp4	7.2 MB
14. ER Data Model - Disadvantages.srt	4.7 KB
2. ER Data Model - What is Entity.mp4	4.2 MB
2. ER Data Model - What is Entity.srt	2.5 KB
3. ER Data Model - Types of Entities - Part 1.mp4	8.3 MB
3. ER Data Model - Types of Entities - Part 1.srt	4.7 KB
4. ER Data Model - Types of Entities - Part 2.mp4	4.3 MB
4. ER Data Model - Types of Entities - Part 2.srt	2.4 KB
5. ER Data Model - Attributes.mp4	4.2 MB
5. ER Data Model - Attributes.srt	2.3 KB
6. ER Data Model - Types of Attributes.mp4	7.9 MB
6. ER Data Model - Types of Attributes.srt	5.4 KB
7. ER Data Model - Entity-Set and Keys.mp4	5.9 MB
7. ER Data Model - Entity-Set and Keys.srt	3.5 KB
8. ER Data Model - Identifier.mp4	3.9 MB
8. ER Data Model - Identifier.srt	2.5 KB
9. ER Data Model - Relationship.mp4	3.1 MB
9. ER Data Model - Relationship.srt	1.6 KB
/11. Dimensional Model/
1. What is Dimension Modelling.mp4	10.6 MB
1. What is Dimension Modelling.srt	5.8 KB
10. Star Schema.mp4	10.4 MB
10. Star Schema.srt	6.8 KB
11. SnowFlake Schema.mp4	7.6 MB
11. SnowFlake Schema.srt	4.3 KB
12. Galaxy Schema or Fact Constellation Schema.mp4	5.7 MB
12. Galaxy Schema or Fact Constellation Schema.srt	2.9 KB
13. Differences between Star Schema and SnowFlake Schema.mp4	12.0 MB
13. Differences between Star Schema and SnowFlake Schema.srt	7.1 KB
14. Conformed Dimension.mp4	12.5 MB
14. Conformed Dimension.srt	8.7 KB
15. Junk Dimension.mp4	6.4 MB
15. Junk Dimension.srt	3.8 KB
16. Degenerate Dimension.mp4	8.3 MB
16. Degenerate Dimension.srt	4.5 KB
17. Slowly Changing Dimensions - Intro and Example Creation.mp4	28.6 MB
17. Slowly Changing Dimensions - Intro and Example Creation.srt	6.4 KB
18. Slowly Changing Dimensions - Type 1, 2 and 3.mp4	40.6 MB
18. Slowly Changing Dimensions - Type 1, 2 and 3.srt	15.0 KB
19. Slowly Changing Dimensions - Summary.mp4	9.5 MB
19. Slowly Changing Dimensions - Summary.srt	3.9 KB
2. Benefits of Dimensional Modelling.mp4	4.0 MB
2. Benefits of Dimensional Modelling.srt	2.2 KB
20. Step by Step approach to set up the Dimensional Model using a retail case study.mp4	15.4 MB
20. Step by Step approach to set up the Dimensional Model using a retail case study.srt	9.0 KB
21. ER Model Vs Dimensional Model.mp4	15.4 MB
21. ER Model Vs Dimensional Model.srt	8.0 KB
3. What is a Dimension.mp4	5.8 MB
3. What is a Dimension.srt	3.2 KB
4. What is a Fact.mp4	4.5 MB
4. What is a Fact.srt	2.5 KB
5. Additive Facts.mp4	4.3 MB
5. Additive Facts.srt	2.0 KB
6. Semi Additive Facts.mp4	5.5 MB
6. Semi Additive Facts.srt	3.4 KB
7. Non-Additive Facts.mp4	3.4 MB
7. Non-Additive Facts.srt	1.9 KB
8. FactLess Facts.mp4	5.5 MB
8. FactLess Facts.srt	3.0 KB
9. What is a Surrogate key.mp4	7.4 MB
9. What is a Surrogate key.srt	4.9 KB
/12. DWH Indexes/
1. What is an Index.mp4	4.5 MB
1. What is an Index.srt	2.6 KB
2. Bitmap Index.mp4	7.6 MB
2. Bitmap Index.srt	4.8 KB
3. B-Tree index.mp4	4.0 MB
3. B-Tree index.srt	2.3 KB
4. Bitmap Index Vs B Tree Index.mp4	7.2 MB
4. Bitmap Index Vs B Tree Index.srt	3.9 KB
/13. Data Integration and ETL/
1. What is Data Integration.mp4	22.8 MB
1. What is Data Integration.srt	8.4 KB
2. What is ETL.mp4	9.4 MB
2. What is ETL.srt	5.7 KB
3. Common Questions and Summary.mp4	6.7 MB
3. Common Questions and Summary.srt	3.6 KB
/14. ETL Vs ELT/
1. ETL - Explained.mp4	14.1 MB
1. ETL - Explained.srt	8.6 KB
2. ELT - Explained.mp4	11.9 MB
2. ELT - Explained.srt	8.0 KB
3. ETL Vs ELT.mp4	5.2 MB
3. ETL Vs ELT.srt	3.0 KB
/15. ETL - Extraction Transformation & Loading/
1. Build Vs Buy.mp4	20.8 MB
1. Build Vs Buy.srt	5.9 KB
2. ETL Tools for Data Warehouses.mp4	3.9 MB
2. ETL Tools for Data Warehouses.srt	2.4 KB
3. Extraction Methods in Data Warehouses.mp4	9.6 MB
3. Extraction Methods in Data Warehouses.srt	7.4 KB
/16. Typical Roles In DWH Project/
1. Project Sponsor.mp4	10.5 MB
1. Project Sponsor.srt	4.3 KB
10. ETL TestersQA Group.mp4	4.2 MB
10. ETL TestersQA Group.srt	2.5 KB
11. DB UNIX Network Admins.mp4	2.1 MB
11. DB UNIX Network Admins.srt	1.1 KB
12. Data Architect, Data Warehouse Architect, BI Architect and Solution Architect.mp4	19.5 MB
12. Data Architect, Data Warehouse Architect, BI Architect and Solution Architect.srt	12.5 KB
13. Final Note about the Roles.mp4	4.3 MB
13. Final Note about the Roles.srt	2.6 KB
2. Project Manager.mp4	3.5 MB
2. Project Manager.srt	2.3 KB
3. Functional Analyst or Business Analyst.mp4	5.7 MB
3. Functional Analyst or Business Analyst.srt	4.0 KB
4. SME - Subject Matter Expert.mp4	20.3 MB
4. SME - Subject Matter Expert.srt	5.8 KB
5. DW BI Architect.mp4	6.9 MB
5. DW BI Architect.srt	3.9 KB
6. Data Modeler.mp4	16.2 MB
6. Data Modeler.srt	11.0 KB
6.1 Roles and Responsibilities of a Data Modeler.docx	16.4 KB
7. DWH Tech Admin.mp4	2.7 MB
7. DWH Tech Admin.srt	1.6 KB
8. ETL Developers.mp4	4.3 MB
8. ETL Developers.srt	2.4 KB
9. BI OLAP Developers.mp4	3.4 MB
9. BI OLAP Developers.srt	1.7 KB
/17. DWBIETL Implementation Approach/
1. Different phases in DWBIETL Implementation Approach.mp4	3.5 MB
1. Different phases in DWBIETL Implementation Approach.srt	2.4 KB
10. Data Access Types - Exception Reporting.mp4	2.8 MB
10. Data Access Types - Exception Reporting.srt	0.8 KB
11. Data Access Types - Calculations.mp4	4.8 MB
11. Data Access Types - Calculations.srt	1.7 KB
12. Data Access Types - Graphics and Visualization.mp4	2.7 MB
12. Data Access Types - Graphics and Visualization.srt	1.1 KB
13. Data Access Types -Data Entry Options.mp4	4.7 MB
13. Data Access Types -Data Entry Options.srt	2.9 KB
14. Data Access Types - Customization.mp4	2.3 MB
14. Data Access Types - Customization.srt	1.4 KB
15. Data Access Types - WebBased Reporting.mp4	2.0 MB
15. Data Access Types - WebBased Reporting.srt	1.1 KB
16. Data Access Types - BroadCasting.mp4	4.0 MB
16. Data Access Types - BroadCasting.srt	1.4 KB
17. Deploy.mp4	4.0 MB
17. Deploy.srt	2.0 KB
18. Iterative Approach.mp4	8.2 MB
18. Iterative Approach.srt	3.7 KB
2. Knowledge Capture Sessions.mp4	8.7 MB
2. Knowledge Capture Sessions.srt	4.7 KB
3. Requirements.mp4	20.4 MB
3. Requirements.srt	8.9 KB
4. Architecture phases.mp4	10.5 MB
4. Architecture phases.srt	5.7 KB
5. Data ModelDatabase.mp4	3.5 MB
5. Data ModelDatabase.srt	1.9 KB
6. ETL Phase.mp4	6.3 MB
6. ETL Phase.srt	3.2 KB
7. Data Access Phase.mp4	5.4 MB
7. Data Access Phase.srt	2.4 KB
8. Data Access Types - Selection.mp4	4.0 MB
8. Data Access Types - Selection.srt	2.0 KB
9. Data Access Types - Drilling Down.mp4	3.7 MB
9. Data Access Types - Drilling Down.srt	1.0 KB
/18. Retired Lectures/
1. ETL Vs ELT.mp4	4.8 MB
1. ETL Vs ELT.srt	3.1 KB
/19. Bonus Section/
1. Links to other courses.mp4	15.6 MB
1. Links to other courses.srt	2.6 KB
/2. Brief about the Data warehouse/
1. Is Data Warehouse still relevant in the age of Big Data.mp4	18.6 MB
1. Is Data Warehouse still relevant in the age of Big Data.srt	5.0 KB
2. Why do we need a Data Warehouse.mp4	11.1 MB
2. Why do we need a Data Warehouse.srt	7.7 KB
3. What is a Data Warehouse.mp4	47.3 MB
3. What is a Data Warehouse.srt	6.8 KB
4. Characteristics of a Data Warehouse.mp4	31.5 MB
4. Characteristics of a Data Warehouse.srt	7.0 KB
4.1 Overall DWH Concepts handbook.pdf	1.1 MB
/3. Business Intelligence/
1. What is Business Intelligence.mp4	17.6 MB
1. What is Business Intelligence.srt	6.4 KB
2. Business Intelligence -Extended Explanation.mp4	9.2 MB
2. Business Intelligence -Extended Explanation.srt	4.3 KB
3. Uses of Business Intelligence.mp4	17.3 MB
3. Uses of Business Intelligence.srt	9.9 KB
4. Tools used for (in) Business Intelligence.mp4	14.4 MB
4. Tools used for (in) Business Intelligence.srt	7.4 KB
/4. Data Warehouse Architectures/
1. Enterprise Architecture or Centralized Architecture.mp4	9.7 MB
1. Enterprise Architecture or Centralized Architecture.srt	5.9 KB
2. Federated Architecture.mp4	6.8 MB
2. Federated Architecture.srt	4.2 KB
3. Multi-Tired Architecture.mp4	7.6 MB
3. Multi-Tired Architecture.srt	3.9 KB
4. Components of a Data Warehouse.mp4	8.4 MB
4. Components of a Data Warehouse.srt	5.3 KB
5. Purpose of a Staging Area in Data Warehouse Architecture - Part 1.mp4	10.2 MB
5. Purpose of a Staging Area in Data Warehouse Architecture - Part 1.srt	6.0 KB
6. Purpose of a Staging Area in Data Warehouse Architecture - Part 2.mp4	8.8 MB
6. Purpose of a Staging Area in Data Warehouse Architecture - Part 2.srt	4.9 KB
7. Advantages of Traditional warehouse.mp4	5.6 MB
7. Advantages of Traditional warehouse.srt	3.2 KB
8. Limitations of Traditional Data Warehouses.mp4	12.3 MB
8. Limitations of Traditional Data Warehouses.srt	7.7 KB
/5. ODS - Operational Data Store/
1. What is ODS.mp4	8.4 MB
1. What is ODS.srt	2.7 KB
2. Define ODS.mp4	15.1 MB
2. Define ODS.srt	11.0 KB
3. Differences between ODS,DWH, OLTP, OLAP, DSS.mp4	12.8 MB
3. Differences between ODS,DWH, OLTP, OLAP, DSS.srt	5.3 KB
3.1 differences-between OLTP, OLAP, ODS, DWH, DSS Sytems.pdf	477.5 KB
/6. OLAP/
1. OLAP Overview.mp4	10.9 MB
1. OLAP Overview.srt	7.4 KB
2. OLTP Vs OLAP - Part 1_U.mp4	9.2 MB
2. OLTP Vs OLAP - Part 1_U.srt	5.4 KB
3. OLTP Vs OLAP - Part 2.mp4	11.8 MB
3. OLTP Vs OLAP - Part 2.srt	7.4 KB
4. OLAP Architecture - MOLAP.mp4	11.9 MB
4. OLAP Architecture - MOLAP.srt	7.6 KB
5. ROLAP.mp4	7.8 MB
5. ROLAP.srt	4.5 KB
6. HOLAP.mp4	5.3 MB
6. HOLAP.srt	3.2 KB
7. DOLAP.mp4	4.2 MB
7. DOLAP.srt	2.0 KB
/7. Data Mart/
1. What is a Data Mart.mp4	4.3 MB
1. What is a Data Mart.srt	1.9 KB
2. Fundamental Difference between DWH and DM.mp4	2.1 MB
2. Fundamental Difference between DWH and DM.srt	0.7 KB
3. Advantages of a Data Mart.mp4	7.0 MB
3. Advantages of a Data Mart.srt	3.2 KB
4. Characteristics of a Data Mart.mp4	8.2 MB
4. Characteristics of a Data Mart.srt	5.2 KB
5. Disadvantages of a Data Mart.mp4	8.2 MB
5. Disadvantages of a Data Mart.srt	4.2 KB
6. Mistakes and MisConceptions of a Data Mart.mp4	6.4 MB
6. Mistakes and MisConceptions of a Data Mart.srt	2.6 KB
/8. Metadata/
1. Overview of Metadata.mp4	6.4 MB
1. Overview of Metadata.srt	2.3 KB
2. Benefits of Metadata.mp4	5.1 MB
2. Benefits of Metadata.srt	1.9 KB
3. Types of Metadata.mp4	14.3 MB
3. Types of Metadata.srt	6.8 KB
4. Projects on Metadata.mp4	14.9 MB
4. Projects on Metadata.srt	7.5 KB
5. Best Practices for Metadata Setup.mp4	3.9 MB
5. Best Practices for Metadata Setup.srt	1.8 KB
6. Summary.mp4	9.5 MB
6. Summary.srt	3.6 KB
/9. Data Modeling/
1. What is Data Modeling.mp4	5.6 MB
1. What is Data Modeling.srt	2.5 KB
2. Data Modeling Techniques.mp4	10.6 MB
2. Data Modeling Techniques.srt	5.2 KB
/
[Tutorialsplanet.NET].url	0.1 KB
Total files 248