Empower modern analytics and business intelligence data cultures with Excel Power BI MS Teams and SharePoint
- Offered byMicrosoft
Empower modern analytics and business intelligence data cultures with Excel Power BI MS Teams and SharePoint at Microsoft Overview
Duration | 7 hours |
Start from | Start Now |
Total fee | Free |
Mode of learning | Online |
Schedule type | Self paced |
Difficulty level | Beginner |
Official Website | Explore Free Course  |
Credential | Certificate |
Empower modern analytics and business intelligence data cultures with Excel Power BI MS Teams and SharePoint at Microsoft Course details
- Introduction to modern analytics using Excel and Power BI
- Automate data cleaning with Power Query
- Introduction to foundations in data modeling
- Transition from Excel to Power BI
- Design interactive data experiences with Power BI Desktop
- Secure, publish, and share data in Power BI
- Transcend data analysis together with Power BI and Excel
- Integrate Power BI in Microsoft Teams and SharePoint
- 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
- 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
- This course 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
Empower modern analytics and business intelligence data cultures with Excel Power BI MS Teams and SharePoint at Microsoft Curriculum
Introduction to modern analytics using Excel and Power BI
Introduction
Benefits of modern analytics
Ecosystem of modern analytics
Roles of modern analytics
Install and update modern analytics applications
Check your knowledge
Summary
Automate data cleaning with Power Query
Introduction
Explore the Power Query user interface
Import data
Common data challenges and Power Query transformations
Lab 01 - Use Power Query in Excel
Check your knowledge
Summary
Introduction to foundations in data modeling
Introduction
Data model relationships
Data model table types
Data model measures
Data model calculated columns
Data model benefits
Check your knowledge
Summary
Transition from Excel to Power BI
Excel to Power BI introduction
Power Query in Power BI Desktop
Data modeling in Power BI Desktop
Exercise - Import to Power BI Desktop
Check your knowledge
Summary
Design interactive data experiences with Power BI Desktop
Introduction
Use Power BI
Use Power BI to build a data model
Check your knowledge
Summary
Secure, publish, and share data in Power BI
Share and use reports in Power BI
Row-level security
Publish a report to a Power BI workspace
Share reports and user experience
Protect data in Power BI
Data refresh and alerts
Check your knowledge
Summary
Transcend data analysis together with Power BI and Excel
Enable compatibility with Excel
Connect Excel to Power BI datasets
Dataset types and security
Convert PivotTables to formulas
Office 365/Excel 2016+ formulas
Featured tables and lineage
Excel and Power BI are better together
Exercise - Creating an Excel report using a Power BI Dataset
Exercise - Excel and Power BI service better together
Check your knowledge
Summary
Integrate Power BI in Microsoft Teams and SharePoint
Introduction
Power BI together with Microsoft Teams
Power BI together with SharePoint Online
Check your knowledge
Summary
Empower modern analytics and business intelligence data cultures with Excel Power BI MS Teams and SharePoint at Microsoft Entry Requirements
- Familiarity with Microsoft Excel, Office 365 and Excel 2016+, PivotTables, Microsoft Teams and SharePoint.
- Not mentioned
Empower modern analytics and business intelligence data cultures with Excel Power BI MS Teams and SharePoint at Microsoft Admission Process
Important Dates
Other courses offered by Microsoft
Student Forum
Anything you would want to ask experts?
TechnologySoftware ToolsPower BIEmpower modern analytics and business intelligence data cultures with Excel Power BI MS Teams and SharePoint