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
Getting Started with Power BI
- Exploring the Power BI ecosystem
- Navigating the Power BI Desktop workspace
- Establishing connections to standard data sources
Data Cleansing and Transformation
- Leveraging Power Query for data hygiene
- Reshaping and modifying data structures
- Consolidating and managing multiple queries
Core Principles of Data Modeling
- Defining relationships across tables
- Handling data types and structural hierarchies
- Constructing efficient star schemas
Crafting Effective Visualizations
- Choosing appropriate visuals for specific data types
- Tailoring the appearance of charts and elements
- Utilizing slicers and filters to refine views
Foundations of DAX
- Distinguishing between calculated columns and measures
- Applying standard DAX functions
- Incorporating time intelligence logic
Advanced Analytical Techniques
- Implementing drill-through capabilities and tooltips
- Enhancing dashboard complexity with advanced visuals
- Applying dynamic conditional formatting
Distribution and Collaboration
- Publishing completed reports to Power BI Service
- Administering workspaces and user permissions
- Distributing dashboards to cross-functional teams
Performance Tuning and Governance
- Optimizing the efficiency of data models
- Adhering to governance and compliance standards
- Setting up automated dataset refresh schedules
Recap and Future Learning Paths
Requirements
- A solid grasp of fundamental data concepts
- Practical experience working with spreadsheets or tabular data
- Basic knowledge of reporting workflows
Target Audience
- Business analysts
- Corporate professionals engaged in data management
- Team members 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