Syracuse University, Masters of Applied Data Science - IST 722 Data Warehouse
Project involves merging customer reviews from Fudgemart and FudgeFlix to create a unified data warehouse using Kimball's approach. Utilizing Power BI, it aims to extract actionable insights for Fudge Inc., guiding strategic decisions, product enhancements, and market expansion based on comprehensive business intelligence.
SQL Data Warehouse project covering dimensional modeling, KPI calculation, data exploration, aggregation, and ranking analysis using Microsoft SQL Server for business analytics.
End-to-end SQL data warehousing project using Bronze-Silver-Gold architecture with ETL pipelines, dimensional modeling, and real-world CRM & ERP datasets in Microsoft SQL Server.
dimensional modeling of AdventureWorks2017 for sales, creating a DataMart. It includes an ETL pipeline that loads the data from AdventureWorks2017 to AdventureWorksDM using SQL Server Integration Services (SSIS) and implements Slowly Changing Dimension (SCD) handling using the SCD wizard and Merge statement.
End-to-end SQL Data Warehouse using a multi-layered architecture (Bronze, Silver, Gold) with automated ETL and star schema design for scalable analytics.
Proyecto de modelado de datos enfocado a la gestión de proyectos
SQL analytics on SQL Server over a Medallion DW (Bronze/Silver/Gold). Seven T-SQL scripts for change-over-time, cumulative trends, performance, segmentation, part-to-whole, and customer/product reports. Includes vendored DW (deps/data-warehouse @ v1.0.1).
SQL Server Medallion data warehouse (Bronze/Silver/Gold) with T-SQL pipelines, CSV sources, quality checks, and star-schema views.
Business Intelligence FER labs
This project showcases how i helped VelociMart shift from Excel-based reporting to a robust data infrastructure using SQL Server and Tableau. Built around Sales, Customers, and Products Data Marts, it follows the Medallion Architecture (Bronze → Silver → Gold) to deliver clean, analysis-ready views for effective business insights.
Add a description, image, and links to the dimensional-modeling topic page so that developers can more easily learn about it.
To associate your repository with the dimensional-modeling topic, visit your repo's landing page and select "manage topics."