Available for opportunities

Swapnil
Nicolson
Dadel

GenAI Data Analyst

Building intelligent analytics products using Python, SQL, Power BI and AI. Turning raw data into decisions that matter.

Resume
Find me on

Analytics Dashboard

Portfolio Overview

Live

Accuracy

94.2%

+2.4%

Records

20K+

+15%

Insights

47

+8

Model Performance

Revenue Trend

PythonSQLPower BIGemini AI

ETL Pipeline

B
Bronze
S
Silver
G
Gold

Hackathons

5 Events

3 National · 2 International

Selected Work

Projects that ship

End-to-end data products — from raw ingestion to business insights. Each project solves a real problem with measurable impact.

Autonomous Data Analyst

Business Problem

An AI-powered Multi-Agent Analytics Platform that automatically collects live cryptocurrency market data, profiles datasets, generates statistical business hypotheses, validates insights using statistical tests (ANOVA/T-Test), and builds executive reports, visualized via an interactive Streamlit dashboard.

Dataset

  • 6 AI Agents
  • LangGraph Data Pipeline

Tech Stack

PythonLangGraphGemini AIStreamlitSQLite

KPIs

6

AI Agents

LangGraph

Data Pipeline

5+

Stat Tests

Gemini

LLM Model

Business Impact

  • LangGraph Multi-Agent Architecture
  • Automated Profiling & Cleaning
  • Gemini-Driven Hypothesis Generation
  • Advanced Statistical Testing (ANOVA/T-Test)
  • Streamlit Live Dashboard & Reports
GitHubLive Demo
Autonomous Data Analyst — Dashboard

6

AI Agents

LangGraph

Data Pipeline

5+

Stat Tests

PythonLangGraphGemini AIStreamlitSQLite

Google Play Store Analytics

Business Problem

End-to-end data analysis pipeline on 10K+ apps — from raw SQL cleaning to ML models and an interactive Power BI dashboard delivering actionable business insights.

Dataset

  • 10K+ Apps Analyzed
  • 814 Duplicates Removed

Tech Stack

PythonSQLPower BIMachine Learning

KPIs

10K+

Apps Analyzed

814

Duplicates Removed

3

ML Models

Power BI

Dashboard

Business Impact

  • SQL Data Cleaning
  • Exploratory Data Analysis
  • Machine Learning
  • Power BI Dashboard
  • Business Insights
GitHub
Google Play Store Analytics — Dashboard

10K+

Apps Analyzed

814

Duplicates Removed

3

ML Models

PythonSQLPower BIMachine Learning

Crypto Intelligence Platform

Business Problem

Real-time crypto analytics platform with live API integration, a Bronze→Silver→Gold ETL pipeline, SQLite data warehouse, Streamlit dashboard, and Gemini AI market analyst.

Dataset

  • 100+ Coins Tracked
  • Live API Data Source

Tech Stack

PythonSQLSQLiteStreamlitGemini AI

KPIs

100+

Coins Tracked

Live API

Data Source

ETL

Pipeline

Gemini AI

AI Reports

Business Impact

  • Live API Integration
  • Bronze → Silver → Gold ETL
  • SQLite Warehouse
  • Streamlit Dashboard
  • Gemini AI Market Analyst
GitHubLive Demo
Crypto Intelligence Platform — Dashboard

100+

Coins Tracked

Live API

Data Source

ETL

Pipeline

PythonSQLSQLiteStreamlitGemini AI

E-Commerce Advanced Analytics

Business Problem

Comprehensive e-commerce analytics covering 20K+ transactions — cohort analysis, funnel analysis, CLV calculation, and executive dashboards for revenue and churn insights.

Dataset

  • 20K+ Records Processed
  • 12% Drop-off Found

Tech Stack

PythonSQLPower BIGemini AI

KPIs

20K+

Records Processed

12%

Drop-off Found

Cohort

Analysis Type

CLV + Churn

Insights

Business Impact

  • Customer Analytics
  • Revenue Analysis
  • Cohort Analysis
  • Customer Lifetime Value
  • Executive Dashboard
GitHub
E-Commerce Advanced Analytics — Dashboard

20K+

Records Processed

12%

Drop-off Found

Cohort

Analysis Type

PythonSQLPower BIGemini AI

Amazon Prime Content Analytics

Business Problem

Exploratory data analysis of Amazon Prime Video's content library — uncovering insights about content distribution, audience preferences, ratings patterns, and global production trends across 9,000+ titles.

Dataset

  • 9K+ Titles Analyzed
  • EDA Analysis

Tech Stack

PythonPandasSeabornMatplotlib

KPIs

9K+

Titles Analyzed

EDA

Analysis

15+

Charts

Content Mix

Insights

Business Impact

  • Content Distribution Analysis
  • Audience Preference Insights
  • Production Trend Analysis
  • Talent Participation Mapping
  • Data-Driven Visualizations
GitHub
Amazon Prime Content Analytics — Dashboard

9K+

Titles Analyzed

EDA

Analysis

15+

Charts

PythonPandasSeabornMatplotlib

Insurance Lead Analytics

Business Problem

Business Analyst project analyzing insurance lead conversion, marketing performance, revenue tracking, and customer segmentation using Python and Power BI to drive data-backed sales decisions.

Dataset

  • Lead Conversion Analysis
  • Customer Segmentation

Tech Stack

