MCSA SQL Server Business Intelligence Development

Description

This 4-day instructor led course describes how to implement a data warehouse platform to support a BI solution. Students will learn how to create a data warehouse with Microsoft® SQL Server® 2016 and with Azure SQL Data Warehouse, to implement ETL with SQL Server Integration Services, and to validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.

The second course is aimed at database professionals who fulfil a Business Intelligence (BI) developer role. This course looks at implementing multidimensional databases by using SQL Server Analysis Services (SSAS), and at creating tabular semantic data models for analysis with SSAS.

Voor wie:
The primary audience for this course are database professionals who need to fulfil a Business Intelligence Developer role. They will need to focus on hands-on work creating BI solutions including Data Warehouse implementation, ETL, and data cleansing.

The secondary audiences for this course are database professionals who need to fulfil BI Developer role to create enterprise BI solutions.

Inhoud:
M20767 Implementing a SQL Data Warehouse
– Module 1: Introduction to Data Warehousing
– Module 2: Planning Data Warehouse Infrastructure
– Module 3: Designing and Implementing a Data Warehouse
– Module 4: Columnstore Indexes
– Module 5: Implementing an Azure SQL Data Warehouse
– Module 6: Creating an ETL Solution
– Module 7: Implementing Control Flow in an SSIS Package
– Module 8: Debugging and Troubleshooting SSIS Packages
– Module 9: Implementing an Incremental ETL Process
– Module 10: Enforcing Data Quality
– Module 11: Using Master Data Services
– Module 12: Extending SQL Server Integration Services (SSIS)
– Module 13: Deploying and Configuring SSIS Packages
– Module 14: Consuming Data in a Data Warehouse
M20768 Developing SQL Data Models
– Module 1: Introduction to Business Intelligence and Data Modeling
– Module 2: Creating Multidimensional Databases
– Module 3: Working with Cubes and Dimensions
– Module 4: Working with Measures and Measure Groups
– Module 5: Introduction to MDX
– Module 6: Customizing Cube Functionality
– Module 7: Implementing a Tabular Data Model by Using Analysis Services
– Module 8: Introduction to Data Analysis Expression (DAX)
– Module 9: Performing Predictive Analysis with Data Mining

Deze certificering bestaat uit de volgende trainingen:
– M20767 Implementing a SQL Data Warehouse
– M20768 Developing SQL Data Models

Exclusief examens:
– 070-767 Implementing a SQL Data Warehouse – Retired
– 070-768 Developing SQL Data Models – Retired

DutchTrain is een officieel geaccrediteerd Test Center voor Pearson Vue Test, Prometric, Kryterion, Castle Worldwide, Certiport & PSI. U bent bij ons van harte welkom voor examens welke via deze Test Centers beschikbaar zijn. Examens kunnen elke dag, binnen kantooruren, worden afgenomen.

Datum:
Neem hiervoor contact op met een van onze opleidingsadviseurs.

Duur:
8 dagen

Dit traject is ook beschikbaar als:
– Education On Demand (E-Learning)
– Maatwerktraining, neem hiervoor contact op met een van onze opleidingsadviseurs.

Voor veelgestelde vragen tijdens het bestelproces, bekijk onze F.A.Q. pagina.