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.
Course info
Background Colour
Font Face
Font Kerning
Font Size
Image Visibility
Letter Spacing
Line Height
Link Highlight
Text Colour
