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
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.