Topic: "dimension-tables"
notonthehighstreet/chicago 📦
Language: Ruby - Size: 531 KB - Last synced at: 16 days ago - Pushed at: almost 7 years ago - Stars: 4 - Forks: 1
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.
Language: TSQL - Size: 39.1 KB - Last synced at: over 1 year ago - Pushed at: about 3 years ago - Stars: 2 - Forks: 0
vaxdata22/Water-Quality-DW-on-SQL-Server
This is an MSSQL Data Warehouse and manual ETL demo on a specially formatted Water Quality dataset from DEFRA, UK. It is a personal academic-grade exercise to explore the basic concepts of data warehousing and manual ETL process from an academic perspective.
Language: Jupyter Notebook - Size: 394 KB - Last synced at: 2 months ago - Pushed at: 2 months ago - Stars: 1 - Forks: 1
osin-vladimir/udacity-data-engineer
Projects from Udacity Data Engineer Nanodegree
Language: Jupyter Notebook - Size: 2.92 MB - Last synced at: about 2 years ago - Pushed at: over 4 years ago - Stars: 1 - Forks: 1
SimplifyData/Cloud-Data-Warehouse-with-Redshift-AWS
Cloud Data Warehouse of Sparkify Data using Redshift
Language: Python - Size: 1.2 MB - Last synced at: 2 months ago - Pushed at: almost 5 years ago - Stars: 1 - Forks: 1
samuel-wahinya/VelociMart-Business-Intelligence-Report
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.
Language: TSQL - Size: 2.22 MB - Last synced at: 26 days ago - Pushed at: about 1 month ago - Stars: 0 - Forks: 0
vaxdata22/Water-Quality-DW-on-Oracle-Database
This is an Oracle DB Data Warehouse and manual ETL demo on a specially formatted Water Quality dataset from DEFRA, UK. It is a personal academic-grade exercise to explore the basic concepts of data warehousing and manual ETL process from an academic perspective.
Language: Jupyter Notebook - Size: 380 KB - Last synced at: 2 months ago - Pushed at: 2 months ago - Stars: 0 - Forks: 0
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/
Language: Python - Size: 77.1 KB - Last synced at: 4 days ago - Pushed at: 4 months ago - Stars: 0 - Forks: 0
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.
Size: 0 Bytes - Last synced at: over 1 year ago - Pushed at: over 1 year ago - Stars: 0 - Forks: 0
sharmasapna/Pubmed_datawarehousing
Data Warehouse creation using MySQL and R
Size: 909 KB - Last synced at: over 1 year ago - Pushed at: over 3 years ago - Stars: 0 - Forks: 0
