MMIS642 ASSIGNMENT
ASSIGNMENT DETAILS
General Instructions:
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.
PART 1
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?
PART 2
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.
PART 3
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?
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.
Our Services
Custom Writings Help is a Quality-Oriented Company in Online Writing as a result of hiring exceptional professionals to execute clients' tasks.
Essays
At Custom Writings Help,We understand the struggle of research paper writing, and that is why at Custom WritingS Help, we are all out to help you. We pride ourselves on having a team of clinical writers. The stringent and rigorous vetting process ensures that only the 'BEST' Writers are chosen for the job. We have highly qualified Ph.D. and MA writers working with us; we equally offer these experienced writers specific bonuses and incentives to make them deliver highly original, unique, and informative content at reasonably low prices.
Admissions
Thesis Writing Service
Worlwide, Many Masters Students are struggling with Thesis Completion. A thesis is likely to be the longest and most challenging piece of work a student has ever completed. However, unlike essays and other assignments, a student can pick a particular interest topic and work on their initiative. Fortunately, we are there for you. At Custom Writings Help, you are assured of an authentic, imaginative, informative, linguistically great, and advantageous thesis that adheres to all your needs. So, why continue considering different writers when you have discovered the best in the field?
Editing
Custom Papers
Not a single student can avoid writing custom papers. However, a total lack of experience, skills, and time makes it very hard to produce a superb writing piece. Therefore, if you are seeking professional help, turn to us. Our specialized and experienced writers compose a variety of model papers, including custom essays, college term papers, research papers, book reports, MBA essays, executive summaries, dissertations, Ph.D. theses, admission essays, and research proposals for college and university students at any level.
Coursework
Essay Writing
Most of the students disregard the critical principles of essay writing and compose papers below sensible guidelines. Therefore, with Custom Writings Help, one should not worry about his/her essay. Our Writers compose informative and engaging content on all complexities and topics. We write meaningful and smart essays while prioritizing all aspects that bring about a good grade, such as impeccable grammar, proper structure, zero-plagiarism, and conformance to guidelines.
Coursework
Coourse Work Writing
Don't let the seemingly never-ending onslaught of writing assignments get you down. If you are looking where to get course work assistance online, the writers at Custom Writings Help are here to assist you with all of your writing needs. We undertake to unique delivery of papers that meet the professor's requirements. The content is proofread, edited, and checked plagiarism before submission to customers. No matter how big or small your work is, we will deliver on time. Try US Now! !
Coursework
Dissertation Writing Service
High-Quality Dissertation Writing Services are rare. They require Ph.D. academicians – not easily found. However, are an exception. The years, time, and resources we have invested in the dissertation world has given us a competitive advantage over others. Choose to come to Custom Writings Help; You will find perfect Ph.D. consultants who have written hundreds of dissertations theses ready to help you. Let our dissertation-writing services help you craft your dissertation, for you are assured we will give you the results.