dimensional-modeling
There are 35 repositories under dimensional-modeling topic.
desaikun1996/New-York-City-Arrests-Data-Modelling-Analysis-and-Visualization
Analysis of New York State Police Department Arrests dataset. Created Dimensional Model for the provided dataset. Using Alteryx and Talend, built ETL pipelines to process, clean the data and create dimensions and facts in the destination database. Further, visualized the necessary details of the database using Tableau and PowerBI.
mahmoudparsian/data-warehousing
This repository is a place for the Data Warehousing course at the Information Systems & Analytics department, Santa Clara University.
rtimbro185/syr_mads_ist722_data_warehouse
Syracuse University, Masters of Applied Data Science - IST 722 Data Warehouse
armanawn/ssc-workshop-databases-2022
2022 SCC Data Science & Analytics Workshop on Databases
nickdgas/SnP500-Analysis
Designed a multi-dimensional data model using LucidChart. Developed ELT pipeline using Python/Pandas. S&P 500 data obtained via yfinance, an open-source library. Output normalized data to excel. Performed analysis and generated reports with Power BI.
SaadAhmedWaqar/Data-Warehousing-Redshift
A Data Warehousing project for retail sales using dimension modelling best practices with SCD type 2 on AWS Redshift. Utilizing AWS Lambda, Glue Workflows and Python Shell jobs to create and automate an ELT pipeline where batch data coming into S3 is loaded onto Redshift and necessary transformations are performed to meet requirements.
ali-bin-kashif/etl-pipeline-project-cola-next
Developed a robust ETL pipeline for Next Cola Pvt. Ltd data which extracts data from many different OLTP sources, converts them into dimensions and facts and load into datawarehouse for analytical workload.
BrksGuiOrnelas/data_modelling_dw
Criação de um Data Warehouse (DW) utilizando modelagem dimensional em um esquema estrela.
desaikun1996/Boston-Food-Inspection-Data-Analysis
An examination of a dataset collecting data from food inspections conducted at several Boston restaurants.
doshiharmish/Driving-Customer-Insights-Post-Merger
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.
eddahbarasa/AdvancedDataModeling
Starts with a conceptual model ends with a Tableau interactive dash board. In between there is building ER diagrams, forward engineering to build normalized databases, dimensional data modelling and visualizations in tableau.
lauranonato/Data-Warehousing
creating a data warehouse for a football game management company and some SQL queries to analyse data.
MEDHAT-ALHADDAD/Pizza_Runner
Case Study SQL Reporting
nshcode/dimensional-data-modeling
Dimensional Data Design
abdulrahmankhayal/AdventureWorksDM
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.
AmmarSahyoun/Traders
Modern data warehouse extracted from a web-application database 'Northwind'.
andyvroberts/banana
Dimensional modelling using SQL Server and SSAS cube (tabular) creation
cadmiumkitty/data-quality-analytics
Data quality analytics prototype linking faceted classification with dimensional data visualisation.
dennis-barrett/dimdates-dot-com
Source code for the Kimball-style date dimension generator dimdates.com.
eddahbarasa/FinalProjectAdvancedDataModelling
Creating erd using MySQL Workbench, Forward engineering, Dimensional data model, Tableau visualisation
hase3b/End-to-End-DWH-Pipeline
This repository contains the end-to-end pipeline for building a data warehouse for a real estate management company. The pipeline includes data generation, ETL process, creation of star schema dimensions and fact table, visualization using Power BI, and automation with Pabbly Connect.
maxhardt/aws-redshift-elt
ELT and Dimensional Modeling on AWS Redshift
maxhardt/data-modeling-with-postgres
ETL and Dimensional Modeling with PostgreSQL
mereshd/COVID-database
A comprehensive dimensional model for COVID data, enabling insights for future vaccination campaigns through robust visual analytics.
ovokpus/analytics-engineering-prototype
Analytics Engineering with dbt on Bigquery. This project implements the use of Analytics Engineering Best practices to build a dimensional data model, using dbt (data build tool) and BigQuery.
Rconybea/xo-unit
compile-time dimension conversion and checking + support fractional dimension
sarutlaa/Instacart-Market-Basket-Analysis
Building Dimensional Model and SQL Analysis in SnowflakeDB
srushtii-m/ETL-Analytics
Data Engineering on GCP and Mage AI
vioxcd/coursera-dwh-for-bi-capstone
Coursera DWH for BI Capstone (Implementation)
desaikun1996/Dallas-Food-Inspection-Data-Analysis
Analysis of a dataset containing information collected on food inspection done at various restaurants in Dallas.
Rconybea/xo-pyunit
python bindings for xo-unit
sanketsanap5/University-Student-Enrollment-DW
Design and develop a dimensional data model for University Student Degree Program Enrollment and Performance using data modeling tool Dataedo
sskender/business-intelligence
Business Intelligence FER labs