Skip to content

Project Setup

Database Setup in SQL Server

A database is created in SQL Server to store the data warehouse and data marts. This involves:

  • Setting up the SQL Server instance.

  • Creating schemas for data marts.

  • Implementing tables based on the dimensional model.

  • Establishing indexes and constraints for optimization.

Setting Up DBT Development Environment

DBT is used to manage transformations and ensure data quality. The setup process includes:

  • Installing DBT and configuring it to work with SQL Server.

  • Defining a DBT project structure.

  • Connecting DBT to the SQL Server database.

  • Version-controlling the project using GitHub.