Course Outline
Power BI – Foundational Concepts
- Introduction to Power BI and its capabilities
- Comparing Power BI Desktop and Power BI Service
- Overview of the report creation process
Introduction to Power BI Components
- Power BI Desktop, Service, and Mobile applications
- Power Query and Power Pivot functionalities
- Understanding datasets, reports, and dashboards
Establishing Data Source Connections
- Supported data sources and available connectors
- Choosing between Import and DirectQuery methods
- Managing data refreshing and updates
Core Data Modeling Principles
- Defining relationships and keys
- Creating hierarchies and calculated columns
- Developing simple measures using DAX
Developing Basic Visualizations
- Utilizing bar, line, pie, matrix, and table visuals
- Applying filters and slicers
- Implementing conditional formatting and drillthrough features
Building Power BI Dashboards
- Pinning visuals to create dashboards
- Configuring tiles and layout options
- Setting up live dashboards and refresh intervals
Dashboard Design Best Practices
- Optimizing data-to-ink ratio and visual hierarchy
- Effective utilization of white space and alignment
- Selecting appropriate visuals to convey specific messages
Interactive Panel Features
- Using bookmarks and buttons for interaction
- Implementing drilldowns and cross-filtering
- Utilizing tooltips and the Q&A visual
Distributing and Publishing Dashboards
- Publishing content to Power BI Service
- Managing workspaces and apps
- Securely sharing reports and dashboards
Navigation and Action Controls
- Designing page navigation flows
- Implementing page tooltips
- Configuring action-based interactions
Power BI Report Design Strategies
- Telling stories with data
- Designing for readability and clarity
- Incorporating shapes, text, and images
Advanced Design Methods
- Layering and grouping visual elements
- Utilizing dynamic titles and metrics
- Configuring drillthrough pages
Applying Themes and Templates
- Creating and applying custom themes
- Leveraging report templates
- Ensuring visual consistency across reports
Mobile Dashboard Design Considerations
- Using the mobile layout editor
- Optimizing interfaces for touch interactions
- Testing dashboard performance on mobile devices
User Experience and Accessibility Standards
- Ensuring color contrast and screen reader compatibility
- Managing tab order and keyboard navigation
- Following best practices for accessible design
Conclusion and Future Directions
- Recap of essential concepts
- Accessing additional Power BI resources
- Exploring certification pathways
Requirements
- A foundational understanding of basic data concepts and structures
- Proficiency in Microsoft Excel and data manipulation techniques
- Familiarity with fundamental statistical concepts
Target Audience
- Data analysts
- Business intelligence specialists
- Professionals responsible for 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
