C&C Group

C&C Group’s coverage of the Business Intelligence discipline includes industry best practise from Inmon, Kimball and Imhoff.  It is founded upon the provision of this category of services to the utilities and pharmaceutical sector for almost ten years.

We have implemented all of the industry best practise approaches, from tactical data-marts through to large-scale operational data stores and dimensional data stores incorporating all types of dimensions, measures and schema, and have delivered projects using most of the market leading frameworks including IBM Cognos, SAP Business Objects, and MicroStrategy. We are also now delivering in Gartner's top ranking BI platform Information Builders.

• Examination and audit of currently available data warehouses, data marts, databases and data sources at your organisation.

• Documentation and analysis of any drivers for change and business requirements.

• Horizon scan for industry best practise and current trends in the adoption of new data sources; for example accessibility data, or sphere of influence and referral pattern data.

• Recommendations, where appropriate, for a new or upgraded platform to deliver the best and most cost effective business intelligence & reporting out of your data.

• Extraction Transformation Load (ETL) processes developed to new staging area.

• Base normalised schema from the raw data.

• Detailed Design Store (DDS) for accurate, fast and dynamic reporting using any business intelligence tool, including C&C Group’s own OLAPLite.

• Microsoft SSRS, SAP Business Objects, MicroStrategy, Oracle BI.

• Training to gain the most from your new information and how to use the BI tools.

• Quick, fast decision making based on accurate and up to date information from within your business.

• Single source of truth for reliable information.

• Pre-aggregated data for fast drill up and drill down analysis.

• Consistent set of key performance indicators (KPIs) to align your business.

Cisco Systems EMEA, APAC, PRIM
Global regional and sub-national sales and marketing data warehouses, data-marts, reseller reporting, data-mining: OLAPonline, AIMserver, Business Objects, MicroStrategy, Cognos, Siebel Analytics, Oracle, SQL Server.

Eurostar
European regional & sub-national data warehouse for 1-1 CRM marketing customer analysis: Business Objects, Oracle, Viper, ODS, DDS, data-mining.

GSK Europe
European regional pharma informatics, CEE data-marts, KPI dashboards: Business Objects, SQL Server, DTS, AIMserver.

IMS Health
UK informatics and data warehousing R&D and consultancy for best practise on Advance View, Early Insight, IDS, and QDB projects: Business Objects, MS Analysis, Oracle.

Lilly EU
European regional pharma informatics data warehouse, analytics, data mining: Business Objects, Oracle.

Leo UK
UK sub-national sales & marketing data warehouse. Cegedim, RSA, TNS, sales, activity, data warehouse, sales force reporting: Cognos, SQL Server, DTS.

AstraZeneca
Business Intelligence Audit and Business Intelligence Strategy consultancy.

British American Tobacco (BAT)
Scientific data management and Analytics study and future strategy: Oracle & SAS.

Elexon
Data Warehouse Consultancy, technology horizon scan, BI strategy.

Daichi Sankyo
European Business Intelligence strategy.

Wyeth Europe & UK
European regional and sub-national sales & marketing data warehouse delivered in OLAPonline with analytics, reporting, decision support, and dashboards: Multiple CRM including Siebel, Cegedim, Dendrite, and in-house. Oracle & Informatica.

Astellas Europe
European regional sales & marketing data warehouse delivered in OLAPonline with analytics, reporting, decision support, and dashboards.

AstraZeneca UKMC
UK pharma informatics. Oxygen, Dendrite, Siebel, sales, activity: Business Objects, Siebel Analytics, ODS, DDS, data warehouse, data-marts, MS Analysis, Oracle, DataStage, DTS.

Allergan Europe
European regional and sub-national pharma informatics sales data warehouse for management and in-field sales force management and incentives: OLAPonline, AIMserver, SQL Server, DTS, data warehouse.

BMS UK, Global/US
UK contracts management, global pricing analysis: Delivered in OLAPonline, AIMserver, SQL Server, DTS, ODS, DDS, ODS-lite.

Boehringer Ingelheim UK
UK national sales & marketing pharma informatics data warehouse and dashboards: Cognos Series 8, SQL Server and C&C Group AIMserver.

Veolia UK
Commercial & industrial customer and route profitability data warehouse: Business Objects, SQL Server, AIMserver, OLAPonline, MS Analysis, data warehouse, ODS, DDS, Reporting Services, DB2.