LP - NUS SOC  - Desktop Image

Analytics: From Data to Insights

Apply data analytics and python techniques and methodologies to uncover key business insights. Integrated with Generative AI (Optional)

Work Experience

Lunar New Year Enrolment Benefit

As we usher in the Lunar New Year, invest in your growth and gain a competitive edge. We’re delighted to offer an enrolment benefit of USD 150 for learners enrolling before Invalid liquid dataWith limited seats available, we encourage you to book your spot soon.

What Will This Programme Do For You?

  • Master critical processes, tools and concepts in data analytics

  • Apply appropriate SQL queries to retrieve information and answer real-world questions

  • Prepare data for creating data models and use analytical expressions to create calculations and measures

  • Employ analytical expressions to perform time-based analyses and visualise data

  • Create Decision Tree models to find patterns and make predictions from data

  • Develop interactive visualisation reports and dashboards

Unlocking the Power of Data: Master Analytics from SQL to Power BI

Join Dr. Ai Xin as she guides you through transforming raw data into actionable insights using tools like SQL, Power BI, and Orange. This hands-on programme equips you with end-to-end analytics skills to drive smarter decisions and real-world impact.

Dr. AI XIN

    Programme Highlights

    LP-APAC-NUSSOC-DA-PH-1

    50+ Pre-Recorded Video Lectures* from NUS faculty

    LP-APAC-NUSSOC-DA-PH-2

    10+ Discussion Boards

    LP-APAC-NUSSOC-DA-PH-3

    10+ Real-World Examples

    LP-APAC-NUSSOC-DA-PH-4

    2 Case Studies

    LP-APAC-NUSSOC-DA-PH-5

    1 Capstone Project

    LP-APAC-NUSSOC-DA-PH-6

    Python Bootcamp

    LP-APAC-NUSSOC-DA-PH-7

    Optional Modules on Generative AI Including Applications

    LP-APAC-NUSSOC-DA-PH-8

    Gen-AI Masterclass and Case Study Discussions

    Note: The programme highlights mentioned above are subject to change based on faculty availability and the desired outcomes of the programme.

    *This programme is primarily self-paced online

    **Assignments will be graded by industry practitioners who are available to support participants in their learning journey, and/or by the Emeritus grading team. The final number of quizzes, assignments, and discussions will be confirmed closer to the start of the programme.

    Cutting-Edge Tools

    Gain hands-on experience using the latest, most in-demand tools to transform and present your data.

    Note: All product and company names mentioned in this material are trademarks or registered trademarks of their respective holders. Their use does not imply any affiliation with or endorsement by them.

    *The tools will be taught by teaching faculty, industry practitioners, or linked to relevant knowledge bases for your reference and self-guided learning.

    Programme Modules

    • The role of analytics in business intelligence and artificial intelligence

    • Data Processing Chain

    • A simple analytics example

    • Understand Databases Structure

    • Exploring a Database in SQLite

    • Getting Started with Queries

    • Turning data into information

    • Working with multiple tables

    • Using functions

    • Data Warehouse and Power Pivot

    • Exploring Power Pivot

    • Importing Data into Power Pivot

    • Data Munging with Power Query

    • Data Warehouse

    • Star Schema Data Model

    • Create a Data Model in Power Pivot

    • What is DAX?

    • DAX Calculation Types

    • DAX Functions

    • Getting Data from Related Tables

    • Data Context

    • Creating Calculated Columns in Power Pivot

    • Creating Measures in Power Pivot

    • Time-based Analysis: an intro

    • Period-Based Evaluations

    • Shifting the Data Context

    • Using Single Date Functions

    • Implementing Time Intelligence in Power Pivot

    • Data Warehouse

    • Using Pivot Table to Explore the Data

    • Add visualization to a Pivot table

    • Working with Pivot Charts

    • Using Multiple Charts and Tables

    • Creating the BI Interface in Excel

    • Case Study using Power Pivot: Reseller Sales Analysis

    • What is Power BI Desktop

    • Building Blocks of Power BI

    • Creating Data Model in Power BI Desktop

    • Common Visualizations in Power BI

    • Creating Visualizations in Power BI Desktop

    • What is a Dashboard?

    • Create Dashboards on Power BI Portal

    • Case Study using Power BI: Sales Quota Analysis

    • Data Mining and CRISP-DM

    • Clustering Analysis

    • K-Means Clustering using Real Life Data

    • Classification using Decision Tree

    • Create Decision Tree Model Using Real Life Data

    • Regression using Linear Regression

    Capstone Project

    Toward the end of the programme, you will demonstrate your newly gained analytics skills by applying what you learned to build a simulation of real-life projects.

    Real-World Examples

    Through real-world examples from multiple industries, you'll see how the theories of data analytics are put into practice.

    Baseball

    Baseball

    The usage of analytics in professional baseball as shown in the movie Moneyball

    Movie Sales

    Analytics in movie sales transaction database

    Sunglasses Retailer

    Analysing data to provide insight for a sunglasses retailer

    RDBMS

    Popular Relational Database Management Systems (RDBMs) software examples

    Data for Businesses

    Turning sales, marketing and customer data into valuable information for businesses

    Airlines Delay Data

    Transforming airline delay data to a user-friendly interface

    Case Studies

    Reseller Sales Analysis

    Case Study using Power Pivot: Reseller Sales Analysis

    Sales Quota Analysis

    Case Study using Power BI: Sales Quota Analysis

    Note: All product and company names are trademarks or registered trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

    Python Bootcamp

    The bootcamp is designed for professionals interested in learning practical coding skills to leverage the massive data stream their company already generates or data that they would like to collect.

    This program will support the participants with valuable instructions in the most popular and fastest-growing programming language and provide skill sets to solve business problems, plan, and communicate more fluently with coders and developers.

    Note: This bootcamp is a value add by Emeritus to ensure comprehensive learning journey and enable holistic development of your data analytics skills.

    Generative AI (Optional)

    • Module 1: Introduction to Generative AI

    • Module 2: Generative AI Models

    • Module 3: Working with Generative AI

    • Module 4: Coding

    Masterclass to address cutting-edge tools and latest developments

    Note: *This programme is primarily self-paced online

    **Assignments will be graded by industry practitioners who are available to support participants in their learning journey, and/or by the Emeritus grading team. The final number of quizzes, assignments, and discussions will be confirmed closer to the start of the programme.

    The bonus content on Generative AI is optional and does not count towards your final evaluation.

    Why Enrol for the Programme?

    The importance of data cannot be overstated when it comes to business success. Not only does data enable companies to understand the current state of the business and its many processes, but it also provides a solid foundation to identify opportunities and predict future outcomes. But collecting data isn't enough. It must be visualised, filtered and broken down into actionable insights by the right data tool for the job.

    Analytics: From Data to Insights, an online programme offered by NUS School of Computing, is designed to give you the hands-on experience you need to master data analytics and make better business decisions. No prior coding experience required.

    Who Is This Programme For?

    Analytics: From Data to Insights programme is designed for analysts, engineers, managers and professionals seeking for a career in data analytics. Both professionals with a tech or non-tech background can benefit from the programme. The programme is applicable across major industries, including IT Services, Financial Services, BFSI, Management, Consulting, and across all functions.

    This programme is beneficial for professionals aspiring to:

    • Understand how to solve business problems with analytical skills in real-world scenarios

    • Develop skills to use large data sets to derive insights for making critical decisions

    Programme Faculty

    AI XIN

    PhD in Electrical and Computer Engineering

    Dr Ai Xin is currently a Lecturer with the School of Computing at the National University of Singapore. She has over a decade of experience teaching Artificial Intelligence an...

    Testimonials

    It has broadened my perception of various aspects of the ever-evolving tech industry. Given the lucrative nature of business analytics career prospects, I wish to use the knowledge imparted in a wide ...
    Nathan Alexander Chay
    Singapore Armed Forces
    It touches the introduction and guidance for the basic usage of all the analytic tools which can be very useful.
    Charyn Lum Shi Heng
    Accounting Ops Supervisor
    The session leaders have been very helpful in explaining and providing more insights about the course and the assignments. They will try to go out of their way to solve our problems that we face.
    Shanel Lim Yan Ling
    Corporate Secretary, APAC Trust Corporate Services Pvt ltd.
    I enjoyed learning about Power BI, SQL and other analytical tools using real life case scenarios. That helped me to understand the importance of what we are learning and how it would be applicable to ...
    Sarah T
    Agent, Propnex
    I learned a lot of new knowledge and tools that I can apply in practice
    Ng Ding Xue
    IT Consultant
    KE SDN BHD
    The programme is comprehensive, and the live sessions are highly engaging
    Mohd Muzammir Husin
    Lead
    TNB

    Past Participant Profiles

    Work Experience

    LP - NUSSOC - AIDA - Past Participant Profiles - Work Experience - img

    Industries

    • Consumer Products/ Retail

    • Consulting

    • IT Products/ Services

    • Advertising/Marketing/PR

    • Healthcare/ Health Services

    • Financial Services

    • Others

    Countries

    • Singapore

    • India

    • Malaysia

    • Others

    Example image of certificate that will be awarded after successful completion of this program

    Certificate

    Upon successful completion of the programme, participants will be awarded a verified digital certificate by NUS School of Computing.

    Note: All certificate images are for illustrative purposes only and may be subject to change at the discretion of the National University of Singapore.

    Emeritus Career Services

    Stepping into a business leadership career requires a variety of job-ready skills. Below given services are provided by Emeritus, our learning collaborator for this program. The primary goal is to give you the skills needed to succeed in your career; however, job placement is not guaranteed.

    Emeritus provides the following career preparation services:

    • Resume building videos

    • Interview preparation videos

    • Linkedln profile building videos

    • Interview guidebooks

    • Glossary of resume templates

    Please note:

    NUS or Emeritus do not promise or guarantee a job or progression in your current job. Career Services is only offered as a service that empowers you to manage your career proactively. The Career Services mentioned here are offered by Emeritus. NUS is not involved in any way and makes no commitments regarding the Career Services mentioned here

    The Learning Experience

    What is it like to learn with the learning collaborator, Emeritus?

    More than 300,000 professionals globally, across 200 countries, have chosen to advance their skills with Emeritus and its educational learning partners. In fact, 90 percent of the respondents of a recent survey across all our programs said that their learning outcomes were met or exceeded. All the contents of the course would be made available to students at the commencement of the course. However, to ensure the program delivers the desired learning outcomes, the students may appoint Emeritus to manage the delivery of the program in a cohort-based manner during the course period the cost of which is already included in the overall Course fee of the course.

    A dedicated program support team is available 7 days a week to answer questions about the learning platform, technical issues, or anything else that may affect your learning experience.

    Explore the 32 weeks, Online - Chief Data, Analytics and AI Officer (CDAIO) Programme by NUS School of Computing

    Know more about NUS School of Computing Chief Data, Analytics and AI Officer (CDAIO) Programme

    FAQs

    The programme is designed for analysts, engineers, managers and professionals seeking for a career in data analytics. Both professionals with a tech or non-tech background can benefit from the programme. The programme is applicable across major industries, including IT Services, Financial Services, BFSI, Management, Consulting, and across all functions. This programme is beneficial for professionals aspiring to understand how to solve business problems with analytical skills in real-world scenarios. It is also ideal for those looking to develop skills to use large data sets to derive insights for making critical decisions

    The curriculum covers topics such as data analytics, data base,data visualisation, data warehouse, data source, power BI, and more.

    You will work with tools like SQLite, Python,Power BI Desktop, PowerPivot, Orange data mining, DAX and more. The curriculum also includes capstone project, case-studies and a python bootcamp.

    The programme is delivered online with live sessions from NUS School of Computing faculty and industry experts. Pre-recorded videos allow flexible learning, while live sessions enable real-time interaction.

    Expect 6-8 hours weekly over 5 months, including video lectures, assignments, and live discussions.

    Yes, the programme offers flexible payment options. You can choose to pay the full fee upfront or spread the cost over two or three instalments, making it easier to manage your finances.

    Upon successful completion of the programme, participants will be awarded a verified digital certificate by NUS School of Computing.

    Access the platform and resources for 12 months post-programme to revisit the content and stay updated.

    Early registrations are encouraged. Seats fill up quickly!

    Starts On