Classroom/ Online: Yes/ No
Scheduling Date(s):
Note: Please click specific date for detailed venue and course fee etc.
2-Day Data Analytics using AI for Business Decision Making
This 2-day practical workshop, Data Analytics using AI for Business Decision Making, is designed to bridge that gap by equipping participants with the knowledge and hands-on skills to leverage AI-powered tools for data analysis. Participants will learn how to use modern AI technologies—such as ChatGPT and other analytics platforms—to clean, analyse, and visualise data with greater speed and accuracy.
Through real-world business scenarios, guided demonstrations, and hands-on exercises, participants will discover how to uncover trends, generate actionable insights, and make data-backed decisions confidently. By the end of the workshop, participants will be able to apply AI-driven analytics techniques to improve efficiency, enhance reporting, and support strategic business outcomes.
Pre-Requisites:
- Basic Excel knowledge
- No coding required
- Participants must bring a wifi-enabled laptop (Windows only, no Macbooks) with Excel 365 / 2019 / 2021 and Power BI Desktop (free) installed
- Web-Based AI tools: (ChatGPT, Gemini, Colab, NotebookLM, etc.)
Through real-world business scenarios, guided demonstrations, and hands-on exercises, participants will discover how to uncover trends, generate actionable insights, and make data-backed decisions confidently. By the end of the workshop, participants will be able to apply AI-driven analytics techniques to improve efficiency, enhance reporting, and support strategic business outcomes.
Pre-Requisites:
- Basic Excel knowledge
- No coding required
- Participants must bring a wifi-enabled laptop (Windows only, no Macbooks) with Excel 365 / 2019 / 2021 and Power BI Desktop (free) installed
- Web-Based AI tools: (ChatGPT, Gemini, Colab, NotebookLM, etc.)
Objective
By the end of the course, participants will be able to:
- Understand how AI enhances data analytics workflows
- Use AI tools to analyse datasets without deep coding
- Generate insights and summaries for decision-making
- Apply AI to common business scenarios
- Automate analytics workflows using AI
- Integrate multiple tools (Excel + AI + Colab)
- Build repeatable analytics processes
Outline
1. Introduction to AI in Analytics
- Role of AI in business analytics
- Overview of tools (ChatGPT, Gemini, NotebookLM, Colab)
- AI vs Traditional Analytics
- Action: Lecture + Demo
2. Data Preparation using AI
- Cleaning messy data with AI prompts
- Structuring datasets
- Common data issues in business
- Action: Demo + Guided + Practice
3. AI-Powered Analysis
- Using AI to generate insights
- Asking the right prompts
- Quick statistical summaries
- Action: Hands-on
4. Visualisation with AI
- Generating charts via AI
- Choosing correct visuals
- Export to Excel / Power BI
- Action: Demo
5. Business Use Cases
- Sales trend analysis
- Customer segmentation
- Financial reporting
- Action: Case Study
6. Risks & Governance
- Data privacy in Singapore context
- AI hallucination risks
- Validation techniques
- Action: Discussion
7. Advanced Prompt Engineering
- Structured prompts
- Iterative refinement
- Business scenario prompting
- Action: Hands-on
8. AI + Python (Colab) - Simple Python analytics
- Upload datasets
- Generate charts automatically
- Action: Guided Lab
9. NotebookLM for Insight Synthesis
- Upload reports
- Extract summaries
- Cross-document insights
- Action: Demo + Practice
10. Automation Workflows
- End-to-end analytics flow
- Reusable templates
- AI-assisted reporting
- Workshop
11. Dashboard Integration
- Feeding AI insights into Power BI
- Enhancing dashboards
- Action: Demo
12. Capstone Project - Real business dataset
- Present insights using AI tools
- Action: Group Work
- Role of AI in business analytics
- Overview of tools (ChatGPT, Gemini, NotebookLM, Colab)
- AI vs Traditional Analytics
- Action: Lecture + Demo
2. Data Preparation using AI
- Cleaning messy data with AI prompts
- Structuring datasets
- Common data issues in business
- Action: Demo + Guided + Practice
3. AI-Powered Analysis
- Using AI to generate insights
- Asking the right prompts
- Quick statistical summaries
- Action: Hands-on
4. Visualisation with AI
- Generating charts via AI
- Choosing correct visuals
- Export to Excel / Power BI
- Action: Demo
5. Business Use Cases
- Sales trend analysis
- Customer segmentation
- Financial reporting
- Action: Case Study
6. Risks & Governance
- Data privacy in Singapore context
- AI hallucination risks
- Validation techniques
- Action: Discussion
7. Advanced Prompt Engineering
- Structured prompts
- Iterative refinement
- Business scenario prompting
- Action: Hands-on
8. AI + Python (Colab) - Simple Python analytics
- Upload datasets
- Generate charts automatically
- Action: Guided Lab
9. NotebookLM for Insight Synthesis
- Upload reports
- Extract summaries
- Cross-document insights
- Action: Demo + Practice
10. Automation Workflows
- End-to-end analytics flow
- Reusable templates
- AI-assisted reporting
- Workshop
11. Dashboard Integration
- Feeding AI insights into Power BI
- Enhancing dashboards
- Action: Demo
12. Capstone Project - Real business dataset
- Present insights using AI tools
- Action: Group Work
Who should attend
- Business Managers & Executives
- Team Leaders & Supervisors
- Operations & Administrative Staff
- Marketing & Sales Professionals
- Finance & Business Analysts
- HR Professionals
- Entrepreneurs & Business Owners
- Anyone involved in decision-making using data
- Team Leaders & Supervisors
- Operations & Administrative Staff
- Marketing & Sales Professionals
- Finance & Business Analysts
- HR Professionals
- Entrepreneurs & Business Owners
- Anyone involved in decision-making using data
Methodology
Practical Example:
- Upload sales data → ask AI: "Identify top 3 revenue drivers and anomalies"
- Compare manual vs AI insights
Pros & Cons of AI Analytics
Pros
- Faster insights
- Lower technical barrier
- Scalable across teams
Cons
- Risk of incorrect outputs
- Over-reliance on AI
- Data security concerns
- Upload sales data → ask AI: "Identify top 3 revenue drivers and anomalies"
- Compare manual vs AI insights
Pros & Cons of AI Analytics
Pros
- Faster insights
- Lower technical barrier
- Scalable across teams
Cons
- Risk of incorrect outputs
- Over-reliance on AI
- Data security concerns
Testimonials
The 2-day Executive Masterclass was very well structured and engaging. The course was well-paced and covered many essential concepts that are highly relevant for business use. Bernard explained the topics clearly and provided practical insights that made the learning process smooth and effective. The course notes are also very comprehensive and will be useful for future reference and revision.
It has been very good. Thank you.
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.
Course maintained an excellent pace that kept us focused without feeling rushed. Comprehensive notes were particularly valuable and will serve as a useful reference moving forward.
Bernard Peh's 2-day masterclass was well-structured and clearly presented, making Power BI concepts easy to grasp for executives. His engaging delivery style encouraged good interaction and thoughtful questions throughout the sessions.
The range of visualisations covered was comprehensive, and the strong emphasis on Power Query Editor (PQE) was especially valuable in building a solid foundation. I also found the additional case studies and real-life applications shared by the trainer very insightful, as they helped contextualise how Power BI can be applied effectively in a work setting.
The workshop was well-designed with a good mix of hands-on practice and guided instruction. The materials provided were extremely useful—especially the Google Sheets notes, which will be instrumental for future revision.
The shared Dropbox resources were also very helpful, as they included not just practice files but additional theoretical content that supports deeper learning beyond the workshop itself.
Overall, the course was very well conducted. One possible enhancement would be to include a slightly more advanced mini-project or mini-capstone exercise at the end, allowing participants to consolidate all concepts learned into a single, end-to-end dashboard.
It has been very good. Thank you.
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.
Course maintained an excellent pace that kept us focused without feeling rushed. Comprehensive notes were particularly valuable and will serve as a useful reference moving forward.
Bernard Peh's 2-day masterclass was well-structured and clearly presented, making Power BI concepts easy to grasp for executives. His engaging delivery style encouraged good interaction and thoughtful questions throughout the sessions.
The range of visualisations covered was comprehensive, and the strong emphasis on Power Query Editor (PQE) was especially valuable in building a solid foundation. I also found the additional case studies and real-life applications shared by the trainer very insightful, as they helped contextualise how Power BI can be applied effectively in a work setting.
The workshop was well-designed with a good mix of hands-on practice and guided instruction. The materials provided were extremely useful—especially the Google Sheets notes, which will be instrumental for future revision.
The shared Dropbox resources were also very helpful, as they included not just practice files but additional theoretical content that supports deeper learning beyond the workshop itself.
Overall, the course was very well conducted. One possible enhancement would be to include a slightly more advanced mini-project or mini-capstone exercise at the end, allowing participants to consolidate all concepts learned into a single, end-to-end dashboard.
Profile of Bernard Peh
Principal Trainer | ACLP Certified | ICF Certified | Data & AI Scientist | Finance & Investment Expert | Senior Fund Manager
Bernard Peh is a Master Trainer, Curriculum Designer, published author, and Hedge Fund Manager with over 25 years of combined experience spanning Data Science and Financial Investments. He specializes in AI, Microsoft 365 Copilot, Power BI, Data Analytics, and workplace automation, helping organizations translate advanced technologies into practical, high-impact business outcomes.
With 15 years of experience as a Financial Services Director across multiple advisory firms, Bernard brings deep real-world industry expertise into his training, particularly in financial analytics, investment strategy, and hedge fund management. He is currently a Senior Partner at BigDataVC, where he co-leads AI- and data-driven investment initiatives powered by predictive analytics.
As an ACLP-certified trainer, Bernard has designed and delivered WSQ, IBF, and SkillsFuture-funded programmes across eight major Accredited Training Organizations (ATOs) in Singapore. Since 2018, he has trained many professionals, earning consistently high learner satisfaction scores for his ability to simplify complex concepts and deliver highly practical, business-relevant learning experiences.
He is also a sought-after keynote speaker and thought leader in Data Science and Investment Strategy, known for bridging the gap between technical analytics and strategic decision-making.
Key Career Highlights
- ACLP-Certified Master Trainer: Developed and delivered WSQ-aligned programmes across 8 leading ATOs in Singapore
- Senior Partner, BigDataVC: Co-leading data-driven investment strategies using AI and predictive analytics
- Financial Services Leader (15 years): Former Director in four leading financial advisory firms in Singapore
- 25+ Years in Data Science & Analytics: Applying advanced analytics to drive business and investment decisions
- Keynote Speaker & Author: Recognized thought leader in Data Science, AI applications, and Investment Strategy
Technical Expertise
- Artificial Intelligence (AI) & Prompt Engineering
- Microsoft 365 Copilot & Power Platform
- Power BI & Data Visualization
- Python, SQL, C / C++
- Microsoft Excel (Advanced)
- Data Science & Predictive Analytics
- Financial Advisory, Investment Strategy & Hedge Fund Management
- Leadership & Business Decision-Making Analytics
