Course Outline
Power BI – Fundamental Concepts
- Introduction to Power BI and its capabilities.
- Comparison between Power BI Desktop and Power BI Service.
- An overview of the report development workflow.
Overview of Power BI Components
- Power BI Desktop, Service, and Mobile applications.
- Power Query and Power Pivot functionalities.
- Understanding the distinctions between datasets, reports, and dashboards.
Establishing Data Source Connections
- Supported data sources and available connectors.
- Differences between Import and DirectQuery methods.
- Processes for refreshing and updating data.
Core Data Modeling Principles
- Defining relationships and keys.
- Managing hierarchies and calculated columns.
- Creating simple measures using DAX.
Creating Basic Visualizations
- Bar, line, pie, matrix, and table visual types.
- Utilizing filters and slicers.
- Applying conditional formatting and drillthrough features.
Power BI Dashboards
- Pinning visuals to create dashboards.
- Configuring tiles and layout options.
- Setting up live dashboards and refresh intervals.
Dashboard Design Best Practices
- Optimizing data-to-ink ratio and visual hierarchy.
- Effective use of white space and alignment.
- Selecting appropriate visuals to convey specific messages.
Interactive Panel Features
- Implementing bookmarks and buttons.
- Utilizing drilldowns and cross-filtering.
- Adding tooltips and using the Q&A visual.
Sharing and Publishing Dashboards
- Publishing content to Power BI Service.
- Managing workspaces and apps.
- Securely sharing reports and dashboards.
Panel Navigation and Actions
- Designing effective page navigation.
- Utilizing page tooltips.
- Configuring action-based interactions.
Power BI Report Design
- Data storytelling techniques.
- Designing for readability and clarity.
- Incorporating shapes, text, and images.
Advanced Design Techniques
- Layering and grouping visual elements.
- Creating dynamic titles and metrics.
- Configuring drillthrough pages.
Utilizing Themes and Templates
- Creating and applying custom themes.
- Leveraging report templates.
- Maintaining visual consistency across reports.
Mobile Dashboard Design Considerations
- 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.
- Best practices for accessible design.
Summary and Next Steps
- Recap of essential concepts.
- Recommended additional Power BI resources.
- Exploring certification pathways.
Requirements
- A foundational understanding of basic data concepts and structures.
- Experience with Microsoft Excel and data manipulation techniques.
- Familiarity with fundamental statistical concepts.
Target Audience
- Data analysts.
- Business intelligence specialists.
- Professionals responsible for 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.
