Overview
Master data visualization and analytics with Power BI by learning to connect diverse data sources, create compelling reports, transform data using Power Query, design semantic models, and leverage Copilot's AI capabilities.
Syllabus
-
- Module 1: Module 1: Get started building with Power BIIntroductionUse Power BIBuilding blocks of Power BITour and use the Power BI serviceKnowledge checkSummary
- Module 2: Module 2: Get data in Power BIIntroductionGet data from filesGet data from relational data sourcesCreate dynamic reports with parametersGet data from a NoSQL databaseGet data from online servicesSelect a storage modeGet data from Azure Analysis ServicesFix performance issuesResolve data import errorsExercise - Prepare data in Power BI DesktopCheck your knowledgeSummary
- Module 3: Module 3: Clean, transform, and load data in Power BIIntroductionShape the initial dataSimplify the data structureEvaluate and change column data typesCombine multiple tables into a single tableProfile data in Power BIUse Advanced Editor to modify M codeExercise - Load data in Power BI DesktopCheck your knowledgeSummary
- Module 4: Module 4: Design a semantic model in Power BIIntroductionWork with tablesCreate a date tableWork with dimensionsDefine data granularityWork with relationships and cardinalityResolve modeling challengesExercise - Model data in Power BI DesktopCheck your knowledgeSummary
- Module 5: Module 5: Design Power BI reportsIntroductionDesign the analytical report layoutDesign visually appealing reportsReport objectsSelect report visualsSelect report visuals to suit the report layoutFormat and configure visualizationsWork with key performance indicatorsExercise - Design a report in Power BI desktopCheck your knowledgeSummary
- Module 6: Module 6: Create interactive reports using Copilot for Power BIIntroductionPrepare your data for use with Copilot for Power BIUse Copilot for Power BI to model your dataCreate reports with Copilot for Power BICreate summaries with Copilot for Power BIKnowledge checkSummary
- Module 7: Module 7: Introduction to end-to-end analytics using Microsoft FabricIntroductionExplore end-to-end analytics with Microsoft FabricData teams and Microsoft FabricEnable and use Microsoft FabricKnowledge CheckSummary
Taught by
Tags
On-Demand
