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
- Getting to grips with the Power BI Desktop interface
- Establishing connections to common data sources
Data Preparation and Transformation
- Leveraging Power Query for data cleansing
- Reshaping and transforming data structures
- Overseeing and merging queries
Data Modelling Foundations
- Establishing relationships between tables
- Managing data types and hierarchies
- Constructing star schemas
Creating Visualisations
- Choosing the most appropriate visuals for the data
- Customising charts and visual elements
- Effectively utilising slicers and filters
DAX Fundamentals
- Comprehending calculated columns and measures
- Employing standard DAX functions
- Applying time intelligence principles
Advanced Analytics and Reporting
- Developing drill-through and tooltip pages
- Enhancing dashboards with advanced visuals
- Applying conditional formatting techniques
Publishing and Sharing Insights
- Distributing reports to Power BI Service
- Administering workspaces and access controls
- Sharing dashboards with various teams
Performance Optimisation and Governance
- Boosting data model performance
- Adhering to governance and compliance standards
- Executing dataset refresh strategies
Wrap-up and Future Directions
Requirements
- A solid grasp of fundamental data concepts
- Proficiency with spreadsheets or tabular data structures
- Basic familiarity with reporting workflows
Target Audience
- Business analysts
- Corporate professionals engaged in data management
- Individuals required to produce 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
Method of training.
