Course Outline
Introduction to Power BI
- Overview of Power BI and its components
- Understanding the Power BI ecosystem
- Installation and setup of Power BI Desktop
Connecting to Data Sources
- Importing data from Excel, databases, and cloud sources
- Data transformation using Power Query
- Cleaning and shaping financial data
Data Modeling and DAX
- Creating relationships between tables
- Introduction to DAX formulas
- Building calculated columns and measures
Creating Reports and Dashboards
- Designing financial reports with visualizations
- Using tables, charts, and KPIs effectively
- Adding interactivity with slicers and filters
Publishing and Sharing Reports
- Publishing reports to Power BI Service
- Sharing dashboards securely
- Scheduling data refresh and setting up alerts
Power BI Certification Preparation (PL-300)
- Exam overview and objectives
- Practice questions and exam tips
- Recommended study resources
Best Practices for Financial Analysis
- Optimizing performance in Power BI
- Designing user-friendly dashboards
- Common pitfalls and how to avoid them
Summary and Next Steps
Requirements
- Basic understanding of financial data and reporting
- Familiarity with Excel or similar spreadsheet tools
Audience
- Financial analysts
- Business intelligence professionals
- Finance teams looking to leverage Power BI for data-driven decision-making
Delivery Options
Private Group Training
Our identity is rooted in delivering exactly what our clients need.
- Pre-course call with your trainer
- Customisation of the learning experience to achieve your goals -
- Bespoke outlines
- Practical hands-on exercises containing data / scenarios recognisable to the learners
- Training scheduled on a date of your choice
- Delivered online, onsite/classroom or hybrid by experts sharing real world experience
Private Group Prices RRP from €4560 online delivery, based on a group of 2 delegates, €1440 per additional delegate (excludes any certification / exam costs). We recommend a maximum group size of 12 for most learning events.
Contact us for an exact quote and to hear our latest promotions
Public Training
Please see our public courses
Testimonials (5)
The content was tough but that extra effort I had to put helped me remember and understand power BI better.
Melvin - TLI Group
Course - Power BI DAX Fundamentals
Discussing about our issues
Rr Dwi Putri Periska Sari - PT. Becton Dickinson Indonesia
Course - Power BI for Developers
What I liked the most was the coach's openness regarding the change in content as well as the approach that was previously prepared to accommodate our real needs
Ernesto Sitoe Junior - Electricidade de Mocambique
Course - Advanced Power BI
The second day as Power Bi is a really friendly tool, and clearly Costas knows it very well, it was really good to learn about that tool. Unfortunately we have to see Power pivot in excel first which is really not user friendly but definitely a must see first in order to understand how Power Bi works, and it makes Power Bi look super cool :)
Anne-Cecile Jacquot - Ameropa
Course - Excel to Power BI
The second day was very interesting. It was a good training to see some possibilities within Power BI; but mostly you learn then while you work with Power BI. Fact is also that the training base has all access rights and everything works, but as soon as you try to connect to the live system, it does not work and this makes the knowledge transfer a bit difficult.