Excel & Data Analytics | Dashboards, KPI & Reporting
125
Followers
Excel & Data Analytics | Dashboards, KPI & Reporting
Clean Data. Better Decisions.
Good data work starts with accuracy.
I help organize, clean, and validate data so that spreadsheets and datasets are easier to use and trust.
From data entry and formatting to identifying duplicates and inconsistencies, I focus on keeping every detail clear and consistent.
Accuracy → Consistency → Reliable data.
Most small business owners I talk to have the same problem — their data is scattered across WhatsApp messages, paper notes, and half-filled Excel sheets.
They know something is wrong. They just don't know where to start.
Here's what I do in the first 30 minutes of any project:
✅ Understand what data you have and where it lives
✅ Identify what's missing, duplicate, or inconsistent
✅ Suggest the simplest structure that works for your business
No complicated tools. No jargon. Just clean, organised data you can actually use.
If your business data feels messy and overwhelming — let's fix that together.
Message me and we'll start with a free 15-minute consultation. 📊
3
324
Spending hours manually totalling your sales data?
SUMIFS does it in seconds.
=SUMIFS(SalesColumn, CategoryColumn, "Category A", MonthColumn, "June")
Instant totals by product, region, or month — no manual counting needed.
Clean data = faster decisions = business growth. 📊
Data expert: Fast typing, clean formatting, zero errors
5.0
Rating
6
Followers
Data expert: Fast typing, clean formatting, zero errors
This project focuses on transforming a messy, raw dataset into a structured, analysis-ready format using Microsoft Excel.
0
64
Accounts Payable (AP) Invoice Automation:
The project automates the Accounts Payable process by consolidating separate financial data files.
Using Excel’s VLOOKUP function, it links a central summary sheet (AP_Summary.xlsx) with two source workbooks to automatically fill in missing information. It reads the Vendor ID to pull the matching company name from Vendor_Master.xlsx. It reads the Invoice Number to pull the correct billing total from Invoice_Register.xlsx. This process eliminates manual cross-referencing, cuts down on data entry errors, and instantly creates a unified financial dashboard for efficient invoice tracking and accurate bookkeeping.
2
0
324
Accounts Payable (AP) Efficiency & Throughput Dashboard
I built a comprehensive operations dashboard to track invoice lifecycles, measure team performance, and pinpoint costly bottlenecks. This tool transforms raw corporate timeline data into actionable insights, helping finance leaders optimize workflows and scale their processing capacity.
Business Analyst | Power BI Dashboard Expert | Excel Automat
12
Followers
Business Analyst | Power BI Dashboard Expert | Excel Automat
Art Auction Market Intelligence
A professional Art Auction Market Intelligence Dashboard designed to provide a consolidated view of global auction performance, pricing trends, buyer behavior, regional demand, artist markets, and future growth opportunities.
What It Helps With
• Auction Performance — Track total sales, lots sold, average sale price, and sell-through rate.
• Category Analysis — Compare Contemporary Art, Modern Art, Old Masters, Post-War Art, and other categories.
• Market Trend Analysis — Monitor quarterly sales and lot-volume trends to identify market momentum.
• Regional Intelligence — Understand which regions contribute most to overall auction value.
• Artwork & Artist Analysis — Identify high-value artworks, leading artists, and top-performing auction categories.
• Buyer Intelligence — Analyze collector, institutional, fund, and dealer purchasing behavior.
• Pricing Insights — Track average sale prices over time and identify pricing movements.
• Growth Forecasting — Evaluate projected market growth and future revenue opportunities.
Business Value: Helps auction houses, art marketplaces, galleries, collectors, and investment firms make data-driven decisions around pricing, portfolio strategy, buyer targeting, market expansion, and revenue growth.
Client Note:
Built to help auction houses, collectors, and art-market teams evaluate artist performance, auction results, pricing patterns, and emerging market opportunities. The dashboard turns historical auction data into actionable market intelligence.
0
88
Esports Tournament Performance & Revenue Intelligence
A professional Esports Tournament Performance & Revenue Dashboard that provides a comprehensive view of tournament economics, audience engagement, game performance, sponsorships, regional markets, and team-level results. It brings key business metrics such as $248.6M total revenue, 1.92B viewers, 124 tournaments, $142.3M sponsorship revenue, $86.5M ticket & merchandise revenue, and 4.8M average concurrent viewers into one executive view.
What It Helps With
• Tournament Performance — Measure revenue, viewership, tournament growth, and engagement.
• Revenue Intelligence — Understand sponsorships, media rights, ticket sales, in-game items, and merchandise contribution.
• Game Analysis — Compare revenue performance across major game titles.
• Audience Intelligence — Analyze viewer demographics and identify high-value audience segments.
• Regional Insights — Identify markets with the strongest revenue and growth potential.
• Team Performance — Compare top teams by revenue and tournament wins.
• Sponsorship Strategy — Identify commercial opportunities and evaluate sponsorship contribution.
• Growth Planning — Use viewing and revenue trends to support future tournament and market expansion decisions.
Business Value: Helps esports organizations, tournament operators, gaming platforms, media companies, and sponsors make data-driven decisions around monetization, sponsorships, audience growth, team strategy, and international market expansion
Client Note:
Designed for esports organizations and tournament operators to measure audience growth, competitive performance, sponsorship value, and commercial opportunities. The dashboard brings competitive and business metrics together in one decision-making view.
0
76
Sneaker & Fashion Resale
A premium Sneaker & Fashion Resale Intelligence Dashboard designed to analyze resale-market performance across sneakers, apparel, accessories, brands, regions, and sales channels.
The dashboard combines sales, resale prices, demand, inventory, margins, brand performance, and market trends into one executive view, helping businesses identify high-value products and profitable resale opportunities.
What It Helps With
• Resale Performance — Track revenue, units sold, average resale price, and profit margins.
• Brand Intelligence — Compare brand performance and identify high-demand brands.
• Product Analysis — Discover best-selling products and products with strong resale premiums.
• Demand Intelligence — Monitor demand trends and identify emerging products.
• Pricing Strategy — Analyze retail vs. resale prices and optimize pricing decisions.
• Inventory Management — Identify fast-moving and slow-moving inventory.
• Market Insights — Compare regional performance and sales-channel trends.
• Growth Strategy — Identify profitable categories and opportunities for market expansion.
Business Value: Helps resale marketplaces, fashion retailers, sneaker businesses, and investors make smarter decisions around pricing, inventory, sourcing, product selection, and revenue growth.
Client Note:
Developed to help resale businesses identify high-demand products, pricing opportunities, profitable releases, and changing consumer preferences. The dashboard provides a consolidated view of retail pricing, resale premiums, inventory, and market demand.
0
65
Creator Economy Revenue Intelligence
A professional Creator Economy Revenue Intelligence Dashboard designed to analyze how creators generate revenue across platforms, content formats, sponsorships, subscriptions, digital products, and brand partnerships.
The dashboard brings revenue, engagement, audience growth, monetization performance, and content insights into one executive view.
What It Helps With
• Revenue Analysis — Track revenue across sponsorships, subscriptions, advertising, merchandise, and digital products.
• Creator Performance — Identify high-performing creators and monetization opportunities.
• Audience Intelligence — Analyze audience growth, engagement, demographics, and retention.
• Platform Comparison — Compare revenue and engagement across creator platforms.
• Content Performance — Identify content formats and topics generating the strongest results.
• Sponsorship Intelligence — Evaluate brand partnerships and campaign performance.
• Growth Strategy — Discover scalable revenue streams and opportunities for sustainable growth.
Business Value: Helps creator agencies, media companies, talent managers, and digital platforms make smarter decisions around monetization, partnerships, content strategy, audience growth, and revenue expansion.
Client Note:
Designed to help creator businesses and talent teams understand revenue performance across sponsorships, subscriptions, affiliate marketing, and digital products. The dashboard highlights the channels and content strategies generating the strongest commercial returns.
I build AI agents & internal tools that act on data
13
Followers
I build AI agents & internal tools that act on data
Superstore Sales Dashboard — 3-Page Power BI Report
Built an interactive 3-page Power BI dashboard using
the Superstore Sales dataset (9,994 orders across USA).
Page 1 — Sales Overview: KPI cards, monthly trend,
regional breakdown, category performance.
Page 2 — Product Performance: Top products, category
donut, profit analysis, sales vs profit scatter.
Page 3 — Customer & Shipping: Segment breakdown,
top 10 customers, monthly growth, ship mode distribution.
Tools: Power BI, DAX, Superstore Dataset
Theme: Dark professional with interactive year filter.
0
221
I specialize in data cleaning and preprocessing, ensuring your spreadsheets or databases are accurate, well-formatted, and ready for analysis or reporting.
What Ill do for you:
Remove duplicates, nulls, and inconsistencies
Standardize date, text, and numeric formats
Fix spelling/case issues
Split/merge columns (e.g., names, addresses)
Convert file formats (CSV Excel SQL)
Python or SQL-based advanced cleaning (if required)
Supported formats: Excel, CSV, Google Sheets, SQL dumps
Clean, fast & confidential service
100% satisfaction guaranteed
Message me before ordering so I can understand your dataset and goals!
0
631
Data Analytics Project – Subscription Model Analysis (SQL & Power BI)
Analyzed a subscription-based business model for Foodie-Fi (TastyStream), a digital platform offering on-demand global cuisine content. The objective was to understand customer journeys, subscription transitions, and revenue performance using SQL and Power BI.
Key Contributions & Insights:
Segmented customers based on trial-to-paid and plan transitions.
Analyzed free trial behavior and conversion patterns.
Evaluated revenue performance across subscription plans.
Built interactive dashboards in Power BI for actionable insights.
Tools Used:
MYSQL, Power BI
Outcome:
Delivered a clear, insight-driven dashboard supporting data-driven decisions in a subscription-based business.
Data Analyst | Automated Excel & Power BI Dashboards
New to Contra
Data Analyst | Automated Excel & Power BI Dashboards
This project involved engineering end-to-end data validation and quality assurance workflows for multi-million row structured datasets containing text-logic outputs from Large Language Models (LLMs). Using advanced SQL scripting, I built automated auditing parameters to map hidden performance drifts and identify structural output anomalies against strict compliance metrics. This workflow successfully isolated model errors, maximizing generative precision and data safety before deployment into live software pipelines.
0
26
This project centered on engineering a high-efficiency technical support and data-triage framework to isolate platform display-logic anomalies and configuration failures. I executed deep-dive root-cause analyses on high-volume systemic defects, cross-verifying active site behaviors against preconfigured system rules. By documenting comprehensive data error logs and mapping systemic errors, I streamlined the delivery of validated defects directly to software engineering pipelines, significantly accelerating technical resolution times and creating standardized operational SOPs for global teams.
0
31
This project focused on building an automated Management Information System (MIS) dashboard for a retail enterprise using Advanced Excel and Power Query. The goal was to take messy, daily operational logs and transform them into a dynamic visual interface. By implementing robust data validation logic and optimized lookup structures, the solution completely eliminated manual data manipulation, giving stakeholders real-time visibility into sales funnels and operational KPIs while saving the execution team 5–10 hours of manual work per week.
Procurement | Strategic Sourcing & Vendor Management | SAP
New to Contra
Procurement | Strategic Sourcing & Vendor Management | SAP
My Freelancing Experience for a USA Based Handmade Products Business
📦 India Operations | 📊 Inventory | 🚚 Shipping | 🛍️ E-commerce | 📧 Marketing
I currently support a US-based handmade products business with manufacturing operations in India, managing the connection between India-side operations and customers/orders in the US.
🔧 What I Manage
📦 Order Management
Manage and track customer orders from the US.
Coordinate order processing and fulfilment with the India team.
Ensure orders are processed accurately and on time.
📊 Inventory Management
Monitor inventory levels and product availability.
Coordinate stock requirements with the manufacturing team.
Maintain visibility of products across sales channels.
🚚 Shipping & Logistics
Coordinate shipments from India to the US.
Track shipments and provide updates on order status.
Help ensure products reach customers within expected timelines.
🛍️ Faire Wholesale Management
Manage the brand's Faire wholesale platform.
Monitor incoming wholesale orders.
Coordinate order processing, fulfilment, and shipping requirements.
📧 Email Marketing
Create and manage email marketing campaigns.
Develop customer re-engagement and abandoned-cart campaigns.
Support customer retention and repeat purchases.
🔍 Market Research
Research market and customer trends.
Identify potential product and business opportunities.
Support decisions around products, customers, and marketing.
🎯 Core Areas
Order Management · Inventory · Logistics · Faire · E-commerce Operations · Email Marketing · Market Research · Customer Retention
💻 Skills & Tools
Faire · E-commerce Operations · Email Marketing · Market Research · Inventory Tracking · Order Management · Shipping Coordination · Customer Communication
🚀 Impact
I act as an operations and e-commerce support partner, helping coordinate the journey from manufacturing in India → inventory → order processing → shipping → US customers, while also supporting the brand's wholesale and marketing activities.
1
260
End-to-End Procurement & Strategic Sourcing
I managed end-to-end procurement activities across data centre and LNG operations, supporting supplier identification, RFQs, quotation analysis, negotiations, vendor selection, order processing, expediting, and payment coordination.
What I Delivered:
1. Identified and evaluated suppliers based on commercial, technical, and compliance requirements.
2. Prepared and managed RFQs and tendering activities.
3. Analyzed vendor quotations and prepared comparative statements.
4. Supported supplier negotiations and vendor finalization.
5. Coordinated vendor onboarding and compliance documentation through SAP Ariba.
6. Managed procurement trackers and maintained accurate procurement records.
7. Coordinated with Operations, Finance, Legal, Compliance, and external stakeholders.
8. Ensured procurement activities followed internal policies and governance requirements.
Tools & Skills
Strategic Sourcing · RFQ Management · Vendor Management · Negotiation · Tendering · Quotation Analysis · SAP Ariba · SAP MM · Procurement Operations · Cost Control
1
329
📋 Vendor Onboarding & Due Diligence Kit
🚀 Simplify your supplier onboarding and vendor evaluation process with this professional Excel-based solution! This all-in-one toolkit is designed for procurement teams, sourcing professionals, supply chain managers, and businesses looking to standardize vendor qualification while reducing compliance and operational risks.
The template includes a 📄 Vendor Onboarding Form to capture complete supplier information, a ✅ Supplier Due Diligence Checklist with dropdown status tracking for document verification, and a 📊 Vendor Risk Assessment Scorecard that automatically calculates weighted risk scores and provides an overall vendor risk rating.
✨ Key Features
🏢 Professional Vendor Information Form
📑 Comprehensive Due Diligence Checklist
✅ Dropdown-Based Status Tracking
📂 Document & Compliance Verification
⚖️ Automated Weighted Risk Assessment
📈 Auto-Calculated Vendor Risk Score
🎯 Standardized Supplier Evaluation Process
📝 Fully Editable & Easy to Customize
💼 Corporate-Style Design
⚡ No Macros Required – Simple Excel Formulas
🎯 Perfect For
✔ Procurement Teams
✔ Supply Chain Professionals
✔ Vendor Management Offices
✔ Manufacturing Companies
✔ EPC & Construction Firms
✔ Startups & SMEs
✔ Consultants & Procurement Freelancers
Whether you're onboarding a new supplier or conducting periodic vendor reviews, this template helps you maintain consistency, improve compliance, minimize supplier risks, and make smarter procurement decisions—all within a clean, professional, and easy-to-use Excel workbook. 📊✨
1
201
Hi, I’m Ameya 👋
I’m a Procurement & Operations professional who combines procurement expertise, data analytics, and technology to help businesses work smarter.
I specialize in strategic sourcing, vendor management, procurement operations, SAP MM, process improvement, data analysis, and reporting.
I enjoy turning complex processes into simple, efficient, and data-driven workflows — whether it’s improving procurement processes, building reports, managing vendors, or automating repetitive tasks.
🚀 Open to freelance, remote, and project-based opportunities.
Let’s build something efficient together.