MCSA: Business Intelligence Online Training

Note: 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

Virtual Labs

This MCSA: Business Intelligence training covers data cleansing, ETL, and warehouse implementation with SQL 2016. Learn to implement business intelligence solutions with multidimensional data models, OLAP cubes, and tabular data models. You'll also work with SQL Server Analysis Services (SSAS) and query with MDX and DAX. This SQL skills course prepares you for the 70-768 exam.

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's the difference between a database and a data warehouse?

The biggest difference between databases and data warehouses is how frequently the stored data is accessed and for what purpose. A database is designed for day-to-day operations and transactional processing – emphasizing frequently accessed data. On the other hand, a data warehouse is more focused on analytical processing of large volumes of historical data from many sources. Data warehouses tend to support more complex queries and analysis, reporting and data mining.

Is it worth learning how to implement and manage data warehouses?

Yes, for people working as data engineers, data analysts and business intelligence professionals (or people who want to get a job in those positions), learning to manage data warehouses is definitely worth it. More and more organizations depend on large volumes of data for analytics, reporting and decision-making. Learning data warehouse concepts like architecture and implementation techniques makes you a valuable asset to companies who need accessibility, reliability and performance.

Did Microsoft retire exam 70-767: Implementing a Data Warehouse using SQL?

Yes, Microsoft retired 70-767 certification exam: Implementing a Data Warehouse Using SQL in January 2021. When they retired the cert and its exam, no replacement was announced, so the 70-767 no longer has a place in the Microsoft certification world. Microsoft has been moving away from certifying technologies and tools that aren't tied to their cloud-based suites, but knowledge and skills related to implementing data warehouses remain (obviously) highly relevant.

Is learning to implement data warehouses in SQL still worth it even though the exam is retired?

Yes, Microsoft's SQL Data Warehouse Implementation cert might have been retired but understanding data warehousing concepts, SQL implementation, ETL processes, and data integration techniques remains crucial in today's data-driven world. The certification might no longer be available, the expertise gained from studying its material remains valuable for professionals seeking to excel in data warehouse implementation and management roles. This course is no less rigorous or thorough for the certification's retirement.

What are the alternatives to exam 70-767: Implementing a Data Warehouse Using SQL?

Now that 70-767 is retired, you might want an alternative way to prove your competence with data warehouse or SQL techniques, tools and technologies. Unfortunately Microsoft doesn't have a direct alternative for the certification. Microsoft does recommend the Microsoft Certified: Azure Database Administrator Associate certification instead (its exam is DP-300: Administering Microsoft Azure SQL Solutions). While similar, that certification and exam are more focused on Azure cloud-based data management.

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

It feels like the best and the brightest people are training with you — and they are just hanging out with you and showing you the ropes.
John McCann | IT manager and CBT Nuggets learner
Very easy and fun way to learn. Keith Barker is my favorite, he'll throw in jokes here and there and it makes me remember certain study points. I highly recommend this app and purchasing subscriptions, it is truly worth the money.
Joshua E. | IT Systems Administrator
CBT Nuggets is exactly what I needed.
Thomas S. | Systems Engineer & Consultant

Study plan

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

Download study plan