Spotify Analytics Dashboard
12,000 streaming records — what retains listeners, and where premium conversion hides.
InteractiveDetails →
Data Analyst · Digital Marketing
Vrushank
Soni
I'm Vrushank Soni — a Data Analyst & Digital Marketer in Ahmedabad, turning business data into clear, confident decisions with Power BI, SQL and Python.
$ whoami
vrushank_soni
$ cat profile.txt
role........ Data Analyst · Digital Marketer
analytics... Power BI · SQL · Excel · Python
marketing... SEO · Google Ads · Meta Ads
education... BBA + PGDM (Marketing & Finance)
$ ./latest --insight
"Month-to-month customers churn 5× more."
$
01 — About
Where the numbers came before the degree.
Coming from a business background, conversations around growth, customers, marketing and finance were always part of everyday life. Those conversations made me curious — not about creating advertisements, but about understanding why businesses grow and how better decisions are made.
That curiosity led me to a BBA in Marketing Management, followed by a PGDM in Marketing & Finance. Internships and client work sharpened the marketing side, while analytics pulled me toward Power BI, SQL and Python — turning business data into insights people can actually act on.
02 — Skills
A toolkit that spans data and marketing.
Analytics
Power BIcore
MySQL
Excel
Python
Marketing
SEO
Google Adscore
Meta Ads
Google Analytics
AI
ChatGPT
Claude
AI-Assisted Analysiscore
Prompt Engineering
Workflow Automation
Professional
Data Visualizationcore
Client Handling
Content Strategy
Critical Thinking
Communication
-- which channel actually converts this week?
SELECT platform,
ROUND(100.0 * clicks / impressions, 2) AS ctr,
ROUND(revenue / NULLIF(spend, 0), 2) AS roas
FROM ad_campaigns
GROUP BY platform
ORDER BY roas DESC;
How I read the numbers
The check before the spend.
In plain English: a query like this shows whether Meta or Google is really earning its budget this week — before the money gets spent finding out the hard way. Data first, then the creative.
03 — Experience
What I actually changed.
Internships and client work, judged the only way that matters — by what moved after I got involved.
Z
Zero Dimensions — Social Media & SEO
Owned on-page SEO and worked hand-in-hand with the off-page team so content ranked, not just shipped. Turned campaign data into weekly reports leadership could act on — engagement up 15%.
P
Provectus — Marketing Intern
Grew an advisory firm's LinkedIn presence 30% in six months by reading which content converted and doubling down — B2B positioning driven by analysis, not guesswork.
S
StuIntern & Freelance — Digital Marketing
Ran Meta Ads, content and reporting for clients end-to-end. Used AI-assisted workflows to ship more ad variations faster, and tied every campaign back to its performance numbers.
0%
Engagement lift · Zero Dimensions
0%
LinkedIn growth · Provectus
0%
Instagram followers · PhysioEdge
Sales Performance Dashboard
8,000 orders, $3.68M revenue — where profit is made and where discounting destroys it.
InteractiveDetails →
Marketing Analytics Dashboard
$4.55M spend → $13.9M revenue — which channels earn their budget, and where it should move.
InteractiveDetails →
Customer Churn Analysis
7,500 subscribers, 28.5% churn — a risk score for who to save first, and what's on the line.
InteractiveDetails →
Hevify Website Analytics
Website & SEO analytics — traffic, bounce, and keyword gaps one push from page one.
InteractiveDetails →
05 — Brands I've worked with
Marketing, content and analytics — across industries.
06 — Achievements & Certificates
Recognised, and certified.
Srijan 2025 — Business Presentation
Winner, group presentation award — SKIPS School of Business, Marketing Maestros Club.
View certificate ↗SKIPS Chaupal 2026 — Presentation
Winner / Runner-Up, presentation competition — SKIPS School of Business.
View certificate ↗Final Year Project Leader
Led the final-year capstone team from research through to final delivery.
Certificates
07 — Notes
Things I've written down.
08 — Contact