Can you help me on these?

Can Orhan TCM 645 – Project Control Systems 1 | P a g e TCM 645 –Project Control Systems –Term Project Details for Graduate 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 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 e xcel data files for your Tableau project . (in .csv format) 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. You need to link these tables in order to get the expected results. ( TCM 645 -A.csv needs to be linked to TCM 645 -B.csv file in the data section.) The data has the same field names in both of these files.) 3. Remember to check for eliminating data when you define your filters. ( HINT: You can exclude “Others ” related data during setting up your filters. ) 4. If you are not very familiar with the Join Types for data. Here is a good link which describes relationships for join types, in this article it talks about tables but it is applicable to all data sources. Consider your first excel data sheet a s Table 1 & a nd the second excel data sheet as Table 2 while reviewing the article. There are also diagrams if you scroll down the page: https://www.w3schools.com/sql/sql_join.asp 5. 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. 6. The following screenshot contains the 4 Worksheets you need to build. You can use the Size ‘Desktop Browser 1000x800 for your dashboard display: 7. 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: https:// onlinehelp.tableau.com/current/pro/desktop/en -us/save_savework_packagedworkbooks.htm 8. Have fun and start using Tableau. It’s very instrumental and very easy to use. Can Orhan TCM 645 – Project Control Systems 2 | P a g e 9. Below are some sample screenshot s of a completed 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.