Create a dimensional data model

Анульовано

Requirement to convert a relational data model into a dimensional model based on standard Kiball design techniques.

There are 43 tables in the source model.

Source model comes from InfoSys Finacle which is a cloud based banking system.

Tables are not entirely 3nf as there is some consolidation during the source extract performed by Finacle.

The source model is best described as an Operational Data Store (ODS).

Your job is to convert the source model into dimensions and fact tables and produce an ERD and "create table" scripts.

Attached is an image of the source model ERD and a document describing the requirement.

Included are rules and guidelines for producing the model as well as complete metadata for all 43 tables.

Applicants should have extensive dimensional modelling experience in a banking environment with Finacle experience strongly preferred.

Feel free to ask questions.

Навички: Обробка даних, Організація сховищ даних, Керування

Показати більше: dimensional model data asia erwin, requirements model data process reporting functional system, model data entry outsourcing company profiles ppt, model data entry outsourcing company profiles, linear model data projects, free create onepage brochure describing companys structure business model culture, extract data excel create report, data entry create accounts getafreelancer, create page bochure describing companys structre business model culture, create onepaged brochure describing companys structure business model culture, create onepage brochure describing companys structure business model culturewrite 750word paper apa format describing structure , create onepage brochure describing companys structure business model culture , create onepage brochure describing companys structure business model, create 1page brochure describing companys structure business model culturewrite 750word paper apa format describing structure bu, create document mysql data, scrape data web create excel getafreelancer, scrape data web create excel, car model data free, car makes model data, free car model data, car model data, create page brochure describing companys structure business model, auto model data, mysql data php create dynamic graphs

ID проекту: #12655210

11 фрілансерів(-а) подали заявки на цю роботу; середня заявка - $638

sheak

Hello! Being one of the most experienced Statistician/Mathematician on this website with around half thousand excellent reviews and proven track record, I would love to work on this project. I am experienced data analy Більше

$688 AUD за 10 дні(-в)
(18 відгуків(-и))
5.0
schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex Більше

$750 AUD за 5 дні(-в)
(43 відгуків(-и))
4.9
point5nyble

Hello, I have been working with a MNC bases company since last ~ 6 years, as an IT BI DWH Professional. The project is a BI DWH project which covers 3 layers of BI (ETL, Data warehouse & Reporting) and helped m Більше

$255 AUD за 10 дні(-в)
(15 відгуків(-и))
4.3
aaienmatloob

My name is M.Matloob ul Hassan, I am accountant in Oil & Gas company and having 6 years experience in different categories like as Quick Book, Microsoft Office excel, word, PowerPoint, web searching, web scraping, data Більше

$575 AUD за 7 дні(-в)
(1 відгук)
0.3
dhanuitdevendra

Hello, Hope you are doing well! I can help you with dimensional data modeling. I worked on similar projects recently. ------------------------------------------------------------------------------- Recent Proje Більше

$1000 AUD за 30 дні(-в)
(0 відгуків(-и))
0.0
$555 AUD за 7 дні(-в)
(0 відгуків(-и))
0.0
Intellify

20 + years experience in Data Management, Business Intelligence & Analytics and Application Development. Have worked on multiple Data migration and Data Warehouse projects successfully. I have 20+ strong technical t Більше

$998 AUD за 10 дні(-в)
(0 відгуків(-и))
0.0
pushar71

Hi I am keen to do this project for you, please consider me for this task. I have been working on DW/BI field for last several years and have done several DW/BI projects. Kindly connect for a short discussion so t Більше

$555 AUD за 10 дні(-в)
(1 відгук)
0.0
rdkaran1

Having more than 15 years of IT experience , working as a Datawarehouse Architect and extensive knowledge in Microsoft BI Stack. Have created and worked in more than 5 enterprise datawarehouse end-to-end.

$611 AUD за 12 дні(-в)
(0 відгуків(-и))
0.0
vksdwivedi9

i have 7+year of experience in datawarehouse design and development, My key skills: Data modeling, database development, datawarehouse(star, snowflake schema) design and development

$777 AUD за 10 дні(-в)
(0 відгуків(-и))
0.0
micheal4299

Contact me. I can assist you. You can also check my portfolio: https://www.freelancer.com/u/micheal4299.html I also have experience in working on similar projects. I can get it done before deadline. Let me know i Більше

$250 AUD за 10 дні(-в)
(0 відгуків(-и))
0.0