Course Outline
Power BI – Core Concepts
- What is Power BI and its capabilities?
- Power BI Desktop versus Power BI Service.
- Overview of the report-building process.
Overview of Power BI Components
- Power BI Desktop, Service, and Mobile.
- Power Query and Power Pivot.
- Understanding datasets, reports, and dashboards.
Connecting to Data Sources
- Supported data sources and connectors.
- Import versus DirectQuery.
- Refreshing and updating data.
Fundamental Data Modelling Concepts
- Relationships and keys.
- Hierarchies and calculated columns.
- Simple measures using DAX.
Creating Simple Visualisations
- Bar, line, pie, matrix, and table visuals.
- Filtering and slicers.
- Conditional formatting and drillthrough.
Power BI Dashboards
- Pinning visuals to dashboards.
- Tiles and layout options.
- Live dashboards and refresh intervals.
Dashboard Design Principles
- Data-to-ink ratio and visual hierarchy.
- Effective use of white space and alignment.
- Selecting the appropriate visual for the message.
Interactive Feature Functions
- Bookmarks and buttons.
- Drilldowns and cross-filtering.
- Tooltips and Q&A visuals.
Sharing and Publishing Dashboards
- Publishing to Power BI Service.
- Workspaces and apps.
- Sharing reports and dashboards securely.
Navigation and Actions within Panels
- Page navigation design.
- Utilising page tooltips.
- Action-based interactions.
Power BI Report Design
- Storytelling with data.
- Designing for readability and clarity.
- Using shapes, text, and images.
Advanced Design Techniques
- Layering and grouping visuals.
- Using dynamic titles and metrics.
- Setting up drillthrough pages.
Utilising Themes and Templates
- Creating and applying themes.
- Using report templates.
- Maintaining visual consistency.
Mobile Dashboard Design Considerations
- Mobile layout editor.
- Optimising for touch interactions.
- Testing dashboards on mobile devices.
User Experience and Accessibility
- Colour contrast and screen reader compatibility.
- Tab order and keyboard navigation.
- Best practices for accessible design.
Summary and Next Steps
- Recap of key concepts.
- Additional Power BI resources.
- Exploring certification options.
Requirements
- Foundational understanding of core data concepts and structures.
- Proficiency in Microsoft Excel and data manipulation techniques.
- Basic familiarity with statistical concepts.
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
engagement with the attendees
