Course Outline
Power BI – Core Concepts
- Understanding Power BI and its capabilities.
- Comparing Power BI Desktop and 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 modes.
- Refreshing and updating data.
Fundamental Data Modeling Concepts
- Relationships and keys.
- Hierarchies and calculated columns.
- Creating simple measures using DAX.
Creating Simple Visualizations
- Utilizing bar, line, pie, matrix, and table visuals.
- Implementing filtering and slicers.
- Applying conditional formatting and drillthrough.
Power BI Dashboards
- Pinning visuals to dashboards.
- Tiles and layout options.
- Configuring live dashboards and refresh intervals.
Dashboard Design Principles
- Maximizing data-to-ink ratio and visual hierarchy.
- Effective use of white space and alignment.
- Selecting the appropriate visual for the message.
Interactive Panel Functions
- Using bookmarks and buttons.
- Implementing drilldowns and cross-filtering.
- Adding tooltips and Q&A visuals.
Sharing and Publishing Dashboards
- Publishing to Power BI Service.
- Managing workspaces and apps.
- Securely sharing reports and dashboards.
Dashboard Navigation and Actions
- Designing page navigation.
- Using 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.
- Setting up drillthrough pages.
Using Themes and Templates
- Creating and applying themes.
- Utilizing report templates.
- Maintaining visual consistency.
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.
- Configuring 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 solid understanding of basic data concepts and structures
- Experience with Microsoft Excel and data manipulation techniques
- Familiarity with fundamental statistical concepts
Audience
- Data analysts
- Business intelligence specialists
- Professionals responsible for reporting and dashboard design
Testimonials (2)
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
The coding and analysis, how the information come together in a report which will be useful for my work
