The labs for this course have been deprecated. Furthermore, the exam associated with this course has been retired. However, this course still retains value as a training resource.
This advanced Microsoft MCSA: Business Intelligence training covers the objectives in the 70-768 exam, which is one of the two exams required to earn the MCSA: SQL 2016 BI Development certification.
There are some data analysts who read about using multidimensional data models, maintaining OLAP cubes, or implementing tabular data models and they get excited -- while others brace themselves. Whether the idea of those business intelligence solutions excites you or fills you with dread, this training has got you covered. The Microsoft Certified Solutions Associate in SQL 2016 Business Intelligence Development (MCSA: SQL 2016 BI Development) certification is more than just a mouthful, it also covers challenging topics in developing SQL data models. But not to worry: you'll be ready for one of the two certifying exams with our MCSA: Business Intelligence training.
For anyone with data analysts on their team, this Microsoft training can be used for 70-768 exam prep, onboarding new data analysts, individual or team training plans, or as a Microsoft reference resource.
MCSA: Business Intelligence: What You Need to Know
For any data analyst using this training for exam preparation, our MCSA: SQL 2016 BI Development course maps to the Microsoft 70-768 exam objectives, and covers topics such as:
- Implementing business intelligence solutions using multidimensional data models
- Using online analytical processing (OLAP) cubes
- Deploying and maintaining tabular data models
- Configuring and maintaining SQL Server Analysis Services (SSAS)
- Querying with multidimensional expressions (MDX) and data analysis expressions (DAX)
Who Should Take MCSA: Business Intelligence Training?
This MCSA: Business Intelligence training is considered associate-level Microsoft training, which means it was designed for data analysts. This SQL skills course is valuable for new IT professionals with at least a year of experience with data models and experienced data analysts looking to validate their Microsoft skills.
New or aspiring data analysts. If you're a new data analyst, or if you're considering entering the field, the need to design multidimensional business intelligence semantic models isn't so much a choice but an inevitability. Half of the MCSA: SQL 2016 is focused on using business intelligence data with high-quality models -- and this training covers that half of the exam.
Experienced data analysts. Data analysts who've been working for several years should recognize the value of knowing how to implement and maintain data models. This MCSA: SQL 2016 BI training gives you familiarity and expertise in designing, developing and creating them. If in your career so far you've missed out on using tabular BI semantic models, multidimensional expressions or data analysis expressions, this training can round out your knowledge.