13 results for “topic:star-schema-tables”
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.
Interactive Power BI dashboard analyzing Spotify user listening behavior using 28K+ records. Includes star schema data modeling, DAX measures, and insights on popularity trends, top artists, and seasonal engagement.
Designed and implemented an end-to-end ETL pipeline using PostgreSQL, transforming raw transactional data into a normalized OLTP schema (3NF) and analytical OLAP star schema. Generated business insights through complex SQL queries and ensured data integrity through validation checks.
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
No description provided.
Integrated Data Warehouse Solution for Airbnb Analytics: ETL Automation, SQL SERVER: Data Warehouse Modelling, OLAP Cube, and PowerBI Reporting
End-to-end Healthcare Data analytics project analyzing 3.15 GB of CMS claims data using Alteryx, SQL Server, and Power BI.
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.
Data Warehouses and Business Intelligence Course Project @ FMI, Sofia University.
Udacity Data Engeneering Nanodegree Program - My submission of Project: Data Modeling with Postgres
Analyzed the dvdrental data along with converting it into star schema.