Aggregation of data is done from diverse multiple sources as below:
ERP: SAP,Oracle, MS Dynamics , custom ERP etc
Databases: Oracle,SQL Server,MySQL etc
Files: Text,PDF,Excel etc
Integrate, transform and improve data to optimize business processes and accelerate performance. This enables
Information based assessment ,Data standardization, and Data transformation
Data Ingestion into Data Storage (ETL/ELT)
Data ingestion is the transportation of data from assorted sources to a storage medium where it can be accessed, used, and analyzed by an organization. The destination is typically a data warehouse, data mart, data lake etc.
Data Cleaning / Cleansing
Data cleansing or data cleaning is the process of detecting and correcting (or removing) corrupt or inaccurate records from a record set, table, or database and refers to identifying incomplete, incorrect, inaccurate or irrelevant parts of the data and then replacing, modifying, or deleting the dirty or coarse data.
Improved production efficiency
Before you start working to improve your organization productivity, it’s important to measure it. That’s often easier said than done, This will help you to get the job done.