Blog

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.

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

https://youtu.be/iKK3P11OCyM

Here are some of my favorite horror stories how things went wrong due to bad data:

https://www.simscale.com/blog/2017/12/nasa-mars-climate-orbiter-metric/

There are several ‘how to’ articles on how to tell a story with data, just google ‘telling stories with data’:

https://www.google.com/search?q=telling+stories+with+data

They all tell pretty much the same story, so you can choose the one that works for you.

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