Datawarehouse & Business Intelligence

Since 2000, Bridge has been implementing Business Intelligence projects in the Fashion, Retail, Manufacturing and Finance segments. Bridge projects cover the whole process, starting from the building of an Enterprise Data Warehouse which contains all the business data, certified and the integrated, till a reporting solution which support the decision making process.

The ELT process was supplemented with a phase of Data Quality to ensure data maximum reliability and accuracy. Specifically, the following checks are performed:

  • Data comparison between source systems and data warehouse system
  • Reference Integrity
  • Semantic checksi
  • Data validation checks

The ELT process provides a number of functions that allow to monitor the different stages through a simple and intuitive “User Interface”; which provides a secure and efficient processing cycle.

THE MAJOR ANALYSES THAT BRIDGE HAS PERFORMED ARE IN:

RETAIL:

  • Standard and promotional sales
  • Procurement
  • Stock and Pricing
  • Reward Schemes
  • Customer profiling and segmentation
  • Geo-marketing

FASHION:

  • Sales budgets
  • Performance of collections
  • Distribution
  • Pricing and Markdown
  • Re-orders
  • Orders and stock/li>
  • Customer profiling and segmentation

INDUSTRY:

  • Active cycle
  • Passive cycle
  • Production - planning and deviations
  • Budget
  • Quality control and assurance
  • Stock and obsolescence
  • Vendor rating

BANKING:

  • Customer rating (personal loans)
  • Data trend profiles
  • Financial dashboards and integration with company balance sheets

Case History: Geomarketing

PROBLEM

Our customer – a well-known supermarket with over a hundred stores across Italy – needed to adopt a centralized architecture for its Business Intelligence systems in order to provide a simplified and shared analysis tool able to compare sales data with socio-economic statistics.
The objective was to allow the different strategic functions (Marketing, Sales, and Development) to direct marketing and assortment policies through geo-marketing analysis of the territory, stores, and buying behaviour of their consumer-members.

SOLUTION

Bridge developed a complete Location Intelligence solution, which was shared, standardized, user- friendly and able to explain the business events dependent on territorial characteristics.
Oracle Spatial & Graph functionality was integrated on Oracle Business Intelligence Enterprise Edition and Oracle Database Exadata Machine.
Data was consolidated in a geo-datawarehouse using a geo-coding process; geographical coordinates were related to more than 1,2 million stores and customer addresses, in order to render data efficiently and immediately accessible.
An interactive map of sales reports "stores by stores", demographics, iso-distance, iso-chronus was also created and provided via web browser.

RESULTS

The solution provides reliable analysis and a consistent, monitored view of data, allowing management to improve competitiveness by avoiding what is unprofitable.

Furthermore, thanks to a unified architecture, the client has also optimized operating times and reduced operating costs by 35%.