Research Data Analyst
Summit Bicycles
Palo Alto, California, United States
- Utilized Excel, along with VBA scripting, to clean and standardize over 1,360 customer data entries, improving data accuracy by 25% and reducing processing time by 40%.- Created dynamic reports using Excel Pivot Tables, enabling data-driven decisions that contributed to an 18.6% increase in sales within three months by identifying underperforming products and optimizing inventory levels.- Designed and implemented an interactive dashboard using Power BI, visualizing key customer… Show more - Utilized Excel, along with VBA scripting, to clean and standardize over 1,360 customer data entries, improving data accuracy by 25% and reducing processing time by 40%.- Created dynamic reports using Excel Pivot Tables, enabling data-driven decisions that contributed to an 18.6% increase in sales within three months by identifying underperforming products and optimizing inventory levels.- Designed and implemented an interactive dashboard using Power BI, visualizing key customer purchasing behaviors and demographics, which provided actionable insights and led to a 15% increase in targeted marketing effectiveness, specifically for bike sales. Show less