Get in Touch

Course Outline

Power BI – Fundamental Concepts

  • Understanding Power BI and its capabilities.
  • Distinguishing between Power BI Desktop and Power BI Service.
  • Overview of the report development lifecycle.

Overview of Power BI Components

  • Introduction to Power BI Desktop, Service, and Mobile.
  • Exploring Power Query and Power Pivot.
  • Understanding the relationship between datasets, reports, and dashboards.

Connecting to Data Sources

  • Supported data sources and available connectors.
  • Comparing Import mode and DirectQuery.
  • Managing data refresh and updates.

Basic Data Modeling Concepts

  • Establishing relationships and utilizing keys.
  • Creating hierarchies and calculated columns.
  • Writing simple measures using DAX.

Creating Simple Visualizations

  • Utilizing bar, line, pie, matrix, and table visuals.
  • Applying filters and slicers for interactivity.
  • Implementing conditional formatting and drillthrough features.

Power BI Dashboards

  • Pinning visuals to dashboards for quick access.
  • Customizing tiles and layout options.
  • Configuring live dashboards and refresh intervals.

Dashboard Design Principles

  • Applying the data-to-ink ratio and visual hierarchy.
  • Effectively using white space and alignment.
  • Selecting the appropriate visual to convey the message.

Interactive Panel Functions

  • Using bookmarks and buttons for navigation.
  • Implementing drilldowns and cross-filtering.
  • Enhancing context with tooltips and Q&A visuals.

Sharing and Publishing Dashboards

  • Publishing content to the Power BI Service.
  • Organizing content using workspaces and apps.
  • Securely sharing reports and dashboards.

Panel Navigation and Actions

  • Designing effective page navigation.
  • Leveraging page tooltips for enhanced information.
  • Implementing action-based interactions.

Power BI Report Design

  • Mastering data storytelling.
  • Designing reports for readability and clarity.
  • Incorporating shapes, text, and images.

Advanced Design Techniques

  • Layering and grouping visuals for depth.
  • Utilizing dynamic titles and metrics.
  • Configuring drillthrough pages for detailed analysis.

Using Themes and Templates

  • Creating and applying custom themes.
  • Utilizing report templates for efficiency.
  • Maintaining visual consistency across reports.

Mobile Dashboard Design Considerations

  • Navigating the mobile layout editor.
  • Optimizing designs for touch interactions.
  • Testing dashboards on various mobile devices.

User Experience and Accessibility

  • Ensuring color contrast and screen reader compatibility.
  • Managing tab order and keyboard navigation.
  • Adopting best practices for accessible design.

Summary and Next Steps

  • Recap of key concepts covered.
  • Additional Power BI learning resources.
  • Exploring certification options for career advancement.

Requirements

  • A foundational understanding of data concepts and structures.
  • Practical experience with Microsoft Excel and data manipulation techniques.
  • Familiarity with fundamental statistical concepts.

Target Audience

  • Data analysts.
  • Business intelligence specialists.
  • Professionals tasked with reporting and dashboard design.
 21 Hours

Number of participants


Price per participant

Testimonials (2)

Upcoming Courses

Related Categories