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.READ MORE