I will build a kpi dashboard in excel or google sheets


About this gig
Do you have the data but no clear picture of how the business is doing? I turn your raw numbers into a dashboard you actually use.
I am an Industrial Engineer with an MBA in Finance and 10+ years turning operating data into decisions for real companies.
WHAT YOU GET
One clean dashboard tab with your key numbers on a single screen
Revenue, margin, cost and volume KPIs with month over month change
Charts that update automatically when you paste new data
A separate raw data tab, so you never touch the formulas
Filters by month, product, client or region
Color coding so problems are visible at a glance
TYPICAL DASHBOARDS I BUILD
Sales and revenue tracking
Gross margin and cost control
Operations and production KPIs
Cash flow and collections
Budget vs actual
WORKS WITH
Excel or Google Sheets, your choice. I take CSV files or exports from any accounting or ERP system. English and Spanish.
Send me a sample of your data before ordering and I will tell you exactly which package you need.
Get to know Luis Prado
Financial Modeling and Cash Flow Forecasts, MBA Finance
- FromGuatemala
- Member sinceAug 2026
- Avg. response time1 hour
Languages
Spanish, English
FAQ
What data do you need from me?
A table with one row per transaction and clear column headers: date, category, amount, and whatever else matters to you. Excel, CSV or Google Sheets all work. If it is messy, I clean it as part of the job.
Will the dashboard update by itself?
Yes. You paste new rows into the data tab and every KPI and chart updates. In the Complete package I also add validation so bad data does not break the numbers. No macros unless you ask for them.
Can you match my company colors?
Yes. Send me your logo or your brand colors and I build the dashboard in that palette so it looks like it came from inside your company. No extra charge.

