Anupam Yadav

About

Business analyst with experience analyzing data, identifying business trends, and turning complex information into actionable insights. Skilled in Excel, SQL, and Power BI with a focus on KPI analysis, dashboards, and business reporting.

Experience

• Business Development Associate Intern
  Property Spotters
  Jul 2025 – Aug 2025

Education

• Bachelor of Management Studies (BMS)
  Aryabhatta College
  Management · 2026

Skills

• SQL
• Business Analysis
• Data Visualization
• Research and Analytics
• Power BI
• Data Cleaning
• Pandas
• Power Query
• DAX
• HLOOKUP
• Requirements Gathering
• Data validation
• Trend analysis
• Microsoft Excel
• Data Modeling
• Dashboard Development
• Excel
• Requirements Analysis
• KPI Analysis
• Window functions
• Subqueries
• Common Table Expressions (CTEs)

Projects

• Amazon Sales Analysis ↗
  SQL, Excel

  Analyzed 100,000 orders, 43,233 customer records, and 50 products to evaluate revenue, product performance, customer behavior, and order trends. Solved 30 business-focused analytical problems covering revenue, customer spending, product categories, payment behavior, cancellation rates, seller performance, and average order value. Identified high-value customers, top-performing products and categories, and key order patterns to generate insights supporting business decision-making and performance analysis.

• Samsung Sales & Inventory Analysis ↗
  Power BI

  Analyzed 23,852 operational records across sales, inventory, procurement, production, and shipment data to develop a consolidated view of business performance. Evaluated 8,500 sales records, 7,500 shipment records, 4,500 production records, 2,200 procurement records, and 1,152 inventory records to identify trends across the supply chain. Developed an interactive dashboard to monitor sales performance, inventory levels, supplier activity, production, and shipments, enabling centralized KPI tracking and actionable business insights.

• Google Pay UPI Insights ↗
  Excel, Pivot Table, Power Query

  Analyzed 5,155 UPI transactions across customer, merchant, geographic, banking, payment, and transaction dimensions to identify key transaction patterns and business trends. Built an interactive dashboard to track transaction value, payment behavior, transaction status, and other key performance indicators for faster analysis. Transformed raw transaction data into structured insights and visual reports to support performance monitoring and data-driven decision-making.