Power BI Jumpstart

Course code: CR1004

3 hours · Instructor-led, hands-on · Beginner

Students connect Power BI Desktop to an Excel sales file and clean it in Power Query. They format the numbers as currency, add a product hierarchy and two measures that count orders and customers correctly. Then they build a dashboard page: four KPI cards, a year slicer, a sales trend line chart and a sales-by-category bar chart they can drill into, and they control which visuals the slicer filters. The instructor shows how a report is published and shared.

Request a Consultant

About This Course

Audience: Analysts and managers who report from Excel today and are new to Power BI.

Prerequisites: Power BI Desktop installed. Sample Excel file downloaded from the link sent before class. Basic Excel helps.

License and software: A Windows PC with Power BI Desktop installed. It is free. It does not run on a Mac. No paid license is needed for the hands-on work. Sharing or publishing a report needs Power BI Pro or Premium Per User and is shown by the instructor.

YOU LEAVE WITH A report file with a dashboard page: four KPI cards, a year slicer, a trend line chart and a drill-down bar chart.

BY THE END, STUDENTS WILL BE ABLE TO

  • Find their way around Power BI Desktop: canvas, panes, ribbon, and Report, Table and Model views

  • Connect Power BI Desktop to an Excel sales file and clean the data in Power Query

  • Format the numbers and add a product hierarchy and two measures

  • Build a dashboard page with KPI cards, a year slicer, a trend line chart and a drill-down bar chart

  • Control which visuals a slicer filters

  • Explain what is needed to publish and share a report

You'll Learn

Module 1: Introduction to Power BI

  • Start a blank report and look through the Get Data dialog

  • The four work areas: canvas, Visualizations pane, Data pane, ribbon

  • Report, Table and Model views

  • Build a quick first report: a bar chart, a card and a slicer

  • List what needs fixing before anyone sees it

  • Lab 1: Interface tour and a quick first report from SalesData.xlsx

Module 2: Connecting to Data and Power Query Essentials

  • Connect with Transform Data instead of Load

  • Check the data first: headers, blanks and columns you will not use

  • Profile the data: column quality, distribution and profile

  • Remove columns, rename columns and set data types

  • Name the query Sales, then Close & Apply

  • Lab 2: Connect to SalesData.xlsx and clean it in Power Query

Module 3: Preparing the Data for Reporting

  • Format prices, sales, cost and profit as currency, and discount as a percentage

  • Build a Category, Subcategory, Product hierarchy

  • Write two measures: Number of Orders and Number of Customers

  • Why counting rows overstates orders

  • Lab 3: Format the fields, build the product hierarchy and write two measures

Module 4: Building an Interactive Dashboard Page

  • Four KPI cards: Total Sales, Total Profit, Total Orders, Total Customers

  • A year slicer from Order Date

  • A sales trend line chart that drills from year to quarter to month

  • A sales-by-category bar chart that drills to subcategory and product

  • Edit Interactions: keep the trend line unfiltered by the slicer

  • Name the page and save the file

  • Lab 4: Build the dashboard page and test every filter

Module 5: Saving and Sharing (instructor demonstration)

  • Saving a .pbix file versus publishing to the Power BI service

  • Publishing and sharing need Power BI Pro or Premium Per User

  • Publish to a workspace and open the report in the service

  • Share the report and refresh the data

Request a Consultant

Speak with a Learning Consultant