MS-MCSA-BI Reporting – MCSA: BI Reporting

Earning an MCSA: BI Reporting demonstrates knowledge relevant to data analysis, data visualization, modeling, dashboards, and direct connectivity to data sources in Excel and Power BI. It is the first step on your path to becoming a Data Management and Analytics Microsoft Certified Solutions Expert (MCSE).

MS-20778 – Analyzing Data with Power BI

The main purpose of the course is to give students a good understanding of data analysis with Power BI. The course includes creating visualizations, the Power BI Service, and the Power BI Mobile App.

MS-20768 – Developing SQL 2016 Data Models

This three-day instructor-led course is aimed at database professionals who fulfil a Business Intelligence (BI) developer role. This course looks at implementing multidimensional databases by using SQL Server Analysis Services (SSAS), and at creating tabular semantic data models for analysis with SSAS.

MS-20767 – Implementing a SQL 2016 Data Warehouse

This 4-day instructor led course describes how to implement a data warehouse platform to support a BI solution. Students will learn how to create a data warehouse with Microsoft® SQL Server® 2016 and with Azure SQL Data Warehouse, to implement ETL with SQL Server Integration Services, and to validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.

MS-10990 – Analyzing Data with SQL Server Reporting Services 2016

This three-day instructor-led course teaches students how to implement a SQL Server 2016 Reporting Services solution for data analysis in an organization. The course discusses how to use the Reporting Services development tools to create and manage reports and implement self-service BI solutions.

MS-10988 – Managing SQL Business Intelligence Operations

This three-day instructor-led course is aimed at database professionals who manage Business Intelligence (BI) operations. This course looks at various options that provide the ability of business users to analyze data and share their findings, starting with managed BI data sources and expanding to personal and external/public data sources

MS-MCSA-SQL-2016-BI – MCSA: SQL 2016 Business Intelligence Development

The MCSA: SQL 2016 Business Intelligence Development Certification validates your extract, transform, and load (ETL) and data warehouse skills, along with those for implementing BI solutions using multidimensional and tabular data models and online analytical processing (OLAP) cubes. This certification will qualify you for a position as a BI developer.
This Unitek Training Boot Camp provides students hands-on experience with SQL Server 2016. The boot camp will highlight what is new in SQL Server 2016 in comparison to SQL Server 2012/2014. It provides guidance on designing, implementing and populating Data Warehouses in SQL 2016. As well as working with cubes and other data models in SQL Server Analysis Services 2016.

MS-20467 – Designing Self-Service Business Intelligence and Big Data Solutions

Unitek Training’s Designing Self-Service Business Intelligence and Big Data Solutions five-day instructor-led course teaches students how to implement self-service Business Intelligence (BI) and Big Data analysis solutions using the Microsoft data platform. The course discusses the rationale for self-service BI, and describes how to use Microsoft SQL Server Reporting Services, Microsoft Excel, Microsoft SharePoint Server, and Microsoft Office 365 Power BI to create self-service data models and reports. The course then goes on to describe how to use Windows Azure HDInsight to perform Big Data analysis.
This course is often taught as part of the FastTrack to MCSE Data Management and Analytics through SQL Business Intelligence.

MS-20466 – Implementing Data Modules and Reports with Microsoft SQL Server

Unitek Training’s Implementing Data Modules and Reports with Microsoft SQL Server five-day instructor-led course is on creating managed enterprise BI solutions. It describes how to implement multidimensional and tabular data models, deliver reports with Microsoft SQL Server Reporting Services, create dashboards with Microsoft SharePoint Server PerformancePoint Services, and discover business insights by using data mining.

MS-20463 – Implementing a Data Warehouse with Microsoft SQL Server

Unitek Training’s Implementing a Data Warehouse with Microsoft SQL Server course describes how to implement a data warehouse platform to support a BI solution. Students will learn how to create a data warehouse with Microsoft SQL Server 2014, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services
This course is often taught as part of the MCSA: SQL Server 2012/2014 Boot Camp.