Data-Driven
Data Cleaning
Python
PostgreSQL
Data Analytics
100

This is considered as the new oil in an organization.

What is data?

100

This is a structured data that is composed of rows and columns.

What is table?

100

Aside from R Programming, this is one of the more popular programming language used for data analytics.

What is Python?
100

This is the meaning of SQL.

What is Structured Query Language?

100

This is the process of analyzing raw data in order to make conclusions about the information. This also has three levels.

What is Data Analytics?
200

This is one of the programs of SM where customers earn points by shopping.

What is SM Advantage Card?

200

This is the meaning of CSV.

What is Comma-Separated Values?

200

This is a function used for displaying texts in Python. This is the first function we used for showing "Hello World".

What is print?

200

BONUS

+ 200 points

200

This level of Analytics answers the question - what had happened which is presented in the form of dashboards and business reporting.

What is Descriptive Analytics?

300

These are facts collected together which is later analyzed to bring value-adding insights. These may be stored in a log book, Excel spreadsheet or computer system.

What is data?

300

This is the function in Python used to read files, specifically the csv files.

What is read_csv?
300

This is a web-based interactive development environment for creating notebooks in Python. This is part also of Anaconda distribution.

What is JupyterLab?

300

LOSE TURN

Sorry!

300

This is a generic term used to call a person who does data cleaning, data analysis, data visualization and other tasks related to data science.

What is Data Scientist?

400

This is the meaning of ETL.

What is Extract Transform Load?

400

This is the function in Python used to assign values on specific location of rows only. 

What is loc?

400

This is a feature in JupyterLab notebook that allows you to include texts as documentation, aside from the actual Python code.

What is markdown?

400

This is SQL command to sort values either by ascending or descending.

What is ORDER BY?

400

This is a software package used in our class where JupyterLab, Python and other tools are included.

What is Anaconda?

500

He or she is responsible for actual cleaning of data, ETL and transformation required by Data Analyst.

Who is Data Engineer?

500

This is an observation in the data that lies in abnormal distance from the other values.

What is outlier?

500

Jupyter stands for Python, R and this other programming language.

What is Julia?

500

This is a SQL command used for deleting table or database

What is DROP?

500

These are the three types of Data Analytics.

What are Descriptive, Predictive and Prescriptive Analytics?