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.
Duration 14 hours
Course Outline
Fundamentals of the Power BI Platform
- Exploring the components of the Power BI ecosystem
- Mastering navigation within the Power BI Desktop interface
- Establishing connections to various data sources
Preparing and Transforming Data
- Utilizing Power Query for efficient data cleaning
- Refining and reshaping raw data
- Consolidating and managing multiple queries
Core Principles of Data Modeling
- Defining relationships across different tables
- Handling data types and establishing hierarchies
- Constructing effective star schema models
Developing Visualizations
- Choosing appropriate visuals for specific data types
- Customizing charts and visual elements
- Implementing slicers and filters for interactive exploration
DAX Fundamentals
- Distinguishing between calculated columns and measures
- Applying standard DAX functions
- Incorporating time intelligence concepts
Advanced Analytics and Reporting Techniques
- Designing drill-through capabilities and tooltip pages
- Enhancing dashboards with complex visual elements
- Applying rules for conditional formatting
Distributing and Sharing Insights
- Deploying reports to the Power BI Service
- Administering workspaces and user access controls
- Distributing dashboards across different teams
Performance Optimization and Governance
- Refining data model performance
- Adhering to governance and compliance standards
- Setting up strategies for dataset refreshes
Conclusion and Future Steps
Requirements
- A foundational grasp of data concepts
- Proficiency with spreadsheets or tabular data structures
- Experience with fundamental reporting tasks
Target Audience
- Business analysts
- Corporate professionals engaged in data-related work
- Individuals responsible for generating dashboards and reports
Testimonials (2)
The most valuable takeaway was learning how to apply the concepts in real-world scenarios and understanding the tools and processes.
Marcel Tansae - DB Technology
Course - Microsoft Power Automate
How to use relationships in Power BIand the differences between columns and measurements