Course Outline
Power BI – Fundamental Concepts
- Defining Power BI and its capabilities
- Distinguishing between Power BI Desktop and the Power BI Service
- An overview of the report creation workflow
Components of the Power BI Ecosystem
- Introduction to Power BI Desktop, Service, and Mobile applications
- Utilizing Power Query and Power Pivot
- Distinguishing between datasets, reports, and dashboards
Establishing Data Connections
- Supported data sources and available connectors
- Comparing Import modes versus DirectQuery
- Managing data refreshes and updates
Foundational Data Modeling
- Defining relationships and keys
- Implementing hierarchies and calculated columns
- Writing simple measures using DAX
Developing Basic Visualizations
- Creating bar, line, pie, matrix, and table visuals
- Applying filters and slicers
- Utilizing conditional formatting and drillthrough features
Constructing Power BI Dashboards
- Pinning specific visuals to dashboards
- Configuring tiles and layout structures
- Managing live dashboards and refresh schedules
Principles of Dashboard Design
- Optimizing the data-to-ink ratio and establishing visual hierarchy
- Effective use of white space and alignment
- Selecting appropriate visuals to convey specific messages
Interactive Panel Capabilities
- Implementing bookmarks and action buttons
- Leveraging drilldowns and cross-filtering
- Using tooltips and the Q&A visual feature
Publishing and Distributing Dashboards
- Publishing content to the Power BI Service
- Managing workspaces and apps
- Securely sharing reports and dashboards
Panel Navigation and Interactions
- Designing effective page navigation
- Implementing page tooltips
- Configuring action-based interactions
Power BI Report Architecture
- Crafting data-driven narratives
- Designing for enhanced readability and clarity
- Incorporating shapes, text, and imagery
Advanced Design Strategies
- Mastering the layering and grouping of visuals
- Implementing dynamic titles and metrics
- Setting up dedicated drillthrough pages
Applying Themes and Templates
- Developing and applying custom themes
- Leveraging report templates
- Ensuring visual consistency across projects
Mobile Dashboard Design Strategies
- Using the mobile layout editor
- Optimizing interfaces for touch interactions
- Conducting tests on mobile devices
User Experience and Accessibility
- Ensuring color contrast and screen reader compatibility
- Managing tab order and keyboard navigation
- Following best practices for accessible design
Recap and Future Pathways
- Reviewing core concepts
- Identifying additional Power BI resources
- Exploring available certification options
Requirements
- A foundational grasp of basic data concepts and structures
- Practical experience with Microsoft Excel and data handling
- Familiarity with fundamental statistical principles
Target Audience
- Data Analysts
- Business Intelligence Specialists
- Professionals responsible for reporting and dashboard architecture
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 3900 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (2)
How to use relationships in Power BIand the differences between columns and measurements
LEUNG Chun Hei - HAESL
Course - Advanced Power BI: Data Modeling, DAX, and Enhanced Analytics
Method of training.
