Open to Summer 2026 Internships
Dhwani
Dhwani Parekh
Dhwani at cafe

Dhwani Parekh

Data analytics student who turns raw, chaotic data into insights that are clear, useful, and actually fun to look at.

Augustana College ยท Rock Island, IL ยท Class of 2027

See my work LinkedIn โ†—
5+
Projects
HM
HackAugie 2026
2027
Graduating
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
Coffee
Fueled entirely by it. Non-negotiable.
Cafe reading
Cafรฉs & Reading
Good book, good brew, good chair. Perfect day.
Pizza
Pizza
I love me some good margherita pizza.
Cozy cafe
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

Concierge Connection
๐Ÿ† 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 โ†—
Superstore Analysis
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 โ†—
SEO Dashboard
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 โ†—
BetaBrite
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.