Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Duration 21 hours
Course Outline
Power BI – Fundamental Concepts
- Introduction to Power BI and its capabilities
- Comparing Power BI Desktop with the Power BI Service
- Overview of the report creation workflow
Key Power BI Components
- Exploring Power BI Desktop, Service, and Mobile applications
- Understanding Power Query and Power Pivot
- Distinguishing between datasets, reports, and dashboards
Connecting to Data Sources
- Supported data sources and connector options
- Choosing between Import and DirectQuery modes
- Strategies for refreshing and updating data
Introduction to Data Modeling
- Establishing relationships and keys
- Working with hierarchies and calculated columns
- Creating simple measures using DAX
Building Basic Visualizations
- Utilizing bar, line, pie, matrix, and table visuals
- Implementing filtering and slicers
- Applying conditional formatting and drillthrough
Power BI Dashboards
- Pinning visuals to create dashboards
- Configuring tiles and layout options
- Managing live dashboards and refresh schedules
Principles of Dashboard Design
- Optimizing data-to-ink ratio and visual hierarchy
- Effective use of white space and alignment
- Selecting appropriate visuals for specific messages
Interactive Panel Features
- Utilizing bookmarks and buttons
- Implementing drilldowns and cross-filtering
- Adding 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 intuitive page navigation
- Leveraging page tooltips
- Implementing action-based interactions
Power BI Report Design
- Storytelling with data
- Designing for readability and clarity
- Incorporating shapes, text, and images
Advanced Design Techniques
- Layering and grouping visuals
- Using dynamic titles and metrics
- Configuring drillthrough pages
Themes and Templates
- Creating and applying custom themes
- Utilizing report templates
- Maintaining visual consistency across reports
Mobile Dashboard Design Considerations
- Using the mobile layout editor
- Optimizing 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
- Applying best practices for accessible design
Summary and Next Steps
- Recap of core concepts
- Exploring additional Power BI resources
- Considering certification options
Requirements
- A foundational grasp of basic data concepts and structures.
- Practical experience with Microsoft Excel and data manipulation techniques.
- Familiarity with fundamental statistical principles.
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
Method of training.
