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 – 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
21 Hours
Testimonials (1)
engagement with the attendees
