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
- Defining Power BI and its capabilities.
- Comparing Power BI Desktop and Power BI Service.
- Overview of the report-building workflow.
Overview of Power BI Components
- Power BI Desktop, Service, and Mobile apps.
- Understanding Power Query and Power Pivot.
- Differentiating between datasets, reports, and dashboards.
Connecting to Data Sources
- Supported data sources and connectors.
- Import mode versus DirectQuery.
- Strategies for refreshing and updating data.
Fundamental Data Modeling Concepts
- Working with relationships and keys.
- Utilizing hierarchies and calculated columns.
- Creating simple measures using DAX.
Developing Simple Visualizations
- Utilizing bar, line, pie, matrix, and table visuals.
- Implementing filters and slicers.
- Applying conditional formatting and drillthrough features.
Power BI Dashboards
- Pinning visuals to dashboards.
- Exploring tile and layout options.
- Configuring live dashboards and refresh intervals.
Dashboard Design Principles
- Maximizing data-to-ink ratio and establishing visual hierarchy.
- Effectively using white space and alignment.
- Selecting the appropriate visual for the message.
Interactive Panel Functions
- Using bookmarks and buttons.
- Navigating drilldowns and cross-filtering.
- Implementing tooltips and Q&A visuals.
Sharing and Publishing Dashboards
- Publishing content to the Power BI Service.
- Managing workspaces and apps.
- Securely sharing reports and dashboards.
Dashboard Navigation and Actions
- Designing page navigation.
- Utilizing page tooltips.
- Creating action-based interactions.
Power BI Report Design
- Telling stories 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
- Addressing color contrast and screen reader compatibility.
- Configuring tab order and keyboard navigation.
- Adhering to 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 basic data concepts and structures.
- Experience with Microsoft Excel and data manipulation techniques.
- Familiarity with basic statistical concepts.
Target Audience
- Data analysts.
- Business intelligence specialists.
- Professionals responsible for reporting and dashboard design.
21 Hours
Testimonials (1)
engagement with the attendees
