logo


your one source for IT & AV

Training Presentation Systems Services & Consulting Cloud Services Purchase Client Center Computer Museum
Arrow Course Schedule | Classroom Rentals | Student Information | Free Seminars | Client Feedback | Partners | Survey | Standby Discounts

Microsoft Power BI - Dashboard in a Day

SS Course: 3000746

Course Overview

TOP
A one-day, hands-on workshop for business analysts that covers all the capabilities of Power BI                                                                  

Scheduled Classes

TOP
09/20/24 - HVH - Virtual Instructor-Led - Virtual Instructor-Led (click to enroll)
11/06/24 - HVH - Virtual Instructor-Led - Virtual Instructor-Led (click to enroll)

What You'll Learn

TOP
After the workshop, you'll better understand how to:
  • Connect to, import, and transform data from a variety of sources.
  • Define business rules and KPIs.
  • Explore data with powerful visualization tools.
  • Build stunning reports with Power BI.
  • Share dashboards with your team and business partners, and publish them to the web.
  • Outline

    TOP
    Viewing outline for:

    Module 1: Accessing and Preparing Data

    In this module you will learn about:

    • Accessing data
    • Data preparation

    Module 2: Data Modeling and Exploration

    In this module, you will:

    • Explore the Power BI Desktop layout
    • Use joins and visuals
    • Create a formula to perform join of many to many
    • Show result in visual
    • Filter the visual to show top 5 manufactures by revenue
    • Learn grouping
    • Make a tree map and show filtering of other visuals
    • Filter the page by group field
    • Create a date hierarchy visual
    • Edit interactions
    • Add in a slicer
    • Add a date table for calculations
    • Make a quick hierarchy on other fields
    • Add a matrix visual
    • Calculate same period last year formula

    Module 3: Data Visualization

    In this module, you will:

    • Use the conditional format for the matrix visual
    • Change dropdown to slicer buttons
    • Change the revenue by year chart to a combo line and clustered
    • Make a gauge visual
    • Try out themes
    • Format country visual
    • Practice page formatting

    Module 4: Publishing

    In this module, you will:

    • Learn how to publish online
    • Create a workspace online and publish to the workspace
    • Pin visuals
    • Ask a question on the dashboard

    Module 5: Making an App

    In this module, you will apply what you've learned to make an app.

    Prerequisites

    TOP
    Attendees should have some experience with Power BI, relational databases and Excel.

      Who Should Attend

      TOP
      The Power BI in a Day course is designed for beginner and intermediate users of Power BI.

      Next Step Courses

      TOP