PowerBI - Dashboard in a Day

This 1-day course aims to showcase the process of creating reports in Power BI Desktop and Publishing in Power Bi service. It begins by connecting to a data source and transforming manipulating data as needed, it explains what is a data model, showcases how to create reports in Power BI Desktop, how to publish and access reports and how to build a dashboard.

7 hours
7 hours
Greek
6 - 16

code:MSAPPS.PPL.PBI.L1

Objectives Topics Participants Methodology Other Details

  • Objectives

    At the end of the course, attendees will:

    • Describe the process of creating and publishing a report In terms of Skills
    • 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.
    • Share dashboards with their team and business partners, and publish them to the web.
    • Adopt Power BI as a tool for data analysis

  • Topics

    Unit 1: Introduction to Power BI

    • What is Power BI

    • The evolution of Power BI

    • Power Platform

    • PowerBI Desktop and Power BI Service

    • Demo of a Power BI Report

    Unit 2: Accessing and Preparing the data

    • Exploring data

    • Accessing Data

    • Data Preparation

    • Lab 1 Accessing & Preparing the data

    • Lab 1 Solution + Questions

    Unit 3: Data Modeling and Exploration

    • Power BI Desktop - Layout

    • Power BI Desktop – Data Exploration

    • Lab 2 Data Modeling and Exploration

    • Lab 2 Solution + Questions

    Unit 4: Visualizations • Power BI Desktop – Visuals

    • Creating Visuals

    • Formatting Visuals

    • Formatting the Canvas

    • Lab 3 Visualizations

    • Lab 3 Solution + Questions

    Unit 5: Publishing and accessing Reports

    • Power BI Desktop – Creating a mobile view

    • What is Power BI Service

    • Power BI Service – Publishing Report

    • Power BI – Building a Dashboard

    • Lab 4 Publishing and accessing Reports (optional Power BI Service demo)

    • Lab 4 Solution + Questions

    Unit 6: Collaboration and Distribution

    • Power BI Service – Collaboration and Distribution

    • Power BI Mobile – Accessing Report on Mobile Device

    • Further Exploration – Power Platform

    • Power Apps

    • Power Automate

    • Dataverse

    • Lab 5 Building a Dashboard and Sharing

    • Lab 5 Solution + Questions

    • Q&A

  • Participants

    Professionals from various sectors who are required to create reports from gathered data or data models provided by their organizations

  • Methodology

    The course is 100% practical. The topics are delivered with short presentations by the instructor followed by a  step-by-step demonstration by the instructor and repetition by the students, examples and discussions on how a feature may be used with real life examples and practice through written exercises.

  • Other Details

    Very Good knowledge of Microsoft Excel.
Make an enquiry