Course Outline
Power BI – Core Concepts
- Introduction to Power BI and its capabilities.
- Differentiating Power BI Desktop from the Power BI Service.
- An overview of the report creation workflow.
Components of the Power BI Ecosystem
- Exploring Power BI Desktop, Service, and Mobile applications.
- Introduction to Power Query and Power Pivot.
- Distinguishing between datasets, reports, and dashboards.
Data Source Integration
- Reviewing supported data sources and available connectors.
- Comparing Import vs DirectQuery methodologies.
- Managing data refresh and update cycles.
Fundamentals of Data Modeling
- Defining relationships and keys.
- Establishing hierarchies and calculated columns.
- Creating basic measures using DAX.
Building Basic Visualizations
- Implementing bar, line, pie, matrix, and table visuals.
- Utilizing filters and slicers for interaction.
- Applying conditional formatting and drillthrough features.
Developing Power BI Dashboards
- Pinning visuals to create dashboard layouts.
- Configuring tiles and layout structures.
- Setting up live dashboards and refresh intervals.
Principles of Dashboard Design
- Optimizing the data-to-ink ratio and visual hierarchy.
- Effective application of white space and alignment.
- Selecting appropriate visuals to convey specific messages.
Interactive Panel Features
- Implementing bookmarks and functional buttons.
- Leveraging drilldowns and cross-filtering techniques.
- Utilizing tooltips and the Q&A visual component.
Dashboard Distribution and Publishing
- Publishing content to the Power BI Service.
- Managing workspaces and applications.
- Secure sharing protocols for reports and dashboards.
Panel Navigation and User Actions
- Designing intuitive page navigation paths.
- Implementing page tooltips for user guidance.
- Configuring action-based interactions.
Power BI Report Architecture
- Crafting narratives through data visualization.
- Designing for optimal readability and clarity.
- Incorporating shapes, text elements, and images.
Advanced Design Strategies
- Managing visual layering and grouping.
- Utilizing dynamic titles and metrics.
- Configuring drillthrough pages for deeper analysis.
Leveraging Themes and Templates
- Creating and applying custom themes.
- Using standardized report templates.
- Maintaining visual consistency across outputs.
Mobile Dashboard Considerations
- Utilizing the mobile layout editor.
- Optimizing interfaces for touch-based interactions.
- Testing dashboard performance on mobile devices.
User Experience and Accessibility Standards
- Ensuring color contrast and screen reader compatibility.
- Defining tab order and keyboard navigation flows.
- Adhering to best practices for inclusive design.
Conclusion and Future Learning
- Summary of core concepts and skills.
- Recommended resources for further Power BI development.
- Exploration of professional certification pathways.
Requirements
- A foundational grasp of basic data concepts and structures.
- Practical experience with Microsoft Excel and data manipulation techniques.
- Basic familiarity with 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.
