• Master the Hybrid Workflow: Understand the strategic transition between Excel, Power BI, AI, and Python for complex tasks.
• AI-Powered Productivity: Utilize Generative AI to accelerate the 4 tools, write complex formulas, debug code, and interpret data trends.
• End-to-End Data Modeling: Perform advanced data cleaning/modeling by linking multiple disparate datasets.
• Advanced Automation: Build automated Python scripts for repetitive data processing tasks.
• Business-Ready Visuals: Create impactful, interactive dashboards for high-level workplace decision-making.

Day 1: Foundation & The Excel-Power BI Bridge

• Module 1: The Modern Analytics Ecosystem
  • Overview of the Power BI ecosystem and workflow.
  • Understanding the strengths of Excel vs. Power BI.
  • Business use cases and the value proposition of integrated analytics.
• Module 2: Advanced Data Preparation with AI
  • Importing data from Excel and other disparate sources.
  • Using AI to assist in complex data cleaning and Power Query, PQE transformations.
  • Building your first multi-source report from scratch.
• Module 3: Data Modeling & Visual Best Practices
  • Linking multiple files and datasets (Data Modeling).
  • Choosing the right visuals (Charts, KPIs, and Tables).
  • Formatting and design principles for business dashboards.

Day 2: Advanced Automation, Python & AI Integration

• Module 4: Python for Data Professionals
  • Introduction to Python environments and basic data libraries (Pandas).
  • Using AI to generate and explain Python code for data manipulation.
  • Automating repetitive data tasks that Excel cannot handle easily.
• Module 5: The “AI-Enhanced” Power Project
  • Adding advanced columns and measures using DAX and AI assistance.
  • Integrating Python scripts directly within Power BI for getting data and advanced analytics.
  • Building a complete, automated business dashboard from a raw dataset.
• Module 6: Case Studies & Workplace Application
  • Deep dive into Sales, Financial, or Operational dashboards.
  • Review of key takeaways and AI prompting frameworks.
  • Q&A and applying analytics to your specific workplace challenges.

This programme is designed for professionals who want to develop end-to-end data analytics capabilities using modern tools and AI, without needing a deep technical background. It is especially suitable for:

• Business Executives and Managers
• Finance and Operations Professionals
• Analysts and anyone looking to improve reporting with Power BI and AI.
• Data Analysts and Marketing Specialists
• Anyone looking to future-proof their career with AI-integrated data skills.
• No Prerequisites of the any of the Tools (eg Python, PBI..) required

• Short, focused concept briefings.
• Step-by-step guided demonstrations and hands-on exercises.
• Real-world business datasets for practical application.
• Continuous application and review.

The trainer delivered the AI course with great clarity, and the introduction to Feedough was especially insightful. The practical examples and guidance made the learning experience highly engaging and useful.

Bernard is friendly and able to draw attention from the participants.

Bernard was knowledgeable and engaging. He customised the course to meet the needs of our group.

informative, engaging, useful info, insights

“The training was very hands-on and practical. I now feel confident using Excel & Power BI to generate reports for my team.” – Sarah T., HR Manager

“Excellent introduction to Excel & Power BI reporting. The instructor made everything easy to understand, even for someone with little experience.” – John P., Finance Assistant

Bernard is a very patient teacher, he was happy to repeat his explanations or simplify his explanations should he be required to
The session provided practical and relevant insights into how generative AI can be applied in a business context. The frameworks, examples, and demonstrations helped me better understand both the opportunities and limitations of GenAI, and I can see clear use cases that are applicable to my work.

Average of >4.9 stars out of 5 stars

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.