Opus One Wineries ( www.opusonewinery.com )
- This was an initiative exclusive initiative between the Rothschild’s family & Robert Mondavi.
- 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.
- 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.
- 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.
- Power Pivot, Power Query, customized Excel Ribbon Interface, automated customer file output
- Technologies used included SQL Server, SSAS, Power Pivot, Excel, VBA and Targit.