Post by Aman Khan
operations intern at eVenture softsol private limited | MBA ā27 | TPO(FMSR) | Operations & Analytics | Six Sigma Green Belt | Excel | Power BI | SQL | team collaboration
Project Title Vendor Performance Analytics Dashboard | Procurement Intelligence Using Microsoft Excel LinkedIn Post š Project Showcase: Vendor Performance Analytics Dashboard | Microsoft Excel I'm excited to share my latest Procurement Analytics project, where I analyzed realistic vendor procurement data and transformed it into meaningful business insights using Microsoft Excel. š¹ Project Objectives Evaluate supplier performance using key procurement KPIs Compare vendors across multiple business dimensions Develop a data-driven vendor ranking system Support strategic procurement decision-making š Key Features ā KPI Dashboard ā Pivot Tables & Pivot Charts ā Vendor Spend Analysis ā Category-wise Procurement Analysis ā Monthly Spend Trend ā On-Time vs Late Delivery Analysis ā Weighted Vendor Scorecard & Vendor Ranking š KPIs Used On-Time Delivery (30%) Lead Time (25%) Cost Competitiveness (20%) Quality Score (15%) Invoice Accuracy (10%) š ļø Tools & Skills Applied Microsoft Excel Pivot Tables & Pivot Charts Excel Functions & Formulas Data Cleaning & Transformation KPI Development Conditional Formatting Data Visualization Procurement & Vendor Analytics šÆ Key Learnings š¹ Converted raw procurement data into actionable business insights. š¹ Gained hands-on experience in designing KPI-driven dashboards. š¹ Learned to use Pivot Tables and Pivot Charts for efficient data summarization. š¹ Developed a weighted vendor scorecard for objective supplier evaluation. š¹ Improved understanding of procurement metrics such as On-Time Delivery, Lead Time, Cost Competitiveness, Quality, and Invoice Accuracy. š¹ Enhanced skills in data visualization, business reporting, and decision-making using Excel. š¹ Understood how analytics can support strategic supplier selection and performance improvement. This project strengthened my practical knowledge of Data Analytics, Procurement Analytics, Dashboard Development, and Business Intelligence, demonstrating how Excel can be used to solve real-world business problems through data-driven insights. I would appreciate any feedback or suggestions for improvement. #MicrosoftExcel #DataAnalytics #BusinessAnalytics #Procurement #SupplyChain #VendorManagement #Dashboard #DataVisualization #PivotTable #ExcelDashboard #KPI #BusinessIntelligence #Analytics #ProjectShowcase #LearningJourney
