Dashboard in a Day
Microsoft Power BI Workshop

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

The world of modern data and analytics continues to rapidly evolve and you need to stay on top of it – both for your personal career development and as an advisor within your organization. Canada’s most successful corporations, governments, and organizations turn to our team for an insider’s view of modern data and analytics.

 

In this workshop, we will guide you through the Power BI platform with a focus on data access, preparation, exploration and visualization. Arm your team with the knowledge and foundation they need to build stunning reports and gain insights from their data. 

At the end of the day, attendees will 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.

  • Share dashboards with their team and business partners,                                                                                                  and publish them to the web.

 

The last two hours of the workshop are dedicated to attendees building reports and dashboards out of their own data with the support of their instructor.

Workshop Outline

 

Overview
o Introduction
o Data Set
o Power BI Desktop

Power BI Desktop – Accessing Data
o  Get Data
o Adding additional data

Power BI Desktop – Data Preparation
(Query Editor)

o Renaming tables
o Defining Data Types
o Filling empty values
o Splitting columns
o Renaming columns
o Using Column from Examples to split columns
o Removing unwanted rows
o Transposing data
o Appending / Merging queries
o  Edit Queries from Data Model Load

2

1

3

Power BI Desktop – Data Modeling and Exploration
o Layout
o Data Exploration
o Creating Custom DAX Measures and Columns       for Trend Analysis
o Edit Visual Interactions
o Create New Hierarchies and Drilldowns
o Create Conditional Formatting for Fields

Power BI Desktop – Data Visualization
o Explore built-in Visualizations and Microsoft               Marketplace visuals

5

4

Newcomp Analytics can deliver your workshop on-site at your location, in classrooms across Canada or via an instructor-led online format.

This private hands-on workshop is for a maximum of 15 students. All students will receive a hard-copy manual and access to the data set for the session.

Let's Schedule Your Team's Power BI 
Workshop

 

Contact us for pricing details!

CONTACT

US

FIND

US

Tel. 647-296-7443

Email: training@newcomp.com

TELL

US