Skip to main content
Before setting up the SQL Data Warehouse project, ensure you have the following prerequisites in place.

​
Docker Environment

Docker & Docker Compose

This project runs entirely in Docker containers, making it easy to set up and tear down without affecting your local system.
Install Docker Desktop for your operating system:
Docker Compose is included with Docker Desktop. For Linux users, you may need to install it separately:
sudo apt-get install docker-compose-plugin

​
System Requirements

Memory

Minimum 4GB RAM available for Docker

Storage

At least 2GB free disk space

CPU

2+ CPU cores recommended

OS

Windows 10+, macOS 10.15+, or Linux

​
Required Knowledge

1

PostgreSQL Basics

Understanding of PostgreSQL databases, SQL queries, and basic database administration.
Familiarity with concepts like schemas, tables, and views will be helpful.
2

Docker Fundamentals

Basic knowledge of Docker containers and Docker Compose for managing multi-container applications.
3

Data Warehousing Concepts

Understanding of ETL processes, data modeling, and the Medallion Architecture (Bronze, Silver, Gold layers).

​
Dataset Requirements

This project requires CSV datasets from two source systems: ERP and CRM.
The datasets should include:

ERP Data

Enterprise Resource Planning system data containing:
  • Sales transactions
  • Product information
  • Operational data

CRM Data

Customer Relationship Management data containing:
  • Customer information
  • Interaction history
  • Customer demographics
Ensure your CSV files are properly formatted and placed in the datasets/ directory before starting the setup process.

​
Verification Checklist

Before proceeding to installation, verify that you have:
Docker Desktop installed and running
Docker Compose available (check with docker compose version)
Sufficient system resources allocated to Docker
CSV datasets ready in the datasets directory
Basic understanding of PostgreSQL and data warehousing
Once all prerequisites are met, you can proceed to the Installation guide.

Build docs developers (and LLMs) love

Get started for freeTalk to us