Course Outline
Power BI – Core Concepts
- Introduction to Power BI and its core capabilities
- Distinguishing between Power BI Desktop and Power BI Service
- A comprehensive look at the report creation workflow
Components of the Power BI Ecosystem
- Overview of Power BI Desktop, Service, and Mobile applications
- Introduction to Power Query and Power Pivot functionalities
- Defining datasets, reports, and dashboards
Data Source Integration
- Exploring supported data sources and available connectors
- Comparing Import mode versus DirectQuery
- Strategies for data refreshing and updates
Fundamentals of Data Modeling
- Establishing relationships and identifying keys
- Working with hierarchies and calculated columns
- Creating basic measures using DAX
Developing Basic Visualizations
- Implementing bar, line, pie, matrix, and table visuals
- Utilizing filters and slicers for data interaction
- Applying conditional formatting and drillthrough features
Constructing Power BI Dashboards
- Pinning visual elements to dashboard layouts
- Managing tiles and layout configurations
- Configuring live dashboards and refresh schedules
Principles of Dashboard Design
- Balancing data-to-ink ratios and establishing visual hierarchy
- Effective utilization of white space and alignment techniques
- Selecting appropriate visuals to convey specific messages
Interactive Functionality Features
- Implementing bookmarks and actionable buttons
- Leveraging drilldowns and cross-filtering mechanisms
- Integrating tooltips and the Q&A visual tool
Distribution and Publishing Strategies
- Deploying reports to Power BI Service
- Managing workspaces and application distribution
- Secure sharing protocols for reports and dashboards
Navigation and User Actions
- Structuring page navigation flows
- Incorporating page-level tooltips
- Designing action-based user interactions
Refining Report Design in Power BI
- Crafting narratives through data storytelling
- Optimizing layouts for readability and clarity
- Integrating shapes, text elements, and imagery
Advanced Design Methodologies
- Organizing visuals through layering and grouping
- Implementing dynamic titles and performance metrics
- Configuring dedicated drillthrough pages
Leveraging Themes and Templates
- Developing and applying custom themes
- Utilizing standardized report templates
- Ensuring visual consistency across reports
Mobile Dashboard Optimization
- Using the mobile layout editor
- Enhancing touch-based interaction experiences
- Conducting tests on various mobile devices
User Experience and Accessibility Standards
- Ensuring proper color contrast and screen reader support
- Managing tab order and keyboard accessibility
- Adopting best practices for inclusive design
Conclusion and Future Pathways
- Review of essential concepts
- Recommendations for additional Power BI resources
- Guidance on pursuing certification options
Requirements
- A foundational grasp of basic data concepts and structural frameworks
- Practical experience with Microsoft Excel and data manipulation techniques
- Familiarity with fundamental statistical principles
Target Audience
- Data analysts
- Business intelligence specialists
- Professionals tasked with reporting 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.
