Portfolio - Sanu Kumar

Hello, I am

Sanu Kumar

Fresher

Resume

1

Excel
Project

2

PowerBI
Projects

About

Hi, I’m Sanu Kumar, an aspiring data analyst currently pursuing an MBA in Analytics and Data Science. My expertise lies in Power BI, SQL, Excel, and Python. I began my data journey with stock trading, where I analyzed Stocks market patterns and volumes. I excel at transforming raw data into clear insights for strategic decisions.

With strong communication and teamwork skills, I collaborate effectively across teams. I’m seeking entry-level Data Analyst or MIS Executive roles and am open to internships to kickstart my career in data analysis.

Let’s connect if you need a dedicated analyst to add value to your team.

Key

Skills

Python

Effective Communication

Stakeholder Management

My

Projects

Sales Analytics (FMCG)

I have generated two reports for the sales team, aiding them in assessing customer performance and gaining insights into their market performance relative to their goals.

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

AtilQ Hardwares, a fast-growing electronics firm, seeks to enhance competitiveness through a power BI analytics solution for data-driven insights and informed decision making.

Hospitality Domain Analytics

AtliQ Grands, with 2 decades in India's hospitality sector faces market share and revenue challenges in luxury/business hotels due to competition and management decisions, aiming for a resurgence. My goal in this Project is to give them data driven insights so that they can take better decision.

Awards

& Certificate

Google Data Analyst Certificate

Contact Me

Email

[email protected]

Github

https://github.com/sanukumar12199

https://www.linkedin.com/in/kumarsanusk/

Call

+91 9518471553

Sanu Kumar

Fresher

Download Resume

Resume

Excel Project

Sales Analytics (FMCG)

I have generated two reports for the sales team, aiding them in assessing customer performance and gaining insights into their market performance relative to their goals.

View Project
Engagement

View Project
on GitHUB

Customer Performance Report displays the yearly net sales performance for each customer.

This report allows stakeholders to evaluate the country's performance over multiple years and compare it to the established targets.

Project Details

In this project, I made a sales report using Excel pivot tables. This report helps businesses figure out good discounts for customers, make negotiations easier, and spot changes to expand into promising countries. The reports I made give practical advice to help businesses improve their sales plans, make customers happier, and earn more money.

I learned these things during this project:

How to use pivot tables
Power Query
Building relationship
Conditional formatting
Making reports look nicer
Metrics related to sales

Overall, this project is about giving businesses the tools and knowledge they need to look, analyze, evaluate and improve their sales. By looking at sales data, businesses can find new changes to grow and stay competitive in the changing market.

PowerBI Project

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

AtilQ Hardwares, a fast-growing electronics firm, seeks to enhance competitiveness through a power BI analytics solution for data-driven insights and informed decision making.

View Project
Engagement

View Project
on GitHUB

Designing a Landing Page that connects with users, making it an essential part of our dashboard.

Data modelling involving 10 + tables

Project Details

The aim of this project is to create a single report that can be used by stakeholders in sales, marketing, finance, and the executive team. The main focus areas are:

1. Creating a strong data structure.
2. Designing a user-friendly report.
3. Providing detailed insights that can be explored further.

During this project, I acquired the following skills and knowledge:

1. Working with Power Query, both basic and advanced operations.
2. Utilizing basic and complex DAX formulas.
3. Building data models with over 10 tables.
4. Selecting appropriate visuals and formatting.
5. Applying principles of dashboard design.
6. Implementing bookmarks for navigation.
7. Deploying the report in Power BI service.
8. Incorporating feedback from stakeholders.
9. Understanding metrics related to sales, marketing, finance, and supply chain.

Project video

Live Interactive Dashboard

PowerBI Project

Hospitality Domain Analytics

View Project
Engagement

View Project
on GitHUB

AtliQ Grands Hotels Classification

Designing a landing page that users connect with, making it a key part of our dashboard.

Project Details

In this project, the goal is to be one report which could be used by management team to make decisions. The focus is made on the following

1. User-empathetic Dashboard/ Report design
2. Drillable Insights

Hello, I am

Sanu Kumar

1

2

About

Key

My

Sales Analytics (FMCG)

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

Hospitality Domain Analytics

Awards

Contact Me

Email

Github

Linkedin

Call

Sanu Kumar

Download Resume