Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Implementing Data

Go down

Implementing Data Empty Implementing Data

Post  aashaya m 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

Back to top Go down

Implementing Data Empty Re: Implementing Data

Post  BoxesAndLines Thu Sep 06, 2012 5:03 pm

Buy one of Kimball's books.
BoxesAndLines
BoxesAndLines

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

Back to top Go down

Implementing Data Empty RE

Post  aashaya m 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

Back to top Go down

Implementing Data Empty Re: Implementing Data

Post  ngalemmo 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?
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Implementing Data Empty Re: Implementing Data

Post  BoxesAndLines 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?
BoxesAndLines
BoxesAndLines

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

Back to top Go down

Implementing Data Empty Re: Implementing Data

Post  aashaya m 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

Back to top Go down

Implementing Data Empty Re: Implementing Data

Post  ngalemmo Sat Sep 08, 2012 12:34 am

Build a dimensional warehouse.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Implementing Data Empty Re: Implementing Data

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top


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