Learning outcomes:

• Data Connectivity: Power BI can connect to a wide range of data sources, including Excel spreadsheets,
  databases, cloud-based and on-premises data sources, and many others.
• Data Transformation and Modelling: Users can shape and transform data using Power BI’s Power Query Editor. This allows for cleaning and formatting data to make it suitable for analysis. The data modelling capabilities enable the creation of relationships between different data tables.
• Data Visualization: Power BI offers a variety of visualization options, including charts, graphs, maps, and
  tables. Users can create interactive and engaging reports and dashboards to represent data in a meaningful
  way.
• Dashboard and Report Creation: Power BI allows users to create interactive dashboards and reports by
  dragging and dropping elements onto a canvas. These dashboards can then be shared with others.
• Natural Language Queries: Users can ask questions about their data using natural language queries, and
  Power BI will generate visualizations based on the data.
• Power BI Service: The Power BI service enables users to share and collaborate on reports and dashboards in
  the cloud. It also provides features for scheduling data refreshes, managing security, and more

Who is the course for?

Participants who are looking to upskill their knowledge on how Power BI works.

Modules:

Power BI – OVERVIEW
→ The Microsoft Power Platform
▪ Power BI Desktop & Power BI Service
▪ Power Automate & Power Apps
▪ Power Query & Power Pivot
→ Power BI Desktop
▪ Getting and Transforming your data
▪ Using Filters and Slicers
▪ Publishing to the Power BI Service
→ Power BI Service
▪ Reports, Pages, Dashboards

Getting the Data
→ The Power Query Editor
▪ Layout
→ Connecting to Data Sources
▪ Excel files: sheets, tables
▪ SQL Server, AzureSQL
▪ Access databases
▪ Dataverse
▪ Web pages

Transforming & Modelling the Data
→ Transforming Data
▪ Removing, renaming, splitting, merging
columns
▪ Removing top rows, duplicates, errors
▪ Promoting header rows
▪ Changing case and trimming spaces
▪ Changing data types

▪ Filtering and Sorting
▪ Replacing values
▪ Filling down

→ Modelling Data
▪ Creating Relationships
▪ Adding new columns
▪ Creating Measures

Reporting and Visualisations
→ Building Reports and Visualisations
▪ Managing Report Pages
▪ Changing Report View Options
→ Working with Visualisations
▪ Matrixes, Tables and Charts
▪ Cards, Slicers
→ Filters and Slicers
▪ Filtering scope: Report, Page, Visualisation
▪ Using Slicers

The Power BI Service
→ Using Workspaces
→ Creating Dashboards
▪ Adding and Positioning Tiles
▪ Configure Tile Alerts

Trainer Profile