Course Outline
Power BI – Foundational Concepts
- Defining Power BI and its core capabilities
- Distinguishing between Power BI Desktop and Power BI Service
- Overview of the report creation workflow
Overview of Power BI Architecture
- Components: Power BI Desktop, Service, and Mobile
- Tools: Power Query and Power Pivot
- Distinguishing between datasets, reports, and dashboards
Establishing Data Connections
- Supported data sources and available connectors
- Comparing Import methods versus DirectQuery
- Managing data refresh and updates
Fundamental Data Modeling
- Defining relationships and keys
- Working with hierarchies and calculated columns
- Creating basic measures with DAX
Building Basic Visualizations
- Utilizing bar, line, pie, matrix, and table visuals
- Applying filters and slicers
- Implementing conditional formatting and drillthrough features
Constructing Power BI Dashboards
- Pinning visuals to the dashboard interface
- Configuring tiles and layout structures
- Managing live dashboards and refresh cycles
Principles of Dashboard Design
- Optimizing data-to-ink ratio and visual hierarchy
- Strategic use of white space and alignment
- Selecting appropriate visuals to convey specific messages
Interactive Panel Capabilities
- Utilizing bookmarks and buttons
- Implementing drilldowns and cross-filtering
- Adding tooltips and using the Q&A visual
Distribution and Publishing
- Deploying to Power BI Service
- Managing workspaces and apps
- Securely sharing reports and dashboards
Navigation and Interactive Actions
- Designing page navigation flows
- Integrating page tooltips
- Creating action-based user interactions
Refining Power BI Reports
- Narrative storytelling through data
- Designing for maximum readability and clarity
- Incorporating shapes, text, and images
Advanced Design Strategies
- Layering and grouping visual elements
- Implementing dynamic titles and metrics
- Configuring dedicated drillthrough pages
Applying Themes and Templates
- Creating and applying custom themes
- Leveraging report templates
- Ensuring consistent visual branding
Mobile Dashboard Design Best Practices
- Using the mobile layout editor
- Optimizing for touch-based interactions
- Testing dashboard performance on mobile devices
User Experience and Accessibility
- Ensuring color contrast and screen reader compatibility
- Configuring tab order and keyboard navigation
- Adhering to accessible design guidelines
Conclusion and Future Directions
- Recap of essential concepts
- Recommended additional Power BI resources
- Exploring professional certification paths
Requirements
- A solid grasp of fundamental data concepts and structural frameworks
- Prior experience using Microsoft Excel for data handling and manipulation
- Knowledge of basic statistical principles
Intended Audience
- Data analysts
- Business intelligence specialists
- Professionals tasked with report generation and dashboard architecture
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.
