Course Outline

Power BI – Basic Concepts

  • What is Power BI and what can it do?
  • Power BI Desktop vs Power BI Service
  • Overview of the report-building process

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 vs DirectQuery
  • Refreshing and updating data

Basic Data Modeling Concepts

  • Relationships and keys
  • Hierarchies and calculated columns
  • Simple measures using DAX

Creating Simple Visualizations

  • Bar, line, pie, matrix, and table visuals
  • Filtering and slicers
  • Conditional formatting and drillthrough

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
  • Choosing the right 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
  • Sharing reports and dashboards securely

Panel Navigation and Actions

  • Page navigation design
  • Using page tooltips
  • Action-based interactions

Power BI Report Design

  • Storytelling with data
  • Designing for readability and clarity
  • Using 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

  • An understanding of basic data concepts and structures
  • Experience with Microsoft Excel and data manipulation
  • Familiarity with basic statistical concepts

Audience

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

Delivery Options

Private Group Training

Our identity is rooted in delivering exactly what our clients need.

  • Pre-course call with your trainer
  • Customisation of the learning experience to achieve your goals -
    • Bespoke outlines
    • Practical hands-on exercises containing data / scenarios recognisable to the learners
  • Training scheduled on a date of your choice
  • Delivered online, onsite/classroom or hybrid by experts sharing real world experience

Private Group Prices RRP from €6840 online delivery, based on a group of 2 delegates, €2160 per additional delegate (excludes any certification / exam costs). We recommend a maximum group size of 12 for most learning events.

Contact us for an exact quote and to hear our latest promotions


Public Training

Please see our public courses

Testimonials (5)

Provisional Upcoming Courses (Contact Us For More Information)

Related Categories