Dimodelo

Dimension Usage Count

Source Target Mapping

Total Fact Estimates

Build & Unit Test
Fact Estimates
Dimension 10
Dimension 11
Dimension 12
Dimension 13
Dimension 14
Dimension 15
Dimension 1
Dimension 2
Dimension 3
Dimension 4
Dimension 5
Dimension 6
Dimension 7
Dimension 8
Dimension 9

Complexity

Modeling
Analysis
Facts
Fact 1 1 1 1 1 1 1 6 C 1.2 1.2 1.2 4.4 8.0
Fact 2 1 1 1 1 4 C 1.2 1.2 1.2 4.4 8.0
Fact 3 1 1 2 C 1.2 1.2 1.2 4.4 8.0
Fact 4 1 1 1 1 1 1 6 C 1.2 1.2 1.2 4.4 8.0
Fact 5 1 1 1 1 1 1 6 M 0.6 0.6 0.6 2.2 4.0
Fact 6 1 1 1 3 C 1.2 1.2 1.2 4.4 8.0
Fact 7 1 1 1 1 1 1 1 1 1 9 C 1.2 1.2 1.2 4.4 8.0
Fact 8 1 1 2 M 0.6 0.6 0.6 2.2 4.0
Fact Usage Count 2 2 7 1 3 1 2 3 4 4 2 2 3 1 1 8.4 8.4 8.4 30.8 56.0
Complexity M M C M M S S M M C C M M M M

Dimension Estimates
Analysis 0.6 0.6 1.2 0.6 0.6 0.3 0.3 0.6 0.6 1.2 1.2 0.6 0.6 0.6 0.6 10.2 Total Days 124
Modeling 0.6 0.6 1.2 0.6 0.6 0.3 0.3 0.6 0.6 1.2 1.2 0.6 0.6 0.6 0.6 10.2
Source Target Mapping 0.6 0.6 1.2 0.6 0.6 0.3 0.3 0.6 0.6 1.2 1.2 0.6 0.6 0.6 0.6 10.2
Build & Unit Test 2.2 2.2 4.4 2.2 2.2 1.1 1.1 2.2 2.2 4.4 4.4 2.2 2.2 2.2 2.2 37.4
Total Dimension Estimates 4.0 4.0 8.0 4.0 4.0 2.0 2.0 4.0 4.0 8.0 8.0 4.0 4.0 4.0 4.0 68.0

www.dimodelo.com
contact@dimodelo.com Instructions
 Dimodelo

Work Breakdown
Days Rate $
Analysis
Business Analysis 10 $ 1,200 $ 12,000
High Level Design 10 $ 1,200 $ 12,000
PreRequisites
Establish Development Environment 10 $ 1,200 $ 12,000
Establish Test Environment 10 $ 1,200 $ 12,000

Build and Unit Test

Data Warehouse
Dimensions 68 $ 1,200 $ 81,600
Facts 56 $ 1,200 $ 67,200
Semantic Model 10 $ 1,200 $ 12,000
Master Data (Reference Data) 10 $ 1,200 $ 12,000
System/UAT Testing 10 $ 1,200 $ 12,000
Deployment 10 $ 1,200 $ 12,000
Security 10 $ 1,200 $ 12,000
Project Management 10 $ 1,200 $ 12,000
Documentation & Handover 10 $ 1,200 $ 12,000

Total Day/$ 234 $ 280,800

www.dimodelo.com
contact@dimodelo.com
© Dimodelo 2016. See www.dimodelo.com for terms of use.
 Instructions
Dimodelo

Estimates
Use the table below to assign a number of days to each of the complexity options available in the Data Warehouse matrix.

Complexity
Complexity Code Estimate (Days) Description
Name

A Simple Dimension or Fact is source from a single existing source, with mostly a one to one relationship
S Simple 2
between source columns and destination columns. The Source is readily available and accessible.

A Medium Dimension or Fact is source from a single existing source, with mostly a one to one
M Medium 4 relationship between source columns and destination columns. However the source many need to be
created, purely for reporting purposes, or there may be many attributes or measures.

Complex will involves at least one issues like: the Source is undecided, data quality issues, multiple
C Complex 8 sources, many attributes, many measures, many dimension associations, or there are complex
transformations and/or derived staging tables required to derive measures or attributes.

Highly Complex will involve a combination of a number of issues like: the Source is undecided, data
Highly
HC 16 quality issues, multiple sources, many attributes, many measures, many dimension associations, or there
Complex
are complex transformations and/or derived staging tables required to derive measures or attributes.

Task Breakdown
The table below breaks down the work required for each Fact and Dimension into Analysis, Modelling, Source-Target mapping and Build/Unit Testing tasks. The break down
is used in the Data Warehouse Matrix spreadsheet to break down all work over these task categories.

Task Breakdown

Analysis 15%

Modeling 15%

Source Target
15%
Mapping

Build & Unit Test,

55%
Integrate
total 100%

Variables
Daily Rate $ 1,200

www.dimodelo.com
contact@dimodelo.com
© Dimodelo 2016. See www.dimodelo.com for terms of use.
Name: Transaction Fact

Type: Fact
Description: Write a brief description of the purpose of the fact

Measures: Name Description

Debit Amt As per source

Credit Amt As per source

Total Amt Debit Amt - Credit Amount

Relationships:
Name Role Play

Customer Primary Customer

Loan

Profiling:

Describe where to find this information in the source system. Include an SQL Statement if possib

Refactor:
 Data Profiling Format Calculated

$ Y

Increases are positive, Decreases

$
are negative.

Description Data Profiling

Primary associated Customer

system. Include an SQL Statement if possible.

Name: Loan

Type: Dimension
Description: Represents one row per Loan including Applications.

Important Attributes: Name Description Data Profiling

LoanId As per Source

Indicates the Loan is for a new

Customer or Existing Customer.
Is New Customer
Values 'New Customer', 'Existing
Customer'

Loan Purpose As per source

Profiling:
Describe where to find this information in the source system. Include an SQL Statement if possib

Refactor:
 Data Profiling Change

lude an SQL Statement if possible.