Its time to Migrate from Excel to dedicated Data Visualization tools ! – Databolism
Digital

Its time to Migrate from Excel to dedicated Data Visualization tools !

Source: revegy.com

With the evolution of Big Data, companies are evaluating their business from Market & Customer Research to HR analytics to internal sales figures. The importance of data is increasing many folds as we’ve entered Big Data world.

Companies are getting data driven in spite they continue using outdated tools to visualize data namely, spreadsheets. In fact, surveys suggest that 1 in 5 businesses are using spreadsheets as the main tool to communicate data internally.

While, there’s nothing technically wrong with spreadsheets; they’re excellent tools for many different jobs. But data visualization and data communication is not one of them.

According to a survey of 2,000 employees in US:

  • More than 80% would like their bosses to share more business performance information.
  • 25% of employees have, or know someone who has, left a job because they weren’t included in or privy to the business’ performance or direction.
  • And more than half of respondents said that knowing company performance data contributed significantly to their own positive performance.

Specifically, employees wish to be included in overall business performance discussions, and that indicates that key performance indicators and other data must be communicated to large groups of people at every level of the business.

And for that to work, for the data to be understood and for the communication to be effective, teams need something that can help them visualize the data more easily and effectively. What I think, We need to rethink about how we are going forward.

  1. For whatever reason Excel has a bad rap, especially among employees who don’t use it often. Whereas a data analyst who is frequently up to his eyeballs in spreadsheets might find them useful tools, people in other departments of the company may find them confusing or intimidating. That means you’ve already alienated a large portion of your audience from the get go. Many people won’t even open an email attachment in Excel, let alone get excited about analyzing them to find insights.
  2. Highlight Important KPI’s. Because you’re seeing all the raw data at once, it’s difficult to interpret what’s important and what’s not.  Visualization tools can be used to highlight the important aspects of a data set or results, but in spreadsheets, it’s hard to see the forest for the trees. You are missing the point if your team finds it hard to identify the messages or see how the data relates to their day job.
  3. Ease of Analysis.Again, especially for lay people, spreadsheets can be difficult to analyze. Worse, the volume of data presented can lead to misinterpretation, and your team could make poor choices or take wrong actions based on that misinterpretation. In addition, people only familiar with spreadsheets and their associated tools tend to make charts and graphs that often distort data, including 3D graphs and pie charts, simply because the tool (like Excel) makes them easy to create.
  4. Data Loss.Spreadsheets aren’t designed to store historical data, so often, in an attempt to keep the size of them manageable, they are “updated” and companies lose their historical data. This makes is hard or impossible to spot trends over time and compare data across longer time horizons.
  5. Even with cloud computing solutions, it’s difficult to share a spreadsheet among many team members. And, because of the possibility that data could accidentally be deleted or changed, the spreadsheet that is shared is rarely “live” or real-time. At best, it might get emailed once a week — which poses the problem of the information getting lost in team members’ inboxes.

The good news is that there are now great and inexpensive tools out there that allow companies to report in more effective ways.

Tools like Tableau and QlikView have sprung up in recent years to bring improved data visualization to the masses, and investors see data visualization as a good bet; Qlik is acquired by a private equity firm Thoma Bravo for a price tag of $3 billion.

In addition, Google recently announced a free version of its Data Studio 360 for smaller businesses and individuals, taking on the likes of Microsoft’s Power BI. It’s a scaled down version of the data visualization tool included in its Analytics 360 suite, which allows enterprise teams access to the ability to visualize data from multiple sources and create accessible reports and graphs that can easily be shared with team members across all levels of a business.

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 organization.

As always, I am keen to hear your views, please share them in the comments below.

Thank you for reading my post.

Image Source: http://www.revegy.com/

Click to comment

Leave a Reply

Your email address will not be published. Required fields are marked *

To Top