Microsoft Power BI Training

Microsoft Power BI Training

Training Format and Learning Outcomes

This 2-day training includes interactive, hands-on exercises and can be delivered either face-to-face or online.
Participants will gain proficiency in connecting to various data sources, cleaning and transforming data, creating data models, and building interactive reports and dashboards.

Participation Requirements

Participants must have Power BI Desktop installed on their personal computers.
Basic knowledge of Excel is sufficient to attend this training.

Content

• General Information
  • Power BI Desktop and service architecture
  • Data sources and types
• Data Acquisition
  • Connecting to data sources in Power BI Desktop
  • Cleaning and transforming data using Query Editor
  • Advanced data sources and transformations
  • Cleaning poorly formatted data
• Data Modeling
  • Introduction to data modeling
  • Managing data relationships
  • Creating calculated columns
  • Optimizing data models
  • Creating calculated measures
  • Exploring time-based data
• Data Visualization
  • Introduction to visualizations in Power BI
  • Creating and customizing basic visuals
  • Combined charts
  • Dynamic filtering (Slicers)
  • Map visualizations
  • Matrices and tables
  • Scatter charts
  • Waterfall and funnel charts
  • Gauges and single-number cards
  • Changing colors in charts and visuals
  • Shapes, text boxes, and images
  • Page layout and formatting
  • Duplicating a report page
  • Displaying categories with no data
  • Visual layers
  • Visual hierarchies and drill-down
• Publishing and Sharing
  • Introduction to Power BI Service
  • Publishing Power BI Desktop reports
  • Introduction to content packs, security, and groups
  • Printing and exporting dashboards and reports
  • Creating and configuring dashboards
  • Sharing dashboards within your organization

Training Request Form