I will build excel dashboard for retail sales and KPI reporting


About this gig
Are you spending hours combining Excel files before you can see how your business is performing?
Maybe your sales reports are manual, KPIs are difficult to track, or every management meeting starts with rebuilding the same report.
The data is there. You need a clearer way to use it.
I build Excel dashboards for retail businesses that turn scattered sales data into a structured, refreshable reporting solution.
I don't start with charts. I start by understanding the business questions your report needs to answer.
I can help you:
Clean and transform your data
Build reliable Excel data models
Create sales and KPI dashboards
Automate recurring reporting with Power Query & Power Pivot
Analyze products, stores, sales and profitability
Build interactive filters and management-ready reports
Basivc: Focused sales dashboard
Standard: Sales & KPI reporting
Premium: Executive Excel BI solution
If your business already relies on Excel but reporting is taking too much time or your numbers are difficult to trust, send me your data and reporting needs.
Let's turn your Excel data into a report you can trust.
Get to know Eric Kyuma
Business Intelligence Consultant Power BI and Excel
- FromKenya
- Member sinceApr 2024
Languages
English, Swahili
My Portfolio
FAQ
What types of data can you use?
I can work with Excel files, CSV exports, and other structured data that can be imported into Excel. Send your files before ordering so I can confirm compatibility.
Can you clean and combine multiple Excel files?
Yes. I can clean, merge, append, and transform multiple files using Excel and Power Query, depending on the selected package.
Will the dashboard be refreshable?
\Yes. Where included in your package, I can build a Power Query workflow so you can refresh the report when new data is added without rebuilding it manually.
Can you recommend the right KPIs?
Yes. I can recommend relevant KPIs based on your business questions and reporting needs, including sales, profit, margin, products, stores, and performance trends.
Should I use Excel or Power BI?
Excel is ideal for structured, refreshable reporting within Excel. For larger datasets, multiple systems, advanced sharing, or scalable BI, Power BI may be the better choice. I can help you decide.
