Portfolio - Adarsh Pratap Singh

Hello, I am

Adarsh Pratap Singh

Data Aspirant

1

Excel
Project

1

PowerBI
Project

1

SQL
Project

About

Hey there!

I'm Adarsh, a Data Analyst blending a software engineering background with nearly 2 years of experience. My passion lies in extracting meaningful insights from intricate datasets.

In my prior role as a Software Engineer, I honed problem-solving and attention-to-detail skills, proving invaluable in my data-centric transition. Proficient in SQL, Power BI, Excel, and Python, I navigate complex data landscapes with precision. This unique fusion enables me to identify edge cases and excel in intricate data scenarios.

Dedicated to growth, I eagerly embrace new opportunities in data analysis. My portfolio showcases impactful business projects using my toolkit. Let's team up and explore ways to drive data-informed insights, creating a meaningful impact together! Ready to embark on this journey? 😉

Technical

Skills

Excel

PowerBI

SQL

Python

Stakeholder Management

Effective Communication

My

Projects

Sales Analytics (FMCG)

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

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

AtliQ Hardwares, a rising star in consumer electronics, faces a data dilemma using Excel for reports, hindering competitiveness. My solution? Propel them forward by implementing Power BI for advanced analytics—a game-changer to unlock valuable insights and drive decisive actions.

Finance & Supply Chain Analytics

Finance & Supply Chain Analytics (FMCG) - Optimize sales, streamline finance, and enhance supply chain. Drive growth with improved decisions and real-time insights. 📈🚀

Awards

& Certificate

Excel: Mother of Business Intelligence

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

SQL Beginner to Advanced For Data Professionals

Hackerrank : SQL (Advanced)

Programming for Everybody (Getting Started with Python)

Contact Me

Github

https://github.com/Adarsh-009

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

Adarsh Pratap Singh

Data Aspirant

Excel Project

Sales Analytics (FMCG)

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

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.

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

Project Details

In this project, I created a sales report using Excel pivot tables which will enable businesses to determine effective customer discounts, facilitate negotiations with consumers, and identify potential business expansion opportunities in promising countries. The reports generated will provide actionable insights and recommendations for businesses to optimize their sales strategies, enhance customer satisfaction, and maximize revenue generation.

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 Dashboard for Finance, Sales, Marketing and Supply Chain

View Project
Engagement

View Project
on GitHUB

User-empathetic landing page as a part of dashboard design

Data modelling involving 10+ tables

Project Details

This project aims to create one report that stakeholders from sales, marketing, finance and executive teams could use. 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

Live Interactive Dashboard

SQL Project

Finance & Supply Chain Analytics

Finance & Supply Chain Analytics (FMCG) - Optimize sales, streamline finance, and enhance supply chain. Drive growth with improved decisions and real-time insights. 📈🚀

View Project
on GitHUB

Gross Sales Report: Monthly Product Transactions

Forecast Accuracy Report

Project Details

Project: Finance & Supply Chain Analytics Using MySQL

Sales Report Highlights:
🎯 Objective: Optimize sales growth and market analysis.
💼 Benefits: Improved customer segmentation & personalized sales reports.

Finance Report Highlights:
💼 Objective: Streamline financial reporting & analysis.
🎉 Achievements: SQL queries, fiscal year function & gross sales reports.

Supply Chain Analytics (FMCG)
Supply Chain Highlights:
🎯 Objective: Enhance supply chain efficiency & inventory management.
💼 Benefits: Real-time data updates & improved decision-making.

⭐ Key Learnings:
1)User-Defined Functions
2)Stored Procedures
3)Event Scheduling
4)Common Table Expressions (CTEs)
5)Database Triggers for Real-Time Updates
6)Optimizing Query Performance
7)Data Integration with Temporary Tables

Full Name *

Email *

Phone Number *

I want to know about: *

I agree to use my communication details for further communication from codebasics.

Hello, I am

Adarsh Pratap Singh

1

1

1

About

Technical

My

Sales Analytics (FMCG)

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

Finance & Supply Chain Analytics

Awards

Contact Me

Github

Linkedin

Adarsh Pratap Singh