Attached Files: File TCM 645 - Term Project -Tableau Instructions FALL 2022.pdf TCM 645 - Term Project -Tableau Instructions FALL 2022.pdf - Alternative Formats (611.549 KB) File TCM 645 Tableau data

Can Orhan TCM 645 – Program and Portfolio Management 1 | P a g e TCM 645 –Program and Portfolio Management –Term Project Details for Graduate Students : You will be working on building a Project Management Tracker - dashboard using Tableau Desktop version which provides insights on the project types for different region s, related project cost and count details using static data files . Please make sure that yo u watch Tableau training videos first. 1. You need to use the provided excel data files for your Tableau project . 2. Review the data file s provided and get familiar with the data. You need to understand the relationship and identify which fields can be used to connect the data from these 2 excel spreadsheets. 3. Remember to check for eliminating data when you define your filters. ( HINT: You can use a left join From Table and joi n on Region & Project Id fields. ) 4. Your assignment consists of building 4 data work sheets and 1 basic dashboard which connects all of these worksheets into 1 Dashboard . Data on the worksheets and dashboard should be dynamic, if a filter or multiple filters are used . (Selected or Unselected) Your graphs should also be updated along with project counts and totals. 5. The following screenshot contains the 4 Worksheets you need to build. You can use the Size ‘Desktop Browser 1200x 12 00 for your dashboard display: 6. Your submission need s to be in packaged workbook format. You can accomplish this easily when doing a “save as ”. But if you need more details, here is the link for saving your document in this format: Packaged Workbooks - Tableau 7. Have fun and start using Tableau. It’s very instrumental and very easy to use. 8. Below are some sample screenshot s of a complete d dashboard view. Changing data updates the dashboard view and count & total numbers dynamically. You do NOT need to use or learn Stor ies or building Story Points in Tableau for this assignment. 9. Since this is a dashboard, the Filter on the left should cont rol all of the data. That means if you change some filters all of the data on your dashboard should be updated. 10. Remember To add Region, Stakeholder and Project Priority Fields to all your Tableau Worksheets. 11. Total Project and Total Costs Work sheets only c ontain a number, no graphs needed . 12. I strongly recommend adding Tableau skill to your resumes. It’s very well adopted in the PM industry. 13. The original Tableau file needs to be created by you. Duplicate submissions may at least result to 0 grade for the term project. Can Orhan TCM 645 – Program and Portfolio Management 2 | P a g e