Looking for Global training? Go to https://firebrand.training/en or stay on the current site (Suomi)
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:
We interview all applicants for the course on their technical background, degrees and certifications held, and general suitability. If you get through this screening process, it means you stand a great chance of passing.
Firebrand Training is an immersive training environment. You must be committed to the course. The above prerequisites are guidelines, but many students with less experience have other background or traits that have enabled their success in accelerated training through Firebrand Training.
If you have any doubts as to whether you meet the pre-requisites please call 09 - 31 587 431 and speak to one of our enrolment consultants, who can help you with a training plan.
We've currently trained 134.561 students in 12 years. We asked them all to review our Accelerated Learning. Currently,
95,98% have said Firebrand exceeded their expectations:
"Great trainers and facilities, and being away from work & family really helps you focus on the material."
R.C.M., PGI - Protection Group International Ltd.. (22/4/2024 (Monday) to 27/4/2024 (Saturday))
"Excellent training. Material and instructor very good. Good facilities. Preferred method of learning moving forward."
J.B.. (22/4/2024 (Monday) to 27/4/2024 (Saturday))
"The in-person training is always effective. I have never done certification before I have around 20+ yrs of exp and I did my first one with Firebrand. The only reason I passed the exam due to focused time and no distraction."
Arul Jayaraman, Yayati consulting ltd. (22/4/2024 (Monday) to 27/4/2024 (Saturday))
"The course was very interesting and interactive."
Matthew Clulee, Venture Systems Group. (23/4/2024 (Tuesday) to 26/4/2024 (Friday))
"A good training course, with experienced and knowledgeable instructor, reacting to skills and experience level of the class students."
Mike Hilton, WWF-UK. (22/4/2024 (Monday) to 24/4/2024 (Wednesday))
Start |
Finish |
Status |
Location |
Book now |
---|---|---|---|---|
27/5/2024 (Monday) |
28/5/2024 (Tuesday) |
Finished - Leave feedback |
- |
|
30/9/2024 (Monday) |
1/10/2024 (Tuesday) |
Wait list |
Nationwide |
|
11/11/2024 (Monday) |
12/11/2024 (Tuesday) |
Limited availability |
Nationwide |
|
|
|
|
|
|
3/2/2025 (Monday) |
4/2/2025 (Tuesday) |
Open |
Nationwide |
|
17/3/2025 (Monday) |
18/3/2025 (Tuesday) |
Open |
Nationwide |
|