Introduction to data driven decision making

Decision making basato sui dati 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
Decision making basato sui dati 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
Decision making basato sui dati in SQL

MovieNow data structure

Decision making basato sui dati in SQL

MovieNow data structure

Decision making basato sui dati in SQL

MovieNow data structure

Decision making basato sui dati in SQL

MovieNow data structure

Decision making basato sui dati in SQL

MovieNow data structure

Decision making basato sui dati 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.
Decision making basato sui dati 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
Decision making basato sui dati in SQL

Let's get started!

Decision making basato sui dati in SQL

Preparing Video For Download...