Power BI Basics: The AI-Enhanced Way to Analyse Data

Power BI Basics: Smarter Insights with AI

Essential Power BI Skills for Working Professionals in the Age of AI

Today’s professionals are expected to transform raw data into actionable insights quickly and effectively. This one-day practical workshop equips participants with the essential skills to build business-ready reports and dashboards using Microsoft Power BI, enhanced with AI-driven workflows.

Participants will learn how to connect, clean, model, and visualise data, while incorporating AI tools to accelerate analysis and improve decision-making. The workshop is designed to be highly practical, with step-by-step guidance and real-world business datasets.

Learners are required to bring a wifi-enabled laptop with Power BI Desktop installed.

Course Objectives
  • Understand the Power BI ecosystem and workflow
  • Build your first Power BI report from scratch
  • Apply data cleaning and transformation techniques
  • Perform data modelling by linking multiple datasets
  • Create impactful visuals and dashboards
  • Use AI tools to enhance data analysis and reporting
  • Develop business-ready dashboards for workplace use
Course Outline

Module 1: Introduction to Power BI

  • Overview of Power BI ecosystem
  • Understanding Power BI Desktop vs Service
  • Business use cases and value proposition

Module 2: Doing Your First Power BI Report

  • Importing data from Excel and other sources
  • Introduction to Power Query
  • Basic data cleaning and transformations
  • Building your first report

Module 3: Introduction to the Different Visuals

  • Charts, tables, and KPIs
  • Choosing the right visuals
  • Formatting and best practices

Module 4: Classic Business Data Report with AI

  • Data Modelling – linking multiple files
  • Advanced data cleaning techniques
  • Adding columns and measures
  • Using AI to assist data analysis
  • Building a complete Power BI report
  • Designing a business dashboard

Module 5: Additional Case Studies (If Time Permits)

  • Sales dashboard
  • Financial reporting dashboard
  • Operational analytics examples

Module 6: Review

  • Key takeaways
  • Q&A
  • Applying Power BI in your workplace
Who should attend

This workshop is designed for working professionals who need to turn data into clear, actionable business insights using Power BI and AI tools.

It is especially suitable for:

  • Business executives and decision-makers who want faster, data-driven insights for better decisions
  • Managers and team leaders who need to interpret dashboards and track performance effectively
  • Business analysts and data professionals responsible for reporting, analysis, and visualization
  • Finance and operations professionals working with data, KPIs, and performance reporting
  • Working professionals new to Power BI who want to build practical, job-ready dashboard skills
  •  Anyone in a data-driven role looking to improve reporting efficiency using AI-enhanced workflows
Training Methodology
  • Short, focused concept briefings
  • Step-by-step guided demonstrations
  • Hands-on practical exercises
  • Real-world business datasets
  • Application and review
Testimonials

I gained the practical Power BI skills I needed and left feeling confident about using data visualisation in my daily work. The course gave me knowledge I could apply right away to make better business decisions.

The workshop was well-structured with a good mix of concepts, real-world examples, and discussion. The materials were clear and useful, and the hands-on elements helped reinforce learning rather than being purely theoretical.

Bernard Peh demonstrated strong knowledge of the subject and explained complex concepts in a clear, accessible manner. He encouraged participation, responded thoughtfully to questions, and shared practical perspectives from real business scenarios, which made the session engaging and relevant.

Bernard selected apps that are user friendly and easy for trainees to try use which greatly enable learning and continued adoption

Bernard has a lot of knowledge and is willing to share, to encourage and enable learning in a fun and engaging environment

Bernard was able and willing to share as much as he could. He takes efforts to endure that we can learn at a suitable pace and regularly check in if we are able to keep pace to the lesson.

Bernard is able to cover both the breath as well as depth of a subject that he covered. He was also able to provide actionable insights using tools that are currently available.

About the Trainer

A person with short dark hair wearing a dark blazer and light shirt is smiling and posing with their right arm crossed over their chest against a plain light background.

Bernard Peh – Data Scientist / A.I Engineer / Principal Trainer [ACLP]

Bernard Peh is a Master Trainer, Curriculum Author, and Hedge Fund Manager with over 20 years of concurrent experience in Finance and Data Science. He specialises in AI, Data Analytics, Power BI, and workplace automation, helping organisations translate AI capabilities into tangible business value.

Formerly a Financial Services Director for 15 years, Bernard brings real-world industry experience into the classroom, including financial analytics and hedge fund strategies.

He is ACLP certified and delivers WSQ, IBF, and SkillsFuture-funded programmes. Known for his engaging teaching style, Bernard consistently receives top learner ratings for simplifying complex concepts and delivering highly practical, business-relevant training.

Bernard has trained extensively across Singapore’s leading institutions and corporates, including NTUC LearningHub, Singtel, and CapitaLand.