Dhwani Parekh

01 — About me

The person behind
the dashboards

I'm a Data Analytics junior at Augustana College with a CS minor, graduating May 2027. I love the moment a messy dataset finally clicks — when a thousand rows of nothing becomes a story someone can actually use.

I've done real SEO analytics work at Tring India in Mumbai, built software for the campus radio station, mentored first-year students as an Emerge Leader, and led the full data and AI layer of an app at HackAugie.

Off the clock? Fueled entirely by coffee, café hopping for the perfect reading spot, or on a mission to find the best pizza.

Coffee

Fueled entirely by it. Non-negotiable.

Cafés & Reading

Good book, good brew, good chair. Perfect day.

Pizza

I love me some good margherita pizza.

Data Analytics

Python, SQL, Tableau — making numbers say something.

🎓

Augustana College

B.A. Data Analytics · CS Minor · May 2027

📍

Rock Island, IL

Open to relocating anywhere for the right role

🏆

HackAugie 2026 — Honorable Mention

Built Concierge Connection in 24 hours — led the data & AI layer

👩‍💻

Rewriting the Code (RTC)

Member — community for women in tech

📜

Certifications

SQL for Data Science (UC Davis/Coursera) · Tableau Essential Training · Excel (Microsoft)

02 — Work

Selected projects

🏆 Honorable MentionAI / MLHackathon

Concierge Connection

Cross-platform migraine tracker built in 24 hours at HackAugie. Real-time symptom logging, AI-powered pattern detection, and a clinical dashboard with live charts for doctors. I designed the DB schema, built pattern detection logic, and all Supabase data functions.

FlutterSupabaseDartPostgreSQL

View ↗

K-MeansTableau

Superstore Profit Analysis

Analyzed 9,994 retail orders and uncovered $135K in losses from discount abuse. Discovered Tables sub-category lost $17,725 despite $206K in sales. Segmented 793 customers into 3 groups using K-Means clustering. Built interactive Tableau dashboard.

PythonScikit-learnTableauJupyter

GitHub ↗

SEOTableau

SEO Traffic Dashboard

Analyzed 50,000+ global websites using Alexa site data to uncover engagement trends, SEO keyword optimization potential, and buyer keyword distribution. Built 3-visual interactive Tableau dashboard: Engagement vs Global Rank, Top SEO Opportunities, and Buyer Keyword Distribution.

TableauData CleaningSEO Analytics

Tableau ↗

PythonHardware

BetaBrite LED Display

Programmed a BetaBrite LED display sign to dynamically show real-time dates and times at the radio station. Brought live information to the broadcast environment using Python and Node.js.

PythonNode.jsJavaScript

View ↗

🎙️

C++Open Source

Audacity ASIO Support

Compiled ASIO (Audio Stream Input/Output) support into Audacity, an open-source digital audio editor, to improve the radio station's audio processing capabilities. Contributed to real production software.

C++AudacityOpen Source

View ↗

03 — Experience

Where I've worked

SEO Data Analyst Intern

Tring · Mumbai, India

Jan 2023 – Apr 2023

Conducted comprehensive keyword research to enhance search engine rankings and improve visibility.
Optimized website content and meta tags aligned with SEO best practices to drive organic traffic.
Monitored website performance using Google Analytics and SEMrush, analyzing competitor strategies.

Google AnalyticsSEMrushKeyword ResearchOn-page SEO

Radio Station Software Developer

Augustana College — WAUG

Sep 2023 – Dec 2024

Assisted in CD ripping and digital archiving, ensuring high-quality audio preservation for on-air use.
Maintained the station's website, updating content and troubleshooting technical issues.
Provided technical support for audio equipment and software for smooth broadcasting.

PythonNode.jsWeb MaintenanceAudio Tech

Emerge Leader

Augustana College

Oct 2024 – Dec 2024

Mentored first-year students through their transition into college life during their initial semester.
Organized and led discussions and activities centered on leadership development and teamwork.
Encouraged campus involvement, fostering confidence and essential leadership skills.

MentoringLeadershipStudent Development

Observer Sportswriter

The Augustana Observer

Sep 2022 – Oct 2023

Conducted interviews with college athletes and coaches for engaging sports coverage.
Researched and compiled game statistics and player data to ensure accurate reporting.
Wrote and edited news articles covering sporting events, game recaps, and athlete highlights.

StorytellingSportswritingData Research

04 — Involvement

On campus

Multicultural Programming Board Member

Augustana College · Part-time

Planning and executing multicultural events to promote diversity and inclusion. Collaborating with student orgs and managing event logistics, outreach, and on-site execution.

Apr 2026 – Present

HackAugie Competitor — Team 404 Not Found

Augustana College Hackathon

Built Concierge Connection — a migraine tracking app with AI-powered insights — in 24 hours. Earned Honorable Mention (Top 3). Led the entire data and AI layer.

Apr 2026

Member

Rewriting the Code (RTC)

Community for women in tech — mentorship, networking, and career development resources.

Present

Emerge Leader

Augustana College Leadership Program

Mentored incoming first-year students. Led workshops on leadership, teamwork, and campus involvement during their critical first semester.

Oct – Dec 2024

Let's build something together.

Actively looking for Summer 2026 Data Analyst internships. If you're working on something interesting, I'd genuinely love to hear about it. Open to relocating anywhere.

Email

dhwaniparekh@augustana.edu

↗

linkedin.com/in/dhwani-parekh

↗

GitHub

github.com/dhwaniparekh05

↗

Tableau Public

public.tableau.com/dhwani.parekh

↗

Dhwani Parekh

The person behindthe dashboards

Selected projects

Where I've worked

On campus

Let's build something together.

The person behind
the dashboards