Course Outline
Power BI – Fundamental Concepts
- Introduction to Power BI and its core capabilities
- Comparing Power BI Desktop with Power BI Service
- An overview of the report creation workflow
Key Components of Power BI
- Power BI Desktop, Service, and Mobile applications
- Introduction to Power Query and Power Pivot
- Distinguishing between datasets, reports, and dashboards
Integrating Data Sources
- Supported data connectors and sources
- Choosing between Import and DirectQuery modes
- Managing data refresh and updates
Core Data Modeling Principles
- Establishing relationships and defining keys
- Working with hierarchies and calculated columns
- Creating simple measures using DAX
Building Basic Visualizations
- Utilizing bar, line, pie, matrix, and table visuals
- Implementing filters and slicers
- Applying conditional formatting and drillthrough features
Managing Power BI Dashboards
- Pinning visuals to dashboard pages
- Configuring tiles and layout options
- Setting up live dashboards and defining refresh intervals
Principles of Dashboard Design
- Optimizing the data-to-ink ratio and visual hierarchy
- Effective utilization of white space and alignment
- Selecting appropriate visuals to convey messages
Interactive Panel Features
- Utilizing bookmarks and action buttons
- Implementing drilldowns and cross-filtering
- Enhancing engagement with tooltips and the Q&A visual
Distributing and Publishing Dashboards
- Publishing content to the Power BI Service
- Managing workspaces and applications
- Securely sharing reports and dashboards
Panel Navigation and User Actions
- Designing intuitive page navigation
- Leveraging page tooltips for context
- Creating action-based interactions
Power BI Report Designation
- Narrative storytelling through data
- Designing for maximum readability and clarity
- Integrating shapes, text, and images effectively
Advanced Design Strategies
- Layering and grouping visual elements
- Implementing dynamic titles and metrics
- Configuring drillthrough pages for detail views
Applying Themes and Templates
- Creating and applying custom themes
- Utilizing predefined report templates
- Ensuring visual consistency across reports
Mobile Dashboard Design Best Practices
- Using the mobile layout editor
- Optimizing layouts for touch-based interactions
- Testing dashboard performance on mobile devices
User Experience and Accessibility Standards
- Ensuring color contrast and screen reader compatibility
- Defining tab order and keyboard navigation paths
- Adhering to best practices for accessible design
Conclusion and Future Pathways
- Review of core concepts and skills
- Recommended resources for further Power BI learning
- Exploring available certification options
Requirements
- A foundational grasp of basic 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
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
