Course Outline
Power BI – Fundamental Concepts
- Understanding what Power BI is and its capabilities.
- Differentiating between Power BI Desktop and Power BI Service.
- A high-level view of the report creation workflow.
Key Power BI Components
- An overview of Power BI Desktop, Service, and Mobile applications.
- Introduction to Power Query and Power Pivot.
- Distinguishing between datasets, reports, and dashboards.
Integrating Data Sources
- Supported data sources and available connectors.
- Choosing between Import and DirectQuery methods.
- Managing data refreshing and updates.
Introductory Data Modeling
- Defining relationships and keys.
- Working with hierarchies and calculated columns.
- Creating simple measures using DAX.
Developing Basic Visualizations
- Using bar, line, pie, matrix, and table visuals.
- Implementing filters and slicers.
- Applying conditional formatting and drillthrough features.
Building Power BI Dashboards
- Pinning visuals to create dashboards.
- Configuring tiles and layout options.
- Setting up live dashboards and refresh schedules.
Principles of Dashboard Design
- Balancing data-to-ink ratio and establishing visual hierarchy.
- Utilizing white space and alignment effectively.
- Selecting the appropriate visual to convey specific messages.
Interactive Panel Features
- Implementing bookmarks and buttons.
- Utilizing drilldowns and cross-filtering.
- Configuring tooltips and the Q&A visual.
Distributing Dashboards
- Publishing content to the Power BI Service.
- Managing workspaces and applications.
- Securely sharing reports and dashboards.
Navigation and Panel Actions
- Designing page navigation flows.
- Using page tooltips.
- Creating action-based interactions.
Power BI Report Creation
- Crafting data-driven narratives.
- Designing for enhanced readability and clarity.
- Incorporating shapes, text, and images.
Sophisticated Design Methods
- Managing layering and grouping of visuals.
- Utilizing dynamic titles and metrics.
- Configuring drillthrough pages.
Applying Themes and Templates
- Developing and implementing custom themes.
- Utilizing report templates.
- Ensuring visual consistency across reports.
Mobile Dashboard Design
- Using the mobile layout editor.
- Optimizing layouts 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.
- Following best practices for accessible design.
Wrap-up and Future Directions
- Reviewing core concepts.
- Exploring additional Power BI resources.
- Considering certification pathways.
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.
