Snack Brands Australia - Customer Case Study

SnackBrands were rapidly growing and acquiring other companies. As such they had sales data in many different systems. They were currently reporting my manually consolidating figures into excel and crunching the numbers. SSW developed the glue that brought all these systems together using SSIS to grab and dump the data into a data warehouse. We worked with the business users to build a cube off that data that helped report on sales, trends, forecasting, volumes, logistics and customers. We also setup SnackBrand's SharePoint infrastructure configuring Excel services and Reporting Services integration, allowing users to easily query the cube and upload and share reports. Empowered users to create their own reports, streamlined their reporting solution by removing the manual steps. We used these technologies: SharePoint 2007 MOSS, Reporting Services 2008, SQL Server 2008, SSIS, and Excel Services