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.
Background & Challenge
Premier Brands of America is a world-class manufacturer and packager based in White Plains, NY. Premier makes a suite of over 125 first aid, foot care, and skin care products including sprays, powders, moisturizers, callus removers, insoles, and more.
Since Premier’s products are sold at most major retail outlets in the US (CVS, Walmart, etc.), there are sales data from dozens of products, hundreds of distributors, and thousands of stores. Sorting through this data to dive deeper into sales and SKU profitability over time is a challenge. Furthermore, Premier’s various brands often experience trends that are difficult to forecast. This is important because Premier’s management wants to make sure their products are always available to customers and properly stocked on the shelves of their retailers’ stores.
Solution
Premier had no cloud analytics platform to date, so Keyrus set up an account in the AWS cloud to begin the cloud journey. We then set up a DirectConnect VPN from the cloud to their on-premise network to load data from the on-prem SQL databases. In QuickSight’s Spice backend, we cleaned up the data for modest data quality considerations (trailing spaces, number formatting, etc.) to be fully ready for dashboarding analyses.
With that data, Keyrus made a QuickSight dashboard that can analyze any key attribute by any key metric with just a few clicks from the end user. Key metrics included quantity, average price, and total sales while key attributes included products and hierarchies, product types (over the counter, pharmacy, etc.), brands, customers, and geographical areas.
Using these interactive functionalities, the Premier team can make a few selections to drill into an area of interest and then view the QuickSight Insights, which provide automated contextual analyses of the top movers by the selected metric. This becomes the starting point to drill in deeper and analyze what is recently driving the growth or decline of products and brands.
Results
As a result, the Premier IT team and management end users now have a much easier way to dive into their data. Rather than weekly analyses that take a few hours each to put together, there are fresh data, insights, and visualizations daily that allow Premier to take action sooner, especially with negatively trending merchandise and when watching products with recent price increases.
“We were impressed with how quickly Keyrus was able to leverage QuickSight to give us dramatically improved visibility into Premier’s data. This new visibility, complete with analyses and trend spotting, continuously has been helping us make better business decisions on a daily basis. Seeing where demand is spiking or lagging on a granular level is helping our supply chain team plan orders and our sales team decide the direction of our SKU offerings.” - Alexander Corsun, President & COO of Premier Brands.
About Keyrus & AWS Analytics
Keyrus is a global consultancy specializing in building modern analytics platforms in the cloud. We are an Advanced Tier AWS Consulting partner with over 20 certifications, three accredited service delivery programs (EC2 for Windows Server, Service Catalog, and Redshift) and are part of two partner programs (Solution Provider and Public Sector). Keyrus’ QuickSight Service Delivery Program helps clients leverage QuickSight to see tangible business results.
Need help with your AWS workloads? Get a free Well-Architected Review.
Never miss an insight
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.
Continue reading
Press release
Keyrus named amongst Top B2B Companies on Clutch
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
PDF Parsing with Alteryx Intelligence Suite
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
Modern Cloud Analytics in Action: Keyrus and Red Ventures
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
Pharma/Biotech GTN Summit 2022
Keyrus & Anaplan Sponsor Life Science Gross-to-Net (GTN) Summit
Press release
Keyrus Achieves AWS Data and Analytics Competency Status
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
Live Webinar: Lessons on workforce capacity planning and optimization from Optum (UnitedHealthcare)
Wednesday, November 9th, 2022 @ 12:00PM Central Time (US and Canada)
Webinar
Tableau Embedded Analytics: Optimizing insights from Salesforce data
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
How C&S Wholesale Grocers maximized ROI with an analytics center of excellence
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
Implementing a cloud security automation tool at a global consulting firm
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
Leveraging Salesforce to improve operations at Pajama Program
Keyrus partnered with Pajama Program, a nonprofit organization, to review their Salesforce architecture and improve overall operations.