Data Analyst · Lafayette, IN

I turn messy data into decisions people can trust.

I studied astrophysics, where one bad measurement can sink a result. Now I apply the same habits to business data: clean it, check it against its source, analyze it, and explain what it means in plain language.

See my projectsView resume

By the numbers

Figures from the projects below.

  • 2.5M → 1,306records filtered to an analysis-ready set
  • 548,951energy records cleaned and validated
  • 164,072galaxy records queried with SQL
  • 25data quality issues found across 7 platforms

Projects

Each one follows the same path: a question, how I worked on it, and what I found.

SDSS Galaxy Data Workflow

SQL · Python · Jupyter
Question
How complete and reliable is a large galaxy survey sample, and which records are good enough to analyze?
Method
Wrote SQL joins, filters, and aggregations to pull 164,072 records, then cleaned and analyzed them in Python. Built a separate 62,879-record validation workflow and documented every assumption and correction.
Result
85.9% spectroscopic completeness. Progressive quality filters cut 2,497,140 source records to a 1,306-record dataset ready for analysis.

Data Center Energy Dashboard

Tableau · Excel
Question
Which U.S. region is the best fit for a data center that needs reliable, renewable power?
Method
Cleaned, reshaped, and validated 548,951 records across 63 authorities and 13 regions. Reconciled totals to the source and tested every calculated field. Built an interactive dashboard with comparison KPIs.
Result
Recommended the Northwest: 52.3% renewable share, +21.7M annual net balance, and surplus power in 77.6% of hours. Tradeoffs and limits are stated in the dashboard.

A/B Testing Decision Analysis

Excel · Tableau · statistics
Question
Should the business ship each change, or stop?
Method
Compared two experiments and tested whether each difference was statistically meaningful or just noise.
Result
One test showed a significant effect and one did not. Each recommendation came with its uncertainty, limitations, and next steps.

Website Performance Analysis: Grammys

Excel · XLOOKUP
Question
How did Grammys and Recording Academy site traffic differ, including on Grammy Awards days?
Method
Calculated pages per session, bounce rate, and average time on site for each dataset and for the two combined. Used XLOOKUP to bring mobile-visit data into the main table, returning 0 when a date was missing.

Business Profile QA Audit

Source verification

Checked business information on seven public platforms and documented 25 missing, inaccurate, or broken fields, ranked by user impact.

Scientific Chart Readability Review

Visual review

Reviewed six astronomy charts for crowded points, low contrast, oversized markers, and unclear labels, with a fix for each.

Skills

Tools

  • SQL
  • Excel
  • Tableau
  • Python
  • Jupyter Notebook
  • Google Sheets
  • Power BI (learning)

Analysis

  • Data cleaning
  • KPI design
  • Dashboards
  • Segmentation
  • Trend and anomaly analysis
  • A/B testing

Data quality

  • Source reconciliation
  • Completeness checks
  • Documentation
  • Reproducible workflows

Communication

  • Data storytelling
  • Stakeholder summaries
  • Remote teamwork
  • English and Spanish

Experience

Data Analytics Trainee, The Global Career Accelerator

Built Tableau dashboards and KPI views, validated multi-source data, and presented recommendations.

QA and Research Analyst Intern, AC Creative Collective

Audited business data on seven platforms and found 25 issues.

Undergraduate Research Assistant, Indiana University Astronomy

Quality-checked SDSS spectra and documented error sources for faculty review.

Education and certifications

  • B.S. Astronomy/Astrophysics, Math minor, Indiana University May 2026
  • Microsoft Power BI Data Analyst Associate (PL-300) In progress
  • Data Analysis and Data Visualization, The Global Career Accelerator 2026

Contact

I am looking for entry-level data analyst roles. Email is the fastest way to reach me.

naomiharkins575@gmail.com

LinkedIn