Microsoft 365 Power BI Desktop - Intermediate

Unlock Advanced Power BI Skills: Interactive Dashboards & Data Modeling

This course builds upon your foundational Power BI knowledge, empowering you to create sophisticated, interactive dashboards that meet the demands of modern business analysis. Learn to leverage data from multiple sources and provide managers with real-time information for informed decision-making.

Data Freshness & Refresh Strategies

Understand the critical importance of data freshness. This course delves into the factors affecting data update frequency, including data source location and the Power BI Desktop connection method. You'll learn how to assess and address issues to ensure your organization's reporting data is always current.

Data Modeling for Powerful Insights

Master data modeling techniques essential for combining data from disparate sources. Key topics include:

• Table Relationships: Establish connections between tables for comprehensive analysis.
• Cardinality: Understand the nature of relationships (one-to-one, one-to-many, many-to-many).
• Row-Level Security: Implement security measures to control data access.
• Referential Integrity: Ensure data accuracy and consistency across your models.

Calculated Columns: Expanding Your Data Capabilities

Address data gaps by creating calculated columns. Learn to derive new data points from existing fields, enabling deeper analysis and forecasting.

Advanced Visualizations

Go beyond basic charts with a comprehensive exploration of advanced Power BI visuals:

• Donut Charts: Visually represent proportions and percentages.
• Tree Maps: Display hierarchical data with proportional areas.
• Line & Stacked Column Charts: Track trends and compare data across categories.
• Line & Cluster Column Charts: Analyze trends and compare multiple series.
• Maps: Visualize data geographically.
• Filled Maps: Show data density across regions.

Each visualization is accompanied by real-world use cases and demonstrations, guiding you to choose the best visual for your specific data and analytical goals.

Interactive Filtering Techniques

Enhance data exploration with powerful filtering options:

• Visual Filters: Filter data within individual visualizations.
• Page Filters: Apply filters to entire report pages.
• Report Filters: Control data displayed across the entire report.
• Include/Exclude Filters: Selectively include or exclude data based on criteria.
• Cross Filters: Dynamically filter visuals based on selections in other visuals.
• Top N Filters: Display the top N values based on a specific metric.
• Relative Date Filters: Filter data based on relative time periods (e.g., last week, this month).

Slicers: Boosting Dashboard Interactivity

Slicers provide visually appealing and interactive filters, ideal for dashboards. This course covers various slicer types:

• Date Slicers: Filter data by date ranges.
• Time Slicers: Filter data by specific times or time periods.
• Numeric Range Slicers: Filter data based on numerical ranges.

Dashboard Enhancement: Taking Your Reports to the Next Level

Even if you're familiar with Power BI dashboards, this course will show you how to leverage the new visualizations, filters, and slicers to create truly dynamic and insightful dashboards.

Instructor: Eric Brockway