Looking for a data visualization framework [closed]

Question

(I know there are post about data visualization, but none of them completely answered my question.)

I am looking for a tool to generate charts from data. I want to tool that is be able to do some computation for me, not only show the data a nice way.

For example here is data from tests I run:

{
    "destination" : "30be317c-e586-4448-8fed-1a9481710670",
    "source" : "30be317c-e586-4448-8fed-1a9481710670",
    "userStatus" : "UNDEF",
    "testName" : "VolumeUp",
    "testStatus" : "WORKED",
    "testStart" : 1323378809108,
    "testEnd" : 1323378809108
}, {
    "destination" : "30be317c-e586-4448-8fed-1a9481710670",
    "source" : "30be317c-e586-4448-8fed-1a9481710670",
    "userStatus" : "FAILED",
    "testName" : "VolumeDown",
    "testStatus" : "FAILED",
    "testStart" : 1323378814065,
    "testEnd" : 1323378816077
}

Note this is currently in JSON, but I can transform it to XML or push it to a database if needed.

What I would like to have is a way to tell the tool:

Create a table with:

• Column one: number of "testStatus" : "WORKED"
• Column two: number of "testStatus" : "FAILED"
• Column three: percentage between one and two.
• Rows: "testName"
• Show the percentage higher than 90% in green

The calculations remain very basic. I did some research and found tools that do it (JasperReport, SpagoBI, RapidMiner) but all of them seem to be too much of a pain to generate easy reports like mine.

Is there a tool/framework that could help me doing that? Or will I have to do the calculations by myself and use a tool like Google Visualization API to show the output?

Thanks

Answer 1

I am not sure if understand correctly.

I understand that you have some data in json format. You can convert this data to xml or load to a database. And you need to visualize this data with special calculations and/or conditional formatting.

The first tool you can use is Excel. You can use Excel's built-in functions to process and visualize your data. I believe that Excel will be enough for your requirements.

If you are going to design a cube with your data you have 2 options. First, you can make these calculations at cube level or you can use the features of the tool you use to visualize your data.

If you design a cube, you can also use Excel. But if you need a more advanced tool, my first suggestion will be TARGIT because of it's ease of use. You can also use QlikView or Tableau. For more advanced solutions, you can go for Microsoft's SharePoint or OBIEE.