Course Outline
Power BI – Fundamental Concepts
- Introduction to Power BI and its core capabilities
- Distinction between Power BI Desktop and Power BI Service
- Overview of the report creation workflow
Understanding Power BI Components
- Exploration of Power BI Desktop, Service, and Mobile applications
- Introduction to Power Query and Power Pivot
- Defining datasets, reports, and dashboards
Data Source Connectivity
- Overview of supported data sources and connectors
- Comparison of Import mode versus DirectQuery mode
- Strategies for refreshing and updating data
Foundational Data Modeling
- Understanding relationships and key structures
- Implementing hierarchies and calculated columns
- Creating basic measures using DAX
Developing Basic Visualizations
- Creating bar, line, pie, matrix, and table visuals
- Utilizing filters and slicers
- Applying conditional formatting and drillthrough features
Constructing Power BI Dashboards
- Pinning visuals to dashboard layouts
- Configuring tiles and layout options
- Managing live dashboards and refresh schedules
Principles of Dashboard Design
- Optimizing the data-to-ink ratio and visual hierarchy
- Effective use of white space and alignment techniques
- Selecting the most appropriate visual for the narrative
Interactive Panel Features
- Implementing bookmarks and action buttons
- Leveraging drilldowns and cross-filtering
- Using tooltips and the Q&A visual
Publishing and Sharing Dashboards
- Deploying reports to the Power BI Service
- Managing workspaces and business apps
- Secure sharing protocols for reports and dashboards
Navigation and Action Configuration
- Designing efficient page navigation flows
- Implementing page-level tooltips
- Configuring action-based user interactions
Power BI Report Design Strategies
- Crafting data-driven stories
- Designing for maximum readability and clarity
- Integrating shapes, text, and images effectively
Advanced Design Methodologies
- Techniques for layering and grouping visual elements
- Utilizing dynamic titles and metric displays
- Setting up dedicated drillthrough pages
Themes and Template Management
- Creating and applying custom themes
- Utilizing standardized report templates
- Ensuring visual consistency across reports
Mobile Dashboard Optimization
- Using the mobile layout editor
- Optimizing interfaces for touch-based interactions
- Testing dashboard performance on mobile devices
User Experience and Accessibility Standards
- Ensuring color contrast and screen reader compatibility
- Configuring tab order and keyboard navigation
- Implementing best practices for accessible design
Conclusion and Pathways Forward
- Review of core concepts
- Recommended additional Power BI resources
- Exploration of professional certification options
Requirements
- Foundational knowledge of data concepts and structures
- Practical experience 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)
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.
