Empower modern analytics and business intelligence data cultures with Excel, Power BI, MS Teams, and SharePoint

Data Analyst
Business Analyst
Power BI
Microsoft Power Platform

Excel is a Microsoft application that has been in use since 1985. You might be surprised that in addition to simple spreadsheets, Excel can enable modern analytics and business intelligence. In this Learning Path, you will learn how to modernize and empower data conversations within your organization using Excel & Power BI together with MS Teams, and SharePoint. You’ll gain awareness of the business intelligence landscape, technology capabilities, and their roles.


Familiarity with Microsoft Excel, Office 365 and Excel 2016+, PivotTables, Microsoft Teams and SharePoint.

Modules in this learning path

Learn how Microsoft Office 365/Microsoft Excel 2016+, combined with Microsoft Power Query, Data Model, Power BI Desktop, and Power BI service come together to provide Microsoft modern analytics capabilities.

Power Query in Microsoft Excel is a powerful data connection, cleaning, and shaping technology that is a core part of the Microsoft modern analytics suite of business intelligence tools. Achieving clean data for analysis consumes countless hours for professionals across all industries. With Power Query, your data preparation and cleaning will be transformed, automated, and improved, giving you time for analysis and for driving business impact.

This module introduces data modeling concepts and the recommended best practices for creating a data model. You will learn about data model relationships, table types, measures, and calculated columns.

Power BI Desktop is a Microsoft application encompassing Power Query and DAX data model technologies from Excel with the cloud Power BI service and many other features.

Power BI enables report authors to produce interactive reports using visuals, slicers, bookmarks, and more.

Secure, share, publish, and keep data up to date using workspaces in the Power BI service, empowering teams to discover limitless data insights.

This module explains the different ways that Microsoft Excel users can interact with Microsoft Power BI datasets to analyze data.

This module goes into the different ways users can incorporate Power BI reports or visuals into Microsoft Teams and SharePoint to collaborate with others.