business metrics

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ian - 12 Oct 2004 01:18 GMT

Can someone suggest appropriate software. I currently
have a SQL db that holds most of our business data. I
regularly create queries in an Access db that has linked
tables then import the queries into excel to use in pivot
tables for my reports.

The problem is - time to automate. I need a program that
will show me simple bar/chart/speedometer graphs that I
can post via our intranet for managers. It doesn't
matter to me in what form it's in. The problem is I need
it to update in real time. I'm having a hell of a time
finding appropriate software. Either it's enterprise
level or makeshift where it will only update if you go
into the original excel chart and update each graph
individually.

Any suggestions?

Reply to this Message

Ed Ferrero - 12 Oct 2004 23:07 GMT

Hi Ian,

1) Create views in SQL Server. That way you do not need to open MS Access to
manipulate the data, and the views are available in real time.

2) In Excel, you can use the options for Pivot Tables or Imported Data
Ranges to refresh the data every time the workbook is opened.

3) I have a Balanced Scorecard workbook that I can email you if you are
interested. It is about a 0.5Mb zip file.

Ed Ferrero
http://edferrero.m6.net

> Can someone suggest appropriate software. I currently
> have a SQL db that holds most of our business data. I
[quoted text clipped - 13 lines]
>
> Any suggestions?

Reply to this Message

- 13 Oct 2004 02:19 GMT

Thank you very much. Is there a query engine in SQL
similir to Access or do I have to translate all of the
Access queries into SQL?

Could you email the file to ian_furst@yahoo.com?

Thanks.

>-----Original Message-----
>Hi Ian,
[quoted text clipped - 30 lines]
>
>.

Reply to this Message

Ed Ferrero - 13 Oct 2004 22:59 GMT

Getting a little off topic here, but...

Access SQL is only a little different from SQL Server. Getting closer in
Access 2000 and later. In many cases, you can simply copy the SQL statement
from an Access query to SQL Server.

Enterprise Manager (in SQL Server) does have a graphical query editor that
works much like Access. Also, if you have Access 2000 and SQL Server 2000
(or later versions) you can use Access to edit views in SQL Server.

Ed Ferrero
http://edferrero.m6.net

> Thank you very much. Is there a query engine in SQL
> similir to Access or do I have to translate all of the
[quoted text clipped - 50 lines]
>>
>>.

Reply to this Message

Max - 13 Oct 2004 23:17 GMT

"Ed Ferrero" <mail@edferrero.m6.net> wrote
....

>3) I have a Balanced Scorecard workbook that I can email
> you if you are interested...

Ed, I'll like to request for a copy of the above
Please email to: demechanik@yahoo.com
Thanks

Signature

Rgds
Max
xl 97
--
Please respond, in newsgroup
xdemechanik <at>yahoo<dot>com
---

Reply to this Message

aaron.kempf@gmail.com - 30 Dec 2004 08:34 GMT

if you use an Access Data Project, you can reuse a lot of your Acces
business logic.

Basically excel is a waste of time.

Use Acess data projects and report directly on the db data
yes, rewriting isn't that difficult.. it builds character LoL

Reply to this Message

Ken Wright - 30 Dec 2004 08:42 GMT

Now you really just took on Troll status - You went for a war of words, got
beaten hands down by the Grand Master and have now degenerated into a petty
mudslinging idiot. A real pity because you probably had a lot of smarts to
offer if you hadn't been so blinded by your obsessive tendencies.

Signature

Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

> if you use an Access Data Project, you can reuse a lot of your Acces
> business logic.
[quoted text clipped - 3 lines]
> Use Acess data projects and report directly on the db data
> yes, rewriting isn't that difficult.. it builds character LoL

Reply to this Message