Lesson 01:
Getting data with power query
- Review of power query interface
- Clean up exercise using Power Query
Lesson 02:
Building a Data Model
- What is a data model?
- Big picture view of your reporting needs
- Why you need FACT files and DIMENSION files
- A to Z building a Data model in Power BI
Lesson 03:
Analyses with the DAX formula language
- How to format your DAX code correctly
- Introduction to the VAR syntax
- DAX functions Vs Excel functions
- Introducing the 3 core DAX measures
- Overview of Filter and row context
- Using quick measures
Lesson 04:
Visualizations
- Building standard visualizations
- Selecting and formatting visuals
- Introduction to customs visualizations
- Building reports with AI capabilities
- Best practice steps for building dashboards
Lesson 05:
Power BI Service
- Overview of the Power BI service
- Publishing to PowerBI.com
- Quick Insights
Lesson 06:
Understanding Apps
- Canvas vs model driven vs portal apps
- Setting up your App environment
- Overview of the common data service
- Creating and customizing a custom entity
- Using the form control to save data into CDS
Lesson 07:
Building a Canvas App
- Lab introduction
- Connecting to data sources and filtering results based on specified criteria
- Working with screens and navigation
- Customizing the user experience with controls, properties, formulas and actions.
- User authentication
- Configuring app settings
- Saving and sharing your app
- Running your app on a mobile device
Lesson 08:
Building a model- driven app
- Lab introduction
- Connecting to data sources and filtering results based on specified criteria
- Working with screens and navigation
- Customizing the user experience with controls, properties, formulas and actions.
- User authentication
- Configuring app settings
- Saving and sharing your app
- Running your app on a mobile device
- Creating a standalone model-driven app
- Customizing forms for the model-driven app
- Using a Business Process Flow to guide users through a process
Lesson 09:
Overview of Power Automate and Virtual Agent
- Introduction to Power Automate
- Introduction to Robotic Process Automation
- Overview of a trigger
- Understanding flow notifications and conditions
- Understanding flow controls, variables and expressions
Lesson 10:
Creating an Approval flow
- Creating a flow that is triggered when a new common Data Service record is created
- Automate sending approval requests
- Customize the approval based on the CDS record.
- Using the Approval centre
Lesson 11:
Automation with the AI Builder
- Enhancing your business flow with AI
- Form processing
- Object detection
- Prediction
- Text classification
- Business card reader
- Key phrase extraction
- Sentiment analysis
- Text recognition
Lesson 12:
Managing Flows
- Flow options
- Importing and exporting a flow
- Saving flow run history and analytics.
- Team flows and sharing flows
Lesson 13:
Introduction to Power Virtual Agent
- Overview of the Power Virtual Agent
- Steps for creating your first bot
- Steps for creating a topic
- Testing your content in real time
- Publishing your bot
- Analyzing the performance of your bot
Lesson 14:
Power Platform Hackathon
The last day of the course is dedicated to exploring the possibilities of the Power Platform through a hackathon, where participants are divided into functional groups and with either own data or ideas or a set of themes. They will attempt to build a business case solution with the Power Platform.
The content will focus on using the skills learnt on the course to mimic an on-the-job experience.