Data and Microsoft Excel spreadsheets go hand in hand. Certainly, data analysts have a love affair with Excel, but other people in their organisations may not be so keen on it. While spreadsheets are useful for documenting data on business performance, they may alienate a number of employees from knowing what’s going on within their companies. Here’s why this matter.
Not everybody has an affinity for Excel documents like data junkies. Excel is a powerful tool for people who know how to use it to its full potential but for most workers in an organisation, it’s likely that they only have a rudimentary understanding of spreadsheets. Many people groan at the sight of spreadsheet attachments landing in their inbox, which is a big deal if their organisations use Excel documents as a primary way of informing employees about business performance.
You want to engage employees and be transparent about how the company is doing but spreadsheets may have the opposite effect, according to Bernard Marr, a leading business and data consultant.
In a blog post on LinkedIn Pulse, he explains that spreadsheets are bad at helping employees visualise data in an effective way because most people don’t like them so they avoid interacting with them, it’s difficult to interpret the raw data on display so it’s hard for people to see how the information impacts their jobs and the volume of data can be confusing.
Marr recommended using data visualisation tools like Tableau, Qlik, Google’s Data Studio and Microsoft’s Power BI for organisations to communicate internal data better to employees.
“To my way of thinking, this is the way all businesses will proceed as they begin to understand not only the importance of the data, but the importance of communicating the insights within it clearly to everyone in their organisation.”
You can read more about this over at LinkedIn Pulse.
[Via LinkedIn Pulse]