Power Bi Minor fix and update
Paid on delivery
I am looking for a Power Bi expert to help me with a minor fix and update in my project. Specifically, I need assistance with fixing data connections.
Skills and Experience:
- Strong proficiency in Power Bi and experience with fixing data connections
- Ability to troubleshoot and resolve any issues related to data connections
- Knowledge of best practices for data connections in Power Bi
The necessary data for the fix is already available and ready to be used.
Ideal timeline for completion is within a week.
If you have the skills and experience required for this project, please submit your proposal.
We have a single page summary dashboard. The updates are relevantly simple and are detailed below.
Updates are as follows:-
applies to 3 gauges showing % achievment to target.
Fix formula and any associated elements to display the % towards a target value. displayed as a gauge(already on dashboard).
Target value is provided for each month and implemented in the project
Actual Value is provided for each month and implemented in the project
The % calculation is incorrect -
In simple terms if our target were 1,000 and actual is 500 then we are 50 % towards achievement , if actual is 250 then we are only 25% towards achievement and so on.
We have targets that are negative(e.g. -10,000) and positive targets.
It is also required that when data is not available for certain months (e.g. only have first 6 months of data) that this should not affect current overall data.
e.g. if each month has achieved 75% for 3 months then overall percent is expected to show 75% and when we have 6 months of data each still@ 75% overall percent should be 75%
However if the first 3 months are 75% each month and then next 3 months are 50% then expected result is 62.5% etc.
It is critical that the % actual displays correctly and only takes into account the available data.
Update the source data paths to read source data from google drive, instead of existing test data source files path.
It is expected that the powerbi project will not need to be updated when files for subsequent years are added to the folders in google drive ( discussion on the feasibility of this should be done before project is awarded)
Tidy up any colour mismatches between data values for the same data category - e.g. Gas should be represented as the same colour on all graphs.
Please note that we have on going work and are seeking to partner with a freelancer that is interested and has the capacity to take on future work. Please indicate what time you have available on a weekly basis to take on additional work
The power bi file and data files will be provided to a shortlist of bidders and will have the opportunity to clarify or withdraw - It is not expected that the bid would be raised at this point.
Task #1 is critical to the fulfilment of this job and will be the first Milestone. Project will not proceed further unless this is completed successfully
Please also state in your proposal when you can start and by what date you expect to deliver all completed work
Please provide copies as proof of your qualifications for this type of work
Project ID: #37481611