Money is held until Job is done
- You pay only the listed price without any hidden costs.
- Money is held securely in Stripe until you are happy with the work.
- Meaning you can have confidence in your delivery.
How many companies have VBA based reports written years ago by someone who has now left the business and no-one has the time or skill to modify them?
Power BI and Excel\'s Power Pivot both use Power Query to transform data into structured data formats ready for reporting. Many complex transformations can be done with no coding knowledge required. I\'ve written VBA for 20 years and 80% of them have been reporting solutions and they could all be done in Power BI or Power Pivot quicker, faster and easier to maintain.
I will advise which parts of the VBA reporting function will be easy to transfer and which will require more complex solutions. In your 3 hours you will receive the following
- Assessment of existing data imports functions
- Assessment of data transformation routines
- Assessment of final reports and visualisations
- Report giving advise on how easy to move the above functions to Power BI or Power Query based Excel report
The work will need to involve online based discussion and offline work by myself. This needs the VBA Report to still be working and sample data to be available where possible. It does not require the staff to understand VBA.
If required the assessment can include a training plan to up skill staff to build the report or a quote for the report to built for you.