Blog

There are numerous online resources explaining the idea of confidence intervals. Here a short video without too many statistical nuances.

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

Look at how to use and not to use pie charts:

https://www.martinraffeiner.blog/using-data-visualizations-bad-guy-pie-charts/

An old but still relevant TED talk by Eli Pariser on how the web is being inconspicuously personalized for individual tastes creating bubbles of like-minded people.

https://www.ted.com/talks/eli_pariser_beware_online_filter_bubbles?utm_source=tedcomshare&utm_medium=social&utm_campaign=tedspread

…and its critique:

https://slate.com/news-and-politics/2011/06/eli-pariser-s-the-filter-bubble-is-web-personalization-turning-us-into-solipsistic-twits.html

…and a more recent take on the topic:

https://www.theverge.com/interface/2019/11/12/20959479/eli-pariser-civic-signals-filter-bubble-q-a

A short summary of important data science concepts we discuss during the course in Aleksi Aaltonen’s blog:

https://aleksiaaltonen.medium.com/a-simple-vocabulary-of-data-science-concepts-dc29c633f5ee

It’s just 2 min read and gives you an overview of many important concepts we will discuss during the semester.

Here are some brilliant examples of correlations that surely do not indicate causation!

https://www.tylervigen.com/spurious-correlations