Using the CDBWin Dashboard
Tip: How to place your business-critical information
right in front of you.
Overview
CDBWin processes business-critical information to help
you manage precisely and profitably. Yet in a fast-paced retail environment,
trends and results can change in the blink of an eye. This makes it important
to place timely performance data right in front of you so you can react quickly and make
the necessary adjustments, ensuring you
keep your business profitable and in control. The CDBWin Dashboard feature does
this, using easy-to-read alert gauges and profitability graphs displayed right on the
CDBWin main window:

Up
to six data "cells" are displayed in a Dashboard set: one graph or four
gauges per cell. The Dashboard allows you select the information on which you want to report, with data selected from the following
categories:
| Gauges (display Alerts) |
Graphs (display report information) |
| Discounts Count |
Department Sales Gross Profit |
| Discounts Value |
Department Sales Margin |
| Max Sales Variance |
Department Sales Money |
| Voids Count |
Fuel Grade Margin |
| Voids Value |
Fuel Grade Sales Cost |
| Level/Grade price margin by Level/Grade |
Fuel Grade Sales Money |
| Tank Inventory variance for each Tank |
Fuel Grade Sales Volume |
| |
Fuel Grade Sales Gross Profit |
| |
Fuel Total Sales Money |
| |
Fuel and Non-Fuel Sales Gross Profit |
| |
Fuel and Non-Fuel Sales Money |
| |
Tank Accumulated Over/Short |
Creating a Dashboard Set
Creating a Dashboard set is done in a few easy steps:
- In CDBWin, on the Setup menu, click Dashboard. The
Dashboard set up window appears:
- Each Dashboard set you create must be assigned an ID. In the
Dashboard ID box, type the ID (limited to 35 alphanumerical characters)
for the Dashboard set (a default set named Standard comes with the
system). After typing the ID, click Edit.
- The Dashboard setup window appears:

The setup window has six panels that correspond to the six Dashboard cells. For
example, what you select to display in the upper left of the setup window will
appear in the upper left of the Dashboard. - Work through this
window to select the information your Dashboard set will display. Use as
many of the six panels as you need to:
Type — Select one of the three option buttons for the panel: Graph,
Gauge or None.- Graph
Report — Use this combo box to select the kind of graph you wish to display
(see above list ).
Date Range — Select a date span for the graph, either 7 Days
or 30 Days. Show —This combo box becomes active if,
in the Report combo box, a selection is chosen that itemizes data by
Fuel Grade. You can use this combo box to display data for an individual
grade or All grades.
- Gauge — When you select Gauge you commit the Dashboard to
display four gauges within one of the six areas of the Dashboard. Use
the combo boxes to select the four trend data types you wish to display
(see above list).
- None — Select None to blank out the portion of the
Dashboard corresponding to the panel.
Other Dashboard Notes
- Multiple Dashboard sets can be created. Select the one you wish
to display by using the Dashboard ID combo box in the upper
left of the main Dashboard display.
- Use the Delete button in the lower left-hand corner of the Dashboard Setup window to delete the
currently displayed Dashboard set.
- Dashboard data is continuously updated in real time. Click the
Refresh button at the top of the main Dashboard display to ensure
you are seeing the latest data.
For more information.....
For a more detailed look on the features and operation of the CDBWin Dashboard,
please consult the CDBWin User's Guide, specifically the sections "Dashboard
Setup" in Chapter 1, and "Dashboard" in Chapter 2.
Past Tips of the Month...
December 2009: Using the Competitive Price Survey to Price Your Fuel Grades
November 2009: Expediting the Recording of Direct Store Delivery (DSD) Invoices
with Vendor Item Numbers
October 2009: Correcting Mistakes with Reversals
September 2009: Identifying Inside Sales Patterns
August 2009: Tracking Your Ratio of Fuel Sales to Store Sales
July 2009: Using CDBWin Reports to Identify
Profitability Issues
June 2009: Get In-Depth Training on Specific, Focused Topics
May 2009: Create Custom Filtered Reports Using
Saved Item Criteria
April 2009: Use CDBWin to Spot Discrepancies between
Orders and Deliveries
March 2009: Maximizing Efficiency with Hand-Held Data Processing
February 2009: Battery Care and Maintenance
January 2009: Using Online Documentation
December 2008: Identifying Fast and Slow Movers
November 2008: Identifying Inventory Changes
October 2008: Identifying Over Stock
September 2008: Identifying Dead Stock
August 2008: No Sales Tracking
July 2008: Refunds Tracking
June 2008: Discounts Tracking
May 2008: Void Tracking
April 2008: Workforce Management
March 2008: Department Projections
February 2008: Resolving HHT Communication Issues
January 2008: Preparing an Annual Budget
December 2007: Speeding Up Direct Store Deliveries
November 2007: Calculating an Accurate Cost of Goods Sold
(COGS) for Lottery Sales
October 2007: Processing Lottery Paidouts
September 2007: Marking Items (in CDBWin) Not to Be Sent to the POS
August 2007: Using Expense Items and Using the Department/Expense
Report in CDBWin 7.4
July 2007: Configuring an Alert for Cash Balance
June 2007: Adjusting Inventory with the Hand-Held on a
Daily or Weekly Basis
May 2007: Scanning Direct Store Delivery Invoices Without
Affecting Retail Prices in CDBWin
April 2007: Restricting Duplicate Invoice Numbers
March 2007: Profit & Loss
February 2007: Fuel Manager Reports
January 2007: How to Buy Coffee Supplies and Expense Them
December 2006: How to Get a PLU Report without Bar Coded Items
November 2006: How to Create a Reorder Using the Hand-Held Terminal (HHT)
October 2006: Reorder Items in Selected Department Range
September 2006: Reorder Quantities Based on Minimum Purchase Quantity
August 2006: Reorder Quantities Based on Sales History
July 2006: How to Reconcile Inventory
June 2006: How to Reconcile Inventory After a Promotion...
May 2006: Reordering the Correct Number of Items
|