Maven Toys Data Analytics using dbt
This data analysis project gives details on the Sales & Inventory data for a fictitious chain of toy stores in Mexico called Maven Toys.
Using dbt, data was transformed and cleaned in order to make it usable for analysis.
Dashboard created using Power BI:
Create a directory from the command line
mkdir [name-of-directory]
cd [name-of-directory]
Create virtual environment
Activate virtual environment
source venv/Scripts/activate
git clone https://github.com/AviatorIfeanyi/maven_toys_dbt_postgres.git
cd maven_toys_dbt_postgres
Set database requirements using credentials in profiles.example.yml
dbt docs generate
dbt docs serve