Data Science

The following video provides a great introduction to doing pivot tables in Excel:

https://youtu.be/UsdedFoTA68

Here is a short clip explaining how relative cell references differ from absolute cell references in Excel.

Here is also a link to my Excel demo spreadsheet.

 

Wikipedia has fairly good articles on KPIs (https://en.wikipedia.org/wiki/Performance_indicator) and the SMART criteria (https://en.wikipedia.org/wiki/SMART_criteria).

Here is a simple introduction to the concepts behind MapReduce and Hadoop Big Data technologies.

Note that the products themselves are less interesting than the idea of how we can process huge amounts of data effectively.

This video demonstrates differences between a relational database and an Excel spreadsheet for storing data:

https://youtu.be/iKK3P11OCyM