
Open
Posted
•
Ends in 3 days
I need a clean, well-structured Excel workbook that lets me drop in raw performance-metrics data and immediately see customer segmentation, trend analysis, and behavioural insights without any extra manual work. Structure & flow • One “Raw_Data” tab where I can paste or Power-Query-refresh the latest export. • A calculation layer (hidden or clearly marked) that handles all formulas, dynamic named ranges, and any DAX/Power Pivot measures you think will keep things fast. • Separate, presentation-ready dashboards: – Segmentation: break customers into meaningful tiers or cohorts and surface key KPIs for each. – Trend Analysis: month-over-month and YTD views, spark lines, variance indicators. – Behavioural Analysis: visualise engagement patterns, repeat-purchase frequency, or other behaviours you recommend from the data. Acceptance criteria 1. Paste-and-refresh workflow works with no broken links or #REF errors. 2. Slicers or drop-downs let me filter by date range and customer segment in real time. 3. All calculations update instantly (under two seconds on a standard laptop). 4. Workbook is handed over unlocked, with a short “Read-Me” sheet that explains data mapping and how to extend the model. Preferred tools: native Excel formulas (including LET/LAMBDA if useful), pivot tables, Power Query, and Power Pivot where they add speed or flexibility—use what suits the task best, just keep it maintainable. Send the finished .xlsx file plus any supporting query files. Once I confirm the dashboards produce the expected results against my sample data, the project is complete.
Project ID: 40380327
8 proposals
Open for bidding
Remote project
Active 20 hours ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
8 freelancers are bidding on average ₹913 INR/hour for this job

I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. I read your project description and I am sure that I can handle your project. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex markets. Experienced MBA Finance as well. 3. Your project will be delivered on time with high standard 4. Assistance will be provided with number of clarifications until client satisfaction.
₹1,000 INR in 40 days
6.9
6.9

Hello, I hope you are doing well. I have carefully reviewed your project description and I'm confident that I can deliver high quality work that meets your expectations. I have experience in this field and pay close attention to detail, accuracy and timely delivery What I offer: High quality and original work. Strict adherence to instructions Timely delivery Clear and professional communication Willingness to revise until you are satisfied I understand the importance of this project and will ensure it is handled with professionalism and care. I'm ready to start immediately and can provide samples of my previous work if needed. Let's discuss more about your project, so I can get started right away. Thank you for your time and consideration.
₹750 INR in 1 day
3.4
3.4

As someone with an extensive background in Excel and VBA, I'm well equipped to create the high-quality performance metrics analysis workbook you're looking for. My proficiency with Excel means I can easily build your "Raw_Data" tab, establishing the calculation layer needed to handle all necessary formulas, dynamic named ranges, and any DAX/Power Pivot measures that will contribute to the swiftness you desire. Furthermore, I'll craft separate dashboards for segmentation, trend analysis, and behavioral analysis that are presentation-ready and tailored to your specific needs. One of my key features is my extensive knowledge of Macros and their ability to automate tasks in Excel. With this at my disposal, I can ensure a streamlined workflow that works flawlessly with your pasting-and-refreshing process while slashing down any broken links or #REF errors. I'm confident in my ability to satisfy all the acceptance criteria you'veoutlined - from implementing filters via slicers or drop-downs for real-time filtering by date range and customer segment to ensuring all calculations update instantly in under two seconds.
₹1,000 INR in 40 days
2.9
2.9

