BI Solution Delivers Enterprise Reporting for Fine Wine Merchant
Case study showing how Maginus BI on Microsoft SQL Server unified data from three systems to give Justerini & Brooks self-service access to seven years of sales and margin data.
Justerini & Brooks needed dynamic reporting across sales channels, producers, and warehouses. Maginus implemented a Microsoft SQL Server data warehouse with PowerPivot that ingests real-time data from the OMS and two other systems. Within three months the warehouse held three million records, enabling 20 standard Excel reports and ad-hoc analysis for staff with varying BI skills.
Unified three source systems into a single 100 GB data warehouse
Delivered 20 standard reports plus self-service drill-down by sales, margin, producer, and location
Cut report generation time from days to minutes with 24/7 portal access
Enabled consistent data for collaboration between account managers and operations
Supports monthly growth of five million new transaction records without added IT overhead
Market overview
Want deeper analysis on vendors?
Related research
Research
Vendors
Company