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 common data sources
Data Preparation and Transformation
- Utilising Power Query for data cleansing
- Shaping and transforming data structures
- Managing and merging queries
Data Modelling Fundamentals
- Establishing relationships between tables
- Working with data types and hierarchies
- Constructing star schemas
Creating Visualisations
- Choosing appropriate visuals for the data
- Customising charts and graphical elements
- Effective use of slicers and filters
DAX Essentials
- Comprehending calculated columns and measures
- Applying common DAX functions
- Incorporating time intelligence concepts
Advanced Analytics and Reporting
- Developing drill-through and tooltip pages
- Enhancing dashboards with sophisticated visuals
- Applying conditional formatting rules
Publishing and Sharing Insights
- Deploying reports to Power BI Service
- Administering workspaces and access controls
- Distributing dashboards across teams
Performance Optimisation and Governance
- Enhancing data model performance
- Adhering to governance and compliance standards
- Implementing dataset refresh strategies
Summary and Next Steps
Requirements
- A foundational understanding of data concepts
- Practical experience with spreadsheets or tabular data
- Basic familiarity with reporting tasks
Target Audience
- Business analysts
- Corporate professionals engaged in data work
- Users required to create dashboards and reports
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized 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 2600 € + 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.
