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
- Mastering the Power BI Desktop interface
- Establishing connections to standard data sources
Data Preparation and Transformation
- Utilising Power Query for data cleansing
- Structuring and reshaping data
- Overseeing and merging queries
Core Principles of Data Modelling
- Establishing relationships between tables
- Managing data types and hierarchical structures
- Constructing star schema models
Creating Visualisations
- Choosing appropriate visuals for specific data sets
- Refining and customising charts and visuals
- Implementing slicers and filters strategically
Essential DAX Concepts
- Grasping calculated columns and measures
- Employing standard DAX functions
- Applying time intelligence principles
Advanced Analytics and Reporting
- Developing drill-through and tooltip pages
- Elevating dashboards with advanced visual elements
- Applying conditional formatting rules
Publishing and Disseminating Insights
- Deploying reports to the Power BI Service
- Administering workspaces and access controls
- Distributing dashboards across team structures
Performance Optimisation and Governance
- Enhancing the performance of data models
- Adhering to governance and compliance standards
- Setting up dataset refresh strategies
Summary and Future Directions
Requirements
- A foundational understanding of data concepts
- Practical experience with spreadsheets or tabular data structures
- Awareness of basic reporting processes
Target Audience
- Business analysts
- Corporate professionals engaged in data-centric roles
- Individuals responsible for creating dashboards and reports
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customised Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from £3200 + VAT*
Contact us for an exact quote and to hear our latest promotions
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.