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%.