Looking for Global training? Go to https://firebrand.training/en or stay on the current site (Nederland)
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:
Other accelerated training providers rely heavily on lecture and independent self-testing and study.
Effective technical instruction must be highly varied and interactive to keep attention levels high, promote camaraderie and teamwork between the students and instructor, and solidify knowledge through hands-on learning.
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.41% 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.
"Training was very good, explanation was very clear and teacher detailed a lot, so for a 3 day course and to have a first understanding of POWER BI is good."
Rosanna Seerattan Cruz, JTI. (19/3/2024 (Tuesday) to 21/3/2024 (Thursday))
"The instructor and the structure of the course were very clear."
EK, JTI. (19/3/2024 (Tuesday) to 21/3/2024 (Thursday))
"Instructor was very knowledgeable and provided real life examples."
FO, NHS Lewisham and Greenwich. (11/10/2023 (Wednesday) to 13/10/2023 (Friday))
"Very intense and professional experience."
Anonymous. (11/10/2023 (Wednesday) to 13/10/2023 (Friday))
"Second course with Firebrand and more booked. Great tutors!"
Kenny Walker, BTEK Consultancy Ltd. (21/8/2023 (Monday) to 24/8/2023 (Thursday))
Start |
Finish |
Status |
Location |
Book now |
---|---|---|---|---|
19/2/2024 (Monday) |
20/2/2024 (Tuesday) |
Finished - Leave feedback |
- |
|
24/6/2024 (Monday) |
25/6/2024 (Tuesday) |
Wait list |
Nationwide |
|
5/8/2024 (Monday) |
6/8/2024 (Tuesday) |
Limited availability |
Nationwide |
|
16/9/2024 (Monday) |
17/9/2024 (Tuesday) |
Open |
Nationwide |
|
28/10/2024 (Monday) |
29/10/2024 (Tuesday) |
Open |
Nationwide |
|
9/12/2024 (Monday) |
10/12/2024 (Tuesday) |
Open |
Nationwide |
|