Browse categories
Explore
Fiverr Pro
English
$
USD
I will create an automated excel dashboard with power query and interactive charts
John
Level 1
5.0
5.0
About this gig
Is your data stuck in messy spreadsheets? I build automated Excel dashboards with Power Query that turn raw, disorganized data into clean, interactive reports so you get real time KPIs and insights without touching a single formula yourself.
Whether you're tracking sales performance or need executive-ready financial reporting, I build dashboards that save hours of manual work every week and make decisions easier at a glance.
What You'll Get
- Automated Excel dashboard
- Power Query automation (connects, cleans, and refreshes your data)
- Interactive charts & slicers
- KPI tracking system
- Pivot tables & advanced formulas
- Data cleaning & transformation
- Executive-style dashboard layout
Tools & Features
- Power Query
- Pivot Tables
- XLOOKUP & INDEX MATCH
- Interactive Visuals
Every dashboard is customized to your business goals and reporting needs not a generic template.
Also available in Google Sheets message me if that's your preferred platform.
Please message me before ordering so we can go over your data and what you need the dashboard to show.
Get to know John
John
Data into dashboards ! Layouts into maps
Level 1
- FromUnited States
- Member sinceNov 2024
- Avg. response time1 hour
- Last delivery3 months
Languages
French, German, English
Hi, I'm John, a dashboard designer and map illustrator skilled in Excel, Power Query, and Adobe Illustrator.
I create clean, professional dashboards and vector maps that turn complex data and layouts into something clear and easy to use.
My focus is on functional design, clear visuals, and results that help clients make faster decisions and navigate their spaces with ease.
I'm committed to delivering work that's both practical and visually compelling.
My Portfolio
FAQ
Do I need to have Power Query installed to use this?
No. I build the automation into the file and deliver it fully working, you just open it and use it. Power Query comes built into modern versions of Excel.
Will this work with my existing spreadsheet, or do I need to start from scratch?
I can build the dashboard on top of your current data structure, or set up a clean one from scratch if that gets you a more reliable result
Can you connect this to my CRM, accounting software, or database?
For many common sources, yes. Message me with what you're using before you order and I'll confirm exactly what's possible for your setup.
How do I keep the dashboard updated after delivery?
Power Query refreshes your data automatically. I'll also walk you through the one-click refresh so you're never stuck waiting on me for updates.
Do you offer this in Google Sheets instead of Excel?
Yes. Message me and I'll confirm scope and timeline for a Google Sheets version of the same dashboard.
What information do you need from me to get started?
A sample of your raw data (even messy is fine) and a quick note on what you want to track — sales, KPIs, financials, etc. We can also hop on a quick message thread to nail down the details before you order.
Reviews
1 reviews for this Gig
| (1) | ||
| (0) | ||
| (0) | ||
| (0) | ||
| (0) |
Rating Breakdown
- Seller communication level
- Quality of delivery
- Value of delivery
Sort By
Most relevant
C cliftonmiller
United States
John was good to work with great communication.
$600-$800
Price
9 days
Duration
Helpful?
Reviews
1 reviews for this Gig
| (1) | ||
| (0) | ||
| (0) | ||
| (0) | ||
| (0) |
Rating Breakdown
- Seller communication level
- Quality of delivery
- Value of delivery
Sort By
Most relevant
C cliftonmiller
United States
John was good to work with great communication.
$600-$800
Price
9 days
Duration
Helpful?
