/Xcompany_case-study_sql

Xcompany - Confirmed Data Engineer Case Study

This repository contains my submition to Xcompany's case study, as part of the hiring process for a Data Engineering position.

The goal is to design and document a part of Xcompany's analytics database.

Table of Contents

Model

  • model/model.mwb : MySQL Workbench file containing the OLTP and OLAP models
  • model/OLTP.png : image of the Transactional model
  • model/OLTP.png : image of the Analytics (star-schema) model

Documentation

  • documentation/DataModel.{md,html,pdf} : description of the OLAP model
    • tables description
      • fields description (type, nullable or not, example value)
    • example SQL queries