Data Warehousing Fundamentals for Beginners

Data Warehousing (DW) is a process for collecting and managing data from different sources to provide meaningful business insights. Data Warehousing concepts form the basis of Business Intelligence, Data Analytics and Data Science.

In this tutorial we will cover all the basic concepts of DW and touch upon the Business Intelligence tools and scenarios.

Approach is to explain in conversational/colloquial Kannada to reinforce the learning and for better understanding.

Modules

1. Introduction to DW: In this module, we will take a real-life scenario of a supermarket and explain the need of a Data Warehouse.
2. Transactional System: In this segment, we will talk about transactional systems, analytical systems and the difference between them.
3. Dimension Modelling: In this module, we discuss the most important topics of Facts and Dimensions, modelling the Data Warehouse objects.
4. Schema: This topic covers the need for a Schema and the types of Schema.
5. Slowly Changing Dimension: In this module, we will discuss the concept of Slowly Changing Dimensions and the types of SCD.
6. Normalization: In this topic we discuss concepts of Normalization and Denormalization.
7. Introduction to BI: We talk about the importance of BI, BI and ETL tools in the market.

Benefits of the Course:

1. Get a complete overview of Data Warehousing.
2. Concepts explained in conversational Kannada for better understanding.
3. Final Quiz to reinforce learning.
4. Course completion certificate from Kaliyona.