PythonPower BIData AnalysisBusiness Analytics

KPIs

Lead Conversion

Analysis

Customer

Segmentation

Power BI

Dashboard

Revenue + Marketing

Insights

Business Impact

  • Lead Conversion Analysis
  • Marketing Performance Tracking
  • Revenue Analytics
  • Customer Segmentation
  • Power BI Dashboard
GitHub
Insurance Lead Analytics — Dashboard

Lead Conversion

Analysis

Customer

Segmentation

Power BI

Dashboard

PythonPower BIData AnalysisBusiness Analytics

Spotify Product Dissection & Schema Design

Business Problem

Product dissection of Spotify's data architecture with a normalized 3NF PostgreSQL schema design, ER diagrams, and advanced SQL analytics using window functions and CTEs for music platform insights.

Dataset

  • 3NF Schema
  • PostgreSQL Database

Tech Stack

PostgreSQLSQLDatabase Design3NF

KPIs

3NF

Schema

PostgreSQL

Database

Advanced SQL

Queries

ER Diagrams

Design

Business Impact

  • 3NF Database Schema Design
  • ER Diagram Architecture
  • Advanced SQL Analytics
  • Window Functions & CTEs
  • Database Optimization
GitHub
Spotify Product Dissection & Schema Design — Dashboard

3NF

Schema

PostgreSQL

Database

Advanced SQL

Queries

PostgreSQLSQLDatabase Design3NF

Healthcare Risk Analysis Dashboard

Business Problem

Power BI analysis examining health risks and safety disparities across 77 U.S. cities using the MetroHealth83 dataset — identifying healthcare gaps, cleaning duplicate records, and generating actionable insights through interactive dashboards.

Dataset

  • 77 Cities Analyzed
  • 16 Cols Data Points

Tech Stack

Power BIData CleaningData Visualization

KPIs

77

Cities Analyzed

16 Cols

Data Points

Power BI

Dashboard

MetroHealth83

Dataset

Business Impact

  • Health Risk Analysis
  • 77 City Comparison
  • Data Cleaning Pipeline
  • Interactive Dashboards
  • Actionable Health Insights
GitHub
Healthcare Risk Analysis Dashboard — Dashboard

77

Cities Analyzed

16 Cols

Data Points

Power BI

Dashboard

Power BIData CleaningData Visualization
View all on GitHub
What I Build

From raw data to real decisions

Four core disciplines that define my work — each one grounded in production-quality output and measurable business value.

Business Intelligence

Power BI dashboards, DAX measures, and KPI frameworks that translate complex data into clear executive narratives.

Data Engineering

Python ETL workflows, SQL pipelines, and layered data architectures (Bronze → Silver → Gold) for reliable, scalable analytics.

Generative AI

LLM-powered analytics, RAG pipelines, AI agents with n8n and CrewAI, and Gemini-integrated market intelligence systems.

Data Analytics

Cohort analysis, funnel analysis, customer lifetime value, statistical modelling, and actionable business insights.

Technical Skills

Tools of the trade

A curated stack built for modern data work — from SQL pipelines to Gemini AI agents.

Languages

PythonSQL

Databases

MySQLSQLite

Analytics

PandasNumPySciPyStatisticsCohort AnalysisFunnel Analysis

Visualization

Power BITableauPlotlyExcel

AI & LLMs

GeminiLLMsRAGLangChainLangGraphVectorDBMCPAI AgentsPrompt Engineering

Development

GitGitHubStreamlitAutomationVS Code

Certifications & Achievements

HackerRank Python (Intermediate)HackerRank SQL (Intermediate)GenAI for Beginners — Great Learning3× National Hackathons2× International Hackathons (Devpost)
Experience

Where I've worked

Hands-on internships that sharpened my ability to deliver data products under real business constraints.

Power BI Intern

NullClass EdTech

Jul 2025 – Aug 2025
Remote
  • Designed and deployed four interactive Power BI dashboards tracking 12+ KPIs across 1,100+ engagement records.
  • Built DAX measures and calculated columns to monitor CTR, impressions, engagement rate, and campaign-level performance trends.
  • Automated data transformation and cleaning using Power Query, reducing manual reporting effort by 60%.
  • Collaborated with business stakeholders to refine KPI definitions, enhance dashboard usability, and support data-driven campaign optimization.

Data Analyst Intern

Zep Analytics

Jun 2025 – Jul 2025
Remote
  • Constructed optimized SQL queries using Joins, CTEs, and Window Functions to examine healthcare data across 77 cities.
  • Engineered Python-based ETL workflows to clean and standardize 15,000+ records, increasing reporting reliability by 95%.
  • Delivered KPI dashboards supporting operational risk assessment and performance evaluation initiatives.
Education

Academic background

Strong computer science foundations from two institutions, culminating in an M.Tech from BIT Mesra.

M.Tech in Computer Science

Birla Institute of Technology, Mesra

2023 – 2025
75.3%

B.Tech in Computer Science

Cambridge Institute of Technology, Ranchi

2017 – 2021
73.3%
Open to opportunities

Let's Build Something
Amazing.

Whether you have a data challenge, a product idea, or just want to connect — I'd love to hear from you. Always open to interesting conversations.

Send me an emailResume

Email

swapnilnicolson.201@gmail.com

GitHub

github.com/swapitsneil

LinkedIn

linkedin.com/in/swapnil-nicolson-dadel