Make data analysis easier with 5 tools

by | Mar 28, 2013 | Business Intelligence

BI_March27_AData can be defined as a set of values that belong to a set of items. If you were to look at a series of numbers stored in a spreadsheet, without any labels, you would have a hard time guessing what it is. Only through analysis will it become useful to us. Because there is often so much data around us, it can be tough to actually analyze it and turn it into useful information. It doesn’t have to be so hard though.

Here’s a brief overview of five data analysis tools that you could use in your business.


One of the more common uses of data is to help a business manager make predictions. We all know predictions are among the hardest things to do. Enterprises hire staff and invest in systems solely with the aim of making predictions. If you’re a small business, you likely don’t need expensive software that is hard to use.

Enter BigML. How it works is you define and upload a set of data and format it. BigML will then take that data, help you to create a prediction model which you then can apply ‘what-if’ variables to and have it generate predictions. The site runs on credits; you pay for a set amount of credits and each part of the process – dataset, model and prediction – is worth a certain amount of credits. Prices start at around USD$6.50 for credits, which gives you 10MB of data, 5MB worth of models and 10K predictions based on this data.

Wolfram|Alpha’s Facebook Reports

WolframAlpha is a search engine that collects data and uses algorithms to interpret it. One feature of this site is that you can develop reports, one of the more useful being Facebook Reports. You can access the report feature by clicking here. Alternatively, you can go to the WolframAlpha website and search for Facebook.

This report provides users with a glimpse into their Facebook Page’s information. It provides you with information on who are the most active posters, how many shares/likes, etc. you get and other useful information in easy to read charts and graphs. The key here is that the report can show you how customers access your Page and where they come from. You could use this information to see what posts users liked and didn’t like, and provide more engaging content.

The basic version of the report is free. More advanced controls and data analysis is available for USD$4.99 a month.

Many Eyes

Many Eyes is a data analysis and visualization tool developed by IBM Research. If you already have data sets then you can upload them to the website and use one of the many different visualization tools to create charts, graphs, etc.

A cool feature of this site is that it has the ability to analyze written documents. Say for example you are writing new content for your website, you can copy and paste the content and get a visual representation of the words you use, how you connect words, etc. If you have a set of keywords you would like to use for SEO and search purposes, you can manually compare them with the visualization. If you notice that an important keyword is missing, or not represented enough, you can go through and re-write the copy a bit.

Best of all, it’s free.

Tableau Public

If you have an idea about Business Intelligence, or have worked with data on a regular basis and have sets that are structured, Tableau Public is probably the most powerful free analysis tool available for small businesses.

While powerful, it isn’t the most user-friendly of options. To get the most out of this program you are going to need to know the basics behind data analysis. If you feel comfortable with the basics, you’ll be creating dashboards, charts, interactive graphs, maps, etc. that look great and can be embedded on your blog or website. Oh yes, did we mention it’s free?


Big data is all the rage these days, it’s hard not to hear techies and data specialists talk about it. While it is an important part of many large businesses’ data analysis practices, the truth is many small businesses don’t need big data just yet. If you have simple data you need to analyze e.g., how many hours have your five employees worked this month? Why not stick with simple spreadsheets like Excel or Google Spreadsheet.

As long as you have data entered in a logical way, you can easily create graphs and charts that can help you visualize and analyze your data.

If you would like help establishing a system that can help you track and analyze your data, please contact us today, we may have a solution that works for you.

Published with permission from Source.

Related Posts

Why Understanding Technology is Crucial for Company Leaders

Why Understanding Technology is Crucial for Company Leaders

Technology is more than just a tool for improved performance at work. New technological innovations impact our daily lives in ways we may not realize. Company leaders who don’t keep themselves informed on recent technological developments may find themselves left...

Keeping Your Business IRS-Compliant

Keeping Your Business IRS-Compliant

Business owners may struggle to handle Federal Tax Information (FTI), unaware of the consequences of non-compliance. Any mishandling or mishaps in using, storing, transmitting, or disposing of FTI may result in penalties. It's imperative to comply with all the...

Hybrid Remote Work: A Viable Long-Term System?

Hybrid Remote Work: A Viable Long-Term System?

A hybrid remote work system splits time between working from home and workplace. As employers reopen workplaces amidst the pandemic, there’s an increasing concern about workers’ safety when they resume working in public offices. Many employees now prefer working for...


Give us a call and discover how great local IT services and computer support can be!