Skip to content
CBT Nuggets

Microsoft MCSA: SQL 2016 BI Development (70-767 & 70-768)

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.

Updated March 2019

6Skills
121Videos
29Virtual Labs
16h 22mTotal
121 videos29 labs16h 22m

Who This Course Is 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.

Skills Your Team Will Gain

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

Course Curriculum

  • Premium skill.Microsoft SQL: Designing a Data Warehouse2h 52m + 5 labs
  • Premium skill.Microsoft SQL: SSIS4h 58m + 18 labs
  • Premium skill.Microsoft SQL: Data Quality1h 49m + 6 labs
  • Premium skill.Microsoft SQL: Data Modeling3h 23m
  • Premium skill.Microsoft SQL: MDX and DAX2h 16m
  • Premium skill.Microsoft SQL: SSAS Tuning1h 3m

Readiness check

Confirm prerequisite knowledge before training begins

A short placement assessment on the CBT Nuggets assessments platform measures whether a learner already has the foundation this course assumes. IT Directors use it to put the right people in the right training — and any learner can take it right now to make sure they'll get full value from day one.

  • Questions generated from this course's own lesson transcripts — what gets measured is exactly what gets taught
  • Instant, per-learner results that show whether the prerequisite foundation is in place
  • Results roll up into team readiness reporting, so training hours go where they change outcomes

Runs on assessments.cbtnuggets.com — sign in with an Adept account so results roll up into team readiness reporting. Need one? Create an Adept account.

This course is included with every subscription

Get your team access to all 559 courses, virtual labs, and practice exams.

Most Popular

Team

$749per seat / year

5+ learner seats

Get Started

Enterprise

Customannual contracts

Any size

Contact Enterprise Sales

Just need this course?

Single-course enrollment — $149 for 1 year of access to MCSA: SQL 2016 BI Development (70-767 and 70-768) Online Training.

Enroll in This Course
Calculate the ROI of training your team

Trusted by 23,000+ organizations

Frequently Asked Questions

Ready to upskill your team?

Talk to our sales team to find the right plan for your organization.