role: data · business · bi analyst

Raw data in. Revenue decisions out.

open_to: 

Darshit Jayswal — Data & Business Analyst, 8 years turning messy business data into clear, money-relevant decisions with Power BI, SQL and Python.

view_projects() → linkedin
Darshit Jayswal
0 yrs
experience
0
portfolio_projects
0%
yoy_growth
0K
revenue_impact
// 01. about

data analytics × business strategy

I started in market research asking why customers behave the way they do — and now answer it with Power BI dashboards, SQL, and Python. My path from primary research to BI gives me an edge most analysts don't have: I understand the business question behind the data request.

At GJ Tech Solutions, I designed acquisition funnel dashboards tracking the complete player journey (lead → KYC → first deposit), connected Power BI directly to Salesforce and Amazon Athena via ODBC to eliminate manual exports, and delivered competitive intelligence that contributed to 20% YoY growth. I also led product research that shaped the roadmap.

Ahmedabad-based. Open to Data / Business / Marketing / BI Analyst & Power BI Developer roles.

📍
location
Ahmedabad, India
🗓
experience
8+ years
💼
status
Open to new opportunities
🌐
languages
English · Hindi · Gujarati
🎓
top certs
Google DA · IBM DS · Six Sigma GB
// 02. skills

my stack

📊
bi_reporting
Power BI DAX Power Query / M Salesforce Connector Amazon Athena Star Schema Data Modeling Advanced Excel PivotTables Power Pivot XLOOKUP
💻
programming_data
SQL CTEs Window Functions Aggregations Python Pandas NumPy SciPy Plotly ETL / Pipelines Data Cleaning
🔍
analysis_business
A/B Testing Churn / RFM Cohort Analysis Funnel Analytics Statistical Testing Market Research Competitive Intel Data Storytelling KPI Definition
// 03. featured work

what I've built

Power BI
project_01 · power-bi · dax · sql · python

Customer Churn & Retention Analytics

26.5% churn Q1 Q2 Q3 Q4 revenue_at_risk ₹5.1L per month · found & targeted
₹5.1L/month revenue at risk — found & targeted

End-to-end 3-page Power BI dashboard analysing 7,043 subscribers with dimensional modelling, DAX time-intelligence, and RFM segmentation. 45.8% of churn occurs within the first 90 days. 8 SQL queries covering cohort retention and contract-tier churn (Monthly 29.5% vs Two-Year 5.9%).

Power BI DAX SQL Python RFM Cohort Analysis
cd ./github →
Power BI
project_02 · power-bi · dax · sql

AI-Driven Tech Layoffs 2026

2020 2021 2022 2023 2024 2026 layoffs 920K+ across 2,900+ co.
920K+ real layoffs across 2,900+ companies analysed

Analysed the 2026 tech layoff wave using real data from layoffs.fyi (2020–2026). 3-page Power BI dashboard covering yearly trends, industry/country breakdowns, and an AI-attribution lens separating AI-cited layoffs from broader cost-cutting. DAX measures include YoY % change and rolling aggregations.

Power BI Power Query (M) DAX SQL Data Storytelling
cd ./github →
Python
project_03 · python · pandas · plotly

Superstore Sales Intelligence

31.6% 26.2% 22.3% 19.9% West East Central South
West region drives 31.6% revenue — Technology leads margin at 17.1%

End-to-end EDA of 10,000+ retail transactions across 4 U.S. regions. Decomposed sales performance by category, sub-category, and customer segment. 8 production-quality visualisations covering regional share, category margin, time-series trends, and sub-category profit deep-dives using Matplotlib, Seaborn, and Plotly.

Python Pandas Matplotlib Seaborn Plotly EDA
cd ./github →
Python
project_04 · python · plotly · funnel-analysis

SaaS Acquisition & Retention Analysis

Lead · 100% Signup · 42% Verified · 29% Paid · 22%
Organic converts 30% vs Paid 16.9% — LinkedIn CAC $143, best channel

Full acquisition funnel analysis (Lead → Signup → Verified → Paid) across 4 channels with CAC and ROI comparison. Cohort retention heatmap identifying Month 1 as the critical drop-off point. MRR trend by traffic source, regional breakdown, and interactive HTML dashboard with 6 Plotly charts.

Python Plotly Cohort Analysis Funnel Analytics MRR CAC / ROI
cd ./github →
Python
project_05 · python · scipy · statistical-testing

A/B Testing: Checkout Redesign Impact

Control 3.5% Variant 4.9% uplift +40% p < 0.0001 CVR CVR
+$970K projected annual uplift — 40% CVR improvement (p < 0.0001)

Rigorous A/B test analysis for an e-commerce checkout redesign across 10,000 users. Control CVR 3.5% vs Variant 4.9%. Chi-Square confirms statistical significance (p < 0.0001). Includes Wilson confidence intervals, Independent T-Test on revenue per user, Mann-Whitney U on session duration, device segmentation, and annual revenue impact model projecting +$970K/year uplift.

Python SciPy Chi-Square Hypothesis Testing Wilson CI Revenue Impact
cd ./github →
// 04. experience

8 years, research → bi

One Park Financial
Apr 2026 – May 2026
data_analyst · ahmedabad (us operations)
  • Partnered with Data Engineering to ingest Salesforce Pardot data into Amazon Athena, then connected Power BI via ODBC — delivering a daily auto-refreshing dashboard replacing a fully manual extraction process
  • Built a Power BI dashboard consolidating ad spend across Meta, TikTok, Google, and partner agencies with lead volume, CPL, and funded conversion metrics
GJ Tech Solutions Pvt. Ltd.
Sep 2022 – Mar 2026
market_researcher & bi_analyst · gift city, gandhinagar
  • Designed Power BI dashboards for gaming acquisition — full player funnel (lead → KYC → first deposit) with DAX conversion rates at each stage
  • Delivered competitive intelligence contributing to 20% YoY business growth
  • Led product research identifying churn points through behavioural data and user surveys; findings fed into the product roadmap
  • Cohort analysis and trend reporting across 100+ analytics projects
ActionEdge Research Services LLP
Feb 2022 – Sep 2022
data_quality_analyst · ahmedabad
  • Validated and cleaned large-scale datasets across 5+ concurrent projects — reduced error rates by 95%
  • SQL-driven cross-verification and audit of datasets; 50+ projects with near-zero escalations
ActionEdge Research Services LLP
Jun 2019 – Feb 2022
senior_researcher → project_associate · ahmedabad
  • 1,000+ B2B research surveys for global clients including IDC, Forbes Insights, and Illuminas
  • Managed 4–5 concurrent enterprise projects; primary POC for 20+ clients
Tech Mahindra Ltd.
Jan 2018 – Feb 2019
customer_support_associate
  • 100+ customers daily; recognised for communication and documentation accuracy
// 05. certifications

credentials & learning

🔵
Google Data Analytics
🔬
IBM Data Science
🐍
Data Science Fundamentals with Python & SQL
🟢
Six Sigma Green Belt
🟡
Six Sigma Yellow Belt
📈
Data Analytics for Lean Six Sigma
🔍
Market Research Specialization
🔒
RISE: Mastery in Retention (WebEngage)
// 06. contact
$ connect --now

Open to Data / Business / Marketing / BI Analyst & Power BI Developer roles.
Let's talk about turning your data into decisions.

✉ email 🔗 linkedin 🌐 portfolio ⌨ github

ahmedabad, india · +91 95744 98784