Data Wrangling, Analysis and Visualisation

Enquiry
Programme CodeD34
Domain
Data Engineering
Artificial Intelligence
Applications Management
Level
Foundation
Learning Partner(s)
Singapore Polytechnic
Duration
3 Days
FormatIn-person
Rating
Job Roles
ICT&SS Professional

Overview

Acquire critical data wrangling, analysis, and visualisation skills essential to overcome the challenges in a variety of modern-day data-driven businesses. In today's era of big data where the computer and network are everywhere and business process may be translated to data, data manipulation and visualisation skills are much needed to make insightful decisions. Knowledge in data analysis and visualisation provides one with the necessary skills that form the basis for deeper quantitative reasoning needed for data and predictive analytics work. Data may be in abundance; however, making it comprehensible and meaningful to stakeholders require a data driven skillsets.

This programme enables the skills to turn raw datasets into interactive and dynamic visualisations and dashboards providing the platform to draw insights for decision making. This programme aims to equip you with the skills to clean data, perform simple analysis and create useful and interactive visualisations and dashboards for presentation and recommendations to stakeholders. You will learn how to achieve this using Excel and Tableau software.

Key Takeaways

At the end of this programme, you will be able to:

  • Prepare, clean, format and manage data using Excel for analysis
  • Summarise and represent data meaningfully using Excel for further analysis and decision-making
  • Prepare and manipulate data for visualisation using Tableau
  • Visualise data using Tableau basics
  • Apply advanced visualisation using charting capabilities in Tableau
  • Build Interactive Dashboards using Tableau

Who Should Attend

Please refer to the job roles section.

Prerequisites

Basic communication skills in the English language. Experience in working with data would be an advantage.

Testimonials

Learning how to use Tableau for visualisation purposes, as well as basic Excel functions such as vlookup, were most useful as I need them in my current area of work.

It was particularly useful learning about the different Excel shortcuts and applications as they are very useful for filtering data. Tableau is also very effective in creating aesthetically pleasing charts and interactive charts that allow for easy viewing.

It was beneficial to learn how to present better to stakeholders using data and analytics. The shared recordings were particularly important for me.