I will perform a migration assessment of moving Excel VBA Reporting to Power BI

Microsoft Office 365 / Microsoft Power BI
  • Not rated yet
  • 30 days
I get a huge buzz from taking clients’ problems and creating solutions that work and can be maintained easily long term. I am even more passionate about training others to problem solve. If I can get another person to taste the buzz of technical problem solving, then I have achieved my goal. I firmly believe data presentation should be beautiful, showing the hidden trends, allowing management to explore data easily. I train and consult in SharePoint, Flow, PowerApps Power BI and VBA

100% Secure

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.

Job Description

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.

Other jobs by lauragb

I will coach you for 2 hours in creating Approval Flows I will coach you for 2 hours in creating Approval Flows
I will coach you for 2 hours in creating Approval Flows
0.0 (0)
250.00 USD
I will create a PowerPoint template branded for your company or event. I will create a PowerPoint template branded for your company or event.
I will create a PowerPoint template branded for your company or...
0.0 (0)
150.00 USD
I will promote your product or service at an Event I will promote your product or service at an Event
I will promote your product or service at an Event
5.0 (1)
50.00 USD