Hi, I'm Shayantan Mitra 👋
Aspiring Data Analyst with a B.Sc. in Computer Science and 2.5+ years of experience in business operations, SAP-based reporting, and data management at RCF Ltd. Passionate about transforming raw data into actionable insights using Excel, SQL, Power BI, and Python. Currently on track to completing my Professional Certification in Data Analytics with GenAI by IITM Pravartak from Coding Ninjas.
- Skilled in Data Analysis, Data Visualization, Business Reporting, and Dashboard Development
- Experienced with Excel, SQL, Power BI, SAP SD, Python, and Data Cleaning
- Interested in Business Intelligence, Financial Analytics, and Data-Driven Decision Making
"Turning data into insights and insights into decisions."
| Project Link | Completion Date | Tools | Project Description |
|---|---|---|---|
| JobMarket-Insights | July 2026 | Python, SerpAPI, MySQL, SQL (aggregation, GROUP BY), Power BI | Built an end-to-end pipeline scraping 11,000+ IT job postings across 42 Indian cities via SerpAPI, cleaning and loading the data into MySQL, then querying it in SQL to surface skill demand, top hiring companies, and employment trends, visualized in a Power BI dashboard. |
| Project Link | Completion Date | Functions & Features | Project Description |
|---|---|---|---|
| US-Healthcare-Excel-Dashboard | August 2026 | PIVOT TABLE, PIVOT CHART, SLICER, KPI CARDS, CALCULATED COLUMNS, DASHBOARD | Built an interactive dashboard on 10,000 patient records to study demographics, billing cost and hospital resources. Found Cancer is the costliest condition (~$39.7K average), Emergency admissions cost the most, and Elective stays are ~35% shorter than Emergency and Urgent stays. |
| India-CPI-Inflation-Excel-Analysis | August 2026 | SUMIF, AVERAGEIFS, CORREL, INDEX/MATCH, SUBTOTAL, EXCEL TABLES, INTERPOLATION, CHARTS | Analysed India's Consumer Price Index from Jan 2013 to May 2023 to answer five questions on basket contribution, inflation trend, food prices, COVID-19 impact and oil-price links. Found 2022 was the highest-inflation year (peak 7.8% in April 2022) and Food is the largest CPI bucket (47.5%, equal-weighted). |
| Project Link | Completion Date | Project Description | Dashboard |
|---|---|---|---|
| E-Commerce-Order-Power-BI-Dashboard | October 2026 | Built a 5-page Power BI dashboard on 2,500 orders across 14 countries to track sales targets and customer behaviour. Used DAX measures, slicers and a map-to-matrix drill-through; found sales at 95.8% of target (55 of 92 POCs below) and 42% of customers who never ordered. | Download |
| Weather-Report-India-Power-BI-Dashboard | September 2026 | Built a Power BI dashboard for 28 Indian cities from the WeatherAPI JSON feed, showing current conditions, a 7-day forecast, chance of rain and PM10-based air quality. Used Power Query to combine 28 API queries and DAX for unit formatting and pollutant colour rules. | Download |