Empower modern analytics and business intelligence data cultures with Excel, Power BI, MS Teams, and SharePoint
At a glance
-
Level
-
Skill
-
Product
-
Subject
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.
Prerequisites
Familiarity with Microsoft Excel, Office 365 and Excel 2016+, PivotTables, Microsoft Teams and SharePoint.
Achievement Code
Would you like to request an achievement code?
Modules in this learning path
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 enables report authors to produce interactive reports using visuals, slicers, bookmarks, and more.
This module goes into the different ways users can incorporate Power BI reports or visuals into Microsoft Teams and SharePoint to collaborate with others.