Course Outline
Power BI – Core Concepts
- Introduction to Power BI and its capabilities
- Comparing Power BI Desktop and Power BI Service
- General overview of the report creation workflow
Key Components of Power BI
- Power BI Desktop, Service, and Mobile interfaces
- Utilizing Power Query and Power Pivot
- Distinguishing between datasets, reports, and dashboards
Establishing Data Connections
- Supported data sources and available connectors
- Differences between Import and DirectQuery modes
- Processes for refreshing and updating data
Fundamentals of Data Modeling
- Setting up relationships and keys
- Working with hierarchies and calculated columns
- Creating simple measures using DAX
Building Basic Visualizations
- Creating bar, line, pie, matrix, and table visuals
- Implementing filters and slicers
- Applying conditional formatting and drillthrough features
Power BI Dashboards
- Pinning visuals to dashboard boards
- Configuring tiles and layout options
- Managing live dashboards and refresh intervals
Principles of Dashboard Design
- Optimizing data-to-ink ratio and visual hierarchy
- Effective use of white space and alignment
- Selecting appropriate visuals to convey messages
Interactive Panel Capabilities
- Using bookmarks and buttons
- Implementing drilldowns and cross-filtering
- Configuring tooltips and the Q&A visual
Sharing and Publishing Dashboards
- Publishing content to the Power BI Service
- Managing workspaces and apps
- Securely sharing reports and dashboards
Panel Navigation and Actions
- Designing page navigation flows
- Utilizing page tooltips
- Implementing action-based interactions
Power BI Report Design
- Storytelling through data
- Designing for readability and clarity
- Incorporating shapes, text, and images
Advanced Design Techniques
- Layering and grouping visuals
- Utilizing dynamic titles and metrics
- Setting up drillthrough pages
Themes and Templates
- Creating and applying custom themes
- Using report templates efficiently
- 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
- Adhering to best practices for accessible design
Summary and Next Steps
- Review of key concepts learned
- Exploring additional Power BI resources
- Considering certification options
Requirements
- Foundational understanding of data concepts and structures
- Proficiency in Microsoft Excel and data manipulation
- Basic familiarity with 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
The basic structure of Power BI, its main functions, as well as some advanced functions
