πŸ§‘β€πŸ« Week 09 Lecture

Designing a Good Database Schema & Best Practices for Data Visualisation

Author

Dr Jon Cardoso-Silva

Published

25 November 2024

Image created with the AI embedded in MS Designer using the prompt 'abstract salmon pink light blue icon depicting the metaphysical experience of cleaning up, reshaping, pivoting, and manipulating data in search of the purest insights in data science.'

⚠️ Our response rate is dangerously red:

Only 36% of you have completed the LSE Course Survey 😒

Could you take 5 minutes to fill it in?
I promised not to talk about it anymore if we reach 60%!

36%

0-50%

50-75%

75-100%

πŸ“ƒ Schedule

πŸ“Location: Thursday 28 November 2024, 4 pm - 6 pm at CLM.5.02

The title of this week’s lecture is Designing a Good Database Schema & Best Practices for Data Visualisation. However, as I know most of you would appreciate having more dedicated time to work on the ✍️ W10 Summative, I will approach this topic in a very practical and targeted way.

πŸ“‹ Preparation

  • Try to collect some JSON files from the Spotify API and save them to a folder before the lecture. This will make us most productive during the session.

  • Don’t worry too much about the database. If you’re not there yet, we will work on it together during the lecture.

Whatever we produce during the lecture will later be made available on the GitHub logo lse-ds105/ds105a-2024 repository.