Mapping of DWH database tables to business entities, attributes & metrics in Python, with automatic creation of flattened tables
-
Updated
Nov 21, 2023 - Python
#
datawarehousing
Here are 37 public repositories matching this topic...
implementing an end-to-end tweets ETL/Analysis pipeline.
tweets analysis twitter-api multithreading api-client datawarehousing datawarehouse web-crawling ssis google-api-client etl-pipeline tweets-classification cube-analysis powerbi-report ssas-multidimensional multi-dimensional-analysis tweets-scraper
-
Updated
Dec 8, 2022 - Python
Efficient YouTube data harvesting and warehousing with Python, SQL, MongoDB, and Streamlit, enabling seamless analysis and visualization for insightful decision-making in content management and audience engagement strategies
-
Updated
Jan 8, 2024 - Python
Data warehousing date dimension and time dimension builders written in Python.
python database python3 datawarehousing datawarehouse csv-export multidimensional date-dimension time-dimension
-
Updated
Oct 21, 2018 - Python
This project demonstrates the creation of a Data Warehouse using SQL Server 2022. It includes the design of dimension and fact tables, ETL processes for data integration, Python scripts for synthetic data generation, and SQL queries for KPI analysis to support business decision-making.
-
Updated
Dec 25, 2024 - Python
Using dbt to load(seed) and do some transformations and then finally load that data to some Cloud Warehouse
-
Updated
May 3, 2023 - Python
Batch ETL pipeline project on GCP to load and transform daily flight data using Spark to update tables in BigQuery. The pipeline is automated using Airflow.
-
Updated
Dec 31, 2021 - Python
This project goal is to design a Data Platform for retail Data Analytics.
mysql sql spark mongodb dashboard etl nosql bigdata postgresql datawarehousing erd datawarehouse dataplatform dataengineering oltp etl-pipeline cognos-analytics
-
Updated
Apr 10, 2024 - Python
Banking Data Warehouse Pipeline
-
Updated
Jun 12, 2024 - Python
Date dimension based on Iranian calendar
-
Updated
Oct 2, 2017 - Python
Data Modeling with Postgres and Python
-
Updated
Oct 12, 2019 - Python
How to manage SCD2 with Apache Hive 1.1 and HBase 1.2 w/o HiveQL UPDATE operation
-
Updated
Jul 2, 2022 - Python
Check daily covid information
-
Updated
May 3, 2021 - Python
A comprehensive LLM data processing system designed to transform raw multi-format data into high-quality training datasets optimized for Large Language Models.
-
Updated
Aug 22, 2025 - Python
⚡ Automatically produce a data model on your database using its information schema using GenAI.
data ai reporting data-structures gemini datawarehousing dwh dataengineering schema-design gemini-api reporting-tool genai
-
Updated
Jun 1, 2024 - Python
End-to-end data warehousing project integrating APIs, ETL workflows, and PostgreSQL for analytics and reporting.
python api postgres data pipeline analytics bigdata postgresql warehouse datawarehousing externalapi
-
Updated
Jul 18, 2025 - Python
End-to-end EV charging demand analytics pipeline using Python, SQL Server, AWS S3, Excel, and Power BI. Analyzes session-level charging data to identify peak hours, city-wise demand, daily trends, and station utilization.
github python aws sql aws-s3 excel reporting faker pandas datawarehousing data-analysis sqlserver powerbi powerbi-visuals trend-analysis datamodeling
-
Updated
Jan 22, 2026 - Python
Implementation ETL with Python for data integration workflows.
-
Updated
May 16, 2023 - Python
Improve this page
Add a description, image, and links to the datawarehousing topic page so that developers can more easily learn about it.
Add this topic to your repo
To associate your repository with the datawarehousing topic, visit your repo's landing page and select "manage topics."