Diya Shah
Data analyst fresher
diya@example.com · Ahmedabad, India
Summary
Statistics graduate seeking an entry-level data analyst role. Used SQL, Excel and Python in independent projects to clean transaction data, define reporting metrics and explain findings with reproducible notebooks and dashboards.
Projects
Retail sales analysis
Public practice dataset; SQL, Excel, Power BI
- Cleaned duplicate orders and missing product categories, and documented the rules used before calculating sales metrics.
- Wrote SQL queries for monthly sales, repeat purchases and category mix; checked totals against spreadsheet pivot tables.
- Built a dashboard with date and category filters and explained seasonal patterns without claiming real business revenue gains.
City air-quality exploration
Open-data practice project; Python, pandas, matplotlib
- Combined daily observations, checked missing readings and compared monthly pollutant trends in a notebook.
- Visualised seasonal changes and noted that missing sensor data limits comparisons between locations.
Education
B.Sc in Statistics
Example College of Science
2023 – 2026
Relevant coursework: Probability, Statistical Inference, Regression Analysis.
Skills
Analysis: SQL, Excel, Python, pandas, Data cleaning, Exploratory data analysis
Reporting: Power BI, Pivot tables, matplotlib, Data visualisation