Course Outline
Power BI – Fundamental Concepts
- Defining Power BI and its core capabilities
- Distinguishing between Power BI Desktop and Power BI Service
- Overview of the report creation workflow
Introduction to Power BI Components
- Power BI Desktop, Service, and Mobile applications
- Power Query and Power Pivot functionalities
- Understanding the relationship between datasets, reports, and dashboards
Data Source Connectivity
- Exploring supported data sources and available connectors
- Comparing Import versus DirectQuery methods
- Processes for refreshing and updating data
Core Data Modeling Principles
- Establishing relationships and key structures
- Working with hierarchies and calculated columns
- Creating basic measures with DAX
Developing Basic Visualizations
- Creating bar, line, pie, matrix, and table visuals
- Implementing filters and slicers
- Applying conditional formatting and drillthrough features
Power BI Dashboard Fundamentals
- Pinning visuals to create dashboards
- Configuring tiles and layout options
- Setting up live dashboards and defining refresh intervals
Principles of Dashboard Design
- Optimizing data-to-ink ratio and visual hierarchy
- Utilizing white space and alignment effectively
- Selecting appropriate visuals to convey specific messages
Interactive Panel Features
- Implementing bookmarks and action buttons
- Utilizing drilldowns and cross-filtering techniques
- Incorporating tooltips and the Q&A visual
Publishing and Sharing Dashboards
- Deploying to the Power BI Service
- Managing workspaces and apps
- Securely sharing reports and dashboards
Navigation and Panel Actions
- Designing effective page navigation
- Implementing page-level tooltips
- Configuring action-based interactions
Power BI Report Architecture
- Leveraging data for storytelling
- Designing for maximum readability and clarity
- Integrating shapes, text, and images
Advanced Design Strategies
- Layering and grouping visual elements
- Utilizing dynamic titles and metrics
- Configuring drillthrough pages
Themes and Template Management
- Creating and applying custom themes
- Utilizing standardized report templates
- Ensuring visual consistency across reports
Mobile Design Considerations
- Using the mobile layout editor
- Optimizing interfaces for touch interactions
- Testing dashboard performance on mobile devices
User Experience and Accessibility Standards
- Ensuring color contrast and screen reader compatibility
- Managing tab order and keyboard navigation
- Adhering to accessible design best practices
Conclusion and Future Directions
- Review of essential concepts
- Access to additional Power BI resources
- Exploring available certification pathways
Requirements
- A foundational grasp of core data concepts and structures
- Prior experience utilizing Microsoft Excel for data manipulation
- Basic familiarity with 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.
