I will create excel dashboards with pivot tables and power query


About this gig
Turn your Excel data into a clear dashboard for sales, expenses or customer activity.
BASIC: One dashboard from one clean table, with up to 2 charts and 2 summary metrics.
STANDARD: One dashboard with up to 4 charts, 4 metrics, 2 slicers and one source table prepared with Power Query.
PREMIUM: One dashboard with up to 6 charts, 6 metrics, 3 slicers and up to three source tables prepared with Power Query.
A source means one structured table from an Excel worksheet or CSV file. Multiple tables in one file count separately.
Standard and Premium include basic preparation: correcting data types, removing blank rows and removing exact duplicates. Manual data entry, complex cleanup and Power Pivot models require a separate quote.
You receive an editable workbook and refresh instructions. Website scraping, live APIs, Power BI and forecasting are excluded.
Please send sample data, your Excel version and the metrics you need before ordering. Revisions cover the agreed requirements.
Get to know Iqrar Khan
Excel VBA Automation, Data Entry Forms and Reports
- FromPakistan
- Member sinceNov 2026
- Avg. response time1 hour
Languages
Urdu, English
My Portfolio
FAQ
Will my dashboard update automatically?
I provide an agreed manual update or refresh process. A refreshable workbook is not an unattended live system; scheduled refresh and live connections require separate review.
Can you clean my data first?
Standard and Premium include the stated Power Query cleaning steps. Extensive correction, missing-data research and changing source layouts need separate scope.
Do you use Power Pivot?
For a small compatible data model, simple relationships can be agreed within Premium. Complex calculations or modelling require a separate review.
Does this include Power BI?
No. The deliverable is a Microsoft Excel workbook. Tell me your Excel edition and operating system before ordering.
Can you match my company colours?
Yes. Send your colour preferences and an authorised logo. Layout revisions must stay within the agreed charts, metrics and data sources.

