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 Concepts
- Introduction to Power BI and its capabilities.
- Distinguishing between Power BI Desktop and Power BI Service.
- An overview of the report creation workflow.
Key Power BI Components
- Power BI Desktop, Service, and Mobile applications.
- Leveraging Power Query and Power Pivot.
- Differentiating between datasets, reports, and dashboards.
Integrating Data Sources
- Review of supported data sources and connectors.
- Comparing Import and DirectQuery modes.
- Processes for refreshing and updating data.
Fundamentals of Data Modeling
- Defining relationships and keys.
- Utilizing hierarchies and calculated columns.
- Creating simple measures using DAX.
Building Basic Visualizations
- Creating bar, line, pie, matrix, and table visuals.
- Implementing filters and slicers.
- Applying conditional formatting and drillthrough features.
Power BI Dashboards
- Pinning visuals to create dashboard views.
- Configuring tiles and layout options.
- Managing live dashboards and refresh frequencies.
Principles of Dashboard Design
- Optimizing data-to-ink ratio and visual hierarchy.
- Effective use of white space and alignment.
- Selecting the most appropriate visual for the intended message.
Interactive Features and Panels
- Using bookmarks and buttons.
- Implementing drilldowns and cross-filtering.
- Utilizing tooltips and the Q&A visual tool.
Sharing and Publishing Dashboards
- Publishing content to the Power BI Service.
- Managing workspaces and apps.
- Securely sharing reports and dashboards.
Navigation and Interactive Actions
- Designing page navigation flows.
- Using page tooltips effectively.
- Configuring action-based interactions.
Power BI Report Design
- Storytelling with data.
- Designing for maximum readability and clarity.
- Incorporating shapes, text, and images.
Advanced Design Techniques
- Layering and grouping visual elements.
- Implementing dynamic titles and metrics.
- Setting up drillthrough pages.
Themes and Templates
- Creating and applying custom themes.
- Utilizing report templates.
- Ensuring visual consistency across reports.
Mobile Dashboard Design
- Using the mobile layout editor.
- Optimizing interfaces for touch interactions.
- Testing dashboard performance on mobile devices.
User Experience and Accessibility
- Ensuring color contrast and screen reader compatibility.
- Configuring tab order and keyboard navigation.
- Best practices for accessible design standards.
Summary and Next Steps
- Recap of core concepts covered.
- Recommendations for additional Power BI resources.
- Exploring available certification paths.
Requirements
- A foundational understanding of basic data concepts and structures.
- Practical experience with Microsoft Excel and data manipulation techniques.
- Familiarity with fundamental statistical concepts.
Target Audience
- Data analysts.
- Business intelligence specialists.
- Professionals responsible for report generation and dashboard architecture.
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
engagement with the attendees
