2199 zł netto
KLUCZOWE ZAGADNIENIA
- tworzenie kostek OLAP, praca z miarami i wymiarami
- podstawy MDX
- praca z modelem Tabular
- podstawy DAX
- wstęp do Data Mining
Bartosz Ratajczyk, Microsoft Certified Trainer
CERTYFIKACJE ZAWODOWE
Certyfikacja podstawowa |
CertyfIkacja specjalistyczna |
Certyfikacja ekspercka |
FUNDAMENTALS |
ASSOCIATE |
EXPERT |
Tematyka szkolenia pokrywa zagadnienia wymagane na ścieżce MCSA: SQL Server 2016 Business Intelligence Development
Dowiedz się więcej o certyfikacjach Microsoft
POZIOM SZKOLENIA
podstawowy |
średniozaawansowany |
zaawansowany |
ekspercki |
100 |
200 |
300 |
400 |
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