@SahyadriTech #SahyadriTech Completed Projects: 1. Hotel Booking Management & Tracking System (Excel + VBA Script) 2. Appsheet: ERP system for textile business 3. MNGL Gas Incident Tracker & Dashboard (Google Sheets + Google Data Studio) 4. Daily Expenses Tracker (Google Sheets) 5. Option Scalping Strategy Automation (Excel VBA) 6. Nifty50 Live Option Chain Dashboard (Google Sheets) 7. Binary Trading Sheet (Google Sheets) 8. Customer Data Cleaning & Sorting Tool (Excel VBA & Python) 9. Historical Stock Closing Price Analysis for 2,600 Stocks (Excel & Python) 10. Power Bi dashboard for F1 Car racing insights 11. GOLD Loan tracking in Google sheet and Google Data studio 12. Local Taxi Tracking System (Google Sheets + Google Data Studio) 13. Appsheet Milk Drivers wages and attendance system (Appsheet + Google sheet ) Key Highlights: 1. Pay only if satisfied with the work 2. Expert in Power BI, Excel, VBA Macros, Google Sheets, Google Apps Script, and Python 3. Experience in 3 American MNCs 4. Skilled in Data Analytics, Automation, and Visualization 5. Proficient in Statistical Analysis 6. Offer Long-Term Support for all projects 7. Quick Delivery with multiple revisions I can deliver any project related to Data Analytics, Automation, and Reporting with precision and reliability.
₹1,000 INR in 40 days
2.7
2.7

Hello, I can build a clean, structured Excel workbook that transforms raw performance data into instant dashboards with zero manual work after refresh. You’ll get: - A dedicated Raw_Data sheet (paste or Power Query refresh) - A clear calculation layer handling all formulas and logic - Interactive dashboards for: • Customer Segmentation • Trend Analysis (MoM & YTD) • Behavioural Insights (frequency, retention, patterns) - Slicers/dropdowns for real-time filtering - A simple Read-Me guide - Fully unlocked, maintainable file My approach is to design a stable data flow (Raw → Calc → Dashboard) so updates never break the model. I use the optimal mix of formulas, Pivot Tables, Power Query, and Power Pivot only where needed—keeping the file fast (under 2 seconds refresh) and easy to extend. The output will not just visualize data, but highlight actionable insights like customer tiers, growth trends, and behavior patterns that support real decisions. If you share your sample data, I’ll tailor the structure exactly to your needs and KPIs. Best regards, Ahmed
₹1,000 INR in 40 days
0.0
0.0

Hello, I am interested in building this Excel workbook with a clean paste-and-refresh workflow, structured calculation layer, and dashboard views for segmentation, trends, and behavioural analysis. While I am new to freelance projects in this specific area, I come from a technical background and focus strongly on structured logic, accuracy, maintainability, and clear documentation. I can create a well-organized workbook with a Raw_Data sheet, calculation/model layer, dashboard sheets, slicers or drop-down filters, and a short Read-Me for usage and extension. I understand the importance of keeping the workbook unlocked, stable, and easy to refresh without broken references or manual rework. My approach would be to keep the model simple, maintainable, and performance-focused using the most suitable native Excel features. Deliverables: * finished .xlsx workbook * supporting query files if used * Read-Me sheet for mapping and extension I’m ready to work carefully with your sample data and build the workbook as per the required flow. Best regards
₹800 INR in 40 days
0.0
0.0

Hi, I can build a clean, fully automated Excel workbook that turns your raw performance-metrics export into clear segmentation, trend, and behavioural dashboards with a simple paste-and-refresh workflow. I’ll structure the file with a dedicated Raw_Data tab, a robust calculation layer, and presentation-ready dashboards using the right mix of Excel formulas, Pivot Tables, Power Query, and Power Pivot to keep it fast, stable, and easy to maintain. The workbook will be delivered unlocked, with filters/slicers for real-time analysis and a short Read-Me sheet explaining the data mapping and how to extend the model. I also focus on usability and handover quality, so you’ll receive a solution that is practical, reliable, and ready to test against your sample data.
₹750 INR in 20 days
0.0
0.0

Hatkoli, India
Member since Apr 9, 2026
$10-30 USD
$750-1500 AUD
₹600-1500 INR
$30-250 USD
$10-30 USD
$250-750 USD
$250-750 USD
₹600-1500 INR
€8-30 EUR
₹750-1250 INR / hour
$30-250 USD
$15-25 USD / hour
$10-30 USD
$15-25 USD / hour
₹750-1250 INR / hour
$10-30 AUD
$30-250 USD
₹600-1500 INR
$30-250 USD
₹600-1500 INR