Video 11 KPI
New Section
In this section, the video discusses creating a coffee and understanding key performance indicators to evaluate the performance of a sales process.
Creating a Coffee
- Selecting metrics like number of orders, average price, and profit from previous data.
- Not having order numbers for components, focusing on orders for accessories and bikes.
- Filtering out unnecessary metrics like average price to focus on number of orders and profit.
- Adding additional metrics like subtotal and product cost to analyze profitability further.
- Adjusting formatting to display profits as percentages instead of decimals for better clarity.
New Section
This part delves into analyzing profits across different categories and setting performance goals based on these insights.
Analyzing Profits
- Converting profit values into percentages for accessories, bikes, and clothing categories.
- Observing profits: 62% in accessories, 41% in bikes, 44% in clothing, and 41% overall.
- Exploring categories with higher or lower profits to gain deeper insights into performance.
New Section
Setting up performance goals based on profit margins and establishing thresholds for acceptable performance levels.
Establishing Performance Goals
- Defining a base field for measuring performance using profit from sales data.
- Setting an absolute value goal of maintaining profits above 40%.
- Establishing performance thresholds: above 4% is good (green), below 3% is poor (red).
New Section
Visualizing performance goals through color-coded indicators based on profit margins achieved.
Visualizing Performance Goals
- Choosing visual styles to represent different levels of goal achievement.
- Utilizing dynamic tables to track progress towards set profit margin targets.
Visual Representation of Sales Data
In this section, the speaker demonstrates a visual method to analyze current sales data based on performance values like profits. The discussion involves filtering data by territories and exploring sales figures for specific regions.
Analyzing Sales Data
- By filtering data based on territories such as Europe, users can observe changes in sales numbers, highlighting areas where targets may not be met.
- The current analysis focuses on understanding the present behavior of the company without predictive elements. Predictive analysis would require different tools or algorithms for implementation.
- To conduct predictive analysis, additional tools and algorithms beyond the current scope are necessary to forecast future trends within the company.
Utilizing Hierarchies and Filters
- Understanding hierarchies is crucial for selecting fields effectively. Users can create hierarchies through filters or rows to observe multiple fields simultaneously.
- Creating hierarchies through filters allows users to generate nested structures for better data visualization, although some errors may occur if selections are not aligned correctly.