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.