Course Outline
Power BI – Fundamental Concepts
- Understanding Power BI and its capabilities.
- Distinguishing between Power BI Desktop and Power BI Service.
- Overview of the report development lifecycle.
Overview of Power BI Components
- Introduction to Power BI Desktop, Service, and Mobile.
- Exploring Power Query and Power Pivot.
- Understanding the relationship between datasets, reports, and dashboards.
Connecting to Data Sources
- Supported data sources and available connectors.
- Comparing Import mode and DirectQuery.
- Managing data refresh and updates.
Basic Data Modeling Concepts
- Establishing relationships and utilizing keys.
- Creating hierarchies and calculated columns.
- Writing simple measures using DAX.
Creating Simple Visualizations
- Utilizing bar, line, pie, matrix, and table visuals.
- Applying filters and slicers for interactivity.
- Implementing conditional formatting and drillthrough features.
Power BI Dashboards
- Pinning visuals to dashboards for quick access.
- Customizing tiles and layout options.
- Configuring live dashboards and refresh intervals.
Dashboard Design Principles
- Applying the data-to-ink ratio and visual hierarchy.
- Effectively using white space and alignment.
- Selecting the appropriate visual to convey the message.
Interactive Panel Functions
- Using bookmarks and buttons for navigation.
- Implementing drilldowns and cross-filtering.
- Enhancing context with tooltips and Q&A visuals.
Sharing and Publishing Dashboards
- Publishing content to the Power BI Service.
- Organizing content using workspaces and apps.
- Securely sharing reports and dashboards.
Panel Navigation and Actions
- Designing effective page navigation.
- Leveraging page tooltips for enhanced information.
- Implementing action-based interactions.
Power BI Report Design
- Mastering data storytelling.
- Designing reports for readability and clarity.
- Incorporating shapes, text, and images.
Advanced Design Techniques
- Layering and grouping visuals for depth.
- Utilizing dynamic titles and metrics.
- Configuring drillthrough pages for detailed analysis.
Using Themes and Templates
- Creating and applying custom themes.
- Utilizing report templates for efficiency.
- Maintaining visual consistency across reports.
Mobile Dashboard Design Considerations
- Navigating the mobile layout editor.
- Optimizing designs for touch interactions.
- Testing dashboards on various mobile devices.
User Experience and Accessibility
- Ensuring color contrast and screen reader compatibility.
- Managing tab order and keyboard navigation.
- Adopting best practices for accessible design.
Summary and Next Steps
- Recap of key concepts covered.
- Additional Power BI learning resources.
- Exploring certification options for career advancement.
Requirements
- A foundational understanding of data concepts and structures.
- Practical experience with Microsoft Excel and data manipulation techniques.
- Familiarity with fundamental statistical concepts.
Target Audience
- Data analysts.
- Business intelligence specialists.
- Professionals tasked with reporting and dashboard design.
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 -