1. Develop a proof of concept data warehouse with more than one fact table by capturing data from North wind, or some other source(s). Document your reasons for selecting the subject area(s), identify key stakeholders, formalise the vision and goals of the data warehouse. Also list the requirements for developing the data warehouse.

2. Develop and present a suitable schema for the data warehouse. Discuss your reasons for the design.

3. Using Microsoft SQL Server, implement your tables and extract, transform and load data from the operational source(s) into the data warehouse. This can be done using any available tool or by writing SQL statements.

4. Produce minimum four reports in support of the requirements outlined in section 1 using SSDT. Also produce four visualisations using R programming language and analyse them.

5. “A good data warehousing professional is always scouting for new sources of data that can be applied to business intelligence”. In this spirit, develop a DTD/XML Schema based on a data warehouse cube and apply it to develop an XML document.

6. Discuss the limitations of the relational E-R and star schema dimensional models. Demonstrate the use of graph using Neo4j technologies.

Presentation slides in PPT

Visual Appeal No errors in spelling, grammar and punctuation. Clear and concise information on each slide.

Visually appealing/engaging.

Content Concise summary of the topic with all questions answered. Comprehensive and complete coverage of information.


• Report (Microsoft Word) including visualisations and R code.

• Data warehouse Design (produced in Visio or in a similar system)

• Data Warehouse (scripts)

• Reports (pdf)

• SSDT Project

• XML DTD /Schema and document

• Neo4j document

• Presentation slides Read Less

Beceriler: Veritabanı Programlama, Microsoft SQL Server, R Programlama Dili, XML

Daha fazlasını gör: building a data warehouse with examples in sql server, how to build a data warehouse with example, developing a data warehouse, building a data warehouse tutorial, building data warehouse from scratch, create first data warehouse, steps for design and construction of data warehouse pdf, how to create data warehouse in mysql, fms failed create thread flash media server errors, oracle dataware house, create flyer house cleaning business, dataware house, auto cad design auto create design house, create project house autocad, create printable house cleaning flyers 100 free, create walkthrough house tutorial, create fashion house logo, create architectural house modeling max, create realistic house interior max, create haunted house game

İşveren Hakkında:
( 0 değerlendirme ) Dublin, Ireland

Proje NO: #18329961

Bu iş için 7 freelancer ortalamada €216 teklif veriyor


Hello, Hope you are doing well. I can help with you in your project CREATE DATAWARE HOUSE. I can assure you the quality job. I have good experience in Database Programming, Microsoft SQL Server, R Programming Daha Fazla

€200 EUR in 2 gün içinde
(21 Değerlendirme)

Hi, I have checked project requirement and it would be completed on time. We can discuss further in more details in PM. Thanks.

€233 EUR in 3 gün içinde
(5 Değerlendirme)

Hello? How are you? I have good experiences in "CREATE DATAWARE HOUSE" as you can see my profile for these (Database Programming, Microsoft SQL Server, R Programming Language, XML). I have been working for 7 yrs in Daha Fazla

€155 EUR in 3 gün içinde
(4 Değerlendirme)

Hello, I am pleasure with your job for CREATE DATAWARE HOUSE. Thank you for the job posting. It’s a pleasure to meet you. I’d really like to work with you on this one if possible! I do have a couple of questions, b Daha Fazla

€155 EUR in 3 gün içinde
(1 Yorum)

I am confident I am the right candidate for this project as I have done many similar projects in the past. With years of experience in this field, I believe this project will be very easy for me.

€367 EUR in 15 gün içinde
(1 Yorum)

Hi I am Microsoft Certified Data Scientist and MCSE in Data Analytics with experience in Predictive Analytics, Descriptive Analytics and Business Intelligence (BI). Total 12 years of experience in Data management a Daha Fazla

€250 EUR in 3 gün içinde
(0 Değerlendirme)

We have lot of experience of the data visualazastiona and dashboard and reporting and data warehouseing and data migration and ETL

€155 EUR in 3 gün içinde
(0 Değerlendirme)