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.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.
"The training for PL-100 is an intense course, jam-packed with references, resources delivered by a super knowledgeable instructor. Would recommend having a sound base knowledge of Microsoft Power Platform before attending. MS Learn provides topics for PL-100 and also a study guide for the exam which is very useful when preparing for exam."
Jessica Brooks, Kenvue. (3/1/2024 (Wednesday) to 4/1/2024 (Thursday))
"Training facilities were great and the hotel onsite is nice."
Anonymous. (18/12/2023 (Monday) to 20/12/2023 (Wednesday))
"It's the best way to learn without any distraction. Training, eat, sleep, shower."
Anonymous. (13/12/2023 (Wednesday) to 15/12/2023 (Friday))
"When learning with Firebrand, everything is taken care of for you. This allows you to pour everything into absorbing and understanding your course content amongst peers."
ML, Griggster Limited. (3/10/2023 (Tuesday) to 6/10/2023 (Friday))
"Perfect instructor with much knowledge and the ability to bring it to the people. Thank you. The topic is huge but I would have expected a little bit more working together in the system."
Reinhard Decker, VAT Vakuumventile AG. (10/10/2023 (Tuesday) to 13/10/2023 (Friday))
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 |
|