Microsoft MCSA - 70-767 - 70-768 - SQL 2016 BI Development - Microsoft Certification Training Training | CBT Nuggets

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


Knox Hutchinson


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

In this entry-level Microsoft Business Intelligence training, Knox Hutchinson and Garth Schulte prepares BI professionals to take the 70-767 and 70-768 exam, which are the two exams required to earn the MCSA: SQL 2016 BI Development certification.

Companies are generating more data than ever before, and they need people to help make sense of it all. That’s the role of a business intelligence professional. This MCSA: SQL 2016 BI Development exams were designed by Microsoft to validate the entry-level skills expected of a BI professional with one year of experience.

After completing this MCSA training, you'll be prepped for the 70-767 and 70-768 and be ready to reap the benefits that come with both Microsoft training and certification.

For anyone who manages their Microsoft training, this MCSA training can be used for 70-767 and 70-768 exam prep, on-boarding new BI professionals, or as part of a team training plan.

MCSA: SQL 2016 BI: What You Need to Know

This MCSA: SQL 2016 BI Development training follows the 70-767 and 70-768 exam objectives, and covers topics such as:

  • 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)

Who Should Take MCSA: SQL 2016 BI Training?

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.

New or aspiring BI professionals. The demand for data professionals who can extract, transform, and load (ETL) data, establish data warehouses, and use multidimensional and tabular data models outpaces the supply. It’s a good time to be an analyst, and this MCSA: SQL 2016 BI Development will prepare you for these types of jobs.

Experienced IT professionals. Employer demand for fully trained BI professionals is rapidly rising. In the past few years, data scientist and data analysts have emerged as the hottest jobs in the United States. If you’re looking to transition to one of these roles, this MCSA: SQL 2016 BI Development training will prepare you to develop data warehouses and create models in a Microsoft SQL Server environment.

Skills You'll Learn in this Course

  • Microsoft SQL: Designing a Data Warehouse

    Advanced1 hr 59 mins18 videos
  • Microsoft SQL: SSIS

    Advanced2 hrs 53 mins24 videos
  • Microsoft SQL: Data Quality

    Advanced1 hr 10 videos
  • Microsoft SQL: Data Modeling

    Advanced3 hrs 13 mins29 videos
  • Microsoft SQL: MDX and DAX

    Advanced2 hrs 6 mins27 videos
  • Microsoft SQL: SSAS Tuning

    Advanced 58 mins13 videos
  • MCSA: SQL 2016 BI Learning Resources

    Our MCSA: SQL 2016 BI Development training includes videos, in-video quizzes, virtual labs hand-built by Knox Hutchinson, and complete Kaplan IT 70-767 and 70-768 practice tests.

    More on our blog

    More on our YouTube channel

    MicroNugget: How to Connect SSAS to Power BI

    In this video, Knox Hutchinson covers how to use SSAS to publish a data model, demonstrating how it will appear to your end users. The material covered here directly ties into Microsoft’s 70-768 exam, which is one of two exams you need to pass to earn an MCSA: SQL 2016 BI Development certification.