In the field of Business Intelligence Sarce has a dedicated team available that has accrued a decade's experience in projects for the design and realisation of B.I. applications (data warehousing, ‘dashboards' for performance monitoring – KPI and KPA, CRM analytical systems). Sarce's team combines the capabilities of defining B.I. objectives and modelling with in-depth skills in optimised data warehouse design and analysis and reporting tools.

Consultancy and Training
Consultancy activities in such a specialised and complex field allow the correct identification of the company's analysis requirements and an accurate assessment of the implementation effort and overall costs of the project, including turn-key offerings. Consultancy is delivered:
on the most widely used methodologies (Corporate information factory, Warehouse Bus, staging area, etc.);
on techniques of dimensional modelling and DFM (Dimensional Fact Model) representations;
on the impact on existing systems, on software and hardware selection;
on techniques of ETL (Extraction, Transformation and Loading) and job loading planning;
on relational and multi-dimensional models, on distinctions between and characteristics of ROLAP, MOLAP and HOLAP systems;
on the definition of corporate and detailed reporting.

Design of the Data Warehouse
The designing and creation of a data warehouse is a critical process that affects every individual aspect of the company. A satisfactory outcome requires, among other things, the following:
organisation of the project on a “spiral” basis;
knowledge of the company processes and the company's methods of operation for which the data warehouse is being implemented;
deepening of the analytical requirements and construction of a scalable reference model;
management of the interaction between the company's business components and its IT components;
high data warehouse design skills and expertise in the operation of the host database;
an in-depth knowledge of the software being used (database, ETL tools, querying and reporting tools).
Creating the ‘dashboard' for performance analysis
Performance measuring systems have experienced great success in recent years and some technologies, such as the Balanced Scorecard , are becoming established in many business set-ups. Sarce's Business Intelligence unit offers:
experience and capability in the definition of KPI and KPA in collaboration with the company;
what if simulations for identification of relationships between areas;
creation of analysis ‘dashboards' with summary indicators and detailed reports;
re-orienting of indicators used by the company to the new approaches relating to definition of the objectives and measurement of results.

Implementation of analytical CRM projects
Sarce also offers specialist skills for CRM analysis, such as:
an understanding of “customer centric” models for designing the customer's database for the analyses;
expertise in the definition of logical models for transforming information from a transactional CRM environment into an information source environment;
expertise in marketing processes in order to be able to define precise indicators which can be used for segmentation and analysis of the client's performance;
an understanding of the technical operation of the necessary software systems.
The tools
Database Oracle and Sql Server;
ETL tools such as: Oracle Warehouse Builder, MS DTS (Data Trasformation Services), B.O. Data Integrator;
Analysis and reporting tools such as: Business Objects and Webintelligence, Crystal Reports, Board , Oracle Discoverer and Reports, Strat&Go, Proclarity, MS OLAP Services.