About Arvind

Marketing & Business Development, Zoho Reports, SaaS BI, P: +1 408 916 9191 x 8064

Just In: Customize Charts to your Heart’s Content!

Posted by Posted on by

Yes, Zoho Reports now offers quite a few customization options for a chart. Let’s see how a chart transforms when its settings are customized. Below is the default chart you would get when plotting Apple’s quarterly revenue numbers (from 1Q 2011 to 1Q 2013).

Click Settings at the top-left and it brings you the ‘Settings’ wizard.

In the General tab, you can set the chart’s ‘Title’ and ‘Description’. The next Axis tab will look like the below.

You can change all the values of the Axis parameters.

And you can set the Borders & Colors too.

We will leave out the last Threshold tab for now (who are we to set a threshold for Apple’s sales? 😉 ). Your chart with the settings modified will look like the below.

That’s quite a transformation from what you saw as the default chart, right? Try your own settings for the charts you create in Zoho Reports now.

Case Study: Using Zoho Reports for Strategic Planning

Posted by Posted on by

Zoho Reports is a versatile reporting tool and we keep coming across customers who use it in a myriad ways. One such customer is María Inés Plaza of Envases, a food/industry packages manufacturer based in Venezuela. María Inés uses Zoho Reports for her planning department’s activities. From automated balance scorecards to variable compensation pay for employees to sales forecasts, Zoho Reports does it all at Envases.

Till 5 months back, Envases’ planning department, like any other SMB’s was using the ubiquitous spreadsheet (Microsoft Excel) for the above functions. It took María Inés a lot of time every month to update the spreadsheet, apply the proper filter and share a copy of it with everyone concerned. She realized there has to be a better way to do it and hit upon the idea of using Zoho Reports. Now, she’s automated all data uploads and calculations. And every employee in Envases has live access to interactive dashboards, based on dynamic data.

The biggest benefit? María Inés is now saving two weeks of effort every month. Read more about how María Inés is using Zoho Reports in Envases.

Zoho CRM Advanced Analytics: Create Region-based Reports

Posted by Posted on by

As a Zoho CRM user, we believe you are taking full advantage of the Advanced Analytics Add-on for Zoho CRM. If you haven’t yet, do try it now as it lets you dive deep into your CRM data and get real insights about your business.

We continue to hear from you about how such and such report would be very useful to have. Sales target (quota) report was one. Here’s one more that can be ultra useful – region-based sales reports.

For building the regional reports, you need the address of each client of yours. And it is there in the Accounts module of Zoho CRM. By default, the address fields aren’t synced from Zoho CRM to Zoho Reports. So, login to your CRM (Admin) account, click Setup -> Apps & Add-ons -> Zoho Apps -> Advanced CRM Analytics -> Settings. Choose Accounts under Modules and check the Billing City, Billing State and Billing Country fields. Click Save.

When the next sync happens, all the addresses of your clients are there in the Accounts table of your Advanced Analytics add-on. You can now create the desired region-based reports that you may need, by pulling in the desired columns.

Try creating your own region-based sales reports and let us know how it went.

Case Study: Improving Sales and Data Accuracy with eSurvey and Zoho Reports

Posted by Posted on by

How do you improve the sales efficiency of your workforce of around 300 sales people, who document and submit their daily sales activities on paper forms? Simple. By moving them to a paperless system, that involves smart phones, a smart data collection app (eSurvey) and a reporting service on the cloud (Zoho Reports). That’s what the farmer owned cooperative, Southern States did.

Know more about how Southern States achieved an increase in sales of 20% and data accuracy of 100%.

New in Zoho Reports – Combo and Smooth Line Charts

Posted by Posted on by

There are situations when you would want to plot two different metrics over time. Say how your sales have trended against your website traffic or, leads got. Until now, the options in Zoho Reports was to have a multi-bar or multi-line chart. Now, you get the best of both worlds with the Combo Chart (also known as Combination Chart or Bar-Line Overlay Chart). One of the metrics can be plotted as bar and the other can be plotted as line, as in the example below.

The other new chart type that’s been added is the Smooth Line Chart (also known as Spline Chart). This chart comes in handy when you want the data plotted to look continuous or when there is some data interpolation involved. Instead of the data points being connected by straight lines, a smoothened curve results.

What scenarios will you be using the above two chart types? Do leave your comments.

London 2012 Olympics: Stats & Dashboards

Posted by Posted on by

Plotting and visualizing data can be fun. And if the data involves the ongoing Olympics, it can be doubly so! As with previous Olympics (Vancouver 2010Beijing 2008), we have compiled some interesting dashboards for London 2012 Olympics too. The dashboards are powered by Zoho Reports and hosted on Zoho Sites.

We plan to add new data and reports as the Olympic games progress, and we will keep you updated. If you like to see any other report added, do leave your comments.

London 2012 Dashboards

Zoho CRM Analytics Add-on: Compare Sales Rep Performance Against Set Sales Targets

Posted by Posted on by

Ever since we announced the Advanced Analytics Add-on for Zoho CRM‘s Enterprise Edition users, the response has been enthusiastic. We have had a good many requests – for opening up the add-on for Zoho CRM’s Professional Edition users and to sync up more CRM modules. All would be available in good time :)

We have had requests for particular types of reports as well, one of the oft requested being the Sales Target report. A Sales Target or Quota report compares a sales person’s set sales target vs the sales actually achieved. The below slide show explains how this can be done easily using the Zoho Reports Advanced Analytics Add-on for Zoho CRM.

Try creating the Sales Target report in your account and post your thoughts of how it went. We will be back with more.