Excel Data Cleaning & Power BI KPI Dashboard
Worldwide
I’m looking for someone to help clean and organise an existing Excel dataset and turn it into a simple, practical Power BI dashboard for internal reporting. The data contains operational records such as dates, categories, status, team/area, planned vs actual activity, revenue and cost information and a small number of quality/performance fields. The goal is to make the data easier to maintain and create a clear dashboard that gives a quick overview of performance and highlights any exceptions or problem areas. Scope of work: Review and clean the existing Excel data Standardise inconsistent categories, blanks and duplicate records Use Power Query where appropriate so the data can be refreshed later Structure the data for use in Power BI Create approximately 5–6 useful KPIs Build a simple 2-page Power BI dashboard Add filters/slicers for key categories such as date, team/area and service/category Create an overview page showing overall performance and trends Create a second page showing exceptions/details that may need attention Check that dashboard figures reconcile with the source data Provide a short explanation of how to refresh/update the dashboard Expected deliverables: Cleaned Excel dataset Power BI .pbix file Two completed dashboard pages Basic KPI definitions Short refresh/update instructions I’m looking for a clean and practical solution rather than an overly complex BI system. The dashboard should be easy to understand and maintain.
- Less than 30 hrs/weekHourly
- < 1 monthDuration
- IntermediateExperience Level
$10.00
-
$30.00
Hourly- Remote Job
- One-time projectProject Type
Skills and Expertise
Activity on this job
- Proposals:50+
- Last viewed by client:yesterday
- Hires:1
- Interviewing:0
- Invites sent:0
- Unanswered invites:0
About the client
- GBRLuton3:04 AM
- $43 total spent1 hire, 0 active
- 3 hours
Explore similar jobs on Upwork
How it works
Create your free profileHighlight your skills and experience, show your portfolio, and set your ideal pay rate.
Work the way you wantApply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
Get paid securelyFrom contract to payment, we help you work safely and get paid securely.
About Upwork
- 4.9/5(Average rating of clients by professionals)
- G2 2021#1 freelance platform
- 49,000+Signed contract every week
- $2.3BFreelancers earned on Upwork in 2020
Find the best freelance jobs
Growing your career is as easy as creating a free profile and finding work like this that fits your skills.
Trusted by