Suvam Bhunia

Data Analyst

Kolkata, IN.

About

Results-driven Data Analyst with foundational expertise in Excel, SQL, Power BI, and Python, adept at transforming complex datasets into actionable insights and interactive dashboards. Currently advancing analytical capabilities through the Google Data Analytics Certificate, eager to leverage data-driven solutions to optimize business performance and decision-making.

Work

Freelance

|

Data Analyst

Remote, N/A, Global

→

Summary

Spearheaded data cleaning, transformation, and visualization initiatives for diverse analytics projects, delivering actionable insights and enhancing decision-making capabilities.

Highlights

Executed comprehensive data cleaning and transformation on over 200,000 rows across 5+ real-world analytics projects using Excel, SQL, Power BI, and Python, significantly enhancing data reliability and insight delivery.

Developed and deployed interactive Power BI dashboards, incorporating advanced slicers, KPIs, and custom visuals, which improved reporting clarity and accelerated data-driven decision-making.

Utilized SQL views and conducted in-depth exploratory data analysis with Python (Plotly) to identify critical user and sales patterns, leading to actionable insights and a notable improvement in reporting speed.

Education

Ramkrishna Mahato Government Engineering College

Purulia, West Bengal, India
→
B.Tech Electronics & Communication Engineering Grade: 8.30/10 CGPA

Certificates

Power BI Masterclass – Basic to Advanced

Lokesh Lalwani

SQL (Intermediate)

HackerRank

Skills

Data Analysis & Business Intelligence Tools

SQL (Joins, CTEs, Window Functions), Power BI (DAX, Power Query, Dashboard Design, KPI Reporting), Microsoft Excel (Pivot Tables, VLOOKUP, Conditional Formatting), Python (Pandas, NumPy, Matplotlib, Seaborn), Plotly.

Data Science & Statistics

Statistics (Hypothesis Testing, Regression, Descriptive Statistics, Inferential Statistics), Data Cleaning, Data Transformation, Exploratory Data Analysis (EDA), Trend Identification, Root Cause Analysis.

Professional Skills

Problem Solving, Communication, Critical Thinking, Team Collaboration, Attention to Detail.

Projects

Adventure Works Sales Dashboard – Power BI

→

Summary

Developed an interactive sales dashboard for Adventure Works using a 56,000+ row dataset, focusing on revenue, profit, and returns.

Rohit Sharma's Batting Performance Dashboard

→

Summary

Developed a comprehensive Power BI dashboard to visualize Rohit Sharma's batting performance across 532 innings, leveraging data scraped from ESPN Cricinfo.

E-commerce Sales Analysis (Python and Plotly)

→

Summary

Performed in-depth sales analysis on 5,000+ online retail transactions using Python (Pandas) and Plotly to identify key market trends.