Bringing disparate data to a single unified format allows you to simultaneously use data from different sources and formats and enhances its value for collaborative analysis
Consolidation
Data grouped by different business aspects, such as sales, plans, budgets, field reports, external statistics, etc. provides better insights
Segmentation
Determination of a wide range of additional product attributes makes analysis a real value for business. Segmentation of outlets tightly aligns with sales regions
Cleansing
Most data, especially external data, requires a substantial amount of prep work before usage
Data Check
Primary data often contains varied anomalies in forms of outliers, duplicates, and missing data - it is impossible to conduct a thorough analysis unless all of these problems are eliminated
Data Mapping
Matching data from different sources and assigning a single global code across all commodity items is often a necessary basic condition for correct data analysis
Types of data
Sales data can be divided into 4 types based on the sales channel and considering plan vs. actual factor
Sell-in/Primary Sales
The amount of goods that vendors sell to distributors, retailers, or retail chains, wholesale
Sell-through/Secondary sales
Distributors' sales to retail outlets and chain stores
Sell-out/Offtakes
Store sales to end consumers
Planned
Planned sales for the current period: year, quarter, month, week, day through all analytical planning aspects