Real-world use case: streaming music service

Streaming Concepts

Mike Metzger

Data Engineer

Streaming music

  • Consider the scenario
  • Not focusing on the actual music being streamed
  • More interested on the user(s)
    • Interactions
    • Music preferences
    • Other details
Streaming Concepts

Interactions

Primary questions

  • What?
  • When?
  • Where?
  • Like / Don't play
  • Next / Previous / Skip
  • Select Channel / Playlist
  • Add / remove song from playlist
Streaming Concepts

How to store data

  • Data is archived as a log
  • Sent as interactions occur
  • Number of interactions will vary considerably between users
  • Logged data can be analyzed later on
Streaming Concepts

Analytics

  • What about preferences?
    • Can be obtained from logged data
    • Favorite genres, bands, etc
    • Most popular times of day
  • Other details?
    • Most popular app platform / version
    • Location data from stream
Streaming Concepts

Let's practice!

Streaming Concepts

Preparing Video For Download...