Power BI: Dashboard in a Weekend

Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

Learn how to create your first dashboard in Power BI in one weekend. This Power BI Dashboard in a Weekend program is a two-day, hands-on workshop for data analysts and business analysts that covers the full capabilities of Power BI.

What You Will Learn

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

This program was adapted from the Microsoft Power BI Dashboard in a Day workshop, and improved upon by CAMANDA Academy

Show More

What Will You Learn?

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

Course Content

Introduction and prerequisites for Power BI – Online Live Class
We will you through the steps of installing the required software on your computer so that you can complete this course.

Access and prepare data for Power BI Desktop – Online Live Class
Explore how to import, transform, and append data from different sources using Power BI Desktop, and prepare it for reporting.1. Accessing data 2. Data preparation

Build your first data model and explore the data by using Power BI – Online Live Class
You will learn to build a Power BI data model for the first time, and then use your first data model to explore data, create relationships, add data visualisations, group and bin data, and create a date table.- Data Modeling and Exploration - Explore the Power BI Desktop layout - Use joins and visuals - Create a formula to perform join of many to many - Show result in visual - 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

Use hierarchies and DAX in your first data model – Online Live Class
In this module, you add a hierarchy to your first data model. Then, you use a matrix visualization and DAX measures to understand more about the data.

Data visualization and reports in Power BI – Online Live Class
Complete a full report that is ready for publishing on the Power BI Service. In the report, you learn how to use conditional formatting, add logos, and apply a custom report theme. - Data Visualization - 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

Import custom visuals and add bookmarks to a report in Power BI – Online Live Class
Complete a full report that is ready for publishing on the Power BI Service. In the report, you learn how to import custom visuals and add bookmarks to a report.

Publish and access reports in Power BI service – Online Live Class
Explore using Power BI to create a mobile view, publish a report, build a dashboard, and use storytelling with Power BI within PowerPoint.- Publishing - Learn how to publish online - Create a workspace online and publish to the workspace - Pin visuals - Ask a question on the dashboard

Interact, share, and collaborate Power BI dashboards – Online Live Class
- Explore how to share Power BI dashboards, collaborate with other users, and access a dashboard on a mobile device. - Making an App - You'll use everything you've learned so far to create an app in this module.

Want to receive push notifications for all major on-site activities?