Portfolio - Priyanshu Singh

Excel Project

Sales and Financial Analytics (FMCG)

Domain/Function: Sales and Financial Analytics (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
on GitHUB

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

The Market Performance vs Target report allows stakeholders to evaluate how well the country is doing and compare it against the target.

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.

PowerBI Project

Business Insights 360

Domain/Function: Finance, Sales, Market and Supply Chain

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.

Finance Insights: Unveiling key financial metrics and trends from the project's analytics dashboard .

Data Model: Incorporating 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.

Live Interactive Dashboard

SQL Project

Consumer Goods Ad-Hoc Insights

Domain/Function: Consumer Goods

Delivered 10 ad-hoc insights for AtliQ Hardware using SQL, addressed data challenges, enhancing analytics capabilities and decision-making for strategic planning. Analyzed 1.8M records, providing actionable data insights on sales trends and product performance.

View Project
on GitHUB

View Project
on

Unique Products sold in FY 2020 & FY 2021 for each segment.

Gross sales amount for the customer Atliq Exclusive for each month in Fiscal Year 2020 & 2021 .

Project Details

Company:
AtliQ Hardware is a leading player in the computer hardware industry with a strong international presence across APEC, EU, LLTAM, and NA regions.

Challenge:
- The company faced challenges with timely and insightful data for strategic decision-making, impacting their ability to optimize operations and respond to market changes.

Solution and Approach:
- SQL Analysis : Performed in-depth SQL analysis to address 10 specified business queries, extracting and manipulating data to uncover key insights.
-Tools & Skills: MySQL, PowerPoint, storytelling, stakeholder focus.
- Impact : Enhanced data analytics capabilities and facilitated informed decision-making to address data gaps and support strategic planning.

Learnings and Key Takeaways:
- Developed advanced skills in SQL for complex data analysis.
- Gained experience in creating impactful Power BI visualizations.
- Improved ability to translate data into actionable insights.

Hello, I am

Priyanshu Singh

1

1

1

About

Key

My

Sales and Financial Analytics (FMCG)

Business Insights 360

Consumer Goods Ad-Hoc Insights

My

Awards

Contact Me

Email

Github

Linkedin

Priyanshu Singh