Rajveer Prajapati
"Excel wizard crafting dashboard that drive real revenue"
New to Contra
Rajveer is building their profile!
I recently completed an Excel-based Sales Performance Analysis Project using a structured sales dataset.
The project focuses on analyzing revenue, profitability, customers, products, regions, discounts, and order performance.
🔹 Key Analysis
• Total Sales: ₹1,70,350
• Total Profit: ₹23,970
• Profit Margin: 13.08%
• Customer & order metrics
• Regional sales performance
• Category-wise sales analysis
• Product performance
• Profit and discount analysis
• Payment mode analysis
🛠️ Excel Skills Used
• Data Cleaning & Preparation
• Excel Formulas & Calculations
• KPI Cards
• Pivot Tables
• Sales & Profit Analysis
• Dashboard Design
• Business Insights & Reporting
🎯 Project Goal:
To transform raw sales data into meaningful KPIs, visual analysis, and business insights that can support better sales and profitability decisions.
Project Link: https://github.com/rajveer7489/sales-financial-kpi-dashboard
0
11
📊 Excel Sales & Employee Data Analysis Project
I recently completed an Excel-based data analysis project focused on Sales Performance and Employee Analysis.
🔹 Sales Analysis
• 50 sales records
• Product & category performance
• Regional sales analysis
• Total sales and order KPIs
• Date-based analysis
• Pivot Tables & charts
🔹 Employee Analysis
• 30 employee records
• Department & job-title analysis
• Salary analysis
• Years of experience
• Salary Rating & Experience Status
• VLOOKUP-based analysis
🛠️ Excel Skills Used
• Data Cleaning
• Formulas & Functions
• VLOOKUP
• Pivot Tables
• KPI Analysis
• Data Categorization
• Business Reporting
This project helped me practice turning raw business data into structured analysis and actionable insights.
Project Link: https://github.com/rajveer7489/sales-employee-analysis
0
15