To provide the knowledge and skills required to identify the main concepts of data warehousing and to make use of effective approaches in designing a data warehouse.
Business analysts and developers.
General knowledge of computer science.
- What are data warehouses and why do they exist?
- Architecture of data warehouses and data stores
- Business Intelligence: data mining, data warehousing and data visualization
- Referential/Universal set (metadata)
- Different stages of data warehouse design
- Modeling, and the star, snowflake and galaxy models
- Considerations for Power BI
- Normalization rules for multidimensional schemas
- Modeling approaches: ascending, descending, mixed
- OLAP techniques (OnLine Analytical Processing): roll-up, drill-down, slice, dice, pivot, drill-through and drill-cross
- ROLAP, MOLAP and HOLAP servers
- Data warehousing applications (ETL, OLAP, etc.)
- Case studies and exercises in multidimensional modeling
- Illustration of various features using the Integration Services and Analysis Services modules in MS SQL Server
Wow! Finally, training I can truly use in the workplace.
Annie L. / Directrice de produits, Banque Nationale du Canada