Solution: Data Analytics & Machine Learning Industry: Retail Chains Core sector: Wholesale Retail

Sales & Product Analysis with Power BI

Power BI Gateway Automation
Filters for Stores, Products, Vendors & Sales
Better Decision Making

The Challenge

House of Champagne have been operating for almost 10 years. While they run a number of specialist stores, the company primarily offers retail and wholesale solutions for quality champagnes and sparkling wines.

Because of this, they have undertaken consistent efforts to digitally transform their commerce solutions. Unity Group was asked to create a solution that can better analyze the sales and product information for greater business insights.

  • The company wanted to be able to filter data at every level – via product categories, store locations, vendors and even between B2C and B2B sales channels.
  • They also needed to be able to check individual warehouses (and their respective products) for updated quantities, purchase prices and more.
  • Likewise, it was also vital that the new analytical solution can view specific traders and their revenue, margins and number of units sold of each respective product.
  • In addition to this, the business required greater sales analytics and the ability to filter results for respective individuals.
  • Finally, all of the above needed to be assessed through like-for-like periods and historical data to better measure and determine successful growth.
Maciej Soporek
House of Champagne

"John Newton said – “I once was lost but now I’m found, was blind but now I see.” This quotation in a way reflects the change brought by Unity Group to House of Champagne in the area of acquired data and its analysis as well as the optimization of purchasing, sales and logistics processes."

The Solution

  • After initial talks and a review of the current system, work started with importing the existing database into Power BI.
  • This was then aggregated under various custom-designed database views to match House of Champagne’s specific needs within the tool.
  • As part of this process, custom filters were set up to separate data – including the breakdown of all sales data into income, margins and units sold, in addition to other filters and slices.

The Result

Power BI Gateway Automation
Building necessary technical foundations for the overall solution.
<efficiency. Implemented>
Filters for Stores, Products & Vendors
Easy access to detailed information about business performance at different levels.
Better Decision Making
Providing management with top-class tools to drive the business in the right direction.
Real Time Information
Ability to respond to market changes quicker and more effectively.

What We Learned

Thanks to the new system, all implemented within Power BI’s user-friendly interface, House of Champagne now have more analytical control than ever before. Because data can be sliced in various ways – via product, category, location, sales representative and specific vendor, to name a few – the company is able to gain the exact insights needed to move forward. Furthermore, with the ability to compare sales periods, warehouses and other like-for-like factors, it’s even easier to both determine and measure success.

The Technologies
/ Behind Solutions

We Can Help You
As Well

This is just one example of the expertise we can bring to your company. Every project is different - so is every answer. Get in touch and let's work on something new, together!