Posted: February 15th, 2017
This week, you will begin putting the pieces together for your course project. Your assignment is to create a project plan and gather the requirements for the data warehouse that you are building. The project plan will list the steps that are required for the project, along with a timeline for how long each step will take to complete. The requirements are gathered based on the interview that you are doing with the project sponsor for ABC University. For the project plan: You can use Microsoft Excel or Microsoft Project, if available. For the requirements gathering: This will be a Word document where you list everything that the university requires for the enterprise data warehouse. Two files are to be submitted to the Dropbox for this assignment.
Full project detail for week3-7 You are a Business Intelligence Consultant who has been contacted by ABC University to submit a proposal for creating an enterprise data warehouse. They want to use this data warehouse to be able to see a single view of all university information for students, faculty, and staff. You are going to create a project plan, choose the BI tools that will be used, and give them cost information.
Currently, the information is contained in a separate database by each university department (HR, Payroll, Registrar, Bursar, etc.). Some of the information contained in the various databases for students are: courses, tuition payments, extracurricular activities, scholarships, grades, and personal information. Faculty/staff: positions held, courses taught, salary & benefits, personal information, and published work or research.
In Weeks 3-6, you are going to research and complete parts of the assignment. Then, in Week 7, you will submit the complete proposal, along with a PowerPoint presentation, to give highlights of your plan.
Guidelines Back to Top Papers should be at least 8-10 pages in length (this would be roughly one page per area included in the report), 10-point font, double-spaced, include a cover page, table of contents, introduction, body of the report, summary, or conclusion and works cited. Even though this is not a scientific-type writing assignment, and is mostly creative in nature, references are still very important. At least six authoritative, outside references are required (anonymous authors or Web pages are not acceptable). These should be listed on the last page titled “Works Cited.” Appropriate citations are required. All DeVry University policies are in effect, including the Plagiarism Policy. Papers are due during Week 7 of this course. Any questions about this paper may be discussed in the weekly Q & A Discussion topic. This paper is worth 200 total points and will be graded on quality of research topic, quality of paper information, use of citations, grammar, and sentence structure. Milestones:
Week 3: Project Plan and Requirements for the Data Warehouse Week 4: Database Design Week 5: ETL Tool Selection Week 6: Data Mining/Reporting Tool Grading Rubrics Back to Top Category Points % Description Overall Presentation 40 20% The professionalism of the proposal. Documentation & Formatting 20 10% Quality work will include a title page, table of contents, and a bibliography with references from all citations and sources used. Organization & Cohesiveness 40 20% Quality work will include an introduction based upon a well-formed thesis statement. The logical order of the content will be derived from the thesis statement. The content will be properly subdivided. With quality work, the conclusion will summarize the previously presented content, and will complement the thesis statement from the introduction. Editing 20 10% Quality work will be free of any spelling, punctuation, or grammatical errors. Sentences and paragraphs will be clear, concise, and factually correct. Content 80 40% Quality work will have significant scope and depth of research to support any statements. Relevant illustration or examples are encouraged. Quality work will employ sound use of reasoning and logic to reinforce conclusions. Total 200 100% A quality paper will meet or exceed all of the above requirements. Best Practices Back to Top The following are the best practices in preparing this paper:
Cover Page – Include who you prepared the paper for, who prepared, and date. Table of Contents – List the main ideas and section of your paper and the pages in which they are located. The illustrations should be included separately. Introduction – Use a header on your paper. This will indicate that you are introducing your paper. The purpose of an introduction or opening:
Introduce the subject and why the subject is important. Preview the main ideas and the order in which they will be covered. Establish a tone of the document. Include in the introduction a reason for the audience to read the paper. Also, include an overview of what you are going to cover in your paper and the importance of the material. (This should include or introduce the questions that you are asked to answer on each assignment):
Body of Your Report – Use a header titled with the name of your project. Example: “The Development of Hotel X – A World Class Resort.” Then, proceed to break out the main ideas. State the main ideas, state major points in each idea, and provide evidence. Break out each main idea that you will use in the body of your paper. Show some type of division like separate sections that are labeled, a separate group of paragraphs, or headers. You would include the information that you found during your research and investigation. Summary and Conclusion – Summarizing is similar to paraphrasing but presents the gist of the material in fewer words than the original. An effective summary identifies the main ideas and major support points from the body of your report. Minor details are left out. Summarize the benefits of the ideas and how they affect the tourism industry. Work Cited – Use the citation format as specified in the Syllabus. Additional hints on preparing the best possible project:
Apply a three-step process of writing…Plan, Write, and Complete. Prepare an outline of your research paper before you go forward. Complete a first draft and then go back to edit, evaluate, and make any changes that are required. Use visual communication to further clarify and support the written part of your report. You could use example graphs, diagrams, photographs, flowcharts, maps, drawings, animation, video clips, pictograms, tables, and Gantt chart
Place an order in 3 easy steps. Takes less than 5 mins.