Upgrade Yourself With These On-Demand Softwares - Part 1

In this article, we will provide you with a list of softwares that is extremely relevant in today’s society. Take charge of your learning, and help unleash a better version of yourself now!

Singapore’s plug and play business environment serves as a great environment for many businesses to nourish, grow and thrive. With these increasing technological advancements, there has been a greater need to upgrade, and upskill ourselves. In part 1 of this 4-part upskilling series, we will list out 2 commonly used softwares for data analysis.

What is data analysis?

Data analysis refers to using tools to process a set of data and interpret important insights. This is important for the decision-making process of organisations. Below are some softwares that you can use for data analysis.

1. Python

Python is a widely used programming and computer language. Like many of the languages of the world, communication languages are just a means of communication. Computer languages are how humans can communicate with computers, as well as other programmers.

Advantages of using Python:

• It has English-like syntax. This makes it easier to read and write, as compared to other programming languages.

• Python directly executes the code line-by-line. This makes debugging easier.

• There is a standard library of functions available in Python. This can include data visualization etc.

Example of how a code might look like on Python:

What can you interpret from this code?

1. Microsoft Excel

Microsoft Office softwares is a familiar tool that many of us grow up with. However, many of us neglect/ are unaware that it is a powerful data analysis tool.

Faced with a large dataset like this?

Excel would be an extremely useful method to help you clean your dataset, making this data easier to interpret. From categorising similar information together to counting the number of items in a certain category, excel would be the right tool for you!

Benefits of using Microsoft Excel:

• Store data easily

• Allow for easy calculation, and visualisation of data

• Can code to automate (runs on VBA Macro programming)

Example of a chart that can be derived from Excel:

Be digitally ready now! What do you think of the tools that we have suggested? Leave your comments below!

Written by: Tan Hui Ling

Edited by: Jamie Tan