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
- Introduction to 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.
- Power Query and Power Pivot functionalities.
- Understanding datasets, reports, and dashboards.
Connecting to Data Sources
- Supported data sources and connectors.
- Import mode versus DirectQuery.
- Data refresh and update procedures.
Basic Data Modeling Concepts
- Relationships and keys.
- Hierarchies and calculated columns.
- Creating 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.
- Selecting the appropriate visual for the message.
Interactive Panel Functions
- Bookmarks and buttons.
- Drilldowns and cross-filtering.
- Tooltips and Q&A visuals.
Sharing and Publishing Dashboards
- Publishing to Power BI Service.
- Workspaces and apps.
- Securely sharing reports and dashboards.
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
- A foundational understanding of data concepts and structures.
- Experience using Microsoft Excel for data manipulation.
- 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