Looking for Global training? Go to https://firebrand.training/en or stay on the current site (Deutschland)
In just 2 days, upgrade your skills to MCSA: SQL Server 2016 Business Intelligence Development. This course is aimed at MCSA: SQL Server 2012/14 certified professionals.
On this course you’ll learn how to implement multidimensional databases and create tabular semantic data models using Server Analysis Services (SSAS).
Your Microsoft Certified Trainer will make use of both theoretical and practical lessons. In combination with this, Firebrand’s unique Lecture | Lab | Review technique will help you better retain knowledge and demonstrate how your skills can be applied to real-life scenarios, including:
You'll also be prepared to sit exam 70-768: Developing SQL Data Models. You'll sit this as part of the course, covered by your Certification Guarantee.
This course is aimed at Business Intelligence Developers with working knowledge of BI solutions, implementing and managing OLAP cubes and implementing tabular data models.
With Firebrand being Microsoft Learning Partners, you'll get access 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 exam, covered by your Certification Guarantee:
The exam will test the following skills:
Your accelerated course includes:
This course requires that you meet the following prerequisites:
Unsure whether you meet the prerequisites? Don’t worry. Your training consultant will discuss your background with you to understand if this course is right for you.
Here's the Firebrand Training review section. Since 2001 we've trained exactly 134561 students and asked them all to review our Accelerated Learning. Currently, 96.40% have said Firebrand exceeded their expectations.
Read reviews from recent accelerated courses below or visit Firebrand Stories for written and video interviews from our alumni.
"I think Firebrand offers a very good and efficient concept to prepare for an exam in a very short period of time."
Anonymous (3.9.2018 (Monday) to 5.9.2018 (Wednesday))
"Good value."
Shankar Natesan. (3.9.2018 (Monday) to 5.9.2018 (Wednesday))
"Firebrand is a great bootcamp, where you can learn a lot and get very useful certifications. "
Adela Toma, Bearing Point. (19.3.2018 (Monday) to 24.3.2018 (Saturday))
"Perfect training!"
P. E.. (4.12.2017 (Monday) to 6.12.2017 (Wednesday))
"A high tempo and lots to learn from a great instructor. Thanks for helping me pass the exam in a quick tempo."
Seth Lindholm, Advitum AB (SWEDEN). (21.11.2016 (Monday) to 25.11.2016 (Friday))
Start |
Finish |
Status |
Location |
Book now |
---|---|---|---|---|
27.11.2023 (Monday) |
28.11.2023 (Tuesday) |
Finished - Leave feedback |
- |
|
1.4.2024 (Monday) |
2.4.2024 (Tuesday) |
Wait list |
Nationwide |
|
13.5.2024 (Monday) |
14.5.2024 (Tuesday) |
Limited availability |
Nationwide |
|
24.6.2024 (Monday) |
25.6.2024 (Tuesday) |
Open |
Nationwide |
|
5.8.2024 (Monday) |
6.8.2024 (Tuesday) |
Open |
Nationwide |
|
16.9.2024 (Monday) |
17.9.2024 (Tuesday) |
Open |
Nationwide |
|