Foresight BI

Welcome

Download the Data

1. Introduction

2. Prerequisites

3. Power BI & Learning Outcome

4. Downloading & Installing Power BI

5. Typical Power BI Flow

6. Understanding Power BI Desktop User Interface

7. Configuring Report Page

8. Changing Canvas Background & Wallpaper

9. Introducing the dataset

10. Intro to getting data into power bi

11. Importing Data into Power Query

12. Understanding how Power Query works

13. Changing Data Types in Power Query

14. Refreshing data and re-opening Power Query

15. Reusing M Queries

Power BI Overview

Intro to Data Analysis and Visualization

Categorizing Data for Visualization

Intro to Reporting in Power BI Desktop

Configuring Visuals

Creating Visuals on Power BI Desktop

Intro to chart formatting

Common Formatting Options

Changing Visuals

Creating additional visuals

Intro to Visuals Field Buckets

Understanding the Axes and Legend

X axis Y axis and Legends example

Intro to Small Multiples

Using Tool Tips

Small Multiples in Power BI Desktop

Enable Drill Down

Configuring Power BI Visuals

Introduction to Power BI Reporting

Prepare data for reporting (Add Day of Week)

Working with Shapes

Working with Text Boxes

Display trends with line charts

Visualizing Rank Changes with Ribbon Chart

Sorting Charts

Apply Gradient Conditional Formatting

ReUsing Charts and Editing Conditional Formatting

Editing Visual Interaction

Using Slicers

Synchronize Slicers

Intro to the Filters Pane

Create Top N Report

Bottom N Report

Using Tables and Matrix Table

Apply Conditional Formatting on Matrix

Basic Matrix Table Formatting

Using Maps

Report Page Tooltip

Report Drill Through

Customize Drill through header text

Summary of reports

Use Decomposition Tree

Use AI to drill decomposition tree

Key Influencer Visual

Intro to Bookmarks and Selections

Implement Bookmarks

Using Q and A

Design Mobile View and prepare to publish

Open a Microsoft 365 Developer Account for Free Power BI License

Export to pdf and publish to web

Wrap up

Visualization Assignment