Course Outline
Power BI – Fundamental Concepts
- Introduction to Power BI and its core capabilities
- Distinguishing between Power BI Desktop and Power BI Service
- A comprehensive overview of the report creation workflow
Power BI Ecosystem Components
- Exploring Power BI Desktop, Service, and Mobile interfaces
- Leveraging Power Query and Power Pivot
- Clarifying the roles of datasets, reports, and dashboards
Data Source Integration
- Supported data sources and connector types
- Comparing Import and DirectQuery modes
- Managing data refresh and update schedules
Core Data Modeling Principles
- Defining relationships and identifying keys
- Structuring hierarchies and creating calculated columns
- Developing basic measures using DAX
Building Basic Visualizations
- Utilizing bar, line, pie, matrix, and table charts
- Implementing filters and slicers for dynamic interaction
- Applying conditional formatting and drillthrough features
Power BI Dashboard Construction
- Pinning key visuals to dashboard tiles
- Configuring tile layouts and structural options
- Setting up live dashboards with specific refresh intervals
Principles of Dashboard Design
- Optimizing data-to-ink ratio and establishing visual hierarchy
- Effective application of white space and alignment techniques
- Selecting appropriate visuals to convey specific messages
Interactive Panel Features
- Creating bookmarks and custom buttons
- Implementing drilldowns and cross-filtering logic
- Utilizing tooltips and the Q&A visual element
Dashboard Distribution and Publishing
- Publishing content to the Power BI Service
- Managing workspaces and creating apps
- Secure sharing of reports and dashboards
Panel Navigation and User Actions
- Designing intuitive page navigation paths
- Incorporating page-level tooltips
- Configuring action-based interactions
Advanced Report Design in Power BI
- Data storytelling techniques
- Designing for maximum readability and clarity
- Integrating shapes, text, and imagery
Sophisticated Design Techniques
- Layering and grouping visual elements
- Implementing dynamic titles and metrics
- Configuring drillthrough pages
Themes and Template Utilization
- Creating and applying custom themes
- Utilizing report templates for efficiency
- Maintaining consistent visual branding
Mobile Dashboard Design Strategies
- Using the mobile layout editor
- Optimizing interfaces for touch-based interactions
- Conducting testing on mobile devices
User Experience and Accessibility Standards
- Ensuring color contrast and screen reader compatibility
- Configuring tab order and keyboard navigation
- Adhering to best practices for accessible design
Course Conclusion and Future Pathways
- Summary of core concepts covered
- Recommendations for additional Power BI resources
- Guidance on certification options
Requirements
- Foundational knowledge of basic data concepts and structures
- Practical experience with Microsoft Excel and data manipulation techniques
- Familiarity with fundamental statistical principles
Target Audience
- Data analysts
- Business intelligence specialists
- Professionals managing reporting 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.
