MCSA: Business Intelligence Online Training

Note: The labs for this course have been deprecated and the exam associated with this course has been retired. However, this course still retains value as a training resource.

Taught by

Knox Hutchinson

UPDATED: October 16, 2019

Expert

This MCSA: Business Intelligence training covers how to design models and queries for managing business intelligence data with SQL 2016. Learn to implement multidimensional data models, OLAP cubes, and tabular models. Gain expertise in SQL Server Analysis Services (SSAS) and querying with MDX and DAX. This Microsoft SQL course can be used for onboarding new data analysts, or as a Microsoft reference resource.

Start a free week

Subscription options

$59.00

Access all premium content with a free week!

Quizzes
CyberVista® IT practice exams
Coaching
IT learner community

Start a free week

See training reviews

What you'll learn

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)

FAQs

What will you learn in this Microsoft SQL data training?

Over the course of this business intelligence and SQL data models training, you'll learn to design multidimensional business intelligence semantic models, design tabular models, develop queries with different syntaxes like MDX and DAX, and configure Microsoft's data mining tool SSAS. In short, this course teaches you to be a Microsoft-powered Business Intelligence whiz.

Who should take this SQL data models development course?

This is a fairly advanced data analytics course that's intended for experienced data professionals who are already familiar with their job but are branching out into different software. If you're just learning Microsoft SQL 2016 but you're familiar with data analysis practices, this course can help you master the outdated software while extending and enhancing your business intelligence skills.

Is this training in developing SQL data models associated with any certifications?

Yes, this course was originally designed to help learners prepare for Microsoft's MCSA: SQL 2016 BI Development certification. Unfortunately, Microsoft retired all MCSA certs in 2020. That doesn't mean the information on this course is no longer valid, though. You won't earn the MCSA after this course, but you will master multidimensional expression-based solutions.

What certification should you consider after taking this course in developing SQL data models?

Although the MCSA series of certifications has been retired, there are still plenty of data analysis and business intelligence certifications from Microsoft to consider after taking this course. Microsoft Certified: Power BI Data Analyst Associate or Microsoft Certified: Azure Enterprise Data Analyst Associate are two excellent data analysis certifications that this course will help you toward.

Why should you take this SQL data model development training?

You should take this course on developing SQL data models so that you can say with a straight face that you know how to design and implement a multidimensional business intelligence semantic model. Impress everyone with your ability to select appropriate dimension models while writing unique formulas in DAX. You'll be the coolest data nerd in the office.

Who is this for?

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.

What our learners say

You constantly have to invest in training for your people.
Rick N. | CEO
Awesome, Top notch, I am super excited and thankful for CBT Nuggets. I am starting to get addicted to CBT Nuggets. I hope that there's no cure!!!
Mike M. | CBTN Learner
The more I put into learning, the more skills I’m going to have — and the better I’m going to be technically.
Knox Hutchinson | CBT Nuggets trainer since 2018

Study plan

Download the free MCSA: Business Intelligence Online Training study plan to complete this course in about 7 hours.

Download study plan