HomeData Driven Decision Making

Data Driven Decision Making

Mean

Median

Mode

Mean vs Median

Variances

Weighted average cost

Count row items

Identify outliers

Youngest vs Oldest

Average Age

Gender Diversity

Male vs Female

Difference between male and female in jobs

Older employees younger salary

Longest in company

Average tenure of employees

Average Salary

Highest Salary and Bonus

Highest paying role

Highest Bonuses employee

Wage gaps between roles

Managers vs Clerks Salary

Employment vs Wage Relationship

Employment and wage rank

Average Bonus per job

Correlation between hire date and salary

Employees per Department

Department with the most managers

Job Title Counts

Budgeting and Workforce

Strategic Impact

Total inventory value

Item contribution to inventory

Item with highest inventory value

Highest QTY on Hand

Largest GAP QTY – RQTY

Which items need to be reordered now

Below Reorder

Below Reorder Quantity

Excessive stock

High cost low stock

Location – Highest Value Inventory

Where is a SKU located

Dimension 1 – Category

Which department has the highest average cost

Analysis we could do

Copyright © 2024 CreateMyExcel.

Close