The Chart Picker Guide

Posted by Posted on by
0

Charts have the magical ability to transform abstract numbers into beautiful readable visualizations. Trouble comes when you have to choose the right chart, that could best visualize the data involved. We have come up with a chart-picker guide that will help you to choose the best chart for the occasion. Go ahead and make the right pick!

Column/Bar Chart
Pick this chart to compare data classified into discrete groups. Be it your sales in each quarter, or say scores comparison among teams.
Column-Bar Chart01

Read more

Support for NoSQL databases and other handy new features from Zoho Reports

Posted by Posted on by
0

No SQLCoined by Huseeb Budhani in 2008, “Big Data” has been a big deal for a few years now. Most traditional database systems manage only regular-sized structured databases, and find it difficult to manage the incredible volumes of big data being generated today. To help with this, a number of experimental new “NoSQL” database systems have come into the picture. By making some tradeoffs, NoSQL databases can easily scale to much larger sizes than their more traditional cousins.

To help you analyze the huge volume of raw business data stored in NoSQL databases, Zoho Reports now fully supports analysis and reporting over data in NoSQL databases. You can now use the advanced reporting options offered by Zoho Reports with these NoSQL database systems:

  • MongoDB
  • Apache Cassandra
  • Apache Hadoop/Hive
  • Cloudera Hadoop/Hive
  • Hortonworks Hadoop/Hive

Read more

Analyze Your Business Data Stored in Cloud Storages & Drives

Posted by Posted on by
0

More and more of your business data reside on the cloud now. For better convenience, you now sync your files online, using cloud services like Zoho Docs, Google Drive, Dropbox, Box or OneDrive. Zoho Reports now makes it easier to analyze your data files (especially spreadsheets) that are stored in such cloud storage services.

Using the new Import from Cloud Storage/Drive link, you can import files directly from other cloud services to Zoho Reports. Read more

Interesting Public Dashboard Examples

Posted by Posted on by
0

Time and again, we come across Zoho Reports being used to analyze varied data sets. Below is a sampling of some of the recent public databases that we found interesting.

1. ARISS (Amateur Radio on the International Space Station)
I never knew that ISS was this connected with Hams, before I came across this ARISS database! Some interesting stats there, about events and contacts made by various schools with ISS, across countries.

2. Austin Real Estate
ABoR (Austin Board of Realtors) has a dashboard each for Travis County and Williamson County detailing avg list prices, foreclosure list price per zip code and types of financial transaction that were carried out.

3. IT Help Desk Stats
This is probably done by a system administrator for her IT team – a dashboard for data upload/download and computers being synced, and another dashboard that analyzes the number of support tickets raised.

4. Small Business Centre, North West Metro
Dashboard that reports the results of a survey done over small businesses in Western Australia.

5. Ministry of Transport & Communication, Mexico
From what little I could decipher using Google Translate, each of the dashboards in this database give out the number of landslides, free passageways and damaged bridges, state-wise.

6. Traffic Accidents
This dashboard analyzes accident numbers – how many injured vs dead, males vs female motorcyclists involved in accidents, number of accidents in different age groups etc.

7. Australian Football Clubs
dashboard made over Aussie football clubs data, and analysis of their profits.

Now, how are you using Zoho Reports? Let us know in the comments.

Just In: 100% Group Bar Chart, Column Subtotals, Top/Bottom N Filter Enhancement and more

Posted by Posted on by
0

Happy New Year 2014 to everyone! On this new year, let’s see some of the latest features of Zoho Reports.

100% Group Bar Chart
This type of bar chart is quite useful when you have to compare each member’s contribution to the overall pie over a period of time. It’s like having a series of pie charts lined up, only better.

100-stacked-bar

Read more

Just In: Email Filtered Reports, Plot Moving Average and more

Posted by Posted on by
1

Zoho Reports has added a lot of cool features recently. Let’s see some of the major features that have come in.

Scheduled Emailing of Reports with Filter Criteria 
You’ve created a set of monthly sales reports. Only that you’d want to filter the region, so as the regional heads see the sales data of their own regions alone. We’ve seen how this can be done in Zoho Reports, without duplicating the same set of reports for each regional head. Now, let’s say you want the same reports to be mailed periodically to the intended recipients. This is possible now. All you’ve to do is,

  • Open one of the reports to be mailed
  • Click ‘Export’ -> ‘Email Multiple Views’ -> ‘As PDF’ Read more

Case Study: Quick Deployment of a Big Data Reporting Solution

Posted by Posted on by
0

There are a lot many businesses who have on-premise, legacy software systems being used for many years. While such software might have served those businesses well over the years, moving to the latest technology always brings in more benefits.

wwex-logoTake the case of Worldwide Express, a global logistics company and an authorized reseller of UPS. Worldwide Express handles millions of shipments for more than 30,000 customers worldwide. Read more