Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create a company based on your assumptions. Come up with a name for the company ( make your own name, do not use existing company

Create a company based on your assumptions. Come up with a name for the company
(make your own name, do not use existing companys name), specify its main product or
service, indicate the number of branches it has, and assess the importance of good
quality and big-sized data for your company. Additionally, provide information on the
number of employees and departments within the company.
2. How do you plan to design the data warehousing architecture? (Select one of five
common architectural types. Find one from the slide note. Open AI may not provide
correct answer.)
3. What data sources will be used for the operational system?
4. Who will be the end users of the Business Intelligence system?
5. Are there data marts in the architecture? Why or why not? If there are data marts, how
would you divide them?
6. What operational infrastructure is required for the data warehouse? This encompasses
factors such as the size of the team, schedule considerations, and the duration of
training.
7. What kinds of physical infrastructure do you need for the data warehouse? Search the
internet to find vendors for each system.
8. Create a hand-drawn illustration of your Data Warehouse Architecture. Draw on paper.
Take a photo of the design and attach it here.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Oracle Database Upgrade Migration And Transformation Tips And Techniques

Authors: Edward Whalen ,Jim Czuprynski

1st Edition

0071846050, 978-0071846059

Students also viewed these Databases questions