Excel MIS Dashboard Development
Budget: ₹1,500 – ₹12,500 INR
I need a sleek, Excel-based MIS dashboard that pulls in my latest sales figures, breaks them down by segment, overlays cost data, and lays everything out in clean bar charts. The workbook should refresh itself automatically—no manual copy-pasting—so linking it to a data sheet or a Power Query connection will be essential.
Here is what matters most to me:
• Core metrics: overall sales, segment-wise revenue, and cost analysis in one glance.
• Visual style: bar charts are my primary choice; if another view helps tell the story better you may add it, but bars need to be front and center.
• Data flow: set up automatic updates triggered by file refresh or a simple button, ensuring the dashboard always reflects the latest numbers without extra effort.
Deliver the finished .xlsx file with all formulas, queries, and chart formatting unlocked so I can tweak ranges later if needed.
Here is what matters most to me:
• Core metrics: overall sales, segment-wise revenue, and cost analysis in one glance.
• Visual style: bar charts are my primary choice; if another view helps tell the story better you may add it, but bars need to be front and center.
• Data flow: set up automatic updates triggered by file refresh or a simple button, ensuring the dashboard always reflects the latest numbers without extra effort.
Deliver the finished .xlsx file with all formulas, queries, and chart formatting unlocked so I can tweak ranges later if needed.