Overview

Most SMB & Enterprise companies across the world have grown inorganically. This has resulted in unplanned growth and organizations have invested in a variety of applications for multiple purposes. Enterprise Resource Planning Systems work efficiently to suit the needs of most enterprises, but an ERP application can not provide the management with what they need the most - a central view of the business with a dynamically-updating visual representation of the business data obtained from processed reports.

This is where the requirement for a business intelligence application comes in, a BI tool that could integrate with current applications and provide an intelligent analysis of the business data being generated.

CloudCodes presents a simple and easy-to-use solution that steps up to this challenge. The Dashboard Connector is a tool which enables you to use Google Docs & Google Sites as a business dashboard, providing a cost effective way to address the most important requirements of your business functions. The Dashboard Connector leverages on the power of real-time collaboration of Google Spreadsheets and uses a very simple principle to integrate with various applications from which it reads and analyses various reports.

The dashboards allow managers/employees to monitor the contribution of the various departments within the organization. To precisely gauge the overall performance and behaviour of an organization, the digital dashboards can be used to capture and report specific data points from each department thus providing a ‘snapshot’ of increased or decreased performance.

How it works

• Dashboard sends a scheduled report to a specific email account (Google Apps Email Account) in xls or csv format
• The DBC then reads the attachment based on the rule which is a Unique Subject Line
• After the mail is identified, the attachment is copied / updated to a specific Google Spreadsheet. You can now use the data to generate different types of chart which can be embedded into Google Sites

Features

The features of Google Apps Downloader are mentioned below,

• The DBC tools is a Cloud Based tool running on Google AppEngine*
• Securely Stores the Data on your Google Apps Account
• Automates the Data updatation from various Applications & ERP
• Simple Rules can be created to handle various reports
• Sends a summary of reports processed by the DBC tool to the admin
• Handles XLS & CSV formats with multiple sheets
• Reads Emails from various sources
• Can be configured for multiple Google Mailboxes at the same time.

Pricing

Edition	Price
Enterprise / Government	USD ($) 1250 / Year
Education / Non- Profit	USD ($) 750 / Year