A successful business operational view gathered information from various source available from data warehouse like ERP, CRM, operational system, SQL and Flat Files, Spreadsheets.
The gathered data from various sources should check for correction and transform the data
into the accurate model through sorting and coding. Finally, load the data into the warehouse.
A data mart is one of the subsets of a data warehouse that provides end-user report.
Business intelligence delivers the information from the data warehouse for taking appropriate
decision in the normal business lifecycle. It involves three process namely static reports which
show already exist data, Dynamic reports shows interactive information and data mining refers
to statistical analyses for a pattern of interest.