Course Overview Print

Understanding data is central to smarter decision-making. This course introduces participants to core data analytics concepts, exploring how data transforms into insight using Excel. They will learn the full cycle from importing and cleaning data, to visualising results and interpreting dashboards.

Learning Outcomes:

  • Understand key concepts in data and analytics

  • Apply descriptive and predictive techniques in Excel

  • Clean and transform raw datasets

  • Create reports and dashboards for decision-making

Key Topics:

  • Basics of data and big data

  • Types of data analytics

  • Data transformation workflows

  • Excel pivot tables

Course Outline

Module 1. Basic concepts of Data

  • Data vs. Information
  • Big Data Buzz
  • V’s of Data
  • How to make Big Data actionable?

Module 2. Concepts of Data Analytics

  • Basics of Data Analytics
  • Types of Data Analytics
  • Why Data Analytics
  • Data Analytics and Business Users (Self-Service BI)
  • Descriptive and Predictive Data Analytics with Excel

Module 3. Start the Data Analytics Process

  • Choosing Data Analytics Platform
  • Accessing Data
  • Importing Data
  • Cleaning and Transforming Data
  • Presenting Results of Data Analytics – Reports and Dashboards

Module 4: Use Pivot Table and Power BI Desktop

  • Table and Pivot Tables
  • Filter Data with Slicers
  • Introduction to Power BI Desktop

Module 5: Create the Data Visualizations

  • Let the visualisation Do the Talking
  • Explore Data visualisation with Cards, Tiles, Maps
  • Export Report

Target Audience and Pre-requisites

Designed for anyone with  no prior knowledge of Data Analytics and looking to acquire foundational skills to understand data better.

Pre-requisites

Participants must have a basic working knowledge of Microsoft Excel.

*Important Note : Fees are subject to Singapore's prevailing Goods and Services Tax (GST).
Complete Data Analytics For Beginners
Fees Enquire Now

Have Question?

We’re here to help — reach out anytime.

By submitting this form, you consent to be contacted via email and/or your mobile number regarding your enquiry. You consent to the collection, use, disclosure and processing of your personal data in accordance with our Personal Data Policy.