Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Power BI – Core Fundamentals
- Understanding Power BI and its capabilities.
- Comparing Power BI Desktop with Power BI Service.
- Overview of the report creation workflow.
Overview of Power BI Ecosystem Components
- Power BI Desktop, Service, and Mobile applications.
- Power Query and Power Pivot functionalities.
- Distinguishing between datasets, reports, and dashboards.
Data Source Connectivity
- Supported data sources and available connectors.
- Import modes versus DirectQuery.
- Managing data refreshing and updates.
Fundamental Data Modeling
- Establishing relationships and keys.
- Defining hierarchies and calculated columns.
- Creating simple measures with DAX.
Building Basic Visualizations
- Utilizing bar, line, pie, matrix, and table visuals.
- Implementing filtering and slicers.
- Applying conditional formatting and drillthrough features.
Power BI Dashboards
- Pinning visuals to dashboard views.
- Configuring tiles and layout options.
- Managing live dashboards and refresh intervals.
Principles of Dashboard Design
- Optimizing data-to-ink ratio and visual hierarchy.
- Effective use of white space and alignment.
- Selecting appropriate visuals for specific messages.
Interactive Panel Features
- Using bookmarks and navigation buttons.
- Implementing drilldowns and cross-filtering.
- Leveraging tooltips and the Q&A visual.
Publishing and Sharing Dashboards
- Publishing content to Power BI Service.
- Managing workspaces and apps.
- Securely sharing reports and dashboards.
Navigation and Panel Actions
- Designing page navigation flows.
- Utilizing page-level tooltips.
- Creating action-based interactions.
Power BI Report Design
- Storytelling through data.
- Designing for maximum readability and clarity.
- Incorporating shapes, text, and images.
Advanced Design Methods
- Layering and grouping visual elements.
- Implementing dynamic titles and metrics.
- Configuring drillthrough pages.
Themes and Templates
- Creating and applying custom themes.
- Utilizing report templates.
- Maintaining visual consistency across reports.
Mobile Dashboard Design
- Using the mobile layout editor.
- Optimizing for touch-based interactions.
- Testing dashboards on mobile devices.
User Experience and Accessibility
- Ensuring color contrast and screen reader compatibility.
- Managing tab order and keyboard navigation.
- Following best practices for accessible design.
Summary and Future Directions
- Review of key concepts.
- Additional Power BI resources.
- Exploring professional certification options.
Requirements
- A solid grasp of fundamental data concepts and structures.
- Hands-on experience with Microsoft Excel and data manipulation techniques.
- Familiarity with basic statistical principles.
Target Audience
- Data analysts.
- Business intelligence specialists.
- Professionals responsible for reporting and dashboard design.
21 Hours
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.
