SQL BI Data Warehouse Training Course

TSQL Training

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

SQL BI Data Warehouse Training Course Agenda

SQL Server Data Warehousing – Introduction
  • BI Overview
  • Multidimensional and Tabular
  • 3NF and Relational
  • Star and Snowflake schemas
  • Dimension and Fact Tables
  • Cubes and SSIS
SQL Server Data Warehousing – Multidimensional Model
  • Attributes and Relationships
  • Calculations, KPIs and Actions
  • Partitions, Aggregation Design
  • Whats your perspective?
  • Visualisations
  • Administration
SQL Server Data Warehousing – Tabular Data Model
  • The same but different
  • Data Sources and Cubes
  • Measures, Attributes and Hierarchies
  • Advanced Properties
  • Relationships, Calculations & KPIs
  • Actions, Perspectives & Translations
  • Administration
SQL Server Integration Services
  • 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!

 

You Might Also Like…

New Features of SQL Course
Advanced TSQL Course
Advanced SQL DBA Course
Performance Tuning Course
SSAS Multidimensional Course
SSAS Tabular Course
SSIS Training Course
SSRS Training Course
Power BI Training Course

 

3 + 3 =

Summary
SQL BI Data Warehouse Training Course
Service Type
SQL BI Data Warehouse Training Course
Provider Name
Sequallity Ltd,
80-83 Long Lane,London,EC1A 9ET,
Telephone No.020 3507 1989
Area
UK
Description
Learn how to build a BI data warehouse on this SQL BI Data Warehouse Training Course. 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.