Course Outline
Introduction to Power BI Fundamentals
- Understanding the capabilities and purpose of Power BI.
- Comparing Power BI Desktop and Power BI Service.
- A general overview of the report creation workflow.
Key Components of Power BI
- An introduction to Power BI Desktop, Service, and Mobile applications.
- Exploring Power Query and Power Pivot functionalities.
- Distinguishing between datasets, reports, and dashboards.
Data Source Connectivity
- Reviewing supported data sources and available connectors.
- Understanding the differences between Import and DirectQuery methods.
- Managing data refreshing and updates.
Fundamental Data Modeling
- Establishing relationships and defining keys.
- Creating hierarchies and calculated columns.
- Developing basic measures using DAX.
Developing Basic Visualizations
- Utilizing bar, line, pie, matrix, and table charts.
- Implementing filtering and slicer functionality.
- Applying conditional formatting and drillthrough features.
Building Power BI Dashboards
- Pinning visuals to create dashboard layouts.
- Configuring tiles and layout options.
- Setting up live dashboards and refresh intervals.
Dashboard Design Best Practices
- Optimizing the data-to-ink ratio and visual hierarchy.
- Leveraging white space and alignment for better readability.
- Selecting the most appropriate visual elements to convey messages.
Interactive Panel Features
- Using bookmarks and buttons for navigation.
- Implementing drilldowns and cross-filtering.
- Utilizing tooltips and the Q&A visual tool.
Publishing and Sharing Strategies
- Publishing content to the Power BI Service.
- Managing workspaces and apps.
- Securely sharing reports and dashboards.
Navigation and Action Configuration
- Designing effective page navigation flows.
- Utilizing page tooltips for additional context.
- Configuring action-based interactions.
Advanced Report Design
- Crafting data-driven narratives.
- Prioritizing readability and clarity in design.
- Incorporating shapes, text, and images effectively.
Advanced Design Techniques
- Layering and grouping visual elements.
- Utilizing dynamic titles and metrics.
- Configuring drillthrough pages for deeper analysis.
Themes and Templates
- Creating and applying custom themes.
- Leveraging report templates for consistency.
- Maintaining visual uniformity across reports.
Mobile Design Considerations
- 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.
- Managing tab order and keyboard navigation.
- Following best practices for inclusive design.
Conclusion and Future Learning
- Recap of essential concepts covered in the course.
- Resources for further Power BI development.
- Information on available certification paths.
Requirements
- A solid grasp of fundamental 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 involved in 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.
