You are leaving our main website to go to our chinese website hosted in China. For legal reasons there will not be any links pointing back to the main website.
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.
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.
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.
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.
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.
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.
Stay updated on the latest articles, events, and more
Your email address is only used to send you the Keyrus newsletter and for commercial prospecting purposes. You can use the link in our emails to opt-out at any time. Learn more about the management of your data and your rights.
Press release
The Keyrus team is excited to announce that we’ve been named one of the top 1000 companies on Clutch’s platform in 2022! This is the second year that Keyrus has been recognized by Clutch as a top company and B2B leader.
Webinar
In 20 minutes, we’ll teach you how to use Alteryx Intelligence Suite to eliminate common problems and inefficiencies in accessing data from .pdf files. In the past, you’d need to run custom Python and complex parsing logic to get any usable data from a pdf. Now, you can parse PDFs with out-of-the-box features in Alteryx Intelligence Suite.
Webinar
The cloud offers new opportunities to save you time and money, allowing you to shift focus from maintaining growing servers and upgrading infrastructure to making your data work for you and the success of your business. Watch the webinar and Q&A to learn how AWS, Tableau, and Keyrus worked together to help Red Ventures migrate to a powerful cloud BI tool that created new pathways for success and a modern data culture.
Event
Keyrus & Anaplan Sponsor Life Science Gross-to-Net (GTN) Summit
Press release
Keyrus achieved Amazon Web Services (AWS) Data and Analytics Competency. To receive the designation, AWS Partners must possess deep AWS expertise and deliver solutions seamlessly on AWS.
Webinar
Wednesday, November 9th, 2022 @ 12:00PM Central Time (US and Canada)
Webinar
Want to optimize your visual analytics in Salesforce? You need the right tools. Tableau Embedded Analytics can be used to help you build and visualize reports in Salesforce.
Success story
C&S Wholesale Grocers worked with Keyrus and Alteryx to implement an analytics center of excellence to help them efficiently and effectively achieve business objectives, maximize return on investment (ROI), and standardize best practices.
Success story
Keyrus partnered with a consulting firm to build an in-house cloud security solution that would automate their verification processes and keep their information safe.
Success story
Keyrus partnered with Pajama Program, a nonprofit organization, to review their Salesforce architecture and improve overall operations.