Course Outline
Power BI – Fundamental Concepts
- Defining Power BI and its capabilities.
- Differentiating between Power BI Desktop and Power BI Service.
- An overview of the report creation workflow.
Introduction to Power BI Components
- Power BI Desktop, Service, and Mobile applications.
- Understanding Power Query and Power Pivot.
- Distinguishing between datasets, reports, and dashboards.
Linking to Data Sources
- Reviewing supported data sources and connectors.
- Comparing Import modes versus DirectQuery.
- Managing data refreshes and updates.
Core Data Modeling Concepts
- Establishing relationships and keys.
- Working with hierarchies and calculated columns.
- Creating simple measures using DAX.
Developing Basic Visualizations
- Utilizing bar, line, pie, matrix, and table visuals.
- Implementing filters and slicers.
- Applying conditional formatting and drillthrough features.
Constructing Power BI Dashboards
- Pinning visuals to create dashboards.
- Managing tiles and layout configurations.
- Configuring live dashboards and refresh schedules.
Principles of Dashboard Design
- Optimizing the data-to-ink ratio and visual hierarchy.
- Effective application of white space and alignment.
- Selecting appropriate visuals to convey messages.
Interactive Panel Features
- Implementing bookmarks and action buttons.
- Utilizing drilldowns and cross-filtering.
- Using tooltips and the Q&A visual.
Distributing and Publishing Dashboards
- Publishing content to the Power BI Service.
- Managing workspaces and apps.
- Securely sharing reports and dashboards.
Navigation and Action Panels
- Designing page navigation structures.
- Implementing page tooltips.
- Creating action-based interactions.
Power BI Report Architecture
- Using data for storytelling.
- Designing for readability and clarity.
- Incorporating shapes, text, and images.
Advanced Design Strategies
- Layering and grouping visual elements.
- Implementing dynamic titles and metrics.
- Configuring drillthrough pages.
Applying Themes and Templates
- Creating and applying custom themes.
- Utilizing report templates.
- Ensuring visual consistency across reports.
Mobile Dashboard Design Best Practices
- Using the mobile layout editor.
- Optimizing for touch-based interactions.
- Testing dashboards on mobile devices.
User Experience and Accessibility
- Ensuring color contrast and screen reader compatibility.
- Configuring tab order and keyboard navigation.
- Adhering to accessible design standards.
Conclusion and Future Directions
- Reviewing key concepts learned.
- Exploring additional Power BI resources.
- Considering certification pathways.
Requirements
- A foundational grasp of core data concepts and structures.
- Proficiency with Microsoft Excel and data manipulation techniques.
- Basic familiarity with statistical principles.
Target Audience
- Data analysts.
- Business intelligence specialists.
- Professionals tasked with report generation and dashboard architecture.
Testimonials (2)
The most valuable takeaway was learning how to apply the concepts in real-world scenarios and understanding the tools and processes.
Marcel Tansae - DB Technology
Course - Microsoft Power Automate
How to use relationships in Power BIand the differences between columns and measurements
