Business Intelligence and Data Warehousing Project

About MovieMonk:
MovieMonk is an online movie booking aggregator platform that allows customers to book movies at theatres across multiple locations. It provides an alternate and more convenient way for a customer to buy movie tickets.

Objective:
Objective is to create a Datawarehouse (OLAP system) which contains integrated data and enable faster analytics.

Data pipeline

Figure: Data Pipeline

Figure: Data Pipeline Architecture

Schemas

Figure: Star Schema (Dimension Data Modelling)

Tableau Analytics - Please refer attached .TWBX File.