Get in Touch

Course Outline

Power BI – Fundamental Concepts

  • Defining Power BI and its capabilities
  • Comparing Power BI Desktop and Power BI Service
  • Overview of the report-building lifecycle

Overview of Power BI Components

  • Power BI Desktop, Service, and Mobile
  • Power Query and Power Pivot
  • Understanding datasets, reports, and dashboards

Connecting to Data Sources

  • Supported data sources and connectors
  • Import mode vs. DirectQuery
  • Refreshing and updating data

Basic Data Modeling Concepts

  • Relationships and keys
  • Hierarchies and calculated columns
  • Creating simple measures using DAX

Creating Simple Visualizations

  • Utilizing bar, line, pie, matrix, and table visuals
  • Applying filtering and slicers
  • Conditional formatting and drillthrough functionality

Power BI Dashboards

  • Pinning visuals to dashboards
  • Tiles and layout options
  • Live dashboards and refresh intervals

Dashboard Design Principles

  • Data-to-ink ratio and visual hierarchy
  • Effective use of white space and alignment
  • Selecting the appropriate visual for the message

Interactive Panel Functions

  • Bookmarks and buttons
  • Drilldowns and cross-filtering
  • Tooltips and Q&A visual

Sharing and Publishing Dashboards

  • Publishing to Power BI Service
  • Workspaces and apps
  • Securely sharing reports and dashboards

Panel Navigation and Actions

  • Designing page navigation
  • Using page tooltips
  • Action-based interactions

Power BI Report Design

  • Data storytelling
  • Designing for readability and clarity
  • Incorporating shapes, text, and images

Advanced Design Techniques

  • Layering and grouping visuals
  • Using dynamic titles and metrics
  • Setting up drillthrough pages

Using Themes and Templates

  • Creating and applying themes
  • Using report templates
  • Maintaining visual consistency

Mobile Dashboard Design Considerations

  • Mobile layout editor
  • Optimizing for touch interactions
  • Testing dashboards on mobile devices

User Experience and Accessibility

  • Color contrast and screen reader compatibility
  • Tab order and keyboard navigation
  • Best practices for accessible design

Summary and Next Steps

  • Recap of key concepts
  • Additional Power BI resources
  • Exploring certification options

Requirements

  • A foundational understanding of data concepts and structures
  • Experience with Microsoft Excel and data manipulation
  • Familiarity with fundamental statistical concepts

Target Audience

  • Data analysts
  • Business intelligence specialists
  • Professionals responsible for reporting and dashboard design
 21 Hours

Number of participants


Price per participant

Testimonials (2)

Upcoming Courses

Related Categories