BE A CERTIFIED DATA ANALYST (FOR ENTERPRISES)
MORE THAN 33 RUNS AND OVER 500 PROFESSIONALS TRAINED
Background
The Certified Data Analyst (CDA) program, designed for professionals seeking to master data analysis and visualization, embraces Microsoft’s Power Platform (Power Query, Power Pivot, Power BI) and AI Co-Pilots. Spread over four two-day modules, this comprehensive curriculum is tailored to equip participants with cutting-edge skills in data querying, wrangling, modeling, visualization, and automation. By integrating Microsoft technologies with the capabilities of AI Co-Pilots, the program offers a unique blend of tools and techniques vital for insightful data analysis and decision-making in today’s data-driven landscape.
Programme Design And Objectives
UNIQUELY DESIGNED BY RESEARCH ROOM (rR) and delivered through JCube
Our certification model is uniquely designed by founders of Research Room (rR)*, an AI consulting and implementation group that was co-founded by a team of Singaporean Ph.Ds who have worked on bespoke implementations of data driven strategies that delivers complex prediction and decision-making capabilities to thousands of clients and organizations. The programme is well-supported by a network of experienced Data Scientists and Analysts. Course is short and compact, targeted to get you industry ready and certified within the shortest time, working around your busy schedule.
Participants of the CDA program will:
- Master data querying and wrangling techniques using Microsoft Power Query, enhanced with AI Co-Pilot insights.
- Develop robust data models and learn to write powerful DAX expressions in Microsoft Power Pivot.
- Create advanced, interactive dashboards and reports for decision support using Microsoft Power BI, incorporating AI Co-Pilot analytics.
- Automate routine data analysis tasks using Macros, VBA, and AI Co-Pilots, enhancing efficiency and accuracy
Workshop 1: Certified Data Analyst I: Data Querying and Wrangling using Microsoft Power Query and AI Co-Pilots (2 Days)
This workshop focuses on the foundational skills of data querying and wrangling using Microsoft Power Query, enhanced with the intelligence of AI Co-Pilots. Participants will learn how to efficiently extract, transform, and load (ETL) data from various sources, utilizing Power Query’s robust interface and AI-assisted capabilities to clean and prepare data for analysis. This module is crucial for those looking to streamline their data preparation processes and gain insights more quickly and accurately.
Workshop 2: Certified Data Analyst II: Data Modeling using Microsoft Power Pivot, Data Analysis Expressions (DAX) and AI Co-Pilots (2 Days)
This workshop deep dives into the advanced features of Microsoft Power Pivot and the powerful Data Analysis Expressions (DAX) language, enhanced with AI Co-Pilots. Participants will learn how to create sophisticated data models that can handle complex analytical challenges, enabling deeper insights and more dynamic reports. This module is essential for those who aim to leverage the full potential of Excel’s data modeling capabilities in combination with AI to enhance data analysis and decision-making processes.
Workshop 3: Certified Data Analyst III: Advanced Dashboard Visualization for Decision Support using Microsoft Power BI and AI Co-Pilots (2 Days)
This workshop is centered on leveraging Microsoft Power BI along with AI Co-Pilots to create advanced, interactive dashboards and visualizations that support decision-making. This workshop teaches participants to transform data into compelling stories, enhancing the visualization of complex information to inform strategic decisions effectively. The use of Power BI combined with the analytical prowess of AI Co-Pilots enables participants to deliver deeper insights with interactive and dynamic data visualizations.
Workshop 4: Certified Data Analyst IV: Task Automation with Macros, VBA and AI Co-Pilots (2 Days)
This workshop delves into automating data-related tasks using Macros, Visual Basic for Applications (VBA), and AI Co-Pilots within the Microsoft Excel environment. This session focuses on equipping participants with the skills to automate repetitive and time-consuming tasks, enhancing efficiency and accuracy in data handling. By integrating AI Co-Pilots, participants will also learn how to enhance these automations, making them more intelligent and adaptive to changing data scenarios. Towards the end of the workshop, a basic introduction to Python is provided, offering insights into how it can be used to further automate and streamline tasks.
Course Fees
Individual Rate:
S$1600 per pax for a 2 day workshop
Corporate Rate:
Less than 8 pax ($5,500 for a 1 day workshop and $11,000 for a 2 day workshop)
8 – 15 pax ($6,000 for a 1 day workshop and $12,000 for 2 day workshop)
Note: Our course fees are exempt from GST charges.
Policies
1. Cancellation by Client
1.1. Notification:
All cancellations must be submitted in writing via email to admissions@jcube-institute.com.
1.2. Refunds:
– Up to 30 days before the class start date: Full refund minus a processing fee of SGD 800 per class.
– 30 days or less before the class start date: No refund.
1.3. Substitutions:
The client may substitute participants up to 5 days before the class start date without any additional fees.
2. Cancellation by JCube Institute
2.1. JCube Institute reserves the right to cancel the class. In such cases, clients will be notified at least 10 days before the class start date.
2.2. Refunds: In the event of cancellation by JCube Institute, clients will receive a full refund of the class fees.
3. Force Majeure
In the event of circumstances beyond our control (e.g., natural disasters, pandemics, government restrictions), JCube Institute reserves the right to reschedule or cancel the class. Clients will be offered the option to attend on the new date or receive a full refund.
4. Rescheduling
4.1. Client-Initiated Rescheduling: Requests to transfer reschedule the class date must be made at least 14 days before the original class start date. Transfers are subject to availability and a rescheduling fee of SGD 500 per class may be levied.
4.2. JCube Institute-Initiated Rescheduling: If JCube Institute reschedules the class, clients will be offered the option to transfer to the new date or receive a full refund.
5. Attendance Requirements
5.1. Participation: Participants are expected to attend up to 75% of scheduled sessions of the training class to receive any certificates of completion associated with the course.
5.2. Punctuality: Participants should arrive on time for each session. Late arrivals may be allowed at the discretion of the instructor but may result in missing critical content.
5.3. Absenteeism:
– Notification of Absence: If a participant is unable to attend a session, the client must inform JCube Institute as soon as possible. Do note that participants are expected to attend up to 75% of scheduled sessions of the training class to receive any certificates of completion.
Where Our Students Work At

