Repository for tutorials, information and notes on technology in general.
-
Updated
May 23, 2024 - Python
Repository for tutorials, information and notes on technology in general.
Working with relational data models in R
A free to use dbt package for creating and loading Data Vault 2.0 compliant Data Warehouses (powered by dbt, an open source data engineering tool, registered trademark of dbt Labs)
A Personal Data Platform and the culmination of years of curiosity and learning in the Data Engineering space.
This project enables users to fetch data from YouTube by utilizing the YouTube Data API key. The retrieved data is then stored in a MySQL database. Subsequently, the stored data is analyzed and presented in a Streamlit web application using Pandas DataFrame.
Extraction of data from different Database sources, Transformation (unification and cleaning) of extracted data and laoding into the data warehouse
Data Analysis, Analytics, Science, AI & ML, LLM etc.
Explore the transformative power of data analytics in my portfolio, where Google Analytics and Snowflake converge to provide comprehensive insights. This project leverages advanced ETL techniques and real-time data integration to enhance user engagement and optimize content delivery effectively.
This repository contains Apache Airflow Directed Acyclic Graphs (DAGs) and associated scripts for orchestrating an Extract, Transform, Load (ETL) workflow. The workflow is designed to extract data from a source, perform transformations, and load it into a data warehouse.
The repo simulates query load, optimizes performance, and offers practical guidance for building data warehouses with Azure Synapse Analytics. 🚀
This project goal is to design a Data Platform for retail Data Analytics.
DataWarehousing on Chicago food database.
Employed statistical analysis, forecasting, clustering, and control chart techniques to extract insights and monitor data variation effectively, showcasing Tableau's advanced capabilities for informed decision-making.
Data warehouse (DW) quickstarts! 💽
In this project Utilizing advanced time series forecasting models, successfully predicted department-wide sales for each store for the upcoming year and Visualizing the data in streamlit GUI.
A collection of my academic write-ups including topics pertaining to Machine Learning, Statistics, Data Analytics, etc.
Creating a database management system that takes in SQL statements and generates custom databases, tables, views, e.t.c
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
Add a description, image, and links to the datawarehousing topic page so that developers can more easily learn about it.
To associate your repository with the datawarehousing topic, visit your repo's landing page and select "manage topics."