Turn your spreadsheets into interactive reports in seconds

Nov 09, 2016

We introduce Spreadsheet Analytics. That means there is a new way to visualize and explore your spreadsheet data. Spreadsheet Analytics is an application build using ZoomCharts SDK and it shows only part of what you can achieve with ZoomCharts technology.

Let's list what benefits Spreadsheet Analytics offer:

Visualize your excel file.

You have an excel file with a lot of records in it? Would you like to see how that data looks in various graphics or charts? Maybe even use those charts to select fields, group, filter and sort on the fly? ZoomCharts Spreadsheet Analytics application does that and even more! Spreadsheet Analytics uses ZoomCharts interactive charts meaning you get a new and awesome way to explore your data.

Visual Filtering.

Touch any slice on Pie Charts to filter the data accordingly. Select time range to filter data by time.
Have more than one date column or multiple value columns? Switch to any of those using single click. All the charts interact with each other other.

Stacked TimeChart.

You can even view stacked data on TimeChart instead of just count or sum.

At the example below TimeChart data can be stacked by products, managers or source, meaning that TimeChart allows you to visually faster understand such information like how many what kind of products have been sold in particular period or who was the best manager in that period.

Look for "Stack by" button at the top-right side of the TimeChart.

Find the relevant data points.

Narrow the results using instant full-text search with search-as-you type implementation.

Your data doesn't leave your PC.

We care about your data, we have put a lot of effort to make our application safe. When you select an excel file to be processed, it's not uploaded anywhere and stays in your browser.

Even when you select an option to share report with someone, data is being encrypted before saved to our server. So the URL you receive when sharing your report is the only way to access it, so keep it safe!

Share your reports with others.

Want to send a report to some colleague? No problem. Even more - you can filter some results like specific time period and/or any other field values, and share that particular results with anyone.

Spreadsheet Analytics offer various sharing options:


  • Download shortcut - a html file that contains encrypted data and automatically posts those data to Spreadsheet Analytics. Filters are preserved. Nothing is sent to our servers.
  • Cloud sharing - an option to share your data with a link. In this case we receive encrypted data and save them to our servers. The only way to access those data is by opening a link that is generated and returned to you. Then it's fully up to you to whom you want to send that link.
  • Download json file - a file that contains all data and filters.
  • Embed - imagine your interactive report with your data embedded in your blog or website. How awesome is that?

Use on mobile devices.

Analyze your data on any device and in any situation even in your phone.

Spreadsheet Analytics consists of:
  • TimeChart - interactive chart displaying your data by date and time. It allows to stack data and group by various fields.
  • PieCharts - every column data that isn't date and coordinates is displayed in PieCharts. Interactive chart that show proportion of column values. All the charts interact between each other. Click on one chart will filter records accordingly in other charts.
  • Grid - table where filtered results are displayed. You can limit how many records can be visible.

Spreadsheet data on the map.

Spreadsheet Analytics offer you to see the data on the map with aggregated data points. All you need is data with coordinates (wgs84 formatted). We try to make your work with data easier and so you'll soon have a feature to use geocoding. All countries or addresses will be automatically converted to coordinates and displayed on the map.

Data sources.

  • Excel file - but it isn't the only supported file type.
  • ZIP file containing data formatted in json.
  • Google Docs spreadsheets - load file providing URL.
  • POST data - any table data can be visualized in Spreadsheet Analytics with just a single button.

Merge multiple data sources.

If you have more than one excel file that you would like to visualize with some similar data - you can merge those files just by selecting another file. You can do that even if you have one data in excel file and the other in google spreadsheets or json format.

Examples

With a TimeChart:

Go to example

With a GeoChart:

Go to example

Using API:

A standard table you can see in many websites. Check out how this table looks in Spreadsheet Analytics.
DateManagerSourceProductCount soldSum
2016-05-25EmilydirectBoots2153591.12
2016-05-29AndreadirectSkirt18568.96
2016-06-01EmilywebsiteJeans331063.05
2016-06-07EmilywebsiteT-shirt537.35
2016-06-08MikewebsiteJeans15510.30
2016-06-08EmilydirectHats1421844.58
2016-06-12AndreadirectT-shirt130971.10


Or simply start the free trial and try all the goods that the Spreadsheet Analytics application offers!

Start your 7 day free trial

Comments

Online Examples

See various ZoomCharts exmaples in our online examples gallery. Each of examples has sample source code exposed.

See ZoomCharts examples

ZoomCharts Pricing

ZoomCharts licensing is transparent and simple, yet widely configurable to fit your company's needs and budget.

See pricing

Use case for a Drill Down Graph PRO visual: analyzing internal email communication

With the latest 1.6 release (September, 2020), ZoomCharts Drill Down Graph PRO has become more powerful than ever, enabling users to detect patterns,... Read More

Sep 22, 2020

Use case for a graph visual: mapping subsidiaries of an international organization

ZoomCharts Drill Down Graph PRO offers multiple layout options and unseen level of interaction. In this article we will explore a use case of mapping parent... Read More

Sep 22, 2020

September 2020 product release - extended measure support, powerful new features for graph visual and a redesigned trial experience

Just in time for a fall season, ZoomCharts is releasing the 1.6. version of the Drill Down Visuals. Along with multiple smaller yet nifty improvements, this... Read More

Sep 22, 2020

Communicating data in the language of the decision makers. 5 tips for making business-friendly Power BI reports.

There is an ocean of resources out there explaining best practices of data visualization and storytelling. It seems that secrets of data communication have... Read More

Mar 24, 2020

Deep dive into Coronavirus (COVID -19) with Drill Down Visuals

81 384 infected, 2 770 dead and counting. The Coronavirus has been in the headlines of every news station, portal and newspaper for the last 2 month. Is it... Read More

Feb 26, 2020

Sales overview by product and sales representatives: sample report

Get inspired! Take a look at this sample report and find new ideas for sprucing up your own sales reports in Power BI. Check out interactions, chart... Read More

Feb 26, 2020