Global Tech · Detroit, MI · Jan 2024 – Apr 2024
Data Analysis Trainee
Built Pandas/NumPy cleaning pipelines and Tableau dashboards that informed product decisions.
Overview
At Global Tech in Detroit I worked with multi-source datasets — including industry sets from partners like Intel and Instacart — to clean data faster and turn it into dashboards product teams could use.
What I built
- Processed 10+ datasets from industry sources to identify trends and improve data collection and service decisions.
- Developed a Python script with Pandas and NumPy that automated data cleaning, cutting processing time by 40%.
- Created interactive Tableau dashboards for market penetration and tech adoption rates that supported a client product launch strategy.
Outcomes
- 40% faster cleaning pipelines versus the prior manual process.
- Dashboards used in product strategy conversations, not just static reports.
- Clearer trend signals across multi-source datasets for client decision-making.
Tools
- Python
- Pandas
- NumPy
- Tableau
- SQL
