Dashboard Resource - Executive, Business Digital Dashboards

Transportation Dashboards | Dashboard for tracking Transport business

Any data and statistics stored in a computer or available on paper are potential Key Performance Indicators (KPIs) that can be translated into electronic dashboard displays. In transport business, trucks, buses, ambulances, taxis, and other vehicles that transport people or products, the cost of operation is an essential measure of business performance. This along with the variety of other issues - scheduling, vehicle availability, repair status, etc. - can all be measured, monitored and managed by using Dashboard Programs. Some issues that transportation companies may wish to track include: * Vehicles in use. * Vehicles available. * Vehicles in for repairs. * Drivers operating. * Drivers available. * Hiring/training status. * Shipment schedules. * Operating cost per mile. * Deadheading. * Accident statistics. We can help you create dashboard solution for your business. contact"AT"infocaptor.com

Posted in General | No Comments »

Dashboards for attorneys, CPAs, architects and consultants

If you are a Professional service firms of attorneys, CPAs, architects and consultants; along with business services such as facility management, office administrative support and employment; then there is a high chance that you are using Quickbooks or Peachtree or some similar accounting Package. All of these businesses have widely different measures of business success. However, every one of these businesses has activities that can be measured, monitored and managed by using Dashboard Programs. Tracking client activity, status of specific projects, and steps in an approval process are possible Key Performance Indicators (KPIs) that can be translated into data for dashboard displays. Some issues that professional service businesses may wish to track include: * Status of client projects. * Work per employee. * Billable hours by employee/project. * Status of training or professional continuing education. * Marketing/new business activities. * Pro bono actions. * Referrals. * Employee benefit usage. * Service calls. * Waiting time for type of work. We have built custom ...

Posted in General | No Comments »

Restaurant KPIS and Dashboards

If you are a restaurant owner and use a small business accounting package like Quickbooks, Peachtree or Microsoft Solution then you may wish to track some of the following metrics and numbers * Customers by time of day/day/week/month. * Menu items ordered. * Cash vs. credit card payments. * Customer satisfaction ratings. * Employee ratings. * Per plate food costs. * Promotional coupons used. Key Performance Indicators, such as the ones listed above, and the tables, charts and performance dials used to display the information, can be selected and customized for the business owner, partners and others responsible for specific areas. Please get in touch contact"AT"infocaptor.com

Posted in General | No Comments »

WholeSale Dashboard - KPIs and Custom Dashboards

Dashboards are very effective and efficient in tracking general activities and how they contribute to the success of the business. In addition, dashboards also present other essential information, such as special orders, promotional offer sales, return goods, warranty claims, plus service issues. These activities and others can be measured, monitored and managed as Key Performance Indicators (KPIs). Some issues that wholesalers and distributors may wish to track include: * Customer purchasing. * Inventory turns. * Cash vs. credit card payments. * Satisfaction ratings. * Fill rate. * Percent of orders shipped. * Return on investment. * Sales involving promotional coupons. * Co-op advertising sales. * Product training status for customers. If you need to get a custom dashboard created for your Wholesale business please contact us contact"AT"infocaptor.com

Posted in General | No Comments »

Quickbooks Sales and COGS

Another Dashboard for Quickbooks. This one is for Sales and COGS

Posted in General | No Comments »

Dashboard for Quickbooks: Expense Analysis

If you are a small business then there is a high chance you are using Quickbooks. Here is a sneek preview of a pre-defined Quickbooks Dashboard. This is the screenshot of Expense Analysis Dashboard. KPIs included are Average Expense/Day Expense Trend by Year Expense Trend by Quarter Expense Trend by Month Expense by Payee (Top 10 Payees) Expense by Account (top 10 account)

Posted in General | No Comments »

History of Dashboards

(source: Wikipedia) Historically, the idea of digital dashboards follows the work in the 1970s with the study of decision support systems. In the late 1990s with the surge of the web, digital dashboards as we know them today began appearing. Many systems were developed in-house by organizations to consolidate and display data already being gathered in various information systems throughout the organization. Today, digital dashboard technology is available "out-of-the-box" with many software providers on the scene. Certain companies however still continue to do in-house development and maintenance of dashboard applications. For example, GE Aviation has developed a proprietary software/portal called "Digital Cockpit" to monitor the trends in aircraft spare parts business. -------- Benefits of digital dashboards Most organizations have various departments all contributing to its overall success and thus it is important to be able to assess the progress of each department. Digital dashboards, which are a type of executive information system, ...

Posted in General | No Comments »

Color code Bar chart based on numeric range value

In the above example, the requirement is to code the bars based on the value of the bar. To achieve this you need to enable Dynamic Java Script and then add the following Java Script. You need to understand the code that is highlighted in Orange. Basically you can supply any number of colors and range values for e.g. you need the following { if bar value between 0 and 5 then use Color Red} {if bar value between 5 and 10 then use Color Blue} {if bar value between 10 and 100 then use color Green} Now we can split the above rule into following arrays (NOTE: you can use RGB values like new Color(255,0,0) ) Color Array { Color.red, Color.blue, Color.Green } Next create a Low value array { 0, 5, 10 } Next create a high value array { 5, 10, 100 } And now replace the above arrays in the highlighted yellow text area below. //import the necessary classes import org.jfree.*; import org.jfree.chart.axis.CategoryAxis; //import org.jfree.chart.axis.CategoryLabelPositions; import org.jfree.chart.axis.NumberAxis; //import org.jfree.chart.labels.CategoryItemLabelGenerator; //import org.jfree.chart.labels.StandardCategoryItemLabelGenerator; import org.jfree.chart.plot.CategoryPlot; import org.jfree.chart.plot.PiePlot3D; import org.jfree.chart.plot.PlotOrientation; import org.jfree.chart.renderer.category.BarRenderer; import org.jfree.chart.renderer.category.BarRenderer3D; //import org.jfree.chart.renderer.category.CategoryItemRenderer; //import org.jfree.chart.renderer.category.LineAndShapeRenderer; import ...

Posted in Charts, General | No Comments »

Dashboard: How to add Date parameter or range of Dates

How to add date parameters to the Dashboard query You have a dashboard query for which you want your users to enter a date (From and To) and the user should be able to query for records that fall between those two dates. Here are the steps we need to follow We will discuss approaches for MySQL and Oracle databases The approaches are identical except for the handling of date and time components. If you want to use it for other database then just use the appropriate date functions for that database. Create a new parameter (Menu Create à Parameter) Parameter Name : From Date Display Column : '2007-10-15 00:00:00' The display column indicates the format in which the user will type the date in this field. This is a free form text field so providing a default format like above helps the user to type the correct date Type 'From dual' in the text area. Dual is a dummy ...

Posted in How-to | No Comments »

InfoCaptor Registration

Once you purchase a license of InfoCaptor, Please send us the following information. Go to Help Menu -> Register Copy the highlighted User key text (sample user key shown in yellow below) Please email the above user key so that license key can be generated and will be emailed back ASAP.

Posted in General | No Comments »