Portfolio - Rahul Yadav

Excel Project

Sales Optimization Engine

I delivered 2 game-changing reports to the sales team. The first dives deep into customer performance, revealing hidden opportunities. The second provides a clear picture of market performance vs. targets, allowing them to adjust strategies for maximum impact.

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

Project: Sales Optimization Engine
Impact: I developed a dynamic sales report using Excel pivot tables, empowering businesses to unlock hidden revenue streams. This report goes beyond basic data - it provides actionable insights for:
Strategic Discounts: Identify optimal discounts for different customer segments, maximizing profitability and customer satisfaction.
Win-Win Negotiations: Equip your sales team with data-driven insights to negotiate confidently and close more deals.
Global Expansion Roadmap: Uncover promising countries with high sales potential, guiding strategic expansion decisions.
Key Learnings:
Advanced Excel Skills: Mastered pivot tables, Power Query, DAX fundamentals, and conditional formatting to create visually compelling reports.
Sales Analytics Expertise: Gained in-depth understanding of sales domain metrics to translate data into actionable insights.
This project goes beyond reporting - it's a strategic tool for sustainable business growth!

Excel Project

Performance Scorecard: Measuring Your Financial Success

I developed 3 powerful reports for the finance team. *Year-Over-Year Performance Analysis: Identify trends and opportunities for growth. * Market-Specific Profit & Loss (P&L) Breakdown: Make informed decisions by understanding profitability across different markets.

View Project
on GitHUB

Performance Scorecard: Measuring Your Financial Success

P&L Statement by Fiscal year: Provides insight on financial health of company over the years

P&L Statement by Market: Enables stakeholders to assess the country's performance and compare it to set targets.

Project Details

Performance Scorecard: Measuring Your Financial Success
Objective: Empower informed decisions with market-specific & year-over-year P&L reports.

Impact: Leverage data insights to:

Boost Profitability: Identify trends & optimize financial performance.
Mitigate Risks: Proactive risk management through data-driven analysis.
Drive Strategic Growth: Align financial planning with long-term goals.
Technical Skills: Mastered ETL (Extract, Transform, Load), Power Query, DAX & data modeling.

Soft Skills: Deep understanding of Sales & Finance, user-centric design, and report optimization.

Built a Systematic Approach: Streamlined report building for maximum efficiency.

PowerBI Project

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

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

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

Rahul Yadav

2

1

About

Key

My

Sales Optimization Engine

Performance Scorecard: Measuring Your Financial Success

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

Contact Me

Email

Github

Linkedin

Call

Rahul Yadav

Download Resume