Power BI for Beginners

Overview

Organizations have, and continue to accumulate, masses of data from multiple sources. This data, being largely unformatted, does not yield readily pertinent information. Microsoft tackled this issue by adding data analytics tools to their Microsoft Office 365 suite. Power BI, the latest addition to Office 365, enables users to aggregate and interpret massive data in a user-friendly environment. With this data visualization tool, analysts build custom data analysis and dashboards with scheduled automated updates: empowering managers’ decision making with accurate and intuitive real-time measures.

This fast-paced introductory course to Microsoft’s Power BI application covers key concepts for delivering effective automated dashboards. This is a hands-on training session: participants learn Power BI’s functionalities as they build an interactive report. Best practices for data visualizations and dashboards are described and applied through examples.

 

Topics

  • Understand the Power BI Solution workflow to properly use the different apps
  • Build an interactive report in Power BI Desktop app
  • Combine multiple data sources and create dynamic data visualizations
  • Use storytelling tools: bookmarks, spotlight, focus, tooltip, axis hierarchy
  • Explore advanced functionalities to transform and enhance data with Power Query Editor and measures in DAX
  • Master the Power BI Service app to collaborate and share reports within your organization
  • Create dashboards in Power BI Service, set alerts and publish to specific users as an app

 

Audience

  • Analysts, accountants, report builders
  • Managers seeking to optimize their reports’ update process

 

Duration

6 hours

Cost

  • $595 (plus tax)
  • As of January 2023: $655 (plus tax)

Featured Instructor

Patrick Boily is a professor in the Department of Mathematics and Statistics at the University of Ottawa and a founding member of the Data Action Lab. Since 1999, he has taught more than 50 courses at universities in the Ottawa area and conducted more than 200 days of workshops for federal government employees on data science, data visualization and statistical analysis. His interests include the use of mathematics and statistics for decision support, and he has managed and participated in over 35 consulting projects throughout his career.

 

Sessions

Event CodeTitleBegin DateEnd DateTermDelivery MethodRegister to Event
P01512210APower BI for Beginners10/7/202210/7/2022AutumnIn PersonRegister to Event
P01512211APower BI for Beginners11/17/202211/18/2022AutumnOnlineRegister to Event
P10512302APower BI for Beginners2/21/20232/22/2023WinterOnlineRegister to Event
P01512304BPower BI for Beginners4/13/20234/13/2023WinterIn PersonRegister to Event