Introduction to data driven decision making

Data-Driven Decision Making in SQL

Irene Ortner

Data Scientist at Applied Statistics

Aim of this course

  • A short review of SQL know-how
  • Apply your SQL know-how to extract business insights from data
  • Learn about new SQL statements to summarize data
    • OLAP extensions were developed specifically for business intelligence
    • Examples are CUBE, ROLLUP and GROUPING SETS
Data-Driven Decision Making in SQL

MovieNow: an online movie rental company

  • Platform to stream movies
  • Additional information for each movie: genre, main actors, etc.
  • Customer information
  • Customers can give a rating after watching a movie
Data-Driven Decision Making in SQL

MovieNow data structure

Data-Driven Decision Making in SQL

MovieNow data structure

Data-Driven Decision Making in SQL

MovieNow data structure

Data-Driven Decision Making in SQL

MovieNow data structure

Data-Driven Decision Making in SQL

MovieNow data structure

Data-Driven Decision Making in SQL

Objectives of data driven decision making

  • Information for operational decisions

    • Popularity of actors to decide which movies to invest in.
    • Revenue of the last months to estimate budget for short term investments.

  • Information for strategic decisions

    • Success across countries to decide on market extensions.
    • Longterm development of revenue for long term investments.
Data-Driven Decision Making in SQL

KPIs: Key Performance Indicators

Extract information from the data which is relevant to measure the success of MovieNow.

  • Total number of rentals: revenue
  • The average rating of all movies: customer satisfaction
  • Number of active customers: customer engagement
Data-Driven Decision Making in SQL

Let's get started!

Data-Driven Decision Making in SQL

Preparing Video For Download...