datamodeling

A lightweight Python-based tool for extracting and analyzing column lineage for dbt projects

DATA ANALYTICS PORTFOLIO

This repository can be iused to flatten and sessionise the raw GA4 tables in a cost-effective and easy way.

Code/Notes for the Data Engineering Zoomcamp by DataTalksClub

Community Data Models for Earth Prediction Systems

Personal finance database creation, SQL analysis, and Power BI dashboard

This project presents an interactive Power BI dashboard that analyzes the annual sales performance of electronic items. The report provides clear insights into sales trends, product-wise performance, regional distribution, and key business metrics through structured and interactive visualizations.

Content published on social channels

Data Science and Artificial Intelligence advanced certification course led by the IIT Madras & Intellipaat

ITI Intensive Code Camp – (Power BI Developer) Specialization

Data Engineering framework written in Python based in Polars.

Udacity Data Engineering Nano Degree Project, Data Modeling for fact and dimension tables, and ETL pipeline that transfers data from files in two local directories into these tables in Postgres using Python and SQL.

A comprehensive solution analyzing Facebook & Instagram ad performance. Key features: Platform comparison (CTR, Conversion Rate), Campaign efficiency (Total Budget, Purchases), and Audience insights (Age, Gender, Ad Type, Geo). Optimize your Meta ad spend with data-driven insights.

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.

Analysis of E-commerce sales data

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

Customer Churn Analysis Report using powerbi

End-to-end SQL Data Warehouse project implementing Medallion Architecture and Star Schema. Engineered automated ETL pipelines for data integration. Beyond engineering, I performed advanced SQL analysis using CTEs & Window Functions to uncover key business insights. Demonstrates mastery in data modeling, SQL Server, and analytical problem-solving.