Data Analytics

How many steps involved in data analysis process?

• 5 Steps

• 4 Steps

• 6 Steps

• 7 Steps

What step do the data analyst spend most of their time during data analysis process?

• Step 1: Define the question

• Step 2: Collect the data

• Step 3: Clean the data

• Step 4: Analyze the data

Listed are types big data analytics EXCEPT

• Abstractive Analytics

• Descriptive Analytics

• Prescriptive Analytics

• Predictive Analytics

Listed are functions for cleaning data in Excel EXCEPT

• Concatenate

• Trim

• Replace

• Remove

What are the characteristics of Big Data?

• High Volume Low Variety

• High Veracity High Value

• Low Value Low Authenticity

• High Authenticity Low Veracity

What is the function in Excel to counts the number of cells that are not empty in a range?

• Count

• CountA

• CountBlank

• CountIf

Function SumIF() is to sum the values in a range that meet criteria.

• True

• False

Which of the followings is unstructured data?

• Excel Spreadsheet

• CSV file format

• Web API file

• YouTube Video

Embrace Failures is one of the step in data analytics process.

• True

• False

Usage data is one of data collection tools

• True

• False