Course Outline
Power BI – Basic Concepts
- What is Power BI and what can it do?
- Power BI Desktop vs Power BI Service
- Overview of the report-building process
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 vs 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
- Choosing the right 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
- Sharing reports and dashboards securely
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
- An understanding of basic data concepts and structures
- Experience with Microsoft Excel and data manipulation
- Familiarity with basic statistical concepts
Audience
- Data analysts
- Business intelligence specialists
- Professionals responsible for reporting and dashboard design
Testimonials (5)
The subject was taught in an engaging way, making me want to learn more.
kgotla Moncho - Martin Engineering Africa
Course - PL-300T00: Microsoft Power BI Data Analyst
Blessing made sure that he knows every one , and referred every candidate by their name which is excellent. He is a well experienced Trainer and has patience, and very helpful to all the candidates. Trainer like him make the training more interesting. Wish to have him allocated to my next training that I will be doing with your company.
Alfred Mashala - National Transmission Company South Africa
Course - Analyzing Data with Power BI
The manner in which the presenter addressed questions. The method of delivering the course was very beneficial to the students. A very good teacher indeed.
ROSE BALOYI - National Transmission Company South Africa
Course - Power BI: Basics to Advanced
What I liked the most was the coach's openness regarding the change in content as well as the approach that was previously prepared to accommodate our real needs
Ernesto Sitoe Junior - Electricidade de Mocambique
Course - Advanced Power BI
The second day as Power Bi is a really friendly tool, and clearly Costas knows it very well, it was really good to learn about that tool. Unfortunately we have to see Power pivot in excel first which is really not user friendly but definitely a must see first in order to understand how Power Bi works, and it makes Power Bi look super cool :)
