Course Outline
Power BI – Fundamental Concepts
- Defining Power BI and its capabilities
- Distinguishing between Power BI Desktop and Power BI Service
- An overview of the report creation workflow
Power BI Ecosystem Components
- Power BI Desktop, Service, and Mobile applications
- Power Query and Power Pivot functionalities
- Clarifying the roles of datasets, reports, and dashboards
Data Source Connectivity
- Supported data sources and available connectors
- Comparing Import and DirectQuery methods
- Managing data refresh and update cycles
Introductory Data Modeling
- Defining relationships and keys
- Working with hierarchies and calculated columns
- Creating basic measures using DAX
Building Basic Visualizations
- Utilizing bar, line, pie, matrix, and table visuals
- Implementing filtering and slicers
- Applying conditional formatting and drillthrough features
Constructing Power BI Dashboards
- Pinning key visuals to dashboards
- Managing tiles and layout configurations
- Setting up live dashboards and refresh intervals
Principles of Dashboard Design
- Balancing data-to-ink ratio and establishing visual hierarchy
- Strategic use of white space and alignment
- Selecting the most appropriate visual for each message
Interactive Panel Features
- Configuring bookmarks and buttons
- Implementing drilldowns and cross-filtering
- Using tooltips and the Q&A visual
Dashboard Sharing and Publishing
- Publishing content to the Power BI Service
- Managing workspaces and apps
- Securely sharing reports and dashboards
Panel Navigation and Interactions
- Designing effective page navigation
- Leveraging page tooltips
- Creating action-based interactions
Power BI Report Design Strategies
- Storytelling through data
- Designing for optimal readability and clarity
- Incorporating shapes, text, and images
Advanced Design Methods
- Layering and grouping visuals effectively
- Implementing dynamic titles and metrics
- Configuring drillthrough pages
Leveraging Themes and Templates
- Creating and applying custom themes
- Utilizing report templates
- Ensuring visual consistency across reports
Mobile Dashboard Design
- Using the mobile layout editor
- Optimizing layouts for touch interactions
- Testing dashboards on various mobile devices
User Experience and Accessibility Standards
- Ensuring color contrast and screen reader compatibility
- Defining tab order and keyboard navigation
- Following best practices for accessible design
Conclusion and Future Directions
- Recap of essential concepts
- Recommended additional Power BI resources
- Exploring professional certification options
Requirements
- Foundational understanding of data concepts and structures
- Proficiency with Microsoft Excel and data manipulation techniques
- Basic familiarity with statistical concepts
Target Audience
- Data analysts
- Business intelligence specialists
- Professionals managing reporting strategies and dashboard design
Testimonials (2)
How to use relationships in Power BIand the differences between columns and measurements
LEUNG Chun Hei - HAESL
Course - Advanced Power BI: Data Modeling, DAX, and Enhanced Analytics
Method of training.
