This course introduces core concepts and architecture of data warehousing, including the need for data warehouses, differences from operational databases, and OLAP vs. OLTP. Learners explore key features, data types, and warehouse design using star, snowflake, and constellation schemas. It covers essential procedures like data extraction, cleaning, loading, and refreshing, as well as OLAP operations such as drill down, roll up, and slicing. The course concludes with data visualization techniques and tools used to analyze and present warehouse data effectively, preparing students for practical applications in analytical processing and decision support systems.


Accessibility

Background Colour Background Colour

Font Face Font Face

Font Kerning Font Kerning

Font Size Font Size

1

Image Visibility Image Visibility

Letter Spacing Letter Spacing

0

Line Height Line Height

1.2

Link Highlight Link Highlight

Text Colour Text Colour