The following video provides a great introduction to doing pivot tables in Excel:
Blog
Great Tutorial on Excel Pivot Table Feature
The following video provides a great introduction to doing pivot tables in Excel:
Key Performance Indicator
Wikipedia has fairly good articles on KPIs and the SMART criteria.
MapReduce and Hadoop Technology
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.
What is a Relational Database?
This video demonstrates differences between a relational database and an Excel spreadsheet for storing data:
How Bad Data Ruins Your Day
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/
Infographics
Differences between infographics and data visualizations are discussed in these two posts:
https://www.statsilk.com/blog/real-difference-between-infographics-and-data-visualizations
https://killervisualstrategies.com/blog/difference-between-infographics-data-visualization.html
We use Piktochart to create an infographic on MIS0855, but there a numerous other web-based tools available:
Telling Stories with Data
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.
Bad Pies
Look at how to use and not to use pie charts:
https://www.martinraffeiner.blog/using-data-visualizations-bad-guy-pie-charts/
Beware Online Filter Bubbles
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.
…and its critique:
…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