all groups > sql server data warehouse > may 2004 >
You're in the

sql server data warehouse

group:

Purpose of BI?



Purpose of BI? Richard G
5/19/2004 12:10:51 PM
sql server data warehouse: I'm wondering in general about the main purpose of BI. More specifically,
should BI be used only for internal business intelligence, e.g., trends and
analysis for senior managment and marketing, or can it also be appropriately
used for daily operational reports? We have daily/weekly/monthly reports
that need to go to third parties, for example, how many customers have
signed up for our service via their service. The BI team is saying that
these reports should not be produced from the data warehouses, but rather
from the source systems. One of the reasons is because the ETL may fail,
therefore the report may not be reliablly produced in a timely manner.

Any input regarding your experience or opinion is appreciated.

Richard

RE: Purpose of BI? Jamie
7/23/2004 2:03:04 AM
If your BI team think the ETL may fail then they're not doing their job properly.
A properly bult data warehouse is the ideal way to provide the information you are after. It is bad practise to build reports off live OLTP systems.

Regards
Jamie

[quoted text, click to view]
AddThis Social Bookmark Button