Data-Driven
Mathematical Models
Python
Excel
Data Analytics
100

This is considered as the new oil in an organization.

What is data?

100

It is a representation of real world situation using mathematical concepts and language.

What is mathematical model?

100

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

What is Python?
100

Every formula in Excel or spreadsheet starts with this symbol.

What is =?

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 amount from total payment minus interest rate.

What is principal?

200

This is a function used for displaying texts in Python. 

What is print?

200

In Excel, this is a function we use to raise a number to an exponent.

What is power?

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 sales minus the cost of goods sold.

What is gross profit?

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

This is a function in Excel is used to calculate the net present value?

What is NPV?

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

Aside from people and business, these are also one of the biggest generators of data.

What are machines?

400

This is the formula for linear model for demand prediction.

What is D=a-bP?

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 the term use for a group of cells in spreadsheet, usually when you highlight multiple adjacent cells (B1:B5)

What is range?

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 the formula for monthly loan amortization.

What is A = Pr(r+1)t / (r+1)t - 1

500

In python, this is how you show a block of code since there are no curly braces { }. unlike in other languages.

What is indention?

500

This is the formula for getting the number of rows from cells A1 to A10.

What is COUNT(A1:A10)?

500

These are the three types of Data Analytics.

What are Descriptive, Predictive and Prescriptive Analytics?