For any Data Management or business intelligence (aka information management)
work of any significance, excel is not the right tool (unless it is used just
for front end and is not the repository of Data). The reasons are as follows:
- Data Integrity: You can send the excel files via email, they can be changes
by different users, there can be separate version floating across in the system,
they don't have the way to synch up with the data in company databases. For
example the customer master in an excel file could be totally out of synch
with the customer master in your ERP systems.
- Its difficult to refer to common meta-data to manage data on excel.
- The scalability of excel.
These are few of may reasons that excel should not be considered as a tool
to do any initiative of significance.
|
