Course Outline
Power BI – Basic Concepts
- What is Power BI and its capabilities?
- Comparing Power BI Desktop with Power BI Service
- An overview of the report-building workflow
Overview of Power BI Components
- Power BI Desktop, Service, and Mobile applications
- Power Query and Power Pivot
- Understanding datasets, reports, and dashboards
Connecting to Data Sources
- Supported data sources and available connectors
- Import mode versus DirectQuery
- Refreshing and updating data
Basic Data Modeling Concepts
- Relationships and keys
- Hierarchies and calculated columns
- Creating simple measures using DAX
Creating Simple Visualizations
- Bar, line, pie, matrix, and table visuals
- Filtering techniques and slicers
- Conditional formatting and drillthrough functionality
Power BI Dashboards
- Pinning visuals to dashboards
- Tiles and layout options
- Live dashboards and refresh intervals
Dashboard Design Principles
- Data-to-ink ratio and visual hierarchy
- Effective use of white space and alignment
- Selecting the appropriate visual for the message
Interactive Panel Functions
- Bookmarks and buttons
- Drilldowns and cross-filtering
- Tooltips and Q&A visual
Sharing and Publishing Dashboards
- Publishing to Power BI Service
- Workspaces and apps
- Securely sharing reports and dashboards
Panel Navigation and Actions
- Page navigation design
- Using page tooltips
- Action-based interactions
Power BI Report Design
- Storytelling with data
- Designing for readability and clarity
- Using shapes, text, and images
Advanced Design Techniques
- Layering and grouping visuals
- Using dynamic titles and metrics
- Setting up drillthrough pages
Using Themes and Templates
- Creating and applying themes
- Using report templates
- Maintaining visual consistency
Mobile Dashboard Design Considerations
- Mobile layout editor
- Optimizing for touch interactions
- Testing dashboards on mobile devices
User Experience and Accessibility
- Color contrast and screen reader compatibility
- Tab order and keyboard navigation
- Best practices for accessible design
Summary and Next Steps
- Recap of key concepts
- Additional Power BI resources
- Exploring certification options
Requirements
- A foundational understanding of basic data concepts and structures
- Practical experience with Microsoft Excel and data manipulation
- Familiarity with fundamental statistical concepts
Target Audience
- Data analysts
- Business intelligence specialists
- Professionals tasked with 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
engagement with the attendees
