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
- Connecting to common data sources
Data Preparation and Transformation
- Utilising Power Query for data cleaning
- Shaping and transforming data
- Managing and combining queries
Data Modelling Fundamentals
- Establishing relationships between tables
- Working with data types and hierarchies
- Constructing star schemas
Building Visualisations
- Selecting appropriate visuals for your data
- Customising charts and visuals
- Effective use of slicers and filters
DAX Essentials
- Understanding calculated columns and measures
- Applying common DAX functions
- Implementing time intelligence concepts
Advanced Analytics and Reporting
- Creating drill-through and tooltip pages
- Enhancing dashboards with advanced visuals
- Applying conditional formatting
Publishing and Sharing Insights
- Publishing reports to Power BI Service
- Managing workspaces and access rights
- Sharing dashboards across teams
Optimising Performance and Governance
- Improving data model performance
- Adhering to governance and compliance practices
- Implementing dataset refresh strategies
Summary and Next Steps
Requirements
- A foundational understanding of data concepts
- Experience working with spreadsheets or tabular data
- Familiarity with basic reporting tasks
Target Audience
- Business analysts
- Corporate professionals working with data
- Users requiring the creation of dashboards and reports
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
engagement with the attendees