Portfolio - Deepak Singh

Hello, I am

Deepak Singh

Data Aspirant

Resume

1

Excel
Project

1

PowerBI
Project

About

Hey there! It's Deepak here, I'm diving into the world of data with a passion for turning numbers into useful insights. Even though I have a B.sc degree, my knack for data analysis took me by surprise during my studies. I'm your go-to person for playing with Excel, PowerBI, SQL, and Python to make sense of complex data. Check out my portfolio below to see some cool projects where I've flexed my analytical muscles. Sure, I haven't clocked in any office hours yet, but my projects speak for themselves. I'm all about finding meaningful trends and telling a story with the data. My commitment to learning and improving is rock solid. Let's team up on this exciting journey into the world of data! If you're ready to turn numbers into decisions, let's connect and make things happen!

Key

Skills

Effective Communication

Stakeholder Management

Python

My

Projects

Sales Analytics Report

Created 2 reports for the sales team which will help them to evaluate customer performance and understand their market performance concerning their target.

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

AtliQ Hardware is a consumer electronics company expanding rapidly but is not able to compete with other companies using data as most of their report still exist in Excel. My goal is to implement an advanced analytics solution using Power BI that will enable the company to get insights.

Contact Me

Email

[email protected]

Github

https://github.com/DeepakPratapSingh

https://www.linkedin.com/in/deepak-singh-39b798272/

Call

+91 7068109749

Deepak Singh

Data Aspirant

Download Resume

Resume

Excel Project

Sales Analytics Report

Created 2 reports for the sales team which will help them to evaluate customer performance and understand their market performance concerning their target.

View Project
on GitHUB

Customer Performance Report: Provides net sales performance of each customer across years

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

Project Details

For this project, I made a sales report using Excel pivot tables. This report helps businesses figure out good customer discounts, talk better deals with customers, and find chances to grow in new countries. The reports give practical advice for businesses to improve how they sell things, make customers happier, and make more money.

I have learned the following:

1. Pivot table
2. Power Query
3. DAX (Basics)
4. Conditional Formatting
5. Report Beautification
6. Sales Domain Metrics

Overall, this project aims to empower businesses with the necessary tools and insights to monitor, evaluate, and enhance their sales activities. By leveraging sales data analysis, businesses can unlock new opportunities, drive growth, and stay competitive in the dynamic market landscape.

PowerBI Project

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

User-empathetic landing page as a part of dashboard design

Data modelling involving 10+ tables

Project Details

In this project, the goal is to be one report which could be used by stakeholders from sales, marketing, finance and executive team. The focus is made on the following

1. Robust Data Modeling
2. User-empathetic Report design
3. Drillable Insights

I learned the following things in this project

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

Hello, I am

Deepak Singh

1

1

About

Key

My

Sales Analytics Report

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

Contact Me

Email

Github

Linkedin

Call

Deepak Singh

Download Resume