Looking for Global training? Go to https://firebrand.training/en or stay on the current site (Suomi)
On this accelerated 5 day MCSA: SQL Server 2016 Business Intelligence Development course, you’ll learn to implement a SQL Server 2016 data warehouse solution to support a business intelligence. You’ll go on to learn how to use the capabilities of SQL Server 2016 to create business intelligence solutions.
These skills will allow you to query, process, analyse and report on a vast amount of raw business data. Skills you’ll learn will include creating multidimensional databases and cubes, using MDX, DAX and data mining.
Your accelerated course will be taught by Microsoft Certified Trainers (MCT), using Microsoft Official Curriculum (MOC) and practice tests. You’ll also use Firebrand’s unique Lecture | Lab | Review technique, covering topics like:
This course is best suited towards database professionals who work with SQL Server 2016 and conduct analysis using business intelligence solutions.
This module describes data warehouse concepts and architecture consideration.
Lessons
Lab : Exploring a Data Warehouse Solution
After completing this module, you will be able to:
This module describes the main hardware considerations for building a data warehouse.
Lessons
Lab : Planning Data Warehouse Infrastructure
After completing this module, you will be able to:
This module describes how you go about designing and implementing a schema for a data warehouse.
Lessons
Lab : Implementing a Data Warehouse Schema
After completing this module, you will be able to:
This module introduces Columnstore Indexes.
Lessons
Lab : Using Columnstore Indexes
After completing this module, you will be able to:
This module describes Azure SQL Data Warehouses and how to implement them.
Lessons
Lab : Implementing an Azure SQL Data Warehouse
After completing this module, you will be able to:
At the end of this module you will be able to implement data flow in a SSIS package.
Lessons
Lab : Implementing Data Flow in an SSIS Package
After completing this module, you will be able to:
This module describes implementing control flow in an SSIS package.
Lessons
Lab : Implementing Control Flow in an SSIS Package
Lab : Using Transactions and Checkpoints
After completing this module, you will be able to:
This module describes how to debug and troubleshoot SSIS packages.
Lessons
Lab : Debugging and Troubleshooting an SSIS Package
After completing this module, you will be able to:
This module describes how to implement an SSIS solution that supports incremental DW loads and changing data
Lessons
Lab : Extracting Modified Data
Lab : Loading a data warehouse
After completing this module, you will be able to:
This module describes how to implement data cleansing by using Microsoft Data Quality services.
Lessons
Lab : Cleansing Data
Lab : De-duplicating Data
After completing this module, you will be able to:
This module describes how to implement master data services to enforce data integrity at source.
Lessons
Lab : Implementing Master Data Services
After completing this module, you will be able to:
This module describes how to extend SSIS with custom scripts and components.
Lessons
Lab : Using scripts
After completing this module, you will be able to:
This module describes how to deploy and configure SSIS packages
.Lessons
Lab : Deploying and Configuring SSIS Packages
After completing this module, you will be able to:
This module describes how to debug and troubleshoot SSIS packages.
Lessons
Lab : Using a data warehouse
After completing this module, you will be able to:
This module introduces key BI concepts and the Microsoft BI product suite.
Lessons
Lab :;Exploring a BI Solution
After completing this module, you'll be able to:
This module describes how to create multidimensional databases using SQL Server Analysis Services.
Lessons
Lab : Creating a multidimensional database
After completing this module, you will be able to:
This module describes how to implement dimensions in a cube.
Lessons
Lab : Working with Cubes and Dimensions
After completing this module, you will be able to:
This module describes how to implement measures and measure groups in a cube.
Lessons
Lab : Configuring Measures and Measure Groups
After completing this module, you will be able to:
This module describes the MDX syntax and how to use MDX.
Lessons
Lab : Using MDX
After completing this module, you will be able to:
This module describes how to customise a cube.
Lessons
Lab : Customising a Cube
After completing this module, you will be able to:
This module describes how to implement a tabular data model in Power Pivot.
Lessons
Lab : Working with an Analysis Services Tabular Data Model
After completing this module, you'll be able to:
This module describes how to use DAX to create measures and calculated columns in a tabular data model.
Lessons
Lab : Creating Calculated Columns and Measures by using DAX
After completing this module, you'll be able to:
This module describes how to use data mining for predictive analysis.
Lessons
Lab : Using Data Mining
After completing this module, you'll be able to:
You'll sit the following exams, covered by your Certification Guarantee:
Exam 70-767: Implementing a SQL Data Warehouse
The skills you'll be tested on include the following:
Exam 70-768: Developing SQL Data Models
The skills you'll be tested on include the following:
It is recommended you have at least 2 years’ experience of working with relational databases, including:
An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable
Olemme kouluttaneet kymmenen vuoden aikana yli 134.561 opiskelijaa. Heitä kaikkia on pyydetty arvioimaan pikakurssimme. Tällä hetkellä 95,63% on sitä mieltä, että Firebrand on ylittänyt heidän odotuksensa:
"Unlike any other training I've taken before in that it's all encompassing for the duration of the course, but if you can deal with the extra effort you have to put in, its well worth the investment. A tough but very worthwhile learning experience. "
Carl Vonk. (9/3/2020 (Maanantai) - 13/3/2020 (Perjantai))
"Fast paced training with very knowledgeable teacher. I had a great time learning for my MCSA at Firebrand."
Alexandre Snoeck, Fanuc Europe Corporation. (9/3/2020 (Maanantai) - 13/3/2020 (Perjantai))
"Thank you, a fantastic course!"
Denys Lykov, National Grid. (11/3/2019 (Maanantai) - 15/3/2019 (Perjantai))
"Firebrand, as intensive as it is has certainly accelerated my learning and performance to a level I didnt know was possible. I have learned things that will aid my going forward in my career and a certification is the cherry on top. The instructor is a fantastic teacher, with incredible knowledge levels on the subjects at hand. Her method of teaching has certainly aided me in appreciating just how enjoyable Firebrand can be."
Andrew ODonnell, Amey Defence Services. (11/3/2019 (Maanantai) - 15/3/2019 (Perjantai))
"Its Good."
Lyndon Martin, Nottinghamshire Healthcare. (26/11/2018 (Maanantai) - 30/11/2018 (Perjantai))
Alkaa |
Loppuu |
Saatavuus |
Sijainti |
Rekisteröidy |
---|---|---|---|---|
27/5/2024 (Maanantai) |
31/5/2024 (Perjantai) |
Päättynyt - Jätä palautetta |
- |
|
30/9/2024 (Maanantai) |
4/10/2024 (Perjantai) |
Odotuslista |
Maanlaajuinen |
|
11/11/2024 (Maanantai) |
15/11/2024 (Perjantai) |
Rajoitettu määrä paikkoja |
Maanlaajuinen |
|
|
|
|
|
|
3/2/2025 (Maanantai) |
7/2/2025 (Perjantai) |
Paikkoja saatavilla |
Maanlaajuinen |
|
17/3/2025 (Maanantai) |
21/3/2025 (Perjantai) |
Paikkoja saatavilla |
Maanlaajuinen |
|