dimension-tables
There are 15 repositories under dimension-tables topic.
prachi-mate/Supermarket-Data-Analysis
This is a business intelligence project on analyzing super market data. Check out the README file for more details.
osin-vladimir/udacity-data-engineer
Projects from Udacity Data Engineer Nanodegree
richardgourley/data-analysis-report-with-sql
A simplified introdocutory data analysis report to show how using SQL queries can answer questions from a data warehouse with a star schema. The report answers why server downtime happens and how it can be fixed.
SimplifyData/Cloud-Data-Warehouse-with-Redshift-AWS
Cloud Data Warehouse of Sparkify Data using Redshift
techmitchh/POSTGRES_DATAMODELING
In this project, I'll apply what I've learned on data modeling with Postgres and build an ETL pipeline using Python. To complete the project, I will define the fact and dimension tables for a star schema for a particular analytic focus, and write an ETL pipeline that transfers data from files in two local directories into these tables in Postgres using Python and SQL.
vaxdata22/Water-Quality-DW-on-SQL-Server
This is an MSSQL Data Warehouse and ETL implementation on specially formatted Water Quality dataset from DEFRA, UK
Yan-Luo-AU/SnowFlake_Data_Warehouse_Project_ETL_Process
Star Schema design and Data Ingestion
iOS00/Databricks_on_Azure
Contains script in Python for Data Pipeline solution on Azure Databricks
MezbanS/Worldwide-Restaurant-Analysis-for-Zomato
Analyzed Zomato's restaurant data to reveal global insights, highlighting continent-wise restaurant counts, average costs, and ratings. Also, identified country-level cuisine counts to enhance Zomato's data-driven decision-making.
mlight9/DataModelingwithPostgreSQL
Using ETL process to Extract, Transform, and Load local data into a PostgreSQL database
MrBenA/Data_Warehouse-Amazon_Redshift
Udacity Data Engineering project: Data Warehouse
sharmasapna/Pubmed_datawarehousing
Data Warehouse creation using MySQL and R
vaxdata22/Water-Quality-DW-on-Oracle-Database
This is an Oracle DB Data Warehouse and ETL implementation on specially formatted Water Quality dataset from DEFRA, UK
LaggAt/DimensionTabler
Builds dimension tables with configurable/variable granularity. Keeps those tables up-to-date. This makes reporting queries performant and doable. I use it with https://grafana.com/