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.
o Data Set
o Power BI Desktop
Power BI Desktop – Accessing Data
o Get Data
o Adding additional data
Power BI Desktop – Data Preparation
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
Power BI Desktop – Data Modeling and Exploration
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