Data Warehousing and BI
Since the inception of MSC the primary focus of the company has been the design and implementation of data warehousing and business intelligence solutions. Having completed over 40 successful implementations we have developed a core set of technologies and methodologies that can assist any organisation in the development of a comprehensive and robust data warehousing and performance management environment.
Over time as projects have been implemented these methodologies, templates and business focused components have been redesigned, and refined and have therefore been verified by business and technology users as being fit for purpose.
By using proven and tested components the costs normally associated with development are significantly reduced whilst the project timescales are accelerated. In addition the risks inherent in such complex IT programmes are reduced providing added confidence and peace of mind.
The core components are:
- ETL - templates and patterns for the Extraction, Transformation and Load of source data from core transaction processing systems.
- Front -end visualisation - MSC has a wealth of experience implementing dashboarding, reporting and analytical solutions. This includes:
Microsoft Office SharePoint Server 2013, including Excel Services, Performance Point Services, PowerPivot and PowerView,Tableau Desktop and Server 8.1
SSRS+: a Moore Stephens developed product offering an improved, and mobile ready, user interface for the SQL Server Reporting Services solution.
- Portal deployment - for most successful data warehousing implementations the key is the delivery of an enhanced User experience. MSC has developed a comprehensive user interface (UI), delivered through Microsoft Sharepoint, for surface analysis, reporting and KPI information, via a user friendly web navigation experience.
The components have built-in flexibility to accommodate the needs of a broad spectrum of clients, from small companies to enterprise level organisations.
In addition to our comprehensive BI expertise, Moore Stephens has a track record of developing bespoke applications for clients.