Overview of the Microsoft BI Platform

Course Description:

Building on the Kimball approach, this seminar will guide the students through the DWH project lifecycle, from analysis and gathering of business requirements, through to design, implementation and maintenance of the DWH, based on the rich and robust Microsoft Business Intelligence product stack. Students of this seminar will gain invaluable knowledge and insight into development techniques and methodologies alongside hands-on experience.

Trainer:

Guy Glantser is the owner and CEO of Madeira. His SQL Server career started way back in his army service at the elite intelligence unit 8200, where he served, among his various positions, as the IT team leader. He moved on to the successful gaming website, 888.com, as the database development team leader, and later on as the database consultant for the company. Today, with 13 years of hands-on experience, Guy is focusing on sharing his knowledge as part of the SQL Server community.

The DWH Project and the Business

The DWH Project Lifecycle
DWH Project Management Basics
How to Collect Business Requirements
The DWH Bus Matrix
Overview of the Microsoft BI Product Stack

The Basics of Dimensional Modeling

Designing Dimension and Fact Tables
Dimension Types
Design of Tables and Columns
Indexes and Foreign Keys
Partitioning Strategies

The ETL Platform

An Introduction to the SSIS Environment
Plan and Design of the ETL Scheme
Implementation Pieces Using SSIS
Techniques of Reuse
Parent-Child Packages
Populating Dimension Tables
Populating Fact Tables
Auditing Suggestions

The OLAP Platform

An Introduction to the SSAS Environment
Create Dimensions and Cubes Using BIDS
Aggregations – What is It and How to Use It?
Partitioning Strategies in SSAS
Calculations, KPIs and Actions
Database Deployment Strategies
Monitoring Performance
Security

לחץ כאן לרישום

תשארו בקשר

יתכנו שינויים במועדי הסדנאות או התכנים*