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
Introduction to Power BI
- Exploring the Power BI ecosystem
- Navigating the Power BI Desktop interface
- Establishing connections to standard data sources
Data Preparation and Transformation
- Leveraging Power Query for data cleansing
- Shaping and refining data structures
- Orchestrating and merging queries
Data Modeling Basics
- Establishing relationships between tables
- Managing data types and hierarchies
- Constructing star schema models
Developing Visualizations
- Choosing appropriate visuals for specific data types
- Customizing charts and graphic elements
- Utilizing slicers and filters for enhanced interaction
Core DAX Concepts
- Comprehending calculated columns and measures
- Applying standard DAX functions
- Incorporating time intelligence principles
Advanced Analytics and Reporting
- Developing drill-through and tooltip pages
- Enhancing dashboards with specialized visuals
- Applying conditional formatting rules
Publishing and Distributing Insights
- Deploying reports to the Power BI Service
- Administering workspaces and access controls
- Distributing dashboards among team members
Performance Optimization and Governance
- Boosting data model efficiency
- Adhering to governance and compliance standards
- Establishing dataset refresh protocols
Summary and Future Pathways
Requirements
- A foundational grasp of data concepts
- Proficiency with spreadsheets or tabular data structures
- Basic familiarity with reporting workflows
Target Audience
- Business analysts
- Corporate professionals engaged in data-centric roles
- Individuals tasked with developing 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