Performed data pre-processing, optimized data warehousing, applied statistics and machine learning, and used Power BI for insightful visualizations to support informed decisions
Modeling a database using the Star Schema, applied to the context of "CFB Pharmacy", which seeks to develop decision support systems for revenue analysis. The project was carried out in two stages: (A1) involved the creation of the relational and conceptual model; (A2) focused on the implementation of the dimensional model and Data Warehouse (DW).
A complete end-to-end customer segmentation case study using RFM analysis, from raw data cleaning and star-schema design to Python automation and interactive Tableau dashboards.
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
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
Udacity Data Engeneering Nanodegree Program - My submission of Project: Data Modeling with Postgres
Analyzed the dvdrental data along with converting it into star schema.
Add a description, image, and links to the star-schema-tables topic page so that developers can more easily learn about it.
To associate your repository with the star-schema-tables topic, visit your repo's landing page and select "manage topics."