Data Wrangling, Analysis and Visualisation

by Singapore Polytechnic Claim Listing

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.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Singapore Polytechnic Logo

img Duration

3 Days

Course Details

Data Wrangling, Analysis and Visualisation are critical skills that are necessary in the handling 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 provide one with the necessary skills that form the basis for deeper quantitative reasoning needed for data and predictive analytics work.

 

Course Objective

Data may be in abundance, however making it comprehensible and meaningful to stakeholders requires data driven skillsets. This course enables participants to pick up skills to turn raw datasets into interactive and dynamic visualisations and dashboards to provide the platform to draw insights for decision-making.

 

Course Outline

This course aims to equip participants with the skills to clean data, perform simple analysis and create useful and interactive visualizations and dashboards for presentation and recommendations to stakeholders. Participants will learn how to achieve this using Excel and Tableau software.

By the end of the course, participants 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

Topics to be covered

Part 1 Collecting and Managing Business Data

  • Getting external data from various sources (CSV files, text files, database files, web data, etc.).

  • Preparing and cleaning data using text manipulation (trimming spaces, extracting parts of the cell to create a new column, replacing values etc.)

  • Extracting data with Essential Formulae/Functions.

  • Formatting and conditional formatting.

  • Tapping into real data from Internet for business analysis.

  • Data format required for analysis

Part 2: Understanding your Data

Data Calculations and Management

  • Using functions and formulae for calculations and data preparations.

  • Exploring data using AutoFilter and Excel tables.

  • Summarising and analysing worksheet data using PivotTables

  • Visualising summary report using PivotCharts

Decision making using What-If Analysis

  • Using Goal Seek to find desired output.

  • Building Data Tables for sensitivity analysis.

  • Using Scenario Manager for reporting different scenarios.

Part 3: Prep your Data with Tableau Prep

Tableau Prep Introduction

  • Tableau Prep Interface and Options

  • Tableau Prep Cleaning Options

  • Reading multiple sheets and files

  • Data aggregation

  • Workflow and joining files

  • Pivot data with Tableau Prep

Part 4: Visualising your Data

Tableau Basics

  • Visual Analytics Principles

  • Intro to Tableau software

  • Basic data import

  • Basic chartsBasic sorting

  • Basic filtering and paging

  • Using ShowMe

  • Basic Dashboarding

  • Tableau Story Design

Advanced Tableau Charting

  • Geographical maps

  • Histograms, scatter plots, box plots

  • Calculated fields

  • Clustering using Tableau

  • Sharing charts and dashboards

Interactive Dashboarding

  • Action filters

  • KPIs and Parameter controls

  • Groups and Sets

 

Minimum Requirements

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

 

Certification / Accreditation

Certificate of Attendance (electronic Certificate will be issued)

  • A Certificate of Attendance will be awarded to participants who meet at least 75% attendance rate

Certificate of Completion (electronic Certificate will be issued)

  • A Certificate of Completion will be awarded to participants who pass the assessment and meet at least 75% attendance rate

 

Suitable for

Data Analyst / Business and Quantitative Analysts

  • Central Branch

    500 Dover Road, Central

Check out more Data Visualization courses in Singapore

Xaltius Academy Logo

Big Data Analytics Using Spark

Data is exploding every single day and the volume is just enormous! We need a way to manage and perform analytics on the data. This workshop shows you how Big data tools and Spark can be leveraged for analytics and machine learning!

by Xaltius Academy [Claim Listing ]
Advanced Learning Singapore Logo

Power BI Desktop Series 1 - Data Model, DAX And Dashboard Visualization

Microsoft Power BI is quickly becoming the world’s most powerful self-service business intelligence (BI) platform, and an absolutely essential tool for data professionals and beginners alike. Microsoft Power BI can help you get more insights from your data on your computer or in the cloud.

by Advanced Learning Singapore [Claim Listing ]
ICDL Foundation Logo

Big Data

This module introduces Big Data, a term which relates to the management and analysis of sets of data that are typically too large for traditional data-processing software.

by ICDL Foundation [Claim Listing ]
Koenig-Solutions Logo

Microsoft Power BI Data Analyst Course

The PL-300T00: Microsoft Power BI Data Analyst certification is a qualification necessary for individuals who analyze and visualize data using Power BI.

by Koenig-Solutions [Claim Listing ]
Impress Training Logo

Data Visualisation With Tableau

Tableau is a powerful and fastest-growing data visualization tool used in the Business Intelligence Industry. It helps in simplifying raw data into a very easily understandable format.

by Impress Training [Claim Listing ]

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy