1 - Prioritize data sources by selecting those that will have the greatest impact on retailer decision-making
Manufacturers that are category captains may already be getting retailer POS data for planogramming and category management activities. Couple this with syndicated consumer and scan data to give strong retailers the ability to execute at store level.

2 - Design a manageable data flow schematic
For frequently updated data sources such as POS and syndicated data, identify how it will be delivered from the source. Direct transmissions of weekly or monthly extracts are the most efficient way to deliver the data. Also, make sure presentation developers are notified when new data becomes available.

3 - Eliminate redundant tasks from the data collection and updating process
Delivering data that your people don’t need or having many people pull the same data over and over again is inefficient and costly. Optimize these tasks by centralizing data collection and data maintenance activities, and delivering “slices” or “cubes” of data to remote end-users that contain just what they need and nothing more.

4 – Identify workflow bottlenecks
One common bottleneck is the lengthy process involved to integrate new items into your databases with the correct hierarchy, segmentation, and masking properties. Clear the bottleneck with step-by-step guidelines, automation, and better data knowledge.

5 - Automate repetitive tasks that do not need hands-on management
Automate lengthy and repetitive tasks such as loading data sources, appending or updating the latest data, or integrating new data sources. Automation allows for unattended processing and it can be scheduled to run on non-peak hours to minimize network traffic.