Are you spending hours consolidating data from multiple Excel files for monthly reports? Do you rely on your team to create charts for board presentations? This course eliminates that bottleneck. In just 2 days, you’ll master Power BI to create interactive dashboards that update automatically, answer complex business questions with a click, and present insights that drive executive action. No prior technical experience required—if you can use Excel, you can master this.

Who Should Attend

Senior managers and executives who want to stop depending on analysts for basic reporting and gain direct control over their data insights. Perfect for leaders who know Excel but want to level up their data visualization and analytical capabilities.

Learning Objectives

Upon completion of the course, participants will be able to:

1. Build an executive dashboard in 4 hours that consolidates data from Excel and CSV – no IT support needed
2. Confidently present data-driven recommendations to senior leadership using compelling visualizations
3. Identify trends and outliers instantly, reducing monthly reporting cycles from 3 days to 3 hours

Course Outline

• Orientation to Power BI Interface
  • The 3 major components of Power BI: Report, Data, and Model

• Understanding Data
  • What is Data?
  • 6 types of data you must know
  • The type of data relating to business

• Getting data from different sources
  • Excel Files
  • CSV

• Transforming Data
  • Organizing your data for modeling
  • Delete Rows and Columns
  • Changing the Type of Data
  • Filters
  • Sorting Data
  • Extract Data
  • Unpivot Columns
  • Merge Queries
  • Append Queries

• Data Modelling
  • Connecting multiple sets of data
  • Introduction to DAX
  • Creating Measures
  • Creating Calculated Columns
  • Creating a Date Table

• Common Charts and their intended purposes
  • Bar Chart
  • Column Chart
  • Map Chart
  • Pie Chart
  • Bubble Chart
  • Cards
  • Slicers
  • Drill down
  • Focus

• Formatting elements of the charts
  • Headers
  • Titles
  • Background

• 3 types of filters in Visualization
  • Visual filter
  • Page filters
  • All Pages filter

• Sharing your reports
  • PDF
  • PowerPoint
  • Interactive Report on the Web
  • Interactive Report on Mobile

Program Dates

• 13 – 14 Oct 2025 (Mon and Tue)
• 04 – 05 Dec 2025 (Thu and Fri)
• 06 – 07 Jan 2026 (Tue and Wed)
• 05 – 06 Mar 2026 (Thu and Fri)
• 04 – 05 Jun 2026 (Thu and Fri)
• 24 – 25 Aug 2026 (Mon and Tue)
• 02 -03 Nov 2026 (Mon and Tue)

Mode of Delivery

• Classroom training

Course Duration

• 2 days (7 hours each day) – 9 am to 5 pm

Price

$900 per pax

Need further clarification? Just complete the form below and we will attend to you as soon as possible

________________________

If you need further clarifications, please send us a message using the form here and we will reply you ASAP.