part A
1)In theData Source Interfacewindow, connect to
the Homework_1_Crossfit_Games_2019 excel file (available in
the DOWNLOAD: Course Resources lesson), and perform the following actions:
Bring in the 2019_games_athletes_men source and enable data interpreter
Union the 2019_games_athletes_women source to your main table
Left join your main unioned table to the 2019_games_scores source using
the Competitorid field
2) Update and Transform your fields following the updates listed below:
Change Ordinal field to string type
Hide Competitorid
Split the profilepics3key field
Group the Age field into two groups – Under 40 and Over 40, based on their
values
3) Extract, filter and save your work:
Place a data source filter on overall rank less than 50
Extract the data source
Save your workbook as a .TWBX (Full Desktop)
Upload to Canvas
Place this order or similar order and get an amazing discount. USE Discount code “GET20” for 20% discount