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

Model on KPI

3 posters

Go down

Model on KPI Empty Model on KPI

Post  rkraj Fri Aug 10, 2012 11:16 pm

Assume that i have a current data mart. I Need to come up with a new Data mart using the existing ones for creating a set of reports.

Suppose if i have only KPI's with me for starting our Modeling,

Q1. Will that be sufficient for doing the modeling or i will end up with insufficient information later after i start?

I have the following KPI's
a. Revenue coming out of each Account
b. No of NEW incoming accounts
c. Revenue achived by individual Market Maker

Like this i have a set of KPI's

Q2. Assume if i have completed the model... later when the report is queried i am hoping that there are possibilities of performance issues (due to more joins that may come up)

Kindly help


Posts : 12
Join date : 2012-06-29

Back to top Go down

Model on KPI Empty Re: Model on KPI

Post  yuldashev Tue Aug 14, 2012 6:54 pm


Let me help you with your questions. But first I'd like to understand what you want to achieve.
You are saying that you need to create a new data mart (DM) based on the existing one to be able to create some reports. Why do you need the new DM? Why can't you use the existing one? If the DM created properly, i.e. it's a dimensional model that contains detailed, atomic data, it should accommodate the new reports. If you have a performance issue with the new reports, you can enhance the existing DM by adding performance-enhancing summary data, i.e. aggregates.
Having just KPI's is not enough to build a DM. I would recommend reading Kimball's book "The Data Warehouse Toolkit". It has everything you need to build a data warehouse.


Posts : 13
Join date : 2012-08-14
Location : Ottawa, Canada

Back to top Go down

Model on KPI Empty Re: Model on KPI

Post  sgudavalli Thu Aug 16, 2012 5:36 am

As you said you already have a DataMart and planning to create a new one..
first question that will knock your door is why a new one?

besides, since you already have a Mart in place;

I assume you already know about the set of Dimensions across which the Business Users want to analyse the below KPI's..
KPI's alone doesnt add much value without the Slice Definations.. figure it out (if you dont)


Posts : 29
Join date : 2010-06-10
Age : 39
Location : Pune, India

Back to top Go down

Model on KPI Empty Re: Model on KPI

Post  rkraj Sat Sep 08, 2012 12:55 pm

Thanks Alisher. Regd your answer to the performance issue, I think this is some kind of tweaking logic. Because we will have one more table summary table on the top of existing one which is costly.
The existing Datamart does not have summarised data as they have only transactional level history data. Many dimensions have only the latest data and not history.
So the current data mart is difficult to serve the purpose of generating reports.


Posts : 12
Join date : 2012-06-29

Back to top Go down

Model on KPI Empty Re: Model on KPI

Post  Sponsored content

Sponsored content

Back to top Go down

Back to top

- Similar topics

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