Global Learning for Operational Leaders
Classroom
17 sessions
Scroll for more
Online / Live
17 sessions
Scroll for more
Introduction
Course overview
The Business Intelligence with Power BI training course is designed to give participants a thorough understanding of Business Intelligence (BI) concepts while equipping them with practical skills to use Power BI for data visualization, analysis, and reporting. As a leading BI tool, Power BI allows users to connect, transform, and visualize data in impactful ways that support informed business decision-making. Through hands-on exercises, participants will learn how to create interactive reports and dashboards that bring data to life, making Power BI an indispensable tool for data-driven organizations.
What you will achieve
Learning objectives
- Understand core BI concepts and the importance of data-driven decision-making
- Navigate the Power BI interface and utilize its features for data transformation and visualization
- Import and clean data from multiple sources to prepare it for analysis
- Create interactive and visually engaging dashboards and reports
- Apply DAX (Data Analysis Expressions) to enhance analytical capabilities within Power BI
- Share insights and collaborate effectively using Power BI Service and Power BI Mobile
- Understand and implement data security and governance within Power BI
Who should attend
Target audience
- This training course is suitable to a wide range of professionals but will greatly benefit:
- Business analysts, data analysts, and data scientists who want to leverage BI tools for enhanced analytics
- Professionals from various industries who work with data and seek to improve their data reporting skills
- Decision-makers who wish to create data-driven strategies for their organization
- IT and finance professionals responsible for creating or managing reports and dashboards
- Anyone interested in improving data visualization and storytelling skills with Power BI
- Learning Methods
- This training course will utilise a variety of proven adult learning techniques to ensure maximum understanding, comprehension and retention of the information presented. This includes an interactive mixture of lecture-led learning & group discussions.
Complete course outline
Five focused days of learning and application
The timings provided are estimates and may vary depending on the number of participants and the discussions taking place during the sessions. They are indicative only and do not constitute a binding commitment.
Day 1
Introduction to Business Intelligence and Power BI Fundamentals
- Overview of Business Intelligence and its role in decision-making
- Introduction to Power BI components: Power BI Desktop, Power BI Service, and Power BI Mobile
- Power BI interface and navigation basics
- Connecting to data sources (Excel, SQL Server, web sources, etc.)
- Coffee break
- Connecting to data sources (Excel, SQL Server, web sources, etc.) (continued)
- Data import techniques and understanding data types
- Hands-on: Setting up Power BI Desktop and importing sample datasets
Day 2
Data Transformation and Preparation Using Power Query
- Introduction to Power Query and its ETL (Extract, Transform, Load) functions
- Data cleaning techniques: handling missing data, removing duplicates, filtering
- Data transformation: merging, appending, pivoting, and unpivoting data
- Coffee break
- Data transformation: merging, appending, pivoting, and unpivoting data (continued)
- Creating calculated columns and tables for enhanced analysis
- Practical exercise: Transforming raw data into a structured format using Power Query
Day 3
Data Modeling and DAX Basics
- Importance of data modeling and relationships in BI
- Creating and managing data relationships in Power BI
- Introduction to DAX (Data Analysis Expressions) and its functions
- Calculated columns vs. measures
- Coffee break
- Essential DAX functions: SUM, AVERAGE, COUNT, CALCULATE, and FILTER
- Building hierarchies and creating time intelligence in Power BI
- Hands-on practice: Developing a data model and applying basic DAX expressions
Day 4
Visualizing Data with Power BI
- Choosing the right visual for data representation: tables, charts, maps, and gauges
- Customizing visuals and formatting options for impactful storytelling
- Interactive features: slicers, filters, and drill-through for dynamic reporting
- Creating interactive dashboards with KPI indicators and scorecards
- Coffee break
- Creating interactive dashboards with KPI indicators and scorecards (continued)
- Best practices for designing intuitive and effective reports
- Hands-on session: Building a fully interactive dashboard using sample data
Day 5
Publishing, Sharing, and Power BI Service
- Publishing reports to the Power BI Service and setting up workspaces
- Understanding and managing user roles and permissions
- Creating and managing datasets, reports, and dashboards in the cloud
- Introduction to Power BI Mobile for on-the-go access to reports
- Coffee break
- Introduction to Power BI Mobile for on-the-go access to reports (continued)
- Collaboration and sharing options: sharing dashboards, embedding, and export options
- Data security and governance in Power BI: Row-level security, data refresh, and scheduling
- Hands-on exercise: Publishing a report and sharing it with stakeholders
FAQ
Frequently asked questions
What does Business Intelligence with Power BI (PSM-004) cover?
This course covers Planning and Strategy Management through a structured five-day outline focused on practical application, discussion, and implementation planning.
When is the next available session?
The next scheduled session starts on 9 - 13 November 2026. See the course schedules section for the available dates and delivery formats.
Who should attend this course?
This training course is suitable to a wide range of professionals but will greatly benefit:, Business analysts, data analysts, and data scientists who want to leverage BI tools for enhanced analytics, Professionals from various industries who work with data and seek to improve their data reporting skills
Is bilingual course delivery available?
Yes. All course materials and presentations are provided in English, while bilingual explanation and discussion support may be available depending on the selected location and trainer availability. For example, when attending a course in Istanbul, you may request a Turkish-speaking trainer to explain the English course content in Turkish. Arabic explanation support may also be requested at this location. Other languages are available in selected cities. You can choose your preferred language support as an optional preference during registration.
How can I register for a session?
Use any Register button next to the available course dates to open the participant registration page and submit your booking request for the selected session.
Is this course available online as well as classroom-based?
Check the course schedules section for currently published classroom and Online / Live sessions.
Where are classroom sessions delivered?
Current classroom venues include Istanbul, Barcelona, Vienna, Amsterdam, Paris, Munich, Kuala lumpur, Geneva, Cape Town, Dubai, London.
How long is the training programme?
The programme runs for five days, with up to five training hours per day, from 9:00 AM to 2:00 PM. Each programme includes a total of 25 training hours.
Quick request
Send quick request
Send a fast enquiry about this course and the academy team will get back to you.
Get a quotation
Request a formal quotation
Choose an available date and venue, add your participants, and we will email a formal quotation for Business Intelligence with Power BI to your business address.