Fully Automated Dashboard with Excel VBA

A local airport operator seek us out to create a fully automated dashboard using Excel VBA. The airport operator collects customer satisfaction surveys using iPads and the results are stored in an Oracle database.
Automatic

Client Problem:

A local airport operator seek us out to create a fully automated dashboard using Excel VBA. The airport operator collects customer satisfaction surveys using iPads and the results are stored in an Oracle database. They run weekly management reports to monitor the results to management. The process was repetitive and laborious taking about 2 hours to create.

Click to see larger picture.

Our Solution:

After understanding their report logic, we created an Excel VBA application to automatically extract data from the Oracle database everyday and churned out a dashboard that emails PDF reports to various stakeholders at scheduled times. This self automated solution completely saved them human effort to create timely daily reports.

About Aeternus Consulting

Aeternus Consulting is a Microsoft Office consultancy and & digital creative agency. We specialise in Microsoft Office training, VBA application development, Business modeling in Excel, infographic designs, data visualizations and web UX UI.

Related Link: Aeternus Consulting Singapore

Leave a Reply

Your email address will not be published. Required fields are marked *

Wow! You made it this far?

It must be something important! Drop us a message, we’ll get back to Earth ASAP.
We are a Microsoft Office consultancy & digital creative agency. We specialise in Microsoft Office training courses, VBA application development, Business modeling in Excel, PowerPoint presentation designs, infographic designs, data visualizations and web UX UI.

Search Keywords

Excel Training Course Singapore, PowerPoint Training Course Singapore, Excel VBA Training Course.

Our Location

Location: 182 Cecil St,
Level 17 Frasers Tower,
Singapore 069547.