Excel Data Visualization & Analysis
Budget: ₹12,500 – ₹37,500 INR
I have a dataset in Excel that I need turned into clear insights. Your role will be to clean and organize the raw data, run any necessary analyses, then present the results through professional-looking charts, graphs, and at least one interactive dashboard built directly in Excel.
Please structure the workbook so the visualizations update automatically when new records are added, and label everything clearly so a non-technical stakeholder can follow the story. I’m open to the techniques you prefer—Power Query, Power Pivot, or standard formulas—as long as the final file stays within Excel and remains lightweight.
Deliverables
• Charts and graphs illustrating the key metrics
• A dashboard page summarizing trends and outliers
• The underlying, well-commented workbook so I can track your logic
Acceptance criteria: the visuals must refresh with a single click, no broken links or external connections, and all findings should be easy to understand at first glance. If that sounds straightforward, let’s get started.
Please structure the workbook so the visualizations update automatically when new records are added, and label everything clearly so a non-technical stakeholder can follow the story. I’m open to the techniques you prefer—Power Query, Power Pivot, or standard formulas—as long as the final file stays within Excel and remains lightweight.
Deliverables
• Charts and graphs illustrating the key metrics
• A dashboard page summarizing trends and outliers
• The underlying, well-commented workbook so I can track your logic
Acceptance criteria: the visuals must refresh with a single click, no broken links or external connections, and all findings should be easy to understand at first glance. If that sounds straightforward, let’s get started.
Related categories:
Visual Basic
Data Processing
Excel
Statistics
Excel VBA
Data Visualization
Data Analysis
Data Management