Master Data Warehouse Concepts from Scratch and become an Expert
The Complete Data Warehouse Concepts course
In this course, you would be learning all the concepts and terminologies related to the Data Warehouse , such as the OLTP, OLAP, Dimensions, Facts and much more, along with other concepts related to it such as what is meant by Start Schema, Snow flake Schema, other options available and their differences.
StartEnterprise Architecture or Centralized Architecture (4:08)
StartFederated Architecture (2:49)
StartMuitli Tired DWH Architectures (3:13)
StartComponents of a Data Warehouse (3:57)
StartPurpose of a Staging Area in Data Warehouse Architecture - Part 1 (4:43)
StartPurpose of a Staging Area in Data Warehouse Architecture - Part 2 (3:35)
StartAdvantages of a Traditional Data Warehouse (2:30)
StartLimitations of Traditional Data Warehouses (6:02)
StartQuiz: Test your understanding on DWH Architectures
Data Management and Business Intelligence Consultant/Trainer with 16+ years of extensive work experience on various client engagements. Delivered many large Data Management projects (Data Integration, Data Quality, Data Governance, Metadata Management, Master Data Management, Data Security, Data Catalog etc) and trained numerous professionals on various tools and technologies. Extensively worked on all facets of Data Managment including requirement gathering, gap analysis, database design, data integration, data modeling, enterprise reporting, data analytics, data quality, data visualization, OLAP.
Has worked on broad range of business verticals and hold exceptional expertise on various ETL tools like Informatica Powercenter, SSIS, ODI and IDQ, Data Virtualization, DVO, MDM.
Solid course material, and the instructor clearly knows what he's talking about. Very knowledgeable. The overall presentation is well thought out and maintains a steady pace. Occasional material gets a bit repetitive, but this may be helpful for novice users. That said, its very easy to jump ahead. Loving the course so far!
- Ben Harris
The way Sid explains the topics is awesome! Clear, crisp & to the point.
- Sudeep Behera
Was very helpful in obtaining a practical understanding of the concepts.
- Barry Reese
- Haftamu Hailu Tefera
Clear and concise
- Thomas Lowry
Very clear definitions and explanations. Great meaningful visuals.
- Laurel Uehara