Daxel

Introduction to Power BI

Home / Training / In-Class Power BI courses / Introduction to Power BI
Back to list
Introduction to Power BI

Learn Power BI – Robust Foundations

(2 days – 9AM to 4PM)

 

Hands-On Workshop
  • Participants must bring their own laptop.
Learning Outcomes
  • Gain a savvy understanding of the Power BI workflow: create, share, update
  • Learn robust data cleaning and preparation skills
  • Discover the DAX functions to calculate key indicators
  • Build insightful and interactive data visualizations in Power BI reports and dashboards
Training Location

123 Slater Street, Ottawa ON K1P 5G4

$1,200.00

Master crucial concepts and features to unleash the full potential of Power BI: automated updates, interactive data visuals, key indicators calculations. Build efficient data models to combine multiple data sources. Calculate the variance, fluctuation or difference between key indicators. Create insightful data visualizations with cross-filtering and drilling options. Share and update Power BI dashboards.

Target Audience

Analysts, Data Analytics Professionals, Accountants, Report Builders

 

Bring Your Own Device

Each participant must bring their laptop with the Power BI Desktop application installed.

 

Methodology

Applied demonstrations of the Power BI workflow; self-paced exercises with businesslike examples; troubleshooting; problem solving; course notes in English and French; web documentation references.

 

Microsoft Certified Instructor

Our Ottawa-based instructor is certified by Microsoft, as a skilled professional in Business Intelligence Reporting. Read more.

 

Quality Service

The workshops are limited to 10 attendees to address each participants questions and requests.

The training is delivered in a modern environment: offering a comfortable and bright workplace, centrally located downtown Ottawa.

 

Training Schedule

Training takes place from 9 a.m. to 4 p.m. (Eastern Time)

Learning Outcomes

  • Gain a savvy understanding of the Power BI workflow: create, share, update
  • Learn robust data cleaning and preparation skills
  • Discover the DAX functions to calculate key indicators
  • Build insightful and interactive data visualizations in Power BI reports and dashboards

 

Topics

1. Build a report with Power BI Desktop

  • Explore the Desktop application
  • Import data as an Excel file, a Text file, a Folder or a Web page
  • Use Power Query Editor to transform data: remove lines, use first row as header, remove columns, fill down data, unpivot columns, extract text using delimiters, replace values, set data types, rename fields and queries
    Add relationships between tables
  • Edit Data columns preferred format, summarization, and sort by order
  • Create visualizations: bar chart, column chart, treemap, gauge, KPI, slicer, map
  • Customize visualizations: format axis, title, color theme, header
  • Insert visual elements: image, text box
  • Edit interactions between visualizations
  • Create measures with functions: SUM, MAX, DIVIDE, CALCULATE, DATEADD, TOTALYTD
  • Use report Drill-Through feature
  • Create and use a hierarchy
  • Publish to Power BI Service

2. Master the cloud environment: Power BI Service

  • Understand the terminology
  • Navigate the interface
  • Interact with a report: use filters, slicers, sort order, export, print, publish to web, etc.
  • Use storytelling tools: bookmarks, spotlight, focus, tooltip etc.
  • Collaborate within an App Workspace
  • Build a dashboard
  • Create an app to share