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

Purchasing SQL Server 2005

I have been tasked with determining which edition of SQL server 2005 to purchase for my business.

We currently have SQL server 2005 Enterprise Edition, although due to the spec of our laptops (operating system) we cannot install the full version of this on our laptops (2gb database capped limit)

The laptop specification is:
1.66 Ghz Intel Centrino Duo
1 Gb Ram
60 Gb HDD
Microsoft Windows XP Profressional Version 2002, SP2 (64 bit?)

I believe the Standard Edition will enable us to have an uncapped SQL Server 2005 database limit on the laptops.

Alternatively, please could anybody advise which edition should be purchased

Many thanks

You haven't mentioned about what kind of business you have and wanted to use SQL Server.

I believe you can look into Workgroup edition or SQLExpress of SQL and still I would like to know the size of userbase & database.

|||

I am an Analyst and I need to analyse 5gb + of financial data.

Would Standard edition or Developer edition not suffice?

|||Then Standard edition should do the job, to handle the application.

Public DataTables in Busines Object

Good Day:

I have a business object with a set of public DataTables and Public Strongly Typed Dataset DataTable Types defined. When I add the business object class to the report as a datasource, only public System datatypes (int, string) show up. I added System.Data to the report properties Assemblies, with no change. Any ideas?

Thanks,

Omar

Hello:

I do not know if this is the best solution, but it worked for me. Anyway, I added the DataTable definition from the DAL to the report as a datasource. This gave me the visilibity for the fields. I was already loading the DataTables in the the business layer, so when the front end form call the report, I tie the binding source of the report form to the filled business object Data table present in BL. The result is a report with the field visibility I need and the data generated from the BL.

Thanks,

Omar