Project Deliverable 3: Database and Data Warehousing Design This assignment consists of two (2) sections: a design document and a revised project plan. You must submit both sections as separate files for the completion of this assignment. Label each file
Home>Business & Finance homework help>Marketing homework help>Project Deliverable 3: Database and Data Warehousing Design This assignment consists of two (2) sections: a design document and a revised project plan. You must submit both sections as separate files for the completion of this assignment. Label each file
Gantt
| Create a Gantt Chart in this worksheet. Enter title of this project in cell B1. Information about how to use this worksheet, including instructions for screen readers and the author of this workbook is in the About worksheet. Continue navigating down column A to hear further instructions. | PROJECT TITLE | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Enter Company Name in cell B2. Enter the Project Start date in cell E2 or allow the sample formula to find the smallest date value from the Gantt Data table. Project Start Date: label is in cell C2. | DGT Data Analytica | Project Start Date: | 1/19/19 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Enter the name of the Project Lead in cell B3. A Scrolling Increment is in cell E3. Scrollbar is in cells H3 through M3. Increasing the scrolling increment or using the scrollbar will increment the Gantt chart timeline. An input of 0 in cell E3 resets the charting to the start of the project. | Project Lead | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| To modify the default Milestone Marker type, enter a 0, 1, or 2, in cell E5. The corresponding marker will appear in cell F5. To change the markers, modify the conditional format for that cell and the table below. Months for the dates in row 5 are displayed starting in cells H4 through cell BK4. Do not modify these cells. They are auto updated based on the project start date and scrollbar increment. Scrolling Increment: label is in cell C4. | Milestone Marker: | 1 | 1 | January | February | March | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Cells H5 through BK5 contain the day number of the month for the Month represented in the cell block above each date cell and are auto calculated. Do not modify these cells. Dates leading up to Today are shaded. | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | ||||||
| This row contains headers for the project schedule that follows below them. Navigate from B7 through BK7 to hear the content. The first letter of each day of the week for the date above that heading, starts in cell H7 and continues through cell BK7. All project timeline charting is auto generated based on the category, start date and number of days entered in the Milestones table. Formulas in these cells help create the look of the Gantt Chart. Do not modify these cells. | Milestone Description | Column1 | Progress | Start | No. Days | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | |
| Do not delete this row. This row is hidden to preserve a formula that is used to highlight the current day within the project schedule. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Enter Project information starting in cell B8 through cell F8. Sample data is in cells B8 through G32. Enter Milestone Description, assign someone to the item, enter the progress of the task as a percent of completion, enter a start date and duration of task in number of days. The Gantt chart will auto update as the data is entered. The next instruction is in cell A33. | Feasibility Study 1 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Preliminary Analysis | 50% | 1/22/19 | 5 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| PPIS | 100% | 1/27/19 | 4 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Usability Analysis | 50% | 1/19/19 | 10 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| D R Analysis | 2/11/19 | 1 | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 10% | 1/28/19 | 6 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Requirements Elicitation & Analysis 2 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Data Collection | 60% | 1/28/19 | 13 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Requirements Analysis | 50% | 1/29/19 | 9 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Task 3 | 33% | 2/6/19 | 11 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Task 4 | 2/15/19 | 1 | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Task 5 | 2/16/19 | 24 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Requirements Specification 3 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Task 1 | 2/6/19 | 4 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Task 2 | 2/10/19 | 14 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Task 3 | 2/26/19 | 6 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Task 4 | 3/11/19 | 3 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Task 5 | 3/3/19 | 19 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Requirements Validation 4 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Task 1 | 2/28/19 | 15 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Task 2 | 2/20/19 | 5 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Task 3 | 4/12/19 | 5 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| This is an empty row | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| This row marks the end of the Gantt milestone data. DO NOT enter anything in this row. To add more items, insert new rows above this one. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||