Your Name
Data Analyst
City, Country · email@example.com · linkedin.com/in/yourname · yourportfolio.com
Professional summary
Data Analyst with 4 years turning sales, marketing, and operations data into decisions for a D2C retail brand. Built Power BI dashboards used weekly by 60+ managers, uncovered churn drivers that lifted repeat purchase rate by 11%, and automated reporting that freed 20 hours a week. Strong in SQL, Excel, Python, and presenting findings to leadership.
Skills
SQL · Excel · Tableau · Power BI · Python · Data visualization · Statistics basics · A/B testing · Dashboards · ETL basics · Stakeholder communication · Google Sheets
Experience
Senior Data Analyst — Company Name
2021 – Present
- Built 12 Power BI dashboards on sales, inventory, and returns used weekly by 60+ store and category managers.
- Analyzed 18 months of order data in SQL to identify churn drivers, leading to a loyalty offer that raised repeat purchase rate by 11%.
- Automated weekly Excel reporting with SQL views and Power Query, saving the team 20 hours per week and removing copy-paste errors.
- Analyzed an A/B test on free-shipping thresholds and recommended a change that increased average order value by 7%.
- Standardized 25 KPI definitions across marketing and finance, ending conflicting revenue figures in monthly business reviews.
Projects
E-commerce Sales Dashboard | SQL (PostgreSQL), Excel, Power BI, Olist public dataset
- Cleaned and joined 100K+ orders across 8 tables in SQL, handling missing delivery dates and duplicate reviews.
- Built an interactive Power BI dashboard tracking revenue, delivery delays, and review scores by region and category.
- Showed that late deliveries lowered average review scores by 1.7 stars and summarized three recommendations in a one-page brief.