Each assignment is to be submitted as a single Microsoft Word Document (.doc) using BlackBoard. All sections of each assignment must be handed in the one submission. Every submission must have a header that contains your name, login ID, and the assignment number. Answers to Text Exercises must be sufficient to completely respond to the exercise. All homework is to be submitted in Word format. If there are diagrams or reports, do a screen print, then copy and paste into your word document.
STUDENT NOTE: Please follow the instructions above. If you have enough database systems and data warehousing knowledge, you will be more than able to answer the previous questions fast.
I am attaching the books just in case you require them and a sample assignment.
Data Warehousing Text
Exercise #2 pg. 120
You are the vice president of marketing for a nation-wide appliance manufacturer with three production plants. Describe any three different ways you will tend to analyze your sales. What are the business dimensions for your analysis?
Exercise #4 pg. 137-138
You are the manager for the data warehouse project at a retail chain with stores all across the country and users in every store. How will you ensure that all the details necessary to decide on the DBMS are gathered during the requirements phase? Write a memo to the Senior Analyst directly responsible to coordinate the requirements definition phase.
Exercise #2 pg 161
You have recently been promoted to administrator for the data warehouse of a nationwide automobile insurance company. You are asked to prepare a checklist for selecting a proper vendor tool to help you with the data warehouse administration. Make a list of the functions in the management and control component of your data warehouse architecture. Use this list to derive the tool-selection checklist.
Exercise #5 pg. 221
As the data acquisition specialist, what types of metadata can help you? Choose one of the data acquisition processes and explain the role of metadata in that process3
Exercise #3 pg. 248
What is a factless fact table? Design a simple STAR schema with a factless fact table to track patients in a hospital by diagnostic procedures and time.
Business Intelligence Text
Application Case 3.8 – Question 1,2,3. page 138-139
1. Who are the customers for Expedia.com? Why is customer satisfaction a very important part of their business?
2. How did Expedia.com improve customer satisfaction with scorecards?
3. What were the challenges, the proposed solution, and the obtained results?
Data Warehousing Text
Exercise #2 pg. 279
Assume you are in the insurance business. Find two examples of type 2 slowly changing dimensions in that business. As an analyst on the project, write the specifications for applying the type 2 changes to the data warehouse with regard to the two examples.
Exercise #5 pg. 314
You are the staging area expert on the project team for a large toy manufacturer. Discuss the four modes of applying data to the data warehouse. Select the modes you want to use for your data warehouse and explain the reasons for your selection.
Exercise #2 pg. 337
Assume that you are the data quality expert on the data warehouse project team for a large financial institution with many legacy systems dating back to the 1970’s. Review the types of data quality problems you are likely to have and make suggestions on how to deal with those.
Exercise #2 Page 372
Compare the usage and value of information in the data warehouse with those in operational systems. Explain the major differences. Discuss and give examples.
Exercise #2 Page 405
As a senior analyst on the project team of a publishing company exploring the options for a data warehouse, make a case for OLAP. Describe the merits of OLAP and how it will be essential in your environment.
Exercise #2 Page 487
Prepare an outline for a standards manual for your data warehouse. Consider all types of objects and their naming conventions. Indicate why standards are important. Produce a detailed table of contents.
Data Warehousing Text
Exercise #5 Page 427
As the web specialist on the project team, prepare a document highlighting the major considerations for Web-enabling your data warehouse. Just list the considerations, not the implementation techniques.
Exercise #5 Page 460
In your project you are responsible for analyzing the requirements and selecting a toolset for data mining. Make a list of the criteria you will use for the toolset selection. Briefly explain why each criterion is necessary.
Exercise #4 Page 509
What are the considerations for deploying the data warehouse in stages? Under what circumstances is staged deployment recommended? Describe how you will plan to determine the stages.
Exercise #2 Page 525
You are specifically assigned to improve the query performance in your data warehouse deployed about six months ago. How will you plan for the assignment? What are the types of statistics you will need? Create a plan.
Business Intelligence Text
Question 14 Page 197
What are the privacy issues with data mining? Do you think they are substantial?
Application Case 5.6 –
Questions 1,2 -. page 231-232
1. How did Whirlpool use capabilities of text analytics to better understand their customers and improve product offerings?
2. What were the challenges, the proposed solution, and the obtained results?
Why Work with Us
Top Quality and Well-Researched Papers
We always make sure that writers follow all your instructions precisely. You can choose your academic level: high school, college/university or professional, and we will assign a writer who has a respective degree.
Professional and Experienced Academic Writers
We have a team of professional writers with experience in academic and business writing. Many are native speakers and able to perform any task for which you need help.
Free Unlimited Revisions
If you think we missed something, send your order for a free revision. You have 10 days to submit the order for review after you have received the final document. You can do this yourself after logging into your personal account or by contacting our support.
Prompt Delivery and 100% Money-Back-Guarantee
All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension. In case you cannot provide us with more time, a 100% refund is guaranteed.
Original & Confidential
We use several writing tools checks to ensure that all documents you receive are free from plagiarism. Our editors carefully review all quotations in the text. We also promise maximum confidentiality in all of our services.
24/7 Customer Support
Our support agents are available 24 hours a day 7 days a week and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.
Try it now!
How it works?
Follow these simple steps to get your paper done
Place your order
Fill in the order form and provide all details of your assignment.
Proceed with the payment
Choose the payment system that suits you most.
Receive the final file
Once your paper is ready, we will email it to you.
No need to work on your paper at night. Sleep tight, we will cover your back. We offer all kinds of writing services.
No matter what kind of academic paper you need and how urgent you need it, you are welcome to choose your academic level and the type of your paper at an affordable price. We take care of all your paper needs and give a 24/7 customer care support system.
Admission Essays & Business Writing Help
An admission essay is an essay or other written statement by a candidate, often a potential student enrolling in a college, university, or graduate school. You can be rest assurred that through our service we will write the best admission essay for you.
Our academic writers and editors make the necessary changes to your paper so that it is polished. We also format your document by correctly quoting the sources and creating reference lists in the formats APA, Harvard, MLA, Chicago / Turabian.
If you think your paper could be improved, you can request a review. In this case, your paper will be checked by the writer or assigned to an editor. You can use this option as many times as you see fit. This is free because we want you to be completely satisfied with the service offered.