POWER BI

Iteration 1

• Session 1: Tuesday 14th October – 9:30 am to 1 pm – Online
• Session 2: Tuesday 21st October – 9:30 am to 1 pm – Online

Overview

Power BI is a business analytics service developed by Microsoft. It provides interactive visualizations and business intelligence capabilities with an interface simple enough for end users to create their own reports and dashboards. Power BI allows users to connect to a wide variety of data sources, both on-premises and in the cloud, and then transform and model the data for analysis, reporting and decision-making.
Key features of Power BI include:

• 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.

Course Objectives

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