Developing SQL Data Models - 70-768 - Microsoft Certification Training Training | CBT Nuggets

MCSA: Business Intelligence Online Training


Knox Hutchinson


MCSA: Business Intelligence Online Training

This entry-level Microsoft MCSA: Business Intelligence training covers the objectives in the 70-768 exam, which is one of the two exams required to earn the MCSA: SQL 2016 BI Development certification.

There are some data analysts who read about using multidimensional data models, maintaining OLAP cubes, or implementing tabular data models and they get excited -- while others brace themselves. Whether the idea of those business intelligence solutions excites you or fills you with dread, this training has got you covered. The Microsoft Certified Solutions Associate in SQL 2016 Business Intelligence Development (MCSA: SQL 2016 BI Development) certification is more than just a mouthful, it also covers challenging topics in developing SQL data models. But not to worry: you'll be ready for one of the two certifying exams with our MCSA: Business Intelligence training.

For anyone with data analysts on their team, this Microsoft training can be used for 70-768 exam prep, onboarding new data analysts, individual or team training plans, or as a Microsoft reference resource.

MCSA: Business Intelligence: What You Need to Know

For any data analyst using this training for exam preparation, our MCSA: SQL 2016 BI Development course maps to the Microsoft 70-768 exam objectives, and covers topics such as:

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

Who Should Take MCSA: Business Intelligence Training?

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.

New or aspiring data analysts. If you're a new data analyst, or if you're considering entering the field, the need to design multidimensional business intelligence semantic models isn't so much a choice but an inevitability. Half of the MCSA: SQL 2016 is focused on using business intelligence data with high-quality models -- and this training covers that half of the exam.

Experienced data analysts. Data analysts who've been working for several years should recognize the value of knowing how to implement and maintain data models. This MCSA: SQL 2016 BI training gives you familiarity and expertise in designing, developing and creating them. If in your career so far you've missed out on using tabular BI semantic models, multidimensional expressions or data analysis expressions, this training can round out your knowledge.

Skills You'll Learn in this Course

  • 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
  • More on our blog

    More on our YouTube channel

    What Business Intelligence Jobs Are Available?

    Business intelligence professionals create meaning out of the mountain of data generated by businesses. CBT Nuggets trainer Knox Hutchinson talks about all of the exciting opportunities available in the world of business intelligence.