Success story

Developing sales and finance Tableau dashboards for a global beauty brand

By Francesca Jimenez

Background

Our client is a global beauty company with a large portfolio of brands and products. In a previous project, we joined data from two schemas that separated US and UK data. This allowed the client’s data to be viewed in a single dashboard when reported in Tableau. 

For this project, Keyrus was brought on by Tableau as a trusted business partner to support the client’s continued dashboard development.

Challenge

The client was focused on further improving their dashboards, with the primary focus on profit and loss dashboards for various brands and accounts. They also wanted to improve overall financial data reporting; business users on the finance team were manually completing YoY reporting and actual performance versus various budget and forecast files in an Excel-based reporting tool.

Our Solution

Working with the client’s finance team, Keyrus built a suite of financial reports in Tableau Online. We recreated existing US and UK daily and monthly Excel reports in Tableau to create a Financial Dashboards Workbook. 

With these base reports now in Tableau, business users can work with both US and UK datasets across all dashboards within the Financial Dashboards Workbook.

Dashboard development

In addition to the base daily and monthly reports, the Keyrus team created new visual reports that gave the business a high-level view of brand and customer performance. 

The Financial Dashboard Workbook also includes dashboards for:

• Invoiced Sales by Brand

• Invoiced Sales by Customer

• Sales and Gross Margin by Geography

• Advertising and Promotional Summary and Breakout

• General and Administrative Summary

• Profit and Loss

With these dashboards, the client now has greater reporting capabilities that allow them to slice brand and account information by additional dimensions like salesperson, product type, country, and business-defined segments. 

Documentation and knowledge transfer

Going through the dashboards on a bi-weekly basis, we conducted UAT with stakeholders. We also supplied videos on navigating Tableau Online and training for the initial reporting. The client then led financial dashboard training for their broader team.  

Another part of Keyrus’ engagement was to establish proper project and permission structures so that the client’s future report distribution would have proper governance. Working closely with the client stakeholders, we defined and assigned permissions based on the project structure in Tableau Online. In some cases, we worked with the client to customize these at the dashboard level. 

Results 

Previously, the client was sending out the majority of their reporting manually through Excel as data extracts from their SQL server. Now with reporting fully built out in Tableau, business users save time with automated dashboards. 

Members of the finance team were running manual reports for actual performance versus budget forecast files once a day. With their data migrated to Tableau Online, these reports run automatically at the client’s set cadence. 

The Financial Dashboards Workbook provides the client with greater insight into their sales and marketing efforts, empowering them to make data-driven decisions to expand business efficiently.