- Course info
- Course resources
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.