Microsoft Business Intelligence Training and Courseware 10990 Analyzing Data with SQL Server Reporting Services This five-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. 20767 Implementing a SQL Data Warehouse This five-day instructor-led course provides students with the knowledge and skills to provision a Microsoft SQL Server 2016 database. The course covers SQL Server 2016 provision both on-premise and in Azure, and covers installing from new and migrating from an existing install. 20768 Developing SQL Data Models The focus of this 3-day instructor-led course is on creating managed enterprise BI solutions. It describes how to implement both multidimensional and tabular data models and how to create cubes, dimensions, measures, and measure groups. This course helps you prepare for the Exam 70-768. TP2969 Data Modelling and Analysis with Power BI and Analysis Services After completing this course, students will be able to: Describe self-service BI. Describe the Power BI suite of products. Connect to data sources and optimize data models. Shape and combine data from different sources. Model data. Create a multidimensional database with Analysis Services Implement dimensions in a cube Implement measures and measure groups in a cube Use MDX syntax Customize a cube Implement a tabular database Use DAX to query a tabular model Create reports and dashboards WA2992 Power BI for Managers This Power BI for Managers training will provide IT Leaders with an overview of the key concepts features, and functionality provided by both Microsoft Power BI and SQL Server Analysis Services (SSAS). Participants in this course will gain an understanding of the Data Analysis and Data Visualization capabilities they provide and the possible advantages/disadvantages and use cases for each. WA3099 Custom Power BI using Power BI Report Server (on-premises) This Power BI Training course will discuss the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will also show how to access and process data from a range of data sources including both relational and non-relational data. This Power BI Training course will also explore how to implement publish reports on Power BI Report Server (on-premises) and share reports using users/groups and row-level security. Finally, this course will show how to build paginated reports within the Power BI service and publish them to a workspace for inclusion within Power BI. DA-100T00 Analyzing Data with Microsoft Power BI Also available as an On-Premise version (Power BI Report Server). This Power BI Training course will discuss the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will also show how to access and process data from a range of data sources including both relational and non-relational data. This Power BI Training course will also explore how to implement proper security standards and policies across the Power BI spectrum including datasets and groups. The course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution. Finally, this course will show how to build paginated reports within the Power BI service and publish them to a workspace for inclusion within Power BI. 20779 Analyzing Data with Excel The main purpose of the course is to give students the ability to add BI techniques to Excel data analysis. The course goes beyond the capabilities of tables and charts and uses Pivot Charts, the Excel Data Model, and Power BI.
Microsoft Business Intelligence Training and Courseware 10990 Analyzing Data with SQL Server Reporting Services This five-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. 20767 Implementing a SQL Data Warehouse This five-day instructor-led course provides students with the knowledge and skills to provision a Microsoft SQL Server 2016 database. The course covers SQL Server 2016 provision both on-premise and in Azure, and covers installing from new and migrating from an existing install. 20768 Developing SQL Data Models The focus of this 3-day instructor-led course is on creating managed enterprise BI solutions. It describes how to implement both multidimensional and tabular data models and how to create cubes, dimensions, measures, and measure groups. This course helps you prepare for the Exam 70-768. TP2969 Data Modelling and Analysis with Power BI and Analysis Services After completing this course, students will be able to: Describe self-service BI. Describe the Power BI suite of products. Connect to data sources and optimize data models. Shape and combine data from different sources. Model data. Create a multidimensional database with Analysis Services Implement dimensions in a cube Implement measures and measure groups in a cube Use MDX syntax Customize a cube Implement a tabular database Use DAX to query a tabular model Create reports and dashboards WA2992 Power BI for Managers This Power BI for Managers training will provide IT Leaders with an overview of the key concepts features, and functionality provided by both Microsoft Power BI and SQL Server Analysis Services (SSAS). Participants in this course will gain an understanding of the Data Analysis and Data Visualization capabilities they provide and the possible advantages/disadvantages and use cases for each. WA3099 Custom Power BI using Power BI Report Server (on-premises) This Power BI Training course will discuss the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will also show how to access and process data from a range of data sources including both relational and non-relational data. This Power BI Training course will also explore how to implement publish reports on Power BI Report Server (on-premises) and share reports using users/groups and row-level security. Finally, this course will show how to build paginated reports within the Power BI service and publish them to a workspace for inclusion within Power BI. DA-100T00 Analyzing Data with Microsoft Power BI Also available as an On-Premise version (Power BI Report Server). This Power BI Training course will discuss the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will also show how to access and process data from a range of data sources including both relational and non-relational data. This Power BI Training course will also explore how to implement proper security standards and policies across the Power BI spectrum including datasets and groups. The course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution. Finally, this course will show how to build paginated reports within the Power BI service and publish them to a workspace for inclusion within Power BI. 20779 Analyzing Data with Excel The main purpose of the course is to give students the ability to add BI techniques to Excel data analysis. The course goes beyond the capabilities of tables and charts and uses Pivot Charts, the Excel Data Model, and Power BI.
