Book Appointment


Overview

A client had requested for Ager Consulting to build an end-to-end digital solution, built specifically to capture client and appointment details associated to the business.

The requirements included:

  • Front-end data capture
  • User registration and link to Paypal account
  • Secure could data storage
  • Auto-updates to data based on specific criteria
  • Reporting functionality that can link to “live” data

Solution

The agreed solution was to build in two stages:

Stage 1
  • Build a SQL database in Microsoft Azure and created ‘triggers’ to fire when specific conditions arise during an appointment
  • Set up a virtual machine in Microsoft Azure where a Microsoft Access front-end can be deployed that links back to the Azure SQL database, allowing data entry from any device via a secure login
  • Build interactive reports that links to ‘live’ data

Ager Consulting are experts in creating interactive data visualisations and interactive reports, we use Power BI, Qlik Sense and Qlik View to deliver world-class solutions for our customers. Power BI was chosen as the solution for this project due to its ability to link directly to securely Azure SQL database tables. The desktop version is free to use and also provides a cost effective secure online portal.

Stage 2

Once the initial stage one system had been set up, a web-based portal would be designed that would replace the existing Microsoft Access front-end. The system would then be ready to use worldwide for multiple users and would allow paid subscriptions via Paypal.

 

Result

Stage 1
  • Built successfully using SQL Server 2014 with the database stored in a Microsoft Azure SQL database specifically designed for data entry to suit exactly how an appointment occurs
  • Virtual machine set up in Microsoft Azure with a Microsoft Access front-end deployed where the user can use the system “live” with clients during each appointment to capture details
  • Power BI report created and linked direct to “live” data so when data is entered during n appointment, the data feeds through to the Power BI report instantaneously
Stage 2
  • Web front-end system built using CodeIgnitor, PHP, Javascript, Ajax and HTML that links to the background Microsoft Azure SQL database, allowing users to add, modify and delete records
  • Login system allowing the registration of users who can then subscribe to the website, with payment linked to Paypal
  • Admin portal to manage all users and data entries

The client is extremely happy with the approach and also the stage 1 solution to get them ‘up and running’ whilst the web-portal is being built. Ager Consulting have worked with the client at a pace that suits their needs and budget.