Suman

Data Aspirant

[email protected]

Hello, I am

Suman.

2

Excel
Projects

1

PowerBI
Project

1

SQL
Project

About Me

They say data holds the answers to everything—and I love being the one to uncover them!

Hi, I’m Suman, a data analyst with a Bachelor’s degree in Physics (Hons.) and a year of experience as a data scraper, where I learned the art of gathering and organizing data from diverse sources.

That experience ignited my passion for finding patterns in data and transforming them into actionable insights. Today, I bring those skills to life using Power BI, SQL, and Excel to analyze trends, build interactive dashboards, and solve real-world problems.

This portfolio is a glimpse into my journey and the projects I’ve worked on. Feel free to explore—you might just discover the magic hidden in data too!

Key Skills

Power BI

Microsoft Excel

MYSQL

Effective Communication

Problem Solving

My Projects

CodeX Marketing Analysis

Domain/Function: Marketing

Business Insights 360

Domain/Function: Brick & Mortar and E-commerce

Sales And Finance Analytics

Domain/Function: FMCG

Adidas Sales Insights

Domain/Function: E-Commerce and Retail

My Experience

Data Scraper – Gmware Pvt Ltd, Mohali
Mar 2023 – Mar 2024

Scraped data from 100+ websites, including Uber Eats, Walmart, Amazon Fresh, and Drizly, using Bright Data software and JavaScript, contributing to a 30% improvement in data availability for Project JENDA.
Collected and structured over 10 million records monthly in JSON format, ensuring 99% accuracy and consistency for downstream processing.
Managed and loaded large datasets into XLSX files with up to 5 million rows per file, optimizing workflows and reducing data processing time by 25%.
Streamlined task management and project coordination using Jira, which increased team productivity by 20% and ensured 100% on-time project delivery.
Developed and optimized data scraping pipelines, reducing data retrieval time by 40% and improving overall efficiency for high-demand projects.
Collaborated with the development team to resolve data inconsistencies and integration challenges, achieving a 95% issue resolution rate within set deadlines.
Played a key role in managing large-scale data operations and ensuring compliance with project-specific requirements, contributing to the successful execution of Project JENDA.

Awards & Certificate

Excel: Mother of Business Intelligence

Get Job Ready: Power BI Data Analytics for All Levels 3.0

SQL Beginner to Advanced For Data Professionals

Accenture North America Data Analytics and Visualization Job Simulation

Tata Data Visualization: Empowering Business with Effective Insights Job Simulation

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.

Mail Me

[email protected]

https://www.linkedin.com/in/suman-dhanda333/

SQL Project

CodeX Marketing Analysis

Domain/Function: Marketing

This project is part of the Codebasics Resume Project Challenge #6, where I analyzed survey data using SQL to generate actionable marketing insights for CodeX, a German beverage company that recently launched an energy drink in India.

View Project
Engagement

View Project
on GitHUB

Bangalore And Mumbai are the High Demand Areas.

Smriti Mandhana is relatable brand ambassador to connect with young India

Project Details

CodeX is a German beverage company looking to expand in the Indian market. A few months ago, it launched its energy drink in 10 Indian cities, and the marketing team collected 10,000+ survey responses from potential consumers.

Their goal is to:

Increase brand awareness
Expand market share
Improve product features based on consumer feedback

Problem Statement
The marketing team wanted to gain deeper insights into:

Who their target consumers are
What features customers care about
Why people prefer competitors
Which cities and marketing channels are most effective
How product development can align better with customer needs

Project video

PowerBI Project

Business Insights 360

Domain/Function: Brick & Mortar and E-commerce

AtliQ Hardwares, a consumer electronics company, is growing fast but struggles to keep up with competitors who use data effectively. Most of their reports are still in Excel. My aim is to set up a smart analytics system using Power BI. This will help the company in making smarter decisions.

View Project
Engagement

View Project
on GitHUB

User-empathetic landing page as a part of dashboard design.

Data Model: Incorporating 10+ Tables.

Project Details

In this project, I aimed to create a single, comprehensive report for stakeholders across sales, marketing, finance, and the executive team. My focus areas included:
1. Robust Data Modeling
2. User-empathetic Report design
3. Drillable Insights

What I learned:
1. Power Query (Basic and Advanced Operations)
2. Basic and complex DAX formulas
3. Data modelling involving 10+ tables
4. Choosing the right visuals and formatting
5. Dashboard designing principles
6. Using bookmarks
7. Deploying in Power BI service
8. Stakeholder Feedback Implementation
9. Sales, Marketing, Finance & Supply Chain metrics.

Live Interactive Dashboard

Excel Project

Sales And Finance Analytics

Domain/Function: FMCG

The goal of this project is to deeply understand how the company is doing financially and where it stands in the market. I have created different reports like "Customer Net Sales Performance" and "Market Performance vs. Target" using basic and advanced Excel skills.

View Project
Engagement

View Project
on GitHUB

Market performance vs Target report across years: Enables stakeholders to assess the country's performance and compare it to set targets.

The Customer Performance Report reveals the net sales performance of each customer over multiple years.

Project Details

In this project, I've developed a dynamic sales report using Excel pivot tables, offering businesses invaluable insights into customer discounts, negotiation strategies, and untapped markets. These reports provide actionable recommendations, empowering businesses to refine sales tactics, elevate customer experiences, and maximize revenue.

Throughout this journey, I've honed skills in:

1. Pivot tables
2. Power Query
3. Basic DAX functions
4. Effective Conditional Formatting
5. Report Presentation
6. Sales Domain Metrics

The primary goal is to arm businesses with the tools and insights needed to monitor, assess, and optimize their sales efforts. By leveraging data-driven analysis, businesses can uncover opportunities for growth, adapt to market changes, and maintain a competitive edge in an ever-evolving landscape.

Excel Project

Adidas Sales Insights

Domain/Function: E-Commerce and Retail

This project focuses on data visualization, using an interactive Excel dashboard to analyze Adidas sales data. The dashboard includes multiple visualizations and slicers for filtering by years, products, and regions, enabling dynamic exploration of sales trends and performance.

View Project
Engagement

View Project
on GitHUB

An interactive dashboard was created in Excel to provide a quick summary of all the insights discovered during the analysis.

Sales by Region: The map chart visualizes sales across different regions, allowing for geographic trend analysis and identification of key Metrics.

Project Details

Data Cleaning/Preparation
In the Initial Data Preparation Phase, following tasks were performed:

Loaded the dataset into Excel for analysis.
Inspected the data and confirmed it was already clean and accurate.
No further data cleaning was required, allowing the focus to be on visualization.
Data Analysis:
Utilized pivot charts and tables to create various visualizations and derive key insights.
Each visualization was placed on a separate worksheet for better clarity and organization.
This approach allowed for a more structured analysis and easy navigation through the dashboard.
Data Visualization
An interactive dashboard was created in Excel to provide a quick summary of all the insights discovered during the analysis, allowing for easy exploration and interpretation of key findings.