Purpose of BI?

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
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
"Richard G" wrote:

> 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
>
>
|||"Utf-8BSmFtaWU" wrote:[vbcol=seagreen]
> If your BI team think the ETL may fail then theyre 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
> "Richard G" wrote:
> More specifically,
> trends and
> appropriately
> reports
> have
> saying that
> but rather
> may fail,
> manner.
I agree that there is always a chance that the operational db and the
DW would be out of synch. Typically, you want to do intensive ad-hoc
queries on the DW. I see advantages in doing tight report queries on
the operational system.
Advantages:
-Operational system IS the system of record (SOR), and the most
reliable
-It is always up to date
Disadvantages:
-Would only work for tightly controlled reports that do not cause
extensive cpu load. Seems to be the case here.
http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/Data-Warehou...pict26009.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=485921
|||"steve" <UseLinkToEmail@.dbForumz.com> wrote in message
news:41351fcd$1_3@.news.athenanews.com...
> "Utf-8BSmFtaWU" wrote:
> I agree that there is always a chance that the operational db and the
> DW would be out of synch. Typically, you want to do intensive ad-hoc
> queries on the DW. I see advantages in doing tight report queries on
> the operational system.
> Advantages:
> -Operational system IS the system of record (SOR), and the most
> reliable
> -It is always up to date
> Disadvantages:
> -Would only work for tightly controlled reports that do not cause
> extensive cpu load. Seems to be the case here.
> --
> http://www.dbForumz.com/ This article was posted by author's request
> Articles individually checked for conformance to usenet standards
> Topic URL:
http://www.dbForumz.com/Data-Warehou...pict26009.html
> Visit Topic URL to contact author (reg. req'd). Report abuse:
http://www.dbForumz.com/eform.php?p=485921
Hi,
We have used BI to monitor customer profitability - especially when we do
our annual price review.
High profitability and a high revenue = protect
Low profitability and a low revenue = listprice
/Kent J.
|||"Kent Johnson" wrote:
> "steve" <UseLinkToEmail@.dbForumz.com> wrote in message
> news:41351fcd
_3@.news.athenanews.com...
> not doing
> the
> reports off
> of BI.
> intelligence, e.g.,
> also be
> daily/weekly/monthly
> many customers
> team is
> warehouses,
> because the ETL
> a timely
> appreciated.
> the
> ad-hoc
> queries on
> authors request
> http://www.dbForumz.com/Data-Warehou...pict26009.html
> abuse:
> http://www.dbForumz.com/eform.php?p=485921
> Hi,
> We have used BI to monitor customer profitability - especially when
we
> do
> our annual price review.
> High profitability and a high revenue = protect
> Low profitability and a low revenue = listprice
> /Kent J.
Kent, your example is a very use of BI. I can see that you can either
run such a "report" against operational data source, or DW. Which
one are you running it against?
http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/Data-Warehou...pict26009.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=492950