Skip to content
Spring semester - BA - IBM - Year 1 Calendar view

Introduction to Data Visualization


Class
Christian Olsen
Enrolment for this class is currently closed.

Understanding and interpreting large volumes of data is a challenging task for any person, independently of their background and expertise. In this sense, the human brain has been proved to work better with visual representations than with raw data itself.
The Introduction to Data Visualization module is designed to develop your skills in basic computer and data organisation, as well as to provide knowledge and techniques for summarising, highlighting and visualising information that is reported.

The module covers topics such as basic formatting style, knowing what types of graphs to pick depending on data and data visualisation using the basic tool.

The aim of this module is to familiarise you with data visualisation techniques. Being able to summarise, visualise and present clear reports of any task will provide and added value to your future professional career. In this module, you will use spreadsheets to learn how to apply basic formatting style, summarise data, highlight important information and finally create different types of graphs. A working knowledge of Google Sheets is vital for most professionals today, and stronger spreadsheets skills can open the door to promotion and leadership opportunities.

The module is composed mainly of seminars and will run throughout the semester (14 weeks).

 

Download Syllabus here:

YEAR 1 Students

/files/107980/MSG_DataVizualisation_2021-22_BA_MIUC.docx.pdf

 

Download Syllabus here:

YEAR 4 Students

/files/107980/MSG_DataVizualisation_2021-22_MA_MIUC.docx.pdf

 

 

 

Here is the class outline:

1. Join the class online

Here is the link for joining the class online

Join the class online

2. Week 1 - Introduction to Data Visualization

Week description
Week 1 - Lesson 2
VIDEO RECORDING WEEK 1

3. Week 2 - What is Data Visualization?

The Good, The Bad, and The Ugly
Techniques to Make Your Charts More Engaging
Quick Reference file
Vídeo recording of tuesdays lesson
VIDEO RECORDING THURSDAY LESSON

4. Week 3 - Customizing Charts in Google Sheets

Customizing Charts in Google Sheets
Introduction to Google Sheets
Your first Graph / Chart
DONT PANIC - HANS ROSLING VIDEO
VIDEO RECORDING THURSDAY LESSON
VIDEO RECORDING TUESDAY LESSON

5. Week 4 - Customizing Charts in Google Sheets

Customizing Charts in Google Sheets
A1 - Multiple Questionnaire - Chart Customisation
VIDEO RECORDING TUESDAY LESSON
VIDEO RECORDING THURSDAY LESSON

6. Week 5 -Storytelling with data?

Storytelling with Data?
VIDEO RECORDING TUESDAY LESSON
VIDEO RECORDING THURSDAY LESSON

7. Week 6 - Storytelling with Data?

Week description
A2 - Multiple Questionnaire - What Graph?
VIDEO RECORDING TUESDAY LESSON
VIDEO RECORDING THURSDAY LESSON

8. Week 7 - Bar & Column Charts

Bar & Column Charts
Files for Tuesdays Lesson
Bar & Column Charts / Challenge
VIDEO RECORDING TUESDAY LESSON
VIDEO RECORDING THURSDAY LESSON

9. Week 8 - Histograms

Histograms
Week 8 - Histogram Challenge
VIDEO RECORDING TUESDAY LESSON

10. Week 9 - Line Charts & Trendlines

Line Charts & Trendlines
Files for Tuesdays Lesson - Trendline
Files for Thursdays Lessons / Challenge

11. Week 10 - Area Charts

Area Charts
Area Charts Tutorial Files
Area Chart Challenge
A3 - In-class exercise 3: Case Study to Visualize Data and Summarize Results

12. Week 11 - Pies Charts

Pie Charts
Pie chart / donut - Challenge
Thursday Challenge

13. Week 12 - Scatter Plots & Bubble Charts

Scatterplots & Bubble Charts
Exercise files
Scatterplots/Bubblecharts Challenge

14. Week 13 - Tree Maps

Tree Maps Exercise
Treemap Excel file

15. Week 14 - Combo Charts

– Combo Charts
Combo Chart Challenge - Tuesday