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)

Working with relational data models in R

Mapping of DWH database tables to business entities, attributes & metrics in Python, with automatic creation of flattened tables

implementing an end-to-end tweets ETL/Analysis pipeline.

A REST interface for Mondrian ROLAP server

Building Json data pipeline within Snowflake using Streams and Tasks

Data Engineering, Data Warehouse, Data Mart, Cloud Data, AWS, SAS, Redshift, S3

Scripts complement the Optimizing a Data Vault data warehouse on the Snowflake Cloud Data Platform webinar

Data Analysis, Analytics, Science, AI & ML, LLM etc.

Genomic BigData Warehousing with Apache Spark and LakeHouse Architecture

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.

Data modeling & the Snowflake Data Cloud using SqlDBM Hands-on lab - corresponding scripts.

Data Warehouse with AWS Redshift and Visualizing data using Power BI

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

Performed data pre-processing, optimized data warehousing, applied statistics and machine learning, and used Power BI for insightful visualizations to support informed decisions

Data warehousing date dimension and time dimension builders written in 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

Code and Documents related to the SSB+ Benchmark

Modern Dataware House Demos with Azure Databricks, Azure Data Factory & Azure Dedicated SQL pool (formerly SQL DW)

Data Warehousing (DW) Project Building and Analysing a DW for NatureFresh Stores in NZ, built using a high-performance Oracle database 12c, and Index-Nested Loops Join-Oracle.