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 file A.xlsx (1.425 MB)
File TCM 645 Tableau data file B.xlsx (53.904 KB)
Students enrolled in TCM 645 (graduate students or accelerated Master’s students).
I just want everyone to get the most benefit from our course and decided to use an industry standard tool so that you can use to advance in your current role or add it to your resume as a marketable skill in demand. This will also open up you to the world of Big Data and using tools where excel functionality and presentation tools are not robust to handle.
You will be working and applying your knowledge of Tableau and create a very basic dashboard which displays project count, cost, shareholder information based on dynamic filters. Please refer to the attached detail instructions for your term project. You have a full month to work on it and submit your project. I want you to submit your Tableau file as a packaged workbook. This adds your data files to your file.
You do NOT need to purchase Tableau, if you go to their website and register with a student email, they provide you a license key and a link to download the software for free. I have Tableau 2022.2 desktop version installed which is the most current version available. There are free detailed training videos available on their website with sample data to follow using the application. The term project only covers few fundamental features of the application and hopefully build you a good foundation to use this powerful tool for personal & business needs.
Remember to Review the Instructions File provided. (TCM 645- Term Project – Tableau Instructions)
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