Relational Solutions Blog

Reason #7. What Makes POS Data so Difficult to work with for CPG Data Scientists?

Posted by Janet Dorenkott

Tue, May 19, 2015 @ 10:04 AM


  Point of sale data comes in many different formats. Those formats all need to be transformed into a common data type in order to report off that data. An enterprise architecture needs to be able to extract data, transform the various formats into the same data type and load the data into a format that is easily accessible.

Depending on the database you select for analysis, The various formats listed above need to conform to one single data format. In that process, data needs to be mapped, hierarchies need to be aligned, calendars need to be addressed.





Topics: Relational Solutions, Business Intelligence, POSmart, Demand Signal Repository, data integration, analytics, CPG, data scientist, analyst