Performed data pre-processing, optimized data warehousing, applied statistics and machine learning, and used Power BI for insightful visualizations to support informed decisions

Este é um estudo sobre a criação de um Data Warehouse para uma empresa de e-commerce, focado na análise e gestão do estoque dos centros de distribuição.

Building an ETL pipeline for a database hosted on Redshift. Extracting data from S3 to staging tables on Redshift . Transforming data by executing SQL statements that create the analytics tables from these staging tables by start schema. Loading star schema tables to Redshift

DVD rental schemas and data warehouses tutorial

Udacity Data Engeneering Nanodegree Program - My submission of Project: Data Modeling with Postgres

Analyzed the dvdrental data along with converting it into star schema.

Developed a sales dashboard for AtliQ Hardware, showcasing key metrics like Revenue and Sales Quantity. Enables quick assessment of performance and addressing declining sales with filters by YEAR and MONTH. Detailed SQL commands and DAX queries provided for reference.

Integrated Data Warehouse Solution for Airbnb Analytics: ETL Automation, SQL SERVER: Data Warehouse Modelling, OLAP Cube, and PowerBI Reporting