The curriculum is hands-on and practical, emphasising on developing data science intuition rather than simply coding. Coming from a non programming background, I picked up data analytics, data visualisation and machine learning skills that are relevant to industry practices. With the guidance of the instructors, I’ve since secured a Data Governance role at a leading security organisation. Thank you so much, JCube!!!
Thanks Dr. Jack. The resources are a great help indeed. Really appreciate it. Want to award you “BEST LECTURER EVER”. As for my current work, they are using R scripts to automate the process of combining excel sheets and then writing to word document to send as daily reports.
I say the course curriculum is very focused on training students to handle real-world data analyst work using Python and that the skills learnt will be good enough to support and grow your role as an entry level data analyst.
I have picked up skills working with APIs, data cleaning, data visualisation and data analysis. Projects focused on working with Python 3, Pandas, and Natural Language Toolkit. Both Dr. Ke and Jack are competent, patient and motivating, encouraging us to learn and complete our projects!




















Technology Stacks











Our Faculty
LEARN FROM VETERAN DATA SCIENTISTS AND A.I. EXPERTS
JCube faculty have collectively trained more than 10,000 professionals are among the most respected and passionate practitioners and leaders in the field of digital science and transformation. Their expertise provides the highest quality of instruction to learners. Faculty also teach Data Science at renowned Universities at Undergraduate, Masters and Doctoral Levels and are known to be the best teachers who are patient and experienced in simplifying difficult concepts for learners to grasp easily.
Job of a Data Analyst
The Data Analyst/Associate Data Engineer blends historical data from available industry reports, public information, field reports or purchased sources, basic data cleaning and transformation, and performs analysis to support business and product decisions. He/She uses development tools to generate reports, dashboards, clean and prepare the data and analytical solutions according to business rules and specifications. He is a part of important projects and coordinates with internal teams to develop projection on the outcome of implementing certain business strategies that result in actionable insights. He works in a team setting and is proficient in the analytics tools and techniques required by the organisation. He is also familiar with the relevant software platforms on which the solution is deployed on. The Data Analyst/Data Engineer enjoys working with data and displays willingness to learn. He adopts an analytical approach to solving problems and displays confidence when communicating ideas.

















