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!!!

Evelyn Wong, Analyst, Leading Security Organisation

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.

Tan Cheng Kiat, Analyst, Healthcare Ministry in Singapore

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.

Ng Yee Tat, Manager, Large Telco in Singapore

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!

Cher Kheng Thian, Founder, Marketing Agency

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.

DR. KE JINGHAO
DR. KE JINGHAOPROGRAMME DIRECTOR
Dr. Ke is the co-founder of Research Room, a highly trained team of Data Scientists and Analysts with domain expertise in economics, finance, strategy, and business management. He has provided management consulting for and managed teams to help thousands of individuals, SMEs, MNCs and various Singapore Government agencies deliver bespoke implementations of data-driven turn-key technology solutions in areas of complex prediction, decision making, machine learning, deep learning, amongst others. Dr. Ke is also co-founder of JCube Institute and a full-stack programmer well versed in various analytics stacks such as Python, R, SAS, Microsoft Analytics and Stata. On top of his work, he is adjunct faculty with the Singapore Management University in his spare time and teaches at Professional, Masters and Undergraduate levels.
DR. JACK HONG
DR. JACK HONGLEAD FACULTY
Co-founder of Research Room, an AI consulting and development outfit that delivers decision-making capabilities for complex use-cases, Dr. Hong specializes in developing prediction and decision engines with the use of alternative data. Some of his notable works include omni-channel content personalization systems, manpower resource optimization using deep reinforcement learning, real estate valuation engines, and highly personalized portfolio strategies using applied artificial intelligence (AI).

He is also AI Technology Consultant at Certis Group, Data Science Advisor at Vertex Holdings, advising on Human Conversational AI, Predictive Resource Allocation, Super-Intelligence in Natural Language Capabilities in Finance. He is also CEO of Integrum Global. Dr. Hong is concurrently an adjunct faculty with the Singapore Management University (SMU), and has been actively teaching undergraduate, postgraduate, and professional programmes since 2015. He is the lead instructor for the highly acclaimed “Leading Digital Transformation” course for MBA students.

EVELYN
EVELYNLEAD ASSOCIATE TRAINER
After attending JCube’s Certified Data Analyst (CDA) course, taught and coached by Dr Jack Hong, Evelyn currently leads at Certis Group as a Data Governance Analyst to deploy and enforce policies and procedures that ensure accurate and high data quality throughout its lifecycle. Besides being adept in software development, data analysis, machine learning, natural language programming and applications, Evelyn has an extensive background in corporate functions, including Compliance, Business Development, Sales & Marketing and Project Management at 3M, Agilent Technologies and ST Engineering. Evelyn is also a Certified Lean Six Sigma Green Belt and Certified Scrum Master. She is well-versed in applying the advanced elements of the Lean Six Sigma, Agile and Scrum Methodologies in any organisation.
VICTOR
VICTORLEAD ASSOCIATE TRAINER
Victor used to run his own firm with more than 20 years of financial experience in sales and marketing financial products and risk management, fiscal planning for high-net-worth individuals in the greater China region.

For the past 4 years, he has self -funded his other passion which is algorithmic trading in the trillion dollar forex and gold market. Currently he has a consistent and successful portfolio in the market using proprietary trading systems that he has developed to run on auto mode using machine learning especially in deep reinforcement learning on time series analysis. He runs a lot of statistical analysis on currencies and commodities market and then writes algorithms and programs using C++ and Python.

DR. JONATHAN KHOO
DR. JONATHAN KHOOLEAD FACULTY
Jonathan Khoo, Ph.D. is a full-stack app developer who likes building stuff. He has published papers in Genetic Programming and has a working paper in Energy Prediction. He has successfully delivered many projects on bespoke implementations of data driven strategies that delivers complex prediction and decision-making capabilities to many large organizations. Khoo obtained his Doctor of Philosophy in Business (Finance) at the Singapore Management University. His dissertation thesis investigates corporate finance through the lens of social network graph analytics, where he found a statistically significant “ownership centrality” effect in firm performance. Prior to that, he completed his Masters in Industrial Engineering and Operations Research at the University of Michigan (Ann Arbor), a year after he received degrees with Highest Honors in Economics and Summa Cum Laude in Electrical Engineering. He is an alumnus of Raffles Institution and Hwa Chong Institution.
JUN YI
JUN YIASSOCIATE TRAINER
Currently a Data Scientist for Digital Transformation at Certis Group, Jun Yi is well-equipped with Python and Data Analytics skills under the tutelage of the JCube founders. His established career encompasses diverse experiences in engineering and finance, where he has gained multidisciplinary capabilities through various Front Office to Back Office roles, comprising Operations, Planning, Project Management and Workforce Development. His extensive experience in Business Development and Sales across MNCs and renowned banks, including Maybank Singapore, HSBC, UOB Kay Hian and Bank of America, complements his strong technical expertise in Equipment, Industrial and Facilities engineering roles at Seagate, Singapore Power and Micron Technology.
QIANYU
QIANYUASSISTANT TRAINER
Qian Yu is an Assistant Trainer/Coach at JCube Institute. His interest in Data Analytics and Artificial Intelligence (A.I.) has led him to embark on projects in the varied domains ranging from EdTech to Computer Vision, Natural Language Communication, and social analytics. Combining his passion in healthcare and experience in utilizing data, he and his team engaged NTUC Health to analyze the social networks of community dwelling elderly for early intervention measures. Qian Yu loves sharing his knowledge and experience with anyone entering the fields of analytics and AI, believing that the best way to learn is through asking and learning from others.
CAMELLIA
CAMELLIAASSISTANT TRAINER
Camellia is Assistant Trainer/Coach at JCube Institute. She is an Information Systems professional driven to help businesses to create value in their digital transformation journey. She has worked on various projects with clients such as NTUC Health to create a restroom queue management system and collaborated with SAP Leonardo to help waste management companies to automate waste segregation. Camellia is also a Research Assistant working on solutions to automate bug detection, identification, and correction in the realm of Machine Learning projects. The research pushes the pinnacle of Artificial Intelligence by building State of the Art (SOTA) tools and models to address programming bugs, with the aim of setting a new benchmark for Machine Learning world.

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.