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.
popular business applications smb
traditional spreadsheet approach remains popular despite its tendency to be labor-intensive, time-consuming, and error-prone. Further, although Excel may be undisputedly the most widespread analytic tool, it is also quite susceptible to creating harmful multiple versions of the truth. For example, multiple users will execute the same query against one central data warehouse and unload the data into Excel. Then, one user will filter the data in Excel with a particular set of criteria and create some