5 Cool Things You Can Do With Web Pivot Table
There comes a time when any business faces a need to analyze data that was collected during a certain period. Or you were predictive enough to think about it before the project had even started.
So, you have this data, what’s next? What tool to use for data analysis?
For sure, you can start with Excel that allows to collect, analyse data and to find correlation.
BUT
You can use a lot more than just Excel and try web reporting tools for data management and analysis.
Firstly, to find your tool you should determine what your project goals are.
Thus, when you need something more like:
- Loading and managing data on the fly
- Creating interactive, fancy, customizable to your project requirements, reports
- Always have access to your reports in real-time
- Sharing all your reports with anyone just with a link online and see it on any device
It’s a reason to think about a web pivot table.
The web pivot can give you a lot more options that you can even imagine
Pivot your data
When you have these massive arrays of data and want to find any of interrelation, you rather create pivot table to group and summarize all this data mess. As an example, I will use free tool — WebDataRocks Web Pivot Table to show how it works.
All what you need to do — go and embed a short script into your webpage (it’s simple even for non-code person, believe me, just follow the example).
After, you can load your data in CSV or JSON format with one click on the Toolbar:
… and bingo! — you see your first pivot on your webpage.
Organize your data the way you want
The Pivot Table has this easy-to-apply Fields list. So you can build the needed report just by drag-and-dropping fields to the Rows or Columns boxes.
Then filter, group and sort your data in columns and rows.
Get insights with conditional and number formatting
You’ve got some interesting results while pivoting and want to highlight some important numbers to see the overall picture.
Conditional and number formatting help you to point out the most significant values and notice the deviations in data if any. You can set your own condition and choose the color. For example, you want to point out the sum of price of your products that is less than 10k with yellow colour:
Save the report and export your data
All the configurations and changes you’ve made in your report can always be saved. And just with one click you can export your results in the most common formats like PDF, Excel or HTML.
Share your reports online
When your report view is ready you can share your reports online with other users. You can also give an access not only to see it but to make other operations with the data on the grid. And more to that you can see how the result has been got — drill through and drill down the data to see the information in more detail.
There are a lot more you can get with web reporting, hope you will give it a go, especially when you can use it for free.
Maybe you will get the new insights and ideas that will cardinally rock your business, who knows?