| Event Profile | |
| Class/ Online | Classroom |
| Date | 25 - 26 May 2026 |
| Time | 9am to 5pm |
| Venue | Royal Plaza on Scotts 25 Scotts Road Singapore 228220 |
| Fee | 9% GST will apply SGD 1200.003 & above: SGD1180.00 each For Member SGD 1140 3 & above: SGD1121 each |
| Note | Two tea breaks and buffet lunch will be served. Limited complimentary car parking coupons are available upon request. |
| Other Date(s) | 1) 24 - 25 Aug 2026 2) 23 - 24 Nov 2026 |
| Trainer | |
| Activity | |
| You may reach us via T: 6204 6214 E: info@ccisg.com Alternatively, you may send below details to register Contact Person Company (optional), Name, Job Title, Mailing Address, Tel, Email Participant(s) Name, Job Title, Email | |
This course equips participants with the practical skills to build professional-level analytical reports and dashboards using Microsoft Excel and Power BI. Participants will learn how to extract, transform, and visualize data to drive meaningful business decisions.
Course Pre-Requisites
Participants should have basic computer skills and a working knowledge of simple Excel usage. No prior Power BI experience is required.
Setup Requirements
Participants must bring a wifi-enabled laptop (Windows only, no Macbooks) with Excel 365 / 2019 / 2021 and Power BI Desktop (free) installed
Course Pre-Requisites
Participants should have basic computer skills and a working knowledge of simple Excel usage. No prior Power BI experience is required.
Setup Requirements
Participants must bring a wifi-enabled laptop (Windows only, no Macbooks) with Excel 365 / 2019 / 2021 and Power BI Desktop (free) installed
Objective
By the end of the workshop, you will be able to:
- Identify key data sources and connect them to Excel and Power BI.
- Apply Power Query and DAX to manipulate and analyse data.
- Design dynamic dashboards with slicers, charts, and KPIs.
- Present findings through interactive visuals that tell a story.
Outline
- Introduction to Business Intelligence Concepts
- Data Collection and Integration in Excel and Power BI
- Using Power Query for Data Cleaning and Transformation
- Data Modelling and Introduction to DAX
- Visualisation Principles for Impactful Dashboards
- Creating Interactive Reports in Power BI
- Excel PivotTables, Pivot Charts, and Dashboards
- Publishing and Sharing Dashboards on Power BI Service
Who should attend
- Senior executives
- Business analysts
- Sales, finance, and operations professionals
- Anyone who works with business data regularly
Methodology
- Hands-on practical with real-world datasets.
- Instructor-led demonstrations and guided exercises.
- Group-based problem solving and case studies.
Testimonial
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 is a committed and knowledgeable trainer
A valuable learning experience for me & allow me apply it in work.
Session well organised and easy to follow .
Bernard was knowledgeable and explained contented clearly with practical examples.
The session was effective and overall.
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.
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 selected apps that are user friendly and easy for trainees to try use which greatly enable learning and continued adoption
Bernard is a committed and knowledgeable trainer
A valuable learning experience for me & allow me apply it in work.
Session well organised and easy to follow .
Bernard was knowledgeable and explained contented clearly with practical examples.
The session was effective and overall.
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.
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's Profile
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
Technical Expertise
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
