Dhanbad, Jharkhand · Open to work

Ashmit Srivastava
turns raw data into decisions.

Data Analyst fresher building dashboards, cleaning messy datasets, and finding the number that changes the decision — with SQL, Python, Excel and Power BI.

SQL·PYTHON·POWER BI·EXCEL·TABLEAU
portfolio_overview.pbix
0
Dashboards Built
0
Records Analyzed
0
Reporting Effort Cut
0
Certifications
Quarterly Insight Output
01

About

// who_is_ashmit

I'm a final-year Computer Science student at Siksha 'O' Anusandhan University, Bhubaneswar, with a growing focus on data analysis. I like the part of the job most people skip past — cleaning the messy spreadsheet, checking why two numbers don't match, and building the dashboard that makes the answer obvious.

My projects so far have covered retail sales, e-commerce performance, and credit card financial data — each one taking raw records through cleaning, modeling, and visualization to a dashboard a stakeholder could actually use.

I'm looking for my first full-time role as a Data Analyst, somewhere I can keep learning by solving real business problems with data.

RoleData Analyst (Fresher)
Based InDhanbad, Jharkhand
EducationB.Tech, CSE
CGPA7.7 / 10
GraduatingJune 2026
StatusOpen to opportunities
02

Skills

// tools_and_stack

Analysis & Programming

SQL90%
Python (Pandas, NumPy)80%
Excel (Pivot Tables, Power Query)92%
PostgreSQL / MySQL78%

Visualization & Tools

Power BI & DAX88%
Tableau70%
Git & GitHub75%
Jupyter Notebook80%
03

Projects

// case_studies
01

E‑Commerce Sales Dashboard

Power BI · DAX · Power Query · Excel
  • Built an interactive Power BI dashboard analyzing sales across products, customers, and regions with dynamic KPIs.
  • Designed a scalable data model — multiple tables, relationships, and DAX measures — for accurate business insight.
  • Added drill-through reports, slicers, and filters so users can explore trends and customer behavior on their own.
  • Visualized revenue, profit and order trends using KPI cards, bar/line charts, maps, and scatter plots.
Power BIDAXData Modeling
View on GitHub →
02

Vrinda Store Sales Data Analysis

Excel · Pivot Tables · Pivot Charts · Slicers
  • Analyzed 31,000+ retail sales records to uncover purchasing behavior and regional performance patterns.
  • Built an interactive Excel dashboard with Pivot Tables, Pivot Charts, Slicers, and Conditional Formatting.
  • Cleaned and validated raw sales data, improving reporting accuracy across multiple business dimensions.
  • Identified high-performing customer segments, states, and sales channels for data-driven decisions.
Excel31K+ RecordsData Cleaning
View on GitHub →
03

Credit Card Financial Dashboard

Power BI · PostgreSQL · DAX
  • Built a Power BI dashboard from a SQL database covering 10,000+ transaction and customer records.
  • Streamlined data pipelines, cutting manual reporting effort by 40% while tracking 15+ KPIs.
  • Built dynamic DAX measures for revenue, delinquency, and customer segmentation — 25% more accurate reporting.
  • Helped stakeholders identify at-risk accounts 20% faster through clear, actionable dashboard insights.
PostgreSQL−40% Effort+25% Accuracy
View on GitHub →
04

Education

// academic_record
2022 —
2026

Bachelor of Technology, Computer Science & Engineering

Siksha 'O' Anusandhan University (ITER), Bhubaneswar, Odisha

7.7
CGPA / 10
SQL Foundations
Coursera · Jul 2026
Data Analytics Essentials
Cisco Networking Academy · Jun 2026
Data Analytics & Visualization Job Simulation
Accenture North America (Forage) · Sep 2024
Let's work together

Have a dataset that needs a story? Let's talk.

Open to Data Analyst roles, internships, and freelance dashboard work. Usually replies within a day.

© 2026 Ashmit Srivastava. Built with HTML, CSS & JS. Dhanbad, Jharkhand, India