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.
Course Outline
Power BI – Fundamental Concepts
- What is Power BI and its capabilities?
- Power BI Desktop compared to Power BI Service.
- Overview of the report-building workflow.
Overview of Power BI Components
- Power BI Desktop, Service, and Mobile.
- Power Query and Power Pivot.
- Understanding datasets, reports, and dashboards.
Connecting to Data Sources
- Supported data sources and connectors.
- Import versus DirectQuery.
- Refreshing and updating data.
Basic Data Modeling Concepts
- Relationships and keys.
- Hierarchies and calculated columns.
- Simple measures using DAX.
Creating Simple Visualizations
- Bar, line, pie, matrix, and table visuals.
- Filtering and slicers.
- Conditional formatting and drillthrough.
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.
- Secure sharing of 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 data concepts and structures.
- Experience using Microsoft Excel for data manipulation.
- Familiarity with basic statistical concepts.
Target Audience
- Data analysts.
- Business intelligence specialists.
- Professionals responsible for reporting and dashboard design.
21 Hours
Testimonials (2)
Method of training.
Ineshia Bilankulu - National Transmission Company South Africa
Course - Power BI: Basics to Advanced
- Building dashboards - Learning the counts and SUMs and SWITCH -