Now that you’re familiar with the data available in Flywheel, let’s review how you can apply this information along with your existing business knowledge to gain actionable insights that can be applied to your business.
You have a few tools at your disposal to analyze your data, custom filters, column sorting, date range picker, and export functionality.
Using Custom Filters:
Apply one or more custom filters on the metrics table to narrow down the dataset your viewing to identify areas of your business that may require attention.
After you've narrowed your dataset, further refine the data by sorting the columns.
Continue your analysis outside of Flywheel using the Export functionality. All data within the table and applied filters will be downloaded to a CSV file. Use the data export to compare the performance of your KPIs period over period.
Tracking your KPIs:
The inventory KPIs you choose to track will depend on your business, here are a few suggestions.
Product Performance: Knowing your top and lowest performing products will improve inventory efficiency, follow the 80/20 rule. Sort by sales and total units sold to track products with the highest and lowest revenue.
Sell-Through Rate: Identifying which products are moving quickly and which are moving slowly will help you make decisions on future purchases. For instance, if you learn an item usually sells out every 3 months, you can plan how often to reorder the SKU.
ROI: Knowing how quickly a product moves and how much return you're getting from a product helps you make decisions about which products are worth investing in and how much you should spend on them.
Learn some actions you take to identify areas of your business that may need improvement.
Next: Inventory Dashboard Strategies