[AccessD] Access 2007 - Business Dashboards

Brad Marks BradM at blackforestltd.com
Wed Feb 15 07:34:56 CST 2012


Mark and Stuart,

Thanks for the help.

Brad


-----Original Message-----
From: accessd-bounces at databaseadvisors.com on behalf of Mark Simms
Sent: Mon 2/13/2012 7:34 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Access 2007 - Business Dashboards
 
Tableau is awesome for geographic mapping and graphical display by area.
For simple gauges, you can role-your-own with Shapes in Excel...
or purchase ActiveX components that provide the "gas guage" effect.

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com [mailto:accessd-
> bounces at databaseadvisors.com] On Behalf Of Brad Marks
> Sent: Monday, February 13, 2012 2:53 PM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Access 2007 - Business Dashboards
>
> All,
>
> We have an existing Access 2007 application which provides a number of
> key reports.  Recently there has been some discussion regarding
> Business
> Dashboards.
>
> All of the data for the Dashboards would be from the same data source
> as
> the existing reports in the Access application.
>
> It would be best if the Dashboards were integrated into the existing
> Access Reporting Application if possible.
>
> I believe that we can build most of the basic Dashboard components with
> Access and Excel using Windows Automation (graphs, simple gauges,
> etc.).
>
> However, there may be requests for some things that may be difficult to
> build with Access/Excel.
>
> For example, we might want a map of the U.S. and Canada to show sales
> data by region (group of States or Provinces).  This would involve
> changing the color of the States or Provinces depending on underlying
> data.
>
> I am curious how others may have built Dashboards either with Access
> and/or Excel or with other software products that hopefully integrate
> with Access/Excel.
>
> Are there Dashboard products available that interface nicely with
> Access
> and/or Excel?
>
> Thanks,
> Brad
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.




More information about the AccessD mailing list