MCSA: SQL 2016 BI Development (70-767 and 70-768) Online Training

Note: The exams associated with this course have been retired. However, this course still retains value as a training resource.

Taught by

Knox Hutchinson

UPDATED: March 14, 2019

Expert

Virtual Labs

This intermediate Microsoft Business Intelligence training prepares BI professionals to design, implement, and maintain data warehouses, deploy SSIS packages, implement ETL, and develop BI models using SSAS, MDX, and DAX. This Microsoft course maps to the MCSA: SQL 2016 BI Development (70-767 and 70-768) exams, and teaches valuable BI skills.

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

Design, implement, and maintain a data warehouse
Deploy, configure, and debug SQL Server Integration Services (SSIS) packages
Design and implement an extract, transform, and load (ETL) control flow
Create a Data Quality Services (DQS) knowledge base, perform knowledge discovery and domain management
Implement a Master Data Services (MDS) model and create a Master Data Management (MDM) hub
Design and implement a multidimensional business intelligence (BI) semantic model using Microsoft SQL Server Analysis Services (SSAS)
Design, manage, and publish a tabular BI semantic model
Develop queries using Multidimensional Expressions (MDX) and Data Analysis Expressions (DAX)

FAQs

What was the underlying technology tested on the MCSA: SQL 2016 BI Development?

The underlying technology tested on MCSA: SQL 2016 BI Development and its two required exams 70-767 and 70-768 was data warehouse management and maintenance, including extracting, transforming and loading data, designing multidimensional business intelligence models and developing queries with MDX and DAX. The MCSA: SQL 2016 BI Development and its exams (70-767 and 70-768) were most focused on implementing a data warehouse with SQL and developing SQL data models.

Are the MCSA: SQL 2016 BI Development exams 70-767 and 70-768 retired?

Yes, both of the Microsoft certifying exams 70-767: Implementing a Data Warehouse using SQL and 70-768: Developing SQL Data Models are retired. Microsoft retired 70-767 and 70-768 on January 31, 2021 because they retired their entire series of MCSA certifications. This wasn't like other times when Microsoft was updating the material on certifying exams -- it's no longer possible to take the 70-767 or 70-768 and there are no replacements.

What happened to the Microsoft certification MCSA: SQL 2016 BI Development?

Microsoft retired their MCSA: SQL 2016 BI Development certification on January 31, 2021. Microsoft didn't revoke the cert, so if you'd already taken the certifying exams for the MCSA: SQL 2016 BI Development (70-767 & 70-768), the certification should still be on your transcript. But if you hadn't earned the MCSA: SQL 2016 BI Development before it got retired, it's no longer possible to take the exams or earn the certification.

What certification replaced the MCSA: SQL 2016 BI Development?

Nothing, no certification replaced Microsoft's MCSA: SQL 2016 BI Development. Microsoft retired their entire series of MCSA certifications, including MCSA: SQL 2016 BI Development, because they want their certifications to reflect more broadly everything a person needs to know according to their job. There are Microsoft Certified and Microsoft 365 Certified certifications for data analysts, app developers, data engineers, and others that may replace the MCSA: SQL 2016 BI Development.

Is this MCSA: SQL 2016 BI Development training still valuable?

Yes, this MCSA: SQL 2016 BI Development training is still valuable because the content hasn't expired, just the certification. If you're one of the many IT professionals, administrators, or BI developers who needs to better understand implementing and managing data warehouses using SQL, or multidimensional data models, or even how to maintain OLAP cubes, then this MCSA: SQL 2016 BI Development is definitely still valuable.

Who is this for?

This 70-767 and 70-768 course is valuable for new IT professionals with at least a year of experience with SQL database and experienced BI professionals 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
I didn't ever think I'd have the position I have now.
Jenna B. | Service Operations Manager

Study plan

Download the free MCSA: SQL 2016 BI Development (70-767 and 70-768) Online Training study plan to complete this course in about 16 hours.

Download study plan