data-warehousing

Working with relational data models in R

A full data warehouse infrastructure with ETL pipelines running inside docker on Apache Airflow for data orchestration, AWS Redshift for cloud data warehouse and Metabase to serve the needs of data visualizations such as analytical dashboards.

This is a top level repository for code examples related to Data Warehousing and Very Large Databases.

Real-time Data Warehouse with Apache Flink & Apache Kafka & Apache Hudi

This repository holds the python files and notebooks associated with the Udacity Data Engineering Nanodegree.

is an hypercube of data

An open source enterprise data warehousing and analysis platform.

📜 Simple and flexible application to manage configuration data aka lists of values.

Open-source Twitter collection and archiving tool for tracking specific topics and collecting bulk data.

Make sense of it all. https://totalhack.github.io/zillion/

The CEDS Collaborative Exchange is a repository of code developed by the community that interacts with the CEDS Integration Data Store and the CEDS Elements repositories. All resources provided in this community are considered free and open source.

Modeled for longitudinal storage and reporting of P-20W data, the Common Education Data Standards (CEDS) Data Warehouse implements star schema data warehouse normalization techniques for improved query performance.

Various Projects on Python related to Data Engineering

Save data from Instagram takeout to a SQLite database

Programs for various subjects of Computer Engineering

Business Intelligence and Data Warehousing Project

Starter project for building an ETL pipeline using SSIS in Visual Studio 2019

⭕️ Capstone project for Udacity's Data Engineering Nanodegree

A data warehouse and business intelligence project on Stock market dataset to answer non-trivial BI queries.

Zillion Web: A Demo UI and Web API for Zillion

This course introduces the concept of data warehousing and data integration architecture and explains the role they play in overall business intelligence and analytics strategy of an organization. The course covers predominate architecture design strategies as well as hybrid designs that combine best practices from multiple areas. A key component of instruction is an emphasis on following industry best practices such as adhering to the requirements of an integrated data platform, selecting an appropriate design strategy and the tools to support it, selecting metrics for monitoring performance and data quality, and planning for future enhancements. The course provides hands-on experience in combining structural and design elements with best practices for data governance and coding standards to build a high-level plan for implementing a data warehouse and data integration system for organizations.

This is a flask application that converts an informational model of a decision problem to a snow-flaked star schema

Web Application provides several services for HR(s) and Managers to help them manage all aspects of the workforce in an efficient manner. Provide interfaces for employees to be more involved with Hr and Managers in a transparent mechanism to guarantee integrity environment. Use data warehousing to provide better performance and data analytics.

Data Warehousing project | Outsourced for Autumn Group | Retail Outlet DW | Melbourne based | Sep - Feb 2018

Data Warehousing for OFBiz and derivatives

This repository includes the demos and codes I use to play around with Azure Synapse Anayltics

A simple pipeline infrastructure with ETL pipeline contained in a Docker environment on Apache Airflow for orchestration and Postgres for data warehousing