CBSG Polska | MS-20768 Developing SQL Data Models

MS-20768 Developing SQL Data Models

Kluczowe zagadnienia szkolenia wg trenera CBSG Polska:

Bartosz Ratajczyk, Microsoft Certified Trainer

Certyfikacje zawodowe

Tematyka szkolenia pokrywa zagadnienia wymagane na ścieżce:

MTA	MCS	MCSA	MCSE
			MCSD

Dowiedz się więcej o certyfikacjach Microsoft

Poziom szkolenia wg standardów Microsoft

podstawowy	średniozaawansowany	zaawansowany	ekspercki
100	200	300	400

Czas trwania

Tematyka zajęć

Module 1: Introduction to Business Intelligence and Data Modeling
Introduction to Business Intelligence
The Microsoft business intelligence platform
Lab : Exploring a Data Warehouse

Module 2: Creating Multidimensional Databases
Introduction to multidimensional analysis
Creating data sources and data source views
Creating a cube
Overview of cube security
Lab : Creating a multidimensional database

Module 3: Working with Cubes and Dimensions
Configuring dimensions
Define attribute hierarchies
Sorting and grouping attributes
Lab : Working with Cubes and Dimensions

Module 4: Working with Measures and Measure Groups
Working with measures
Working with measure groups
Lab : Configuring Measures and Measure Groups

Module 5: Introduction to MDX
MDX fundamentals
Adding calculations to a cube
Using MDX to query a cube
Lab : Using MDX

Module 6: Customizing Cube Functionality
Implementing key performance indicators
Implementing actions
Implementing perspectives
Implementing translations
Lab : Customizing a Cube

Module 7: Implementing a Tabular Data Model by Using Analysis Services
Introduction to tabular data models
Creating a tabular data model
Using an analysis services tabular model in an enterprise BI solution
Lab : Working with an Analysis services tabular data model

Module 8: Introduction to Data Analysis Expression (DAX)
DAX fundamentals
Using DAX to create calculated columns and measures in a tabular data model
Lab : Creating Calculated Columns and Measures by using DAX

Module 9: Performing Predictive Analysis with Data Mining
Overview of data mining
Using the data mining add-in for Excel
Creating a custom data mining solution
Validating a data mining model
Connecting to and consuming a data mining model
Lab : Perform Predictive Analysis with Data Mining

	1699zł netto
Pobierz konspekt szkolenia
	Wyświetl oficjalny konspekt szkolenia na stronie Microsoft Learning
	Rejestracja na szkolenie