Excel MIS Dashboard Development

₹1500-12500 INR

Em Andamento

Publicado há aproximadamente 2 meses

₹1500-12500 INR

Pago na entrega

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.

Business Intelligence

Excel Macros

ID do Projeto: 40139497

Sobre o projeto

3 propostas

Projeto remoto

Ativo há 2 meses

Quer ganhar algum dinheiro?

Endereço de e-mail

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo

Seja pago pelo seu trabalho

Descreva sua proposta

É grátis para se inscrever e fazer ofertas em trabalhos

Concedido a:

@sstock935

Hello! I can build a sleek Excel MIS dashboard that auto-refreshes via Power Query, pulling your latest sales and cost data without any copy-paste. It will highlight core KPIs—overall sales, segment-wise revenue, and cost analysis—with clean bar charts front and center (plus an optional comparison view if it adds clarity). I’ll add a one-click refresh button and set robust, transparent formulas, measures, and named ranges so you can tweak sources and chart ranges easily. My expertise spans advanced Excel, Power Query (ETL), dynamic charts, and professional formatting to deliver a fast, accurate, and editable .xlsx.

₹2.850 INR em 3 dias

5,0

(10 avaliações)

2,5

3 freelancers estão ofertando em média ₹4.617 INR for esse trabalho

@debashisp1

I can build a clean, automated Excel MIS dashboard that gives you an instant, decision-ready view of sales and costs—without any manual data handling. How I’ll approach it: • Set up a structured data model using Excel Tables and Power Query so your sales and cost data refresh automatically from the source sheet (or file) • Design a single-glance dashboard showing overall sales, segment-wise revenue, and cost analysis clearly • Use bar charts as the primary visual, styled cleanly for readability, with optional supporting visuals only if they add insight • Add a one-click refresh button (or auto-refresh on open) so the dashboard always reflects the latest data I focus on clarity, automation, and flexibility—no overcomplicated macros unless they add real value. Once you share a sample of your sales and cost data (or column structure), I can move quickly and deliver a dashboard that’s both visually sharp and easy to evolve as your reporting needs grow.

₹4.000 INR em 7 dias

0,0

(0 avaliações)

0,0

@MandeepS1992

Hi, I have carefully reviewed your requirement for collecting 5,000 emails. I am highly skilled in web scraping, data collection, and Excel. I can ensure that all emails will be verified and 100% accurate. I will follow the format provided in your attachment. I am ready to start right now and will deliver quality work within the deadline. Looking forward to your response

₹7.000 INR em 7 dias