10~20 min read of the methodology/presentation/visual of the data reports:
https://wenku.baidu.com/view/04e1116da45177232f60a2cb.html https://wenku.baidu.com/view/aadedc6eaf1ffc4ffe47ace9.html
Choose 1 report, identify some good or learned elements, propose some change/new feature or questions not addressed by author
Task 2: Using Tableau public to create a map on Exercise file then
a. change map layer to actual landscape
b. Create a pie (divide Make by color) or bar chart, or hotmap on this map, to show (by country) the number of incidents
c. Create relationship to this new data source REFERENCE TABLE (希望这次交代清楚了:)
d. Compare Latitude from main file, against latitude from new reference file, in a visual way, to find which country had wrong data.
e. Use Tableau formula to see if you can replace the wrong latitude (southen hemisphere countries should be negative value)
f. Add a data table beside bar chart, format it to alternate color (line 1 background grey, line 2 white, line 3 grey ...)
g. stop filtering dashboard from a sheet, or setup 1 sheet to filter the dashboard
You can do these in Power BI,SuperSet (FREE TABLEAU ALTERNATIVE) ,Metabase, Python, Data Studio (IBM or Google+ Bigquery), or your SQL IDE if you can!
Task 3: 4 questions (SQL, Python, Tableau) to answer: https://dx9.typeform.com/to/qwMEJE
You can submit answer in the survey, or provide a MARKDOWN file and submit through Git commit, then pull request