A wholly owned subsidiary of Mace, the international consultancy and construction company; Macro needed to provide their clients with a single system where they could securely log in, view and interact with their data that was automatically integrated from various line of business systems. The system needed to be accessible from external client sites at worldwide locations and be content driven based on the logged in user. Client managers need the ability to administer various parts of the system for their own departments, view dashboards of reports & be directed to areas of problematic data. They then needed the capability to compile end of month reports and summaries, and assign tasks & actions to staff members based on data discovery. All of this functionality needed to be provided in an easy to use system that didn’t require high level training to use.
To meet the requirements of the system, Dolphin IT Solutions designed a business intelligence application developed on SharePoint 2013 and hosted in Microsoft Azure Cloud. Cloud hosting meant that access by all clients both internal and external to the company could be easily achieved via a secure forms based authentication logon. The speed to market that can be achieved from cloud hosting also meant that the whole solution was delivered to the client within 3 months. SharePoint 2013 was the perfect platform to develop this application with built in features such as business intelligence, search, work flow and security. This meant development time was minimised and licencing costs were absorbed by the company’s existing volume licencing agreement. SQL Server 2012 was the obvious choice for the data warehouse backend to drive ETL with Integration Services & reporting with Reporting Services, including Analysis Services for multi-dimensional reporting and fully interactive user data analysis.