Learn how to build a BI data warehouse using SQL Server.  During the course we build a data warehouse from scratch and use Multidimensional and Tabular data modelling so you appreciate the differences. Finish off with a day spent on SSIS, the ETL tool for moving and updating data into data warehouses.

Learning Outcomes 

A good understanding of data warehousing and BI, the problems involved and how to overcome them.  Keeping it simple and repeatable as well as ensuring it works. And learn this by doing.

Course Requirements

Developers and DBAs and Excel/PowerBI/SSRS or Reporting professionals with an understanding and working with relational databases.

Course Length

3-days

• BI Overview
• Multidimensional and Tabular
• 3NF and Relational
• Star and Snowflake schemas
• Dimension and Fact Tables
• Cubes and SSIS

• Attributes and Relationships
• Calculations, KPIs and Actions
• Partitions, Aggregation Design
• Whats your perspective?
• Visualisations
• Administration

• The same but different
• Data Sources and Cubes
• Measures, Attributes and Hierarchies
• Advanced Properties
• Relationships, Calculations & KPIs
• Actions, Perspectives & Translations
• Administration

• SSIS Architecture
• Tools & Tasks
• Control and Data Flow
• Variables, Expressions and Parameters
• Joining Data
• Creating a Package: Sources and Destinations
• Import/Export
• Data Cleansing, Incremental Loads and Loading a Data warehouse
• Handling Errors

Course Price

This course costs £1,475 excluding VAT

How to Book

Call us or email us on the form below, any questions, ask us!