Problem solve Get help with specific problems with your technologies, process and projects.

Data warehouse schema

I am looking for a schema to build a data warehouse for a financial company.
There is a jump start data model for financial companies available in Ralph Kimball's book "The Data Warehouse Toolkit", but if you're looking for a near-final enterprise schema, that is going to need to be built, not bought off-the-shelf (or available free). Developers of such schemas, which can really only hope to get you half or 3/4 of the way there, also regard these as IP (intellectual property) and charge for them.

Also your classification of your company as a financial company would need to be more specific to assist your search - what kind of financial company and what applications are you interested in? Perhaps checking with what you consider your peer companies to be to see what they've done will help. You can put a lot or a little (relatively speaking) work into building any major subject area of your business like sales, customers or products. The depth appropriate for you will depend on your application needs and the time and budget you have to spend on this.

Another factor that comes into play is what data is available in your source systems. No sense having a model for which source data is unavailable.

I've elaborated elsewhere on the merits of purchasing a data model as part of packaged business intelligence but if you have a need that can be filled with a more encompassing solution, perhaps a packaged data warehouse like SAP BW or Decision Point Applications is appropriate.

Dig Deeper on Marketing automation

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.