Companies relying on an Excel or Excel-like system need to know that, while Excel might suffice for ad hoc analysis and data storage for individuals or small groups, the technological flaw of data and referential integrity prevents it from a corporate-wide, collaborative effort like planning and budgeting, not to mention product development and sourcing.
form of graphs, tables, hierarchy trees, 2-D and 3-D charts, scorecards, and top-n or bottom-n rankings. Bidirectional data integration, whereby any changes made to numbers during the analytic process can be written back to the data source from Excel. For example, this can be used to increase or decrease budget or forecast numbers after they are compared to the actual ones. Also, users should be able to create metadata layers to allow them to better understand, find their way, and select data in complex