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 *

Contact Us

Drop us a message even when it’s late because the best ideas can come at night.

About Aeternus Singapore

aeternus consulting singapore logo
Aeternus Consulting is the premier consultancy firm for analyst-grade Microsoft Office training courses in Singapore. ACRA: T14LL0891K

Microsoft Office training solutions

corporate training course chair
We work with businesses and individuals who need effective Microsoft Office training solutions.

Analyst-Grade Training Courses

analytics with microsoft excel chart
Premium Training for Business Analysts, Data Analysts & Information Specialists in Singapore.

Our Services Include

Our Microsoft Office-centric services include:
* Full range of Microsoft Excel Training Courses in Singapore.
* Microsoft Office PowerPoint Training Courses.
* Consultancy in Excel, Access, VBA Application Development & PowerPoint Presentation Design Projects.
* Personal coaching & corporate bespoke Microsoft Office training sessions for employees.

Training Course List

Excel Basic, Intermediate, Advanced Levels
Excel PivotTables Inside Out
Data Management & Data Analysis in Excel
VBA Programming with Excel
Advanced VBA Programming with Excel
Essential Microsoft Excel for HR Professionals
Up to Speed with Microsoft PowerPoint
PowerPoint Design & Animation Ideas for Business
Microsoft SharePoint Training Workshop

Instagram (@aeternusconsulting)