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.
Introduction to Power BI Components
- Power BI Desktop, Service, and Mobile applications.
- Power Query and Power Pivot functionalities.
- Key differences between datasets, reports, and dashboards.
Data Source Connectivity
- Supported data sources and available connectors.
- Comparison of Import and DirectQuery methods.
- Processes for refreshing and updating data.
Fundamentals of Data Modeling
- Establishing 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.
- Applying conditional formatting and drillthrough features.
Power BI Dashboard Essentials
- Pinning visuals to create dashboards.
- Configuring tiles and layout options.
- Managing live dashboards and refresh intervals.
Principles of Dashboard Design
- Optimizing the data-to-ink ratio and visual hierarchy.
- Effective use of white space and alignment.
- Selecting the appropriate visual to convey the message.
Interactive Panel Capabilities
- Implementing bookmarks and interactive buttons.
- Utilizing drilldowns and cross-filtering.
- Adding tooltips and using the Q&A visual.
Sharing and Publishing Strategies
- Deploying content to the Power BI Service.
- Managing workspaces and apps.
- Securely sharing reports and dashboards.
Navigation and Panel Actions
- Designing page navigation flows.
- Leveraging page tooltips.
- Creating action-based interactions.
Power BI Report Design
- Using data for storytelling.
- Designing for enhanced readability and clarity.
- Incorporating shapes, text, and images effectively.
Advanced Design Techniques
- Layering and grouping visual elements.
- Implementing dynamic titles and metrics.
- Configuring drillthrough pages.
Applying Themes and Templates
- Creating and applying custom themes.
- Utilizing report templates.
- Maintaining visual consistency across reports.
Mobile Design Considerations
- Using the mobile layout editor.
- Optimizing interfaces for touch interactions.
- Testing dashboards on mobile devices.
User Experience and Accessibility
- Ensuring color contrast and screen reader compatibility.
- Managing tab order and keyboard navigation.
- Following best practices for accessible design.
Conclusion and Path Forward
- Review of key concepts.
- Recommended additional Power BI resources.
- Exploring certification opportunities.
Requirements
- Fundamental understanding of data concepts and structures.
- Proficiency in Microsoft Excel and data manipulation techniques.
- Basic knowledge of statistical principles.
Target Audience
- Data analysts.
- Business intelligence specialists.
- Professionals overseeing 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.
