| Event Profile | |
| Class/ Online | Classroom |
| Date | 11 - 12 May 2027 |
| Time | 9am to 5pm |
| Venue | Holiday Inn Atrium Singapore (Halal Certified) 317 Outram Road Singapore 169075 |
| Fee | 9% GST will apply SGD 1050.003 & above: SGD1020.00 each For Member SGD 997.5 3 & above: SGD969 each |
| Note | Two tea breaks and buffet lunch will be served. Limited complimentary car parking coupons are available upon request. |
| Other Date(s) | 1) 4 - 5 Nov 2026 2) 10 - 11 Nov 2026 3) 14 - 15 Jan 2027 4) 8 - 9 Mar 2027 5) 8 - 9 Jul 2027 6) 9 - 10 Sep 2027 7) 15 - 16 Nov 2027 |
| 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 | |
Designed for individuals with little to no prior experience in data analytics or business intelligence tools, this hands-on course introduces the fundamentals of Microsoft’s powerful data visualization platform, and guides learners through the process of connecting to data sources, transforming data, and creating reports.
Course Pre-requisites
This is a beginner Power BI course
Course Pre-requisites
This is a beginner Power BI course
- No pre-requisite is required.
- Participants are required to bring their own laptop PC or MacBook for the practical hands-on portions of the workshop.
- Participants will require access to download and install Power BI Desktop software from Microsoft.
Objective
- Understand the Power BI Ecosystem: Learn what Power BI is, its components, and how it fits into the world of business intelligence and data visualization.
- Manage and Prepare Data for Analysis: Discover how to connect to various data sources, clean and transform raw data, and load it into Power BI for analysis.
- Model Data Effectively: Gain insights into creating data models, building relationships between tables, and optimizing data structures for accurate reporting.
- Explore and Visualize Data: Learn how to build interactive visuals, charts, and dashboards to explore data trends and present insights clearly and effectively.
- Use DAX for Calculated Fields and Measures: Get introduced to DAX (Data Analysis Expressions) and understand how to use it.
Outline
Day 1
Introduction to Power BI
Managing and Preparing Data
Modeling Data
Day 2
Exploring and Visualizing Data
Introduction to DAX (Data Analysis Expressions)
Introduction to Power BI
- Overview of business intelligence and data visualization concepts
- What is Power BI and why it matters
- Components of Power BI: Desktop, Service, and Mobile
- Understanding the Power BI interface and views
- Power BI workflow: From data to dashboard
Managing and Preparing Data
- Connecting to different data sources (Excel, CSV, SQL, etc.)
- Introduction to Power Query Editor
- Data transformation basics: cleaning and shaping data
- Merging and appending data
- Handling missing or inconsistent data
Modeling Data
- Understanding data relationships
- Creating and managing relationships between tables
- Data model design best practices
- Using calculated columns
Day 2
Exploring and Visualizing Data
- Introduction to visualizations
- Creating charts, tables, and slicers
- Using filters and drill-down capabilities
- Designing interactive dashboards
- Publishing and sharing Power BI reports
Introduction to DAX (Data Analysis Expressions)
- What is DAX and why use it
- Creating calculated columns vs. measures
- Basic DAX functions (SUM, AVERAGE, COUNT, etc.)
- Using logical and text functions in DAX
- Time intelligence basics in DAX
Who should attend
This course is intended for
- Professionals from non-technical backgrounds such as marketing, finance, HR, and operations who are seeking to enhance their analytical capabilities.
- project managers, and anyone looking to make data-driven decisions through clear, interactive reports
Methodology
Participants engage in immersive, hands-on learning experiences, where they apply advanced development techniques and workflow design principles in simulated business scenarios. Instructors provide personalized guidance and feedback, fostering an environment conducive to skill mastery and knowledge retention.
Testimonial
Trainer's pace of teaching is good. We are able to understand and catch up with the lessons.
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
