Opus One Wineries

Opus One Wineries ( www.opusonewinery.com )

  1. This was an initiative exclusive initiative between the Rothschild’s family & Robert Mondavi.
  2. We designed and programmed a wine allocations model enabling sales representatives to visit distributors to allocate next year’s wine to each customer whilst incorporating historic data & trends.
  3. Customer dimensional data automatically updated in Power Pivot, SQL Server & SSAS model. Customers to be added at will, automatically updating the Power Pivot, the Excel Data Model, SQL Server & SSAS reporting solution.
  4. Sales representatives could input and capture data through Power Pivot generated views using custom programmed functionality. This is unique for Pivot Tables, but we achieved this.
  5. Power Pivot, Power Query, customized Excel Ribbon Interface, automated customer file output
  6. Technologies used included SQL Server, SSAS, Power Pivot, Excel, VBA and Targit.

Scroll to Top