Analyze Data to Answer Questions

In solving a business problem, analysis process is done by organizing the data after generating and cleaning step. Technical activities in data analysis include formatting and aggregating data to do calculation at the end of the analyzing process.

DATA ORGANIZATION

Sorting and filtering are two common examples of data organization. Sorting is arrangement of data to make it easier to understand and visualize. While filtering is a process of displaying data that we want to see and hiding the rest.

After being sorted and filtered, the next part of analysis are converting and formatting the data. As an analyst, we often face many scenarios that require us to convert data in spreadsheet. Among the conversion requirement and the resources that we can do (in Excel and Google Sheet) are:

String to date. How to convert text to date in Excel & Google Sheets: change date format

String to numbers. How to convert text to number in Excel & how to convert to numbers in Google Sheets

Combining columns. Convert text from two or more cells & how to split or combine cells in Google Sheets

Number to percentage. Format numbers as percentages & TO_PERCENT