Implementing Data

View previous topic View next topic Go down

Implementing Data

Post  aashaya m on Thu Sep 06, 2012 12:35 pm

I will be implementing a BI/Analytic for mid sized financial Institution about 20gb of data. main goal is to create Reports(bar-chart,pie-chart).I will break up the plan here.

*) Data Base will be 3 NF
*) creating a materialized view by making a profile inside a Database.
*) aggregating and indexing (joins) like creating a universe in BO.
*) creating Classes and table hierarchy for Multidimensional analysis inside the BI tool for different servers.


I welcome your suggestions



aashaya m

Posts : 18
Join date : 2011-04-25

View user profile

Back to top Go down

Re: Implementing Data

Post  BoxesAndLines on Thu Sep 06, 2012 5:03 pm

Buy one of Kimball's books.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

RE

Post  aashaya m on Thu Sep 06, 2012 10:39 pm

I studied his books Data warehouse Toolkit, Data warehouse ETL Toolkit, Data warehouse Life cycle

Please guide me in this process

aashaya m

Posts : 18
Join date : 2011-04-25

View user profile

Back to top Go down

Re: Implementing Data

Post  ngalemmo on Fri Sep 07, 2012 4:25 pm

If the database you are using is the operational database, I would not implement materialized views. If you are creating a new database, why build it in 3NF if the intent is to use it for analytics?
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: Implementing Data

Post  BoxesAndLines on Fri Sep 07, 2012 6:24 pm

Where in any of Kimball's books does he recommend building a normalized database as the basis for analytical reporting?
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

Re: Implementing Data

Post  aashaya m on Fri Sep 07, 2012 11:49 pm

If it not with implement with Materialized view than ----> ?

aashaya m

Posts : 18
Join date : 2011-04-25

View user profile

Back to top Go down

Re: Implementing Data

Post  ngalemmo on Sat Sep 08, 2012 12:34 am

Build a dimensional warehouse.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: Implementing Data

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum