Automated Excel KPI Dashboard with Power Query by Renata LimaAutomated Excel KPI Dashboard with Power Query by Renata Lima
Automated Excel KPI Dashboard with Power QueryRenata Lima
Tired of rebuilding the same Excel report every month? I turn your raw exports into a clean, interactive KPI dashboard that refreshes in one click.
Former corporate controller in the industrial sector. I know which numbers managers actually check.
What I build. Sales, margin, cost and cash KPI dashboards; data cleaning and merging with Power Query; slicers, charts and month-over-month comparisons; formulas checked for broken links and hidden errors.
Starter, $15, 2 days. A 1-page dashboard from 1 data source with up to 4 KPIs, 3 charts and slicers. 2 revisions.
Automated, $45, 3 days. Up to 3 sources merged with Power Query, 8 KPIs, 1-click refresh and 2 dashboards. 3 revisions.
Complete Reporting System, $120, 5 days. Up to 3 dashboards and 6 sources, documented formulas and an optional Google Sheets version. 5 revisions.
Every order includes a fully editable .xlsx (no locked sheets) and a short PDF guide to update your data. Anonymized sample data welcome. Works with Excel 2016+ or Microsoft 365 on Windows. Communication in writing, here on Contra.
Automated Excel KPI Dashboard with Power QueryRenata Lima
Starting at$15
Duration2 days
Tags
Microsoft Excel
Data Analyst
Data Visualizer
Financial Analyst
KPI Dashboard
Power Query
Tired of rebuilding the same Excel report every month? I turn your raw exports into a clean, interactive KPI dashboard that refreshes in one click.
Former corporate controller in the industrial sector. I know which numbers managers actually check.
What I build. Sales, margin, cost and cash KPI dashboards; data cleaning and merging with Power Query; slicers, charts and month-over-month comparisons; formulas checked for broken links and hidden errors.
Starter, $15, 2 days. A 1-page dashboard from 1 data source with up to 4 KPIs, 3 charts and slicers. 2 revisions.
Automated, $45, 3 days. Up to 3 sources merged with Power Query, 8 KPIs, 1-click refresh and 2 dashboards. 3 revisions.
Complete Reporting System, $120, 5 days. Up to 3 dashboards and 6 sources, documented formulas and an optional Google Sheets version. 5 revisions.
Every order includes a fully editable .xlsx (no locked sheets) and a short PDF guide to update your data. Anonymized sample data welcome. Works with Excel 2016+ or Microsoft 365 on Windows. Communication in writing, here on Contra.