Course Outline
Power BI – Fundamental Concepts
- Introduction to Power BI and its capabilities.
- Distinguishing between Power BI Desktop and Power BI Service.
- An overview of the report construction workflow.
Introduction to Power BI Components
- Power BI Desktop, Service, and Mobile applications.
- Power Query and Power Pivot functionalities.
- Comprehending datasets, reports, and dashboards.
Linking to Data Sources
- Overview of supported data sources and connectors.
- Comparing Import and DirectQuery methodologies.
- Managing data refresh and updates.
Core Data Modelling Principles
- Establishing relationships and keys.
- Working with hierarchies and calculated columns.
- Developing basic measures using DAX.
Developing Basic Visualisations
- Creating bar, line, pie, matrix, and table visuals.
- Applying filters and slicers.
- Utilising conditional formatting and drillthrough features.
Power BI Dashboards
- Pinning visuals to create dashboards.
- Configuring tiles and layout options.
- Setting up live dashboards and defining refresh intervals.
Dashboard Design Best Practices
- Optimising the data-to-ink ratio and visual hierarchy.
- Effective application of white space and alignment.
- Selecting appropriate visuals to convey specific messages.
Interactive Panel Capabilities
- Implementing bookmarks and buttons.
- Utilising drilldowns and cross-filtering.
- Using tooltips and the Q&A visual.
Distributing and Publishing Dashboards
- Publishing content to the Power BI Service.
- Managing workspaces and apps.
- Securely sharing reports and dashboards.
Panel Navigation and Actions
- Designing page navigation structures.
- Incorporating page tooltips.
- Implementing action-based interactions.
Power BI Report Design
- Crafting data-driven narratives.
- Designing for readability and clarity.
- Incorporating shapes, text, and images.
Advanced Design Methods
- Layering and grouping visuals effectively.
- Implementing dynamic titles and metrics.
- Configuring drillthrough pages.
Applying Themes and Templates
- Creating and applying custom themes.
- Utilising report templates.
- Ensuring visual consistency across reports.
Mobile Dashboard Design Considerations
- Using the mobile layout editor.
- Optimising interfaces for touch interactions.
- Testing dashboard performance on mobile devices.
User Experience and Accessibility
- Ensuring colour contrast and screen reader compatibility.
- Managing tab order and keyboard navigation.
- Adopting best practices for accessible design.
Summary and Future Steps
- Review of key learning points.
- Access to additional Power BI resources.
- Exploring certification pathways.
Requirements
- A solid grasp of fundamental data concepts and structures.
- Proficiency with Microsoft Excel and data manipulation techniques.
- Familiarity with core statistical principles.
Target Audience
- Data analysts.
- Business intelligence specialists.
- Professionals tasked with 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.
