I have attached you some details and I want you make me the presentation as shown in an example and I want you to write 500 words for my video presentation as I need to add my face to present the word...

1 answer below »
I have attached you some details and I want you make me the presentation as shown in an example and I want you to write 500 words for my video presentation as I need to add my face to present the word as I need the material to speak and explain the work and you need you make the tableau work as i have attached it in the files too


BUS2SMV Social Media and Visualisation Assessment 3: Storytelling through suitable Tableau visualisations Overview Throughout this subject, you have developed an understanding of Social Media, Social Media Marketing and how businesses use Social Media to drive engagement and product sales. You have also learned how to create visualisations and how to use them to tell compelling stories about your data. This assessment provides you with the opportunity to draw on all of what you have learned to tell Your Story using the Dataset provided. Specific Requirements This assessment has 2 parts. You will need to create an Oral Presentation via Video Recording. The recording will be of you giving a presentation using Tableau’s Storyboard Feature. The 2 parts - You must submit the following: 1. A video recording (min 5 – max 7 minutes long) • Record the video, you can use any method, Zoom or any other creative way. Make sure you are seen in the video (just the face is sufficient). • Upload to YouTube as an unlisted video and submit the YouTube link to Presentation part of the assessment submission. You can directly paste the YouTube link on to the Turnitin link as a text submission 2. Tableau workbook – Only in this (.twbx) format. To be submitted to Tableau part of the submission. (Note: You will see that there are 2 parts for the Turnitin submission. Make sure you do the submissions correctly) The content of the presentation needs to cover: 1. Your Data Story with effective use of visualisation(s) using the provided Dataset. a. You can choose to tell whatever story you’d like with whatever analysis you want using this dataset. It NEEDS to be PROFESSIONALLY done. b. You can use additional data or information in your story to support your analysis. 2. A presentation providing information: a. Storytelling using Tableau’s storyboard feature. Minimum 5 Visualisations and 1 Dashboard. If possible, have more dashboards. You are telling a story from the viewpoint of a consultant who is either hired by the organisation or has analysed the dataset quite closely. You could be addressing the authorities, or the organisation or public. Please specify your audience at the beginning. b. A strong conclusion – Recommendations to the problem identified. You’ll be required to use external information sources to validate your recommendations (citations to be used). c. Keep the last 2 mins to discuss visualisation techniques used in each visualisation, e.g., colour, shape, position, interactivity etc. Analysis of why you chose these techniques and what makes them effective (refer to lecture materials and Tableau’s online resources). Please refer to the relevant Visualisation when explaining this. d. End with a reference slide – Minimum 4 references in Harvard (https://latrobe.libguides.com/harvard) https://latrobe.libguides.com/harvard Road_Crashes_for_five_Years_-_V XYobjectidaccident_noabs_codeaccident_statusaccident_dateaccident_timealcoholtimeaccident_typeday_of_weekdca_codehit_run_flaglight_conditionpolice_attendroad_geometryseverityspeed_zonerun_offroadnode_idlongitudelatitudenode_typelga_nameregion_namevicgrid_xvicgrid_ytotal_personsinj_or_fatalfatalityseriousinjuryotherinjurynoninjuredmalesfemalesbicyclistpassengerdriverpedestrianpillionmotoristunknownped_cyclist_5_12ped_cyclist_13_18old_pedestrianold_driveryoung_driveralcohol_relatedunlicencsedno_of_vehiclesheavyvehiclepassengervehiclemotorcyclepublicvehicledeg_urban_namedeg_urban_alllga_name_allregion_name_allsrnssrns_allrmarma_alldivideddivided_allstat_div_name 2498217.170000022454870.2521T20140013514ABS to receive accidentUnfinished7/1/1413:09:00NoCollision with vehicleMondayRIGHT THROUGHNoDayYesUnknownOther injury accident60 km/hrNo49465144.97986051-37.40669886IntersectionMITCHELLNORTHERN REGION2498217.172454870.25241001313022000000000No120200TOWNSTOWNSMITCHELLNORTHERN REGIONBBArterial HighwayLocal Road,Arterial HighwayUndividedUndividedCountry 2502934.962423005.2892T20140013549ABS to receive accidentFinished7/2/140:01:00YesCollision with vehicleWednesdayU TURNNoDark Street lights onYesNot at intersectionOther injury accident60 km/hrNo272595-1-1Non-IntersectionWHITTLESEAMETROPOLITAN NORTH WEST REGION2502934.962423005.28943003103022000000001No020200MELB_URBANMELB_URBANWHITTLESEAMETROPOLITAN NORTH WEST REGIONArterial OtherArterial OtherUndividedUndividedMetro 2520154.0392395621.6743T20140013561ABS to receive accidentFinished7/2/148:30:00Nocollision with some other objectWednesdaySTRUCK OBJECT ON CARRIAGEWAYNoDusk/DawnYesNot at intersectionOther injury accident50 km/hrNo273609Non-IntersectionKNOXMETROPOLITAN SOUTH EAST REGION2520154.0392395621.67411001001001000000000No010100MELB_URBANMELB_URBANKNOXMETROPOLITAN SOUTH EAST REGIONLocal RoadLocal RoadUndividedUndividedMetro 2473719.463000012402357.3194T20140013563ABS to receive accidentFinished7/2/1410:08:00NoCollision with vehicleWednesdayCROSS TRAFFIC(INTERSECTIONS ONLY)YesUnk.NoCross intersectionOther injury accidentNot knownNo44382-1-1IntersectionWYNDHAMMETROPOLITAN NORTH WEST REGION2473719.4632402357.31931001221012000000000No020200MELB_URBANMELB_URBANWYNDHAMMETROPOLITAN NORTH WEST REGIONCCArterial OtherArterial Other,Local RoadDividedUndivided,DividedMetro 2484073.998000022409123.6825T20140013567ABS to receive accidentFinished7/2/149:12:00NoCollision with vehicleWednesdayRIGHT THROUGHNoDayYesCross intersectionOther injury accident60 km/hrNo38531-1-1IntersectionWYNDHAMMETROPOLITAN NORTH WEST REGION2484073.9982409123.68221001120002000000010No021100MELB_URBANMELB_URBANWYNDHAMMETROPOLITAN NORTH WEST REGIONArterial OtherArterial Other,Local RoadUndividedUndividedMetro 2496690.5662406551.553000016T20140013582ABS to receive accidentFinished7/2/1412:20:00NoCollision with a fixed objectWednesdayOFF RIGHT BEND INTO OBJECT/PARKED VEHICLENoDayYesNot at intersectionSerious injury accident40 km/hrYes273095144.96206241-37.84213095Non-IntersectionPORT PHILLIPMETROPOLITAN NORTH WEST REGION2496690.5662406551.55311010010000001000000No010010MELB_URBANMELB_URBANPORT PHILLIPMETROPOLITAN NORTH WEST REGIONLocal RoadLocal RoadUndividedUndividedMetro 2491565.8692416426.377T20140013503ABS to receive accidentFinished7/1/147:45:00NoCollision with vehicleTuesdayCROSS TRAFFIC(INTERSECTIONS ONLY)NoDayYesCross intersectionSerious injury accident40 km/hrNo63436144.90428669-37.75307714IntersectionMOONEE VALLEYMETROPOLITAN NORTH WEST REGION2491565.8692416426.3721010111002000000000No020100MELB_URBANMELB_URBANMOONEE VALLEYMETROPOLITAN NORTH WEST REGIONLocal RoadLocal RoadUndividedUndividedMetro 2524006.5222388295.4738T20140013532ABS to receive accidentFinished7/1/1417:35:00NoCollision with vehicleTuesdayREAR END(VEHICLES IN SAME LANE)NoDusk/DawnYesCross intersectionSerious injury accident80 km/hrNo29726145.27319217-38.00626865IntersectionCASEYMETROPOLITAN SOUTH EAST REGION2524006.5222388295.47352011332023000000000No030300MELB_URBANMELB_URBANCASEYMETROPOLITAN SOUTH EAST REGIONAAArterial HighwayArterial Other,Arterial HighwayDividedDivided,UndividedMetro 2238092.7872807967.7289T20140013578ABS to receive accidentUnfinished7/2/1412:20:00NoCollision with vehicleTuesdayCROSS TRAFFIC(INTERSECTIONS ONLY)NoDayYesUnknownOther injury accident50 km/hrNo49225142.1612197-34.18979621IntersectionMILDURAWESTERN REGION2238092.7872807967.72841001322022000000001No020200SMALL_CITIESSMALL_CITIESMILDURAWESTERN REGIONLocal RoadLocal RoadUndividedUndividedCountry 2483961.0982408148.44110T20140013589ABS to receive accidentFinished7/1/1418:00:00YesCollision with vehicleTuesdayLANE CHANGE LEFT (NOT OVERTAKING)NoDark Street lights onYesNot at intersectionOther injury accident100 km/hrNo274299Non-IntersectionHOBSONS BAYMETROPOLITAN NORTH WEST REGION2483961.0982408148.44131001203012000000000No020200MELB_URBANMELB_URBANHOBSONS BAYMETROPOLITAN NORTH WEST REGIONMMFreewayFreewayDividedDividedMetro 2507925.389000012434928.93111T20140013597ABS to receive accidentFinished7/2/1410:45:00NoStruck PedestrianWednesdayFAR SIDE. PED HIT BY VEHICLE FROM THE LEFTYesDayNoNot at intersectionOther injury accident50 km/hrNo278705145.0897231-37.58635549Non-IntersectionWHITTLESEAMETROPOLITAN NORTH WEST REGION2507925.3892434928.93121001111001100000000No010100MELB_URBANMELB_URBANWHITTLESEAMETROPOLITAN NORTH WEST REGIONLocal RoadLocal RoadUndividedUndividedMetro 2519943.0872405930.00212T20140013620ABS to receive accidentFinished7/2/1416:15:00NoCollision with vehicleWednesdayVEHICLE STRIKES ANOTHER VEH WHILE EMERGING FROM DRIVEWAYNoDusk/DawnYesNot at intersectionSerious injury accident80 km/hrNo199769-1-37.84752653Non-IntersectionKNOXMETROPOLITAN SOUTH EAST REGION2519943.0872405930.00231010221012000000001No020200MELB_URBANMELB_URBANKNOXMETROPOLITAN SOUTH EAST REGIONArterial OtherArterial OtherDividedDividedMetro 2494680.581000012413047.6313T20140013533ABS to receive accidentUnfinished7/1/1418:05:00YesCollision with vehicleMondayREAR END(VEHICLES IN SAME LANE)NoDark Street lights onYesUnknownOther injury accident100 km/hrNo356518144.93956893-37.78353915Non-IntersectionMELBOURNEMETROPOLITAN NORTH WEST REGION2494680.5812413047.6352002331023000000002No030300MELB_URBANMELB_URBANMELBOURNEMETROPOLITAN NORTH WEST REGIONMMFreewayFreewayDividedDividedMetro 2502059.025000012417867.2470000114T20140013593ABS to receive accidentFinished7/2/1413:00:00NoCollision with vehicleWednesdayRIGHT THROUGHNoDayYesCross intersectionOther injury accident50 km/hrNo1188-1-1IntersectionDAREBINMETROPOLITAN NORTH WEST REGION2502059.0252417867.24721001101002000000000No020200MELB_URBANMELB_URBANDAREBINMETROPOLITAN NORTH WEST REGIONArterial HighwayArterial Highway,Arterial OtherDividedUndivided,DividedMetro 2498534.7262423633.98615T20140013610ABS to receive accidentFinished7/2/1415:50:00NoCollision with a fixed objectWednesdayLEFT OFF CARRIAGEWAY INTO OBJECT/PARKED VEHICLENoDayYesNot at intersectionOther injury accident100 km/hrYes272631-1-1Non-IntersectionWHITTLESEAMETROPOLITAN NORTH WEST REGION2498534.7262423633.98611001010001000000000No010100MELB_URBANMELB_URBANWHITTLESEAMETROPOLITAN NORTH WEST REGIONMMFreewayFreewayDividedDividedMetro 2511669.752415721.9716T20140013611ABS to receive accidentFinished7/2/1416:40:00NoCollision with vehicleWednesdayREAR END(VEHICLES IN SAME LANE)NoDayYesNot at intersectionSerious injury accident70 km/hrNo274056-1-1Non-IntersectionMANNINGHAMMETROPOLITAN SOUTH EAST REGION2511669.752415721.9721010111001001000000No020110MELB_URBANMELB_URBANMANNINGHAMMETROPOLITAN SOUTH EAST REGIONArterial OtherArterial OtherDividedDividedMetro 2432500.10372522242.413517T20140013619Non ABS accidentFinished7/2/1418:00:00YesCollision with vehicleWednesdayOTHER MANOEUVRING NOT INCLUDED IN DCAs 140-148NoDusk/DawnYesPrivate propertyOther injury accidentCamping grounds or off roadNo273328Off RoadBENDIGONORTHERN REGION2432500.103722522242.4134721001102011000000010No020200LARGE_PROVINCIAL_CITIESLARGE_PROVINCIAL_CITIESBENDIGONORTHERN REGIONCountry 2496742.759000022418172.2818T20140013632ABS to receive accidentFinished7/1/1418:20:00YesCollision with vehicleTuesdayRIGHT NEAR (INTERSECTIONS ONLY)NoDusk/DawnYesT intersectionSerious injury accident50 km/hrNo861144.96304414-37.73737515IntersectionMORELANDMETROPOLITAN NORTH WEST REGION2496742.7592418172.2821010120101000000000No020100MELB_URBANMELB_URBANMORELANDMETROPOLITAN NORTH WEST REGIONLocal RoadLocal RoadUndividedUndividedMetro 2470820.693000022405332.98519T20140013642ABS to receive accidentFinished7/2/1420:38:00YesStruck PedestrianWednesdayFAR SIDE. PED HIT BY VEHICLE FROM THE LEFTYesDark Street lights onYesCross intersectionSerious injury accident50 km/hrNo225891144.66846913-37.8526072IntersectionWYNDHAMMETROPOLITAN NORTH WEST REGION2470820.6932405332.98541010320012100000001No020200MELB_URBANMELB_URBANWYNDHAMMETROPOLITAN NORTH WEST REGIONLocal RoadLocal RoadUndividedUndividedMetro 2523538.5172404691.75420T20140013508ABS to receive accidentFinished7/1/146:50:00NoCollision with vehicleTuesdayRIGHT NEAR (INTERSECTIONS ONLY)NoDark Street lights onYesT intersectionOther injury accident60 km/hrNo67559IntersectionKNOXMETROPOLITAN SOUTH EAST REGION2523538.5172404691.75431001212011001000000No020110MELB_URBANMELB_URBANKNOXMETROPOLITAN SOUTH EAST REGIONArterial OtherArterial Other,Local RoadUndividedUndividedMetro 2520749.7382398706.96121T20140013516ABS to receive accidentFinished7/1/1414:22:00NoCollision with vehicleMondayLEFT FAR (INTERSECTIONS ONLY)NoDayYesT intersectionSerious injury accident80 km/hrNo41878145.23603603-37.91252782IntersectionKNOXMETROPOLITAN SOUTH EAST REGION2520749.7382398706.96121010111002000000000No020200MELB_URBANMELB_URBANKNOXMETROPOLITAN SOUTH EAST REGIONArterial HighwayLocal Road,Arterial HighwayDividedUndivided,DividedMetro 2504925.3282407302.77722T20140013534ABS to receive accidentFinished7/1/1418:28:00YesStruck PedestrianTuesdayPED NEAR SIDE. PED HIT BY VEHICLE FROM THE RIGHT.NoDark Street lights onYesT intersectionOther injury accident60 km/hrNo40434-1-1IntersectionBOROONDARAMETROPOLITAN SOUTH EAST REGION2504925.3282407302.77721001111001100000000No010100MELB_URBANMELB_URBANBOROONDARAMETROPOLITAN SOUTH EAST REGIONArterial OtherArterial Other,Local RoadUndividedUndividedMetro 2504342.2562393778.03123T20140013565ABS to receive accidentFinished7/1/1419:35:00YesStruck PedestrianTuesdayPED NEAR SIDE. PED HIT BY VEHICLE FROM THE RIGHT.NoDark Street lights onYesT intersectionSerious injury accident60 km/hrNo243678145.04944214-37.95717918Non-IntersectionKINGSTONMETROPOLITAN SOUTH EAST REGION2504342.2562393778.03121010111001100001000No010100MELB_URBANMELB_URBANKINGSTONMETROPOLITAN SOUTH EAST REGIONArterial OtherArterial Other,Local RoadUndividedUndividedMetro 2526233.023000012406404.44624T20140013599ABS to receive accidentFinished7/2/1415:41:00NoCollision with a fixed objectWednesdayLEFT OFF CARRIAGEWAY INTO OBJECT/PARKED VEHICLENoDayYesNot at intersectionSerious injury accident50 km/hrYes272511Non-IntersectionKNOXMETROPOLITAN SOUTH EAST REGION2526233.0232406404.44611010010001000000000Yes110100MELB_URBANMELB_URBANKNOXMETROPOLITAN SOUTH EAST REGIONLocal RoadLocal RoadUndividedUndividedMetro 2463001.1792424081.0725T20140013640ABS to receive accidentFinished7/2/1415:14:00NoStruck PedestrianWednesdayPED NEAR SIDE. PED HIT BY VEHICLE FROM THE RIGHT.NoDayYesCross intersectionOther injury accident50 km/hrNo29754-1-1IntersectionMELTONMETROPOLITAN NORTH WEST REGION2463001.1792424081.0721001111001100000000No010100SMALL_CITIESSMALL_CITIESMELTONMETROPOLITAN NORTH WEST REGIONCCArterial OtherArterial Other,Local RoadDividedDividedMetro 2361360.5862447885.40626T20140013562ABS to receive accidentFinished7/2/147:00:00NoVehicle overturned (no collision)WednesdayOFF CARRIAGEWAY TO LEFTNoDayYesNot at intersectionOther injury accident100 km/hrYes272596Non-IntersectionPYRENEESWESTERN REGION2361360.5862447885.40622002011011000000000No010100RURAL_VICTORIARURAL_VICTORIAPYRENEESWESTERN REGIONLocal RoadLocal RoadUndividedUndividedCountry 2506511.0492390953.71127T20140013566ABS to receive accidentFinished7/1/1420:50:00YesCollision with vehicleTuesdayRIGHT NEAR (INTERSECTIONS ONLY)NoDark Street lights offYesT intersectionOther injury accident80 km/hrNo231516145.07420005-37.98260169IntersectionKINGSTONMETROPOLITAN SOUTH EAST REGION2506511.0492390953.71121001102002000000000No020200MELB_URBANMELB_URBANKINGSTONMETROPOLITAN SOUTH EAST REGIONArterial HighwayArterial HighwayDividedUndivided,DividedMetro 2512860.1232375283.42228T20140013672ABS to receive accidentFinished7/3/1413:50:00NoCollision with vehicleThursdayRIGHT THROUGHNoDayYesNot at intersectionSerious injury accident50 km/hrNo55991-1-1IntersectionFRANKSTONMETROPOLITAN SOUTH EAST REGION2512860.1232375283.42221010111001000100000No020100MELB_URBANMELB_URBANFRANKSTONMETROPOLITAN SOUTH EAST REGIONLocal RoadLocal RoadUndividedUndividedMetro 2500961.271000012416398.7400000129T20140013703ABS to receive accidentFinished7/3/1417:37:00NoCollision with vehicleThursdayRIGHT THROUGHNoDusk/DawnYesCross intersectionSerious injury accident60 km/hrNo37986145.01090877-37.75336056IntersectionDAREBINMETROPOLITAN NORTH WEST REGION2500961.2712416398.7421010120101000000010No020100MELB_URBANMELB_URBANDAREBINMETROPOLITAN NORTH WEST REGIONLocal RoadLocal RoadUndividedUndividedMetro 2583476.7832369998.54930T20140013712ABS to receive accidentFinished7/3/1417:00:00NoCollision with vehicleWednesdayRIGHT NEAR (INTERSECTIONS ONLY)NoDusk/DawnYesT intersectionOther injury accident60 km/hrNo278706145.9525372-38.16762935IntersectionBAW BAWEASTERN REGION2583476.7832369998.54931001221012000000000No020200SMALL_CITIESSMALL_CITIESBAW BAWEASTERN REGION,EASTERN REGIONCCArterial OtherLocal Road,Arterial OtherUndividedUndividedCountry 2653141.2732370145.9731T20140013723ABS to receive accidentFinished7/3/1420:59:00YesCollision with vehicleThursdayHEAD ON (NOT OVERTAKING)NoDark No street lightsYesNot at intersectionSerious injury accident100 km/hrNo275287-1-1Non-IntersectionWELLINGTONEASTERN REGION2653141.2732370145.9722020011002000000000Yes120200RURAL_VICTORIARURAL_VICTORIAWELLINGTONEASTERN REGION,EASTERN REGIONAAArterial HighwayArterial HighwayUndividedUndividedCountry 2501434.8922402437.00132T20140013726ABS to receive accidentUnfinished7/3/1421:15:00YesCollision with vehicleWednesdayRIGHT THROUGHNoDark Street lights onYesUnknownOther injury accident60 km/hrNo41249145.01631058-37.87915565IntersectionGLEN EIRAMETROPOLITAN SOUTH EAST REGION2501434.8922402437.00121001102002000000000No020200MELB_URBANMELB_URBANGLEN EIRAMETROPOLITAN SOUTH EAST REGIONArterial OtherArterial Other,Local RoadUndividedUndividedMetro 2511853.6712424317.06633T20140013494ABS to receive accidentFinished7/1/141:11:00YesCollision with a fixed objectTuesdayLEFT OFF CARRIAGEWAY INTO OBJECT/PARKED VEHICLENoDark Street lights onYesNot at intersectionFatal accident60 km/hrYes272364-1-1Non-IntersectionNILLUMBIKMETROPOLITAN NORTH WEST REGION2511853.6712424317.06622101020011000000000No010100MELB_URBANMELB_URBANNILLUMBIKMETROPOLITAN NORTH WEST REGIONLocal RoadLocal RoadUndividedUndividedMetro 2510900.1952412595.9250000134T20140013536ABS to receive accidentFinished7/1/1413:30:00NoStruck PedestrianTuesdayPED STRUCK WALKING TO/FROM OR BOARDING/ALIGHTING VEHICLE.YesDayNoT intersectionSerious injury accidentNot knownNo39301-1-1IntersectionMANNINGHAMMETROPOLITAN SOUTH EAST REGION2510900.1952412595.92521010110000100100000No010000MELB_URBANMELB_URBANMANNINGHAMMETROPOLITAN SOUTH EAST REGIONArterial OtherArterial OtherDividedDivided,UndividedMetro 2397538.8022433514.75935T20140013605ABS to receive accidentFinished7/2/1415:40:00NoCollision with vehicleWednesdayOTHER ON PATHNoDayYesNot at intersectionFatal accident50 km/hrNo272589-1-1Non-IntersectionBALLARATWESTERN REGION2397538.8022433514.75911100010001000000010No020200LARGE_PROVINCIAL_CITIESLARGE_PROVINCIAL_CITIESBALLARATWESTERN REGIONLocal RoadLocal RoadUndividedUndividedCountry 2523675.272000012405598.65236T20140013609ABS to receive accidentFinished7/2/1416:50:00NoCollision with vehicleWednesdayCROSS TRAFFIC(INTERSECTIONS ONLY)NoDayNoCross intersectionOther injury accidentNot knownNo40974IntersectionKNOXMETROPOLITAN SOUTH EAST REGION2523675.2722405598.65221001120101000000000No020100MELB_URBANMELB_URBANKNOXMETROPOLITAN SOUTH EAST REGIONArterial OtherArterial Other,Local RoadUndividedUndividedMetro 2514666.312000012391927.60337T20140013647Non ABS accidentUnfinished7/3/142:45:00YesCollision with a fixed objectWednesdayRIGHT OFF CARRIAGEWAY INTO OBJECT/PARKED VEHICLEYesDark Street lights onYesUnknownOther injury accident50 km/hrYes356197145.16692241-37.97372634Off RoadDANDENONGMETROPOLITAN SOUTH EAST REGION2514666.3122391927.60311001001001000000000No010100MELB_URBANMELB_URBANDANDENONGMETROPOLITAN SOUTH EAST REGIONMetro 2536612.872000012568463.4220000138T20140013666ABS to receive accidentFinished7/3/1411:45:00NoStruck PedestrianThursdayFAR SIDE. PED HIT BY VEHICLE FROM THE LEFTNoDayYesCross intersectionSerious injury accident60 km/hrNo45186-1-1IntersectionSHEPPARTONNORTH EASTERN REGION2536612.8722568463.42221010102001100000010No010100SMALL_CITIESSMALL_CITIESSHEPPARTONNORTH EASTERN REGIONAAArterial HighwayLocal Road,Arterial HighwayDividedDivided,UndividedCountry 2520016.273000022409443.6830000139T20140013764ABS to receive accidentFinished7/2/1412:20:00NoCollision with vehicleWednesdayRIGHT REAR.NoDayNoCross intersectionOther injury accident60 km/hrNo29867-1-1IntersectionMAROONDAHMETROPOLITAN SOUTH EAST REGION2520016.2732409443.68331001221012000000010No020200MELB_URBANMELB_URBANMAROONDAHMETROPOLITAN SOUTH EAST REGIONArterial HighwayArterial Highway,Arterial Other,Local RoadDividedUndivided,DividedMetro 2490953.8552411273.01540T20140013509ABS to receive accidentFinished7/1/1412:00:00NoCollision with vehicleTuesdayCROSS TRAFFIC(INTERSECTIONS ONLY)NoDayYesCross intersectionOther injury accident50 km/hrNo140-1-1IntersectionMARIBYRNONGMETROPOLITAN NORTH WEST REGION2490953.8552411273.01531001212012000000001No020200MELB_URBANMELB_URBANMARIBYRNONGMETROPOLITAN NORTH WEST REGIONLocal RoadLocal RoadUndividedUndividedMetro 2510217.023000012409956.18641T20140013547ABS to receive accidentFinished7/1/1417:45:00NoStruck PedestrianTuesdayPED NEAR SIDE. PED HIT BY VEHICLE FROM THE RIGHT.NoDusk/DawnNoT intersectionOther injury accidentNot knownNo65785-1-1IntersectionWHITEHORSEMETROPOLITAN SOUTH EAST REGION2510217.0232409956.18621001111001100000000No010100MELB_URBANMELB_URBANWHITEHORSEMETROPOLITAN SOUTH EAST REGIONArterial OtherArterial Other,Local RoadUndividedUndividedMetro 2465920.9812443629.6542T20140013551ABS to receive accidentFinished7/2/143:54:00YesCollision with a fixed objectWednesdayRIGHT OFF CARRIAGEWAY INTO OBJECT/PARKED VEHICLENoDark No street lightsYesNot at intersectionSerious injury accident110 km/hrYes286564144.61494049-37.50764331Non-IntersectionMACEDON RANGESNORTHERN REGION2465920.9812443629.6511010010001000000000No010100TOWNSRURAL_VICTORIA,TOWNSMACEDON RANGESNORTHERN REGIONMMFreewayFreewayDividedDividedCountry 2512899.970000012425068.0343T20140013583ABS to receive accidentFinished7/2/1411:35:00NoNo collision and no object struckWednesdayOUT OF CONTROL ON CARRIAGEWAY (ON STRAIGHT)NoDayYesNot at intersectionSerious injury accident70 km/hrNo272597Non-IntersectionNILLUMBIKMETROPOLITAN NORTH WEST REGION2512899.972425068.0311010010000001000000No010010MELB_URBANMELB_URBANNILLUMBIKMETROPOLITAN NORTH WEST REGIONCCArterial OtherArterial OtherDividedDividedMetro 2509675.042000022398432.8630000144T20140013588ABS to receive accidentFinished7/2/1413:30:00NoCollision with vehicleWednesdayVEHICLE STRIKES ANOTHER VEH WHILE EMERGING FROM DRIVEWAYNoDayYesNot at intersectionSerious injury accident50 km/hrNo272879145.11001466-37.91521899Non-IntersectionMONASHMETROPOLITAN SOUTH EAST REGION2509675.0422398432.86322011011002000000001No030300MELB_URBANMELB_URBANMONASHMETROPOLITAN SOUTH EAST REGIONLocal RoadLocal RoadUndividedUndividedMetro 2523488.1952379984.2680000145T20140013598ABS to receive accidentFinished7/2/1414:20:00NoCollision with vehicleWednesdayREAR END(VEHICLES IN SAME LANE)NoDayYesNot at intersectionSerious injury accident80 km/hrNo272881-1-38.08114063Non-IntersectionCASEYMETROPOLITAN SOUTH EAST REGION2523488.1952379984.26872011543034000000000No040400MELB_URBANMELB_URBANCASEYMETROPOLITAN SOUTH EAST REGIONArterial OtherArterial OtherUndividedUndividedMetro 2499978.4462409514.16946T20140013616ABS to receive accidentFinished7/2/1418:30:00YesCollision with vehicleWednesdayRIGHT NEAR (INTERSECTIONS ONLY)NoDark Street lights onYesCross intersectionOther injury accident60 km/hrNo37193IntersectionYARRAMETROPOLITAN NORTH WEST REGION2499978.4462409514.16921001111101000000000No020100MELB_URBANMELB_URBANYARRAMETROPOLITAN NORTH WEST REGIONArterial OtherArterial Other,Local RoadUndividedUndividedMetro 2505078.566000012392833.68447T20140013624ABS to receive accidentFinished7/2/1411:30:00NoCollision with vehicleWednesdayREAR END(VEHICLES IN SAME LANE)NoDayNoCross intersectionOther injury accident80 km/hrNo42744IntersectionKINGSTONMETROPOLITAN SOUTH EAST REGION2505078.5662392833.68421001111002000000001No020200MELB_URBANMELB_URBANKINGSTONMETROPOLITAN SOUTH EAST REGIONArterial HighwayArterial Other,Local Road,Arterial HighwayDividedDivided,UndividedMetro 2537431.882000012476349.2580000148T20140013663ABS to receive accidentFinished7/3/147:15:00NoCollision with vehicleThursdayCROSS TRAFFIC(INTERSECTIONS ONLY)NoDusk/DawnYesCross intersectionOther injury accident50 km/hrNo29972IntersectionMURRINDINDINORTH EASTERN REGION2537431.8822476349.25821001120002000000000No020200TOWNSTOWNSMURRINDINDI,MURRINDINDINORTH EASTERN REGIONBBArterial HighwayLocal Road,Arterial HighwayDividedDivided,UndividedCountry 2556495.525000012433879.15949T20140013674ABS to receive accidentFinished7/3/1414:01:00Nocollision with some other objectThursdaySTRUCK OBJECT ON CARRIAGEWAYNoDayYesNot at intersectionOther injury accident100 km/hrNo273151-1-1Non-IntersectionYARRA RANGESMETROPOLITAN SOUTH EAST REGION2556495.5252433879.15921001120011000000000No010100RURAL_VICTORIARURAL_VICTORIAYARRA RANGESMETROPOLITAN SOUTH EAST REGIONBBArterial HighwayArterial HighwayUndividedUndividedMetro 2501932.4842401577.40550T20140013675ABS to receive accidentFinished7/3/1414:25:00NoStruck PedestrianThursdayPED NEAR SIDE. PED HIT BY VEHICLE FROM THE RIGHT.NoDayYesCross intersectionOther injury accident60 km/hrNo41275-1-1IntersectionGLEN EIRAMETROPOLITAN SOUTH EAST REGION2501932.4842401577.40521001111001100000100No010100MELB_URBANMELB_URBANGLEN EIRAMETROPOLITAN SOUTH EAST REGIONArterial OtherArterial Other,Local RoadUndividedUndividedMetro 2528644.163000012402196.65651T20140013739ABS
Answered Same DayJun 05, 2022

Answer To: I have attached you some details and I want you make me the presentation as shown in an example and...

Mohd answered on Jun 05 2022
92 Votes
Number of cases by Months:
Accident Date
    
    
    
    7,109
    
    
    7000
    
    6,727
    6,892
    
    
    
    
    
    
    
    
    
    
    
    6500
    
    6,358
    6,347
    
    
    6,432
    6,471
    
    
    6000
    6,040
    6,005
    
    
    
    
    
    5,857
    
    5500
    
    
    
    
    
    
    
    
    
    5000

    
    
    
    NumberofRecords
    4500
    
    
    
    
    4000
    
    
    
    
    3500
    
    
    
    
    3000
    
    
    
    
    
    
    
    
    
    2500
    
    
    
    
    2000
    
    
    
    
    1500
    
    
    
    
    1000
    
    
    
    
    500
    
    
    
    
    0
    
    
    
January February March April May June July August September October Thetrendofsum ofNumberofRecordsforAccidentDateMonth.Themarksarelabeledbysum ofNumberofRecords.
NumberofcasesbyMonths
    NumberofRecords
7000
6500
6000
5500
5000
4500
4000
3500
3000
2500
2000
1500
1000
500
0
AccidentDate
6,695
6,580
November
December
Thetrendofsum ofNumberofRecordsforAccidentDateMonth.Themarksarelabeledbysum ofNumberofRecords.
· .
First visualization we have built is number of cases by month. We can see from graph, number of cases peaked in March May and November.
HitRungeographicaly
© 2022Mapbox© OpenStreetMap EASTERN
MapbasedonLongitudeandLatitude.ColorshowsdetailsaboutHitRunFlag.ThemarksarelabeledbyRegionName.ThedataisfilteredonLongitudeandAction(Region Name).TheLongitudefilterkeepsnon-Nulvaluesonly.TheAction(RegionName)filterkeeps1member.
Yes
Paretoofcasesvsaccidenttype
AccidentType
    
    
    
    
    
    96.67%
    100%
    
    
    
    
    
    
    
    
    
    
    45K
    
    
    
    91.70%
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    86.52%
    
    90%
    
    
    
    
    
    
    
    
    
    
    40K
    
    
    
    
    
    
    
    
    
    76.86%
    
    
    80%
    ofTotalRunningSum ofNumberofRecords
    
    
    
    
    
    
    
    
    
    35K
    
    
    
    
    
    
    
    
    
    
    
    
    70%
    
    NumberofRecords
    30K
    
    
    
    
    
    
    
    
    60.74%
    
    
    
    60%
    
    
    
    
    
    
    
    
    
    
    25K
    
    
    
    
    
    
    
    
    
    
    
    
    50%
    
    
    20K
    
    
    
    
    40%
    
    
    15K
    
    
    
    
    
    
    
    
    
    
    
    
    30%
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    %
    
    
    
    
    
    
    
    
    
    10K
    
    
    
    
    20%
    
    
    
    
    
    
    
    
    
    
    5K
    
    
    
    
    10%
    
    
    0K
    
    
    
    
    0%
    
Colisionwithv.Colisionwitha.StruckPedestri.Vehicleovertur.Nocolisionan.
MeasureNames
% ofTotalRunningSum ofNumberofRecordsalongTable(Across) NumberofRecords
ThetrendsofNumberofRecordsand% ofTotalRunningSum ofNumberofRecordsalongTable(Across)for AccidentType.ColorshowsdetailsaboutNumberofRecordsand% ofTotalRunningSum ofNumberof RecordsalongTable(Across).Forpane% ofTotalRunningSum ofNumberofRecords:Themarksarelabeled by% ofTotalRunningSum...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here