business metrics

  • Thread starter Thread starter ian
  • Start date Start date
I

ian

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?
 
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
 
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 (e-mail address removed)?

Thanks.
 
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
 
Ed Ferrero said:
3) I have a Balanced Scorecard workbook that I can email
you if you are interested...
Click to expand...

Ed, I'll like to request for a copy of the above
Please email to: (e-mail address removed)
Thanks
 
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
 
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.
 
Back
Top