Course Outline
Introduction to Power BI Core Concepts
- Defining Power BI and exploring its capabilities.
- Distinguishing between Power BI Desktop and Power BI Service.
- A high-level view of the report creation workflow.
Key Components of the Power BI Ecosystem
- Power BI Desktop, Service, and Mobile applications.
- Introduction to Power Query and Power Pivot.
- Clarifying the roles of datasets, reports, and dashboards.
Establishing Data Source Connections
- Identifying supported data sources and available connectors.
- Comparing Import and DirectQuery methodologies.
- Managing data refresh cycles and updates.
Fundamental Data Modeling Principles
- Setting up relationships and defining keys.
- Working with hierarchies and calculated columns.
- Creating basic measures using DAX.
Developing Basic Visualizations
- Utilizing bar, line, pie, matrix, and table visuals.
- Implementing filters and slicers for data refinement.
- Applying conditional formatting and drillthrough features.
Building Power BI Dashboards
- Pinning selected visuals to dashboard views.
- Configuring tiles and layout arrangements.
- Setting up live dashboards with defined refresh intervals.
Principles of Dashboard Design
- Optimizing the data-to-ink ratio and establishing visual hierarchy.
- Effective application of white space and alignment techniques.
- Selecting appropriate visuals to convey specific messages.
Interactive Panel Capabilities
- Configuring bookmarks and action buttons.
- Implementing drilldowns and cross-filtering interactions.
- Adding tooltips and utilizing the Q&A visual.
Distributing and Publishing Dashboards
- Deploying content to the Power BI Service.
- Managing workspaces and distributing apps.
- Securely sharing reports and dashboards with stakeholders.
Navigation and Action Panels
- Designing intuitive page navigation flows.
- Implementing page-level tooltips.
- Configuring action-based user interactions.
Advanced Power BI Report Design
- Crafting data-driven narratives.
- Designing for maximum readability and clarity.
- Incorporating shapes, text, and imagery.
Sophisticated Design Techniques
- Layering and grouping visual elements.
- Implementing dynamic titles and metrics.
- Configuring dedicated drillthrough pages.
Leveraging Themes and Templates
- Creating and applying custom themes.
- Utilizing standardized report templates.
- Ensuring visual consistency across reports.
Mobile-Friendly Dashboard Design
- Using the mobile layout editor.
- Optimizing interfaces for touch-based interactions.
- Conducting tests on various mobile devices.
User Experience and Accessibility Standards
- Ensuring color contrast and screen reader compatibility.
- Configuring tab order and keyboard navigation.
- Adhering to best practices for accessible design.
Course Summary and Future Pathways
- Reviewing core concepts covered.
- Exploring additional Power BI learning resources.
- Investigating professional certification options.
Requirements
- A foundational grasp of basic data concepts and structural elements.
- Practical experience using Microsoft Excel for data manipulation tasks.
- General familiarity with fundamental statistical concepts.
Target Audience
- Data analysts.
- Business intelligence specialists.
- Professionals tasked with report generation 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
