Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

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 »
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
co
ectly)
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.
. 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
eginning.
. 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
elevant 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
    X    Y    objectid    accident_no    abs_code    accident_status    accident_date    accident_time    alcoholtime    accident_type    day_of_week    dca_code    hit_run_flag    light_condition    police_attend    road_geometry    severity    speed_zone    run_offroad    node_id    longitude    latitude    node_type    lga_name    region_name    vicgrid_x    vicgrid_y    total_persons    inj_or_fatal    fatality    seriousinjury    otherinjury    noninjured    males    females    bicyclist    passenger    driver    pedestrian    pillion    motorist    unknown    ped_cyclist_5_12    ped_cyclist_13_18    old_pedestrian    old_driver    young_driver    alcohol_related    unlicencsed    no_of_vehicles    heavyvehicle    passengervehicle    motorcycle    publicvehicle    deg_u
an_name    deg_u
an_all    lga_name_all    region_name_all    srns    srns_all    rma    rma_all    divided    divided_all    stat_div_name
     XXXXXXXXXX     XXXXXXXXXX    1    T XXXXXXXXXX    ABS to receive accident    Unfinished    7/1/14    13:09:00    No    Collision with vehicle    Monday    RIGHT THROUGH    No    Day    Yes    Unknown    Other injury accident    60 km/hr    No    49465     XXXXXXXXXX     XXXXXXXXXX    Intersection    MITCHELL    NORTHERN REGION     XXXXXXXXXX     XXXXXXXXXX    4    1    0    0    1    3    1    3    0    2    2    0    0    0    0    0    0    0    0    0    No    1    2    0    2    0    0    TOWNS    TOWNS    MITCHELL    NORTHERN REGION    B    B    Arterial Highway    Local Road,Arterial Highway    Undivided    Undivided    Country
     XXXXXXXXXX     XXXXXXXXXX    2    T XXXXXXXXXX    ABS to receive accident    Finished    7/2/14    0:01:00    Yes    Collision with vehicle    Wednesday    U TURN    No    Dark Street lights on    Yes    Not at intersection    Other injury accident    60 km/hr    No    272595    -1    -1    Non-Intersection    WHITTLESEA    METROPOLITAN NORTH WEST REGION     XXXXXXXXXX     XXXXXXXXXX    4    3    0    0    3    1    0    3    0    2    2    0    0    0    0    0    0    0    0    1    No    0    2    0    2    0    0    MELB_URBAN    MELB_URBAN    WHITTLESEA    METROPOLITAN NORTH WEST REGION            Arterial Other    Arterial Other    Undivided    Undivided    Metro
     XXXXXXXXXX     XXXXXXXXXX    3    T XXXXXXXXXX    ABS to receive accident    Finished    7/2/14    8:30:00    No    collision with some other object    Wednesday    STRUCK OBJECT ON CARRIAGEWAY    No    Dusk/Dawn    Yes    Not at intersection    Other injury accident    50 km/hr    No    273609            Non-Intersection    KNOX    METROPOLITAN SOUTH EAST REGION     XXXXXXXXXX     XXXXXXXXXX    1    1    0    0    1    0    0    1    0    0    1    0    0    0    0    0    0    0    0    0    No    0    1    0    1    0    0    MELB_URBAN    MELB_URBAN    KNOX    METROPOLITAN SOUTH EAST REGION            Local Road    Local Road    Undivided    Undivided    Metro
     XXXXXXXXXX     XXXXXXXXXX    4    T XXXXXXXXXX    ABS to receive accident    Finished    7/2/14    10:08:00    No    Collision with vehicle    Wednesday    CROSS TRAFFIC(INTERSECTIONS ONLY)    Yes    Unk.    No    Cross intersection    Other injury accident    Not known    No    44382    -1    -1    Intersection    WYNDHAM    METROPOLITAN NORTH WEST REGION     XXXXXXXXXX     XXXXXXXXXX    3    1    0    0    1    2    2    1    0    1    2    0    0    0    0    0    0    0    0    0    No    0    2    0    2    0    0    MELB_URBAN    MELB_URBAN    WYNDHAM    METROPOLITAN NORTH WEST REGION    C    C    Arterial Other    Arterial Other,Local Road    Divided    Undivided,Divided    Metro
     XXXXXXXXXX     XXXXXXXXXX    5    T XXXXXXXXXX    ABS to receive accident    Finished    7/2/14    9:12:00    No    Collision with vehicle    Wednesday    RIGHT THROUGH    No    Day    Yes    Cross intersection    Other injury accident    60 km/hr    No    38531    -1    -1    Intersection    WYNDHAM    METROPOLITAN NORTH WEST REGION     XXXXXXXXXX     XXXXXXXXXX    2    1    0    0    1    1    2    0    0    0    2    0    0    0    0    0    0    0    1    0    No    0    2    1    1    0    0    MELB_URBAN    MELB_URBAN    WYNDHAM    METROPOLITAN NORTH WEST REGION            Arterial Other    Arterial Other,Local Road    Undivided    Undivided    Metro
     XXXXXXXXXX     XXXXXXXXXX    6    T XXXXXXXXXX    ABS to receive accident    Finished    7/2/14    12:20:00    No    Collision with a fixed object    Wednesday    OFF RIGHT BEND INTO OBJECT/PARKED VEHICLE    No    Day    Yes    Not at intersection    Serious injury accident    40 km/hr    Yes    273095     XXXXXXXXXX     XXXXXXXXXX    Non-Intersection    PORT PHILLIP    METROPOLITAN NORTH WEST REGION     XXXXXXXXXX     XXXXXXXXXX    1    1    0    1    0    0    1    0    0    0    0    0    0    1    0    0    0    0    0    0    No    0    1    0    0    1    0    MELB_URBAN    MELB_URBAN    PORT PHILLIP    METROPOLITAN NORTH WEST REGION            Local Road    Local Road    Undivided    Undivided    Metro
     XXXXXXXXXX     XXXXXXXXXX    7    T XXXXXXXXXX    ABS to receive accident    Finished    7/1/14    7:45:00    No    Collision with vehicle    Tuesday    CROSS TRAFFIC(INTERSECTIONS ONLY)    No    Day    Yes    Cross intersection    Serious injury accident    40 km/hr    No    63436     XXXXXXXXXX     XXXXXXXXXX    Intersection    MOONEE VALLEY    METROPOLITAN NORTH WEST REGION     XXXXXXXXXX     XXXXXXXXXX    2    1    0    1    0    1    1    1    0    0    2    0    0    0    0    0    0    0    0    0    No    0    2    0    1    0    0    MELB_URBAN    MELB_URBAN    MOONEE VALLEY    METROPOLITAN NORTH WEST REGION            Local Road    Local Road    Undivided    Undivided    Metro
     XXXXXXXXXX     XXXXXXXXXX    8    T XXXXXXXXXX    ABS to receive accident    Finished    7/1/14    17:35:00    No    Collision with vehicle    Tuesday    REAR END(VEHICLES IN SAME LANE)    No    Dusk/Dawn    Yes    Cross intersection    Serious injury accident    80 km/hr    No    29726     XXXXXXXXXX     XXXXXXXXXX    Intersection    CASEY    METROPOLITAN SOUTH EAST REGION     XXXXXXXXXX     XXXXXXXXXX    5    2    0    1    1    3    3    2    0    2    3    0    0    0    0    0    0    0    0    0    No    0    3    0    3    0    0    MELB_URBAN    MELB_URBAN    CASEY    METROPOLITAN SOUTH EAST REGION    A    A    Arterial Highway    Arterial Other,Arterial Highway    Divided    Divided,Undivided    Metro
     XXXXXXXXXX     XXXXXXXXXX    9    T XXXXXXXXXX    ABS to receive accident    Unfinished    7/2/14    12:20:00    No    Collision with vehicle    Tuesday    CROSS TRAFFIC(INTERSECTIONS ONLY)    No    Day    Yes    Unknown    Other injury accident    50 km/hr    No    49225     XXXXXXXXXX     XXXXXXXXXX    Intersection    MILDURA    WESTERN REGION     XXXXXXXXXX     XXXXXXXXXX    4    1    0    0    1    3    2    2    0    2    2    0    0    0    0    0    0    0    0    1    No    0    2    0    2    0    0    SMALL_CITIES    SMALL_CITIES    MILDURA    WESTERN REGION            Local Road    Local Road    Undivided    Undivided    Country
     XXXXXXXXXX     XXXXXXXXXX    10    T XXXXXXXXXX    ABS to receive accident    Finished    7/1/14    18:00:00    Yes    Collision with vehicle    Tuesday    LANE CHANGE LEFT (NOT OVERTAKING)    No    Dark Street lights on    Yes    Not at intersection    Other injury accident    100 km/hr    No    274299            Non-Intersection    HOBSONS BAY    METROPOLITAN NORTH WEST REGION     XXXXXXXXXX     XXXXXXXXXX    3    1    0    0    1    2    0    3    0    1    2    0    0    0    0    0    0    0    0    0    No    0    2    0    2    0    0    MELB_URBAN    MELB_URBAN    HOBSONS BAY    METROPOLITAN NORTH WEST REGION    M    M    Freeway    Freeway    Divided    Divided    Metro
     XXXXXXXXXX     XXXXXXXXXX    11    T XXXXXXXXXX    ABS to receive accident    Finished    7/2/14    10:45:00    No    Struck Pedestrian    Wednesday    FAR SIDE. PED HIT BY VEHICLE FROM THE LEFT    Yes    Day    No    Not at intersection    Other injury accident    50 km/hr    No    278705     XXXXXXXXXX     XXXXXXXXXX    Non-Intersection    WHITTLESEA    METROPOLITAN NORTH WEST REGION     XXXXXXXXXX     XXXXXXXXXX    2    1    0    0    1    1    1    1    0    0    1    1    0    0    0    0    0    0    0    0    No    0    1    0    1    0    0    MELB_URBAN    MELB_URBAN    WHITTLESEA    METROPOLITAN NORTH WEST REGION            Local Road    Local Road    Undivided    Undivided    Metro
     XXXXXXXXXX     XXXXXXXXXX    12    T XXXXXXXXXX    ABS to receive accident    Finished    7/2/14    16:15:00    No    Collision with vehicle    Wednesday    VEHICLE STRIKES ANOTHER VEH WHILE EMERGING FROM DRIVEWAY    No    Dusk/Dawn    Yes    Not at intersection    Serious injury accident    80 km/hr    No    199769    -1     XXXXXXXXXX    Non-Intersection    KNOX    METROPOLITAN SOUTH EAST REGION     XXXXXXXXXX     XXXXXXXXXX    3    1    0    1    0    2    2    1    0    1    2    0    0    0    0    0    0    0    0    1    No    0    2    0    2    0    0    MELB_URBAN    MELB_URBAN    KNOX    METROPOLITAN SOUTH EAST REGION            Arterial Other    Arterial Other    Divided    Divided    Metro
     XXXXXXXXXX     XXXXXXXXXX    13    T XXXXXXXXXX    ABS to receive accident    Unfinished    7/1/14    18:05:00    Yes    Collision with vehicle    Monday    REAR END(VEHICLES IN SAME LANE)    No    Dark Street lights on    Yes    Unknown    Other injury accident    100 km/hr    No    356518     XXXXXXXXXX     XXXXXXXXXX    Non-Intersection    MELBOURNE    METROPOLITAN NORTH WEST REGION     XXXXXXXXXX     XXXXXXXXXX    5    2    0    0    2    3    3    1    0    2    3    0    0    0    0    0    0    0    0    2    No    0    3    0    3    0    0    MELB_URBAN    MELB_URBAN    MELBOURNE    METROPOLITAN NORTH WEST REGION    M    M    Freeway    Freeway    Divided    Divided    Metro
     XXXXXXXXXX     XXXXXXXXXX    14    T XXXXXXXXXX    ABS to receive accident    Finished    7/2/14    13:00:00    No    Collision with vehicle    Wednesday    RIGHT THROUGH    No    Day    Yes    Cross intersection    Other injury accident    50 km/hr    No    1188    -1    -1    Intersection    DAREBIN    METROPOLITAN NORTH WEST REGION     XXXXXXXXXX     XXXXXXXXXX    2    1    0    0    1    1    0    1    0    0    2    0    0    0    0    0    0    0    0    0    No    0    2    0    2    0    0    MELB_URBAN    MELB_URBAN    DAREBIN    METROPOLITAN NORTH WEST REGION            Arterial Highway    Arterial Highway,Arterial Other    Divided    Undivided,Divided    Metro
     XXXXXXXXXX     XXXXXXXXXX    15    T XXXXXXXXXX    ABS to receive accident    Finished    7/2/14    15:50:00    No    Collision with a fixed object    Wednesday    LEFT OFF CARRIAGEWAY INTO OBJECT/PARKED VEHICLE    No    Day    Yes    Not at intersection    Other injury accident    100 km/hr    Yes    272631    -1    -1    Non-Intersection    WHITTLESEA    METROPOLITAN NORTH WEST REGION     XXXXXXXXXX     XXXXXXXXXX    1    1    0    0    1    0    1    0    0    0    1    0    0    0    0    0    0    0    0    0    No    0    1    0    1    0    0    MELB_URBAN    MELB_URBAN    WHITTLESEA    METROPOLITAN NORTH WEST REGION    M    M    Freeway    Freeway    Divided    Divided    Metro
     XXXXXXXXXX     XXXXXXXXXX    16    T XXXXXXXXXX    ABS to receive accident    Finished    7/2/14    16:40:00    No    Collision with vehicle    Wednesday    REAR END(VEHICLES IN SAME LANE)    No    Day    Yes    Not at intersection    Serious injury accident    70 km/hr    No    274056    -1    -1    Non-Intersection    MANNINGHAM    METROPOLITAN SOUTH EAST REGION     XXXXXXXXXX     XXXXXXXXXX    2    1    0    1    0    1    1    1    0    0    1    0    0    1    0    0    0    0    0    0    No    0    2    0    1    1    0    MELB_URBAN    MELB_URBAN    MANNINGHAM    METROPOLITAN SOUTH EAST REGION            Arterial Other    Arterial Other    Divided    Divided    Metro
     XXXXXXXXXX     XXXXXXXXXX    17    T XXXXXXXXXX    Non ABS accident    Finished    7/2/14    18:00:00    Yes    Collision with vehicle    Wednesday    OTHER MANOEUVRING NOT INCLUDED IN DCAs XXXXXXXXXX    No    Dusk/Dawn    Yes    Private property    Other injury accident    Camping grounds or off road    No    273328            Off Road    BENDIGO    NORTHERN REGION     XXXXXXXXXX     XXXXXXXXXX    2    1    0    0    1    1    0    2    0    1    1    0    0    0    0    0    0    0    1    0    No    0    2    0    2    0    0    LARGE_PROVINCIAL_CITIES    LARGE_PROVINCIAL_CITIES    BENDIGO    NORTHERN REGION                            Country
     XXXXXXXXXX     XXXXXXXXXX    18    T XXXXXXXXXX    ABS to receive accident    Finished    7/1/14    18:20:00    Yes    Collision with vehicle    Tuesday    RIGHT NEAR (INTERSECTIONS ONLY)    No    Dusk/Dawn    Yes    T intersection    Serious injury accident    50 km/hr    No    861     XXXXXXXXXX     XXXXXXXXXX    Intersection    MORELAND    METROPOLITAN NORTH WEST REGION     XXXXXXXXXX     XXXXXXXXXX    2    1    0    1    0    1    2    0    1    0    1    0    0    0    0    0    0    0    0    0    No    0    2    0    1    0    0    MELB_URBAN    MELB_URBAN    MORELAND    METROPOLITAN NORTH WEST REGION            Local Road    Local Road    Undivided    Undivided    Metro
     XXXXXXXXXX     XXXXXXXXXX    19    T XXXXXXXXXX    ABS to receive accident    Finished    7/2/14    20:38:00    Yes    Struck Pedestrian    Wednesday    FAR SIDE. PED HIT BY VEHICLE FROM THE LEFT    Yes    Dark Street lights on    Yes    Cross intersection    Serious injury accident    50 km/hr    No    225891     XXXXXXXXXX     XXXXXXXXXX    Intersection    WYNDHAM    METROPOLITAN NORTH WEST REGION     XXXXXXXXXX     XXXXXXXXXX    4    1    0    1    0    3    2    0    0    1    2    1    0    0    0    0    0    0    0    1    No    0    2    0    2    0    0    MELB_URBAN    MELB_URBAN    WYNDHAM    METROPOLITAN NORTH WEST REGION            Local Road    Local Road    Undivided    Undivided    Metro
     XXXXXXXXXX     XXXXXXXXXX    20    T XXXXXXXXXX    ABS to receive accident    Finished    7/1/14    6:50:00    No    Collision with vehicle    Tuesday    RIGHT NEAR (INTERSECTIONS ONLY)    No    Dark Street lights on    Yes    T intersection    Other injury accident    60 km/hr    No    67559            Intersection    KNOX    METROPOLITAN SOUTH EAST REGION     XXXXXXXXXX     XXXXXXXXXX    3    1    0    0    1    2    1    2    0    1    1    0    0    1    0    0    0    0    0    0    No    0    2    0    1    1    0    MELB_URBAN    MELB_URBAN    KNOX    METROPOLITAN SOUTH EAST REGION            Arterial Other    Arterial Other,Local Road    Undivided    Undivided    Metro
     XXXXXXXXXX     XXXXXXXXXX    21    T XXXXXXXXXX    ABS to receive accident    Finished    7/1/14    14:22:00    No    Collision with vehicle    Monday    LEFT FAR (INTERSECTIONS ONLY)    No    Day    Yes    T intersection    Serious injury accident    80 km/hr    No    41878     XXXXXXXXXX     XXXXXXXXXX    Intersection    KNOX    METROPOLITAN SOUTH EAST REGION     XXXXXXXXXX     XXXXXXXXXX    2    1    0    1    0    1    1    1    0    0    2    0    0    0    0    0    0    0    0    0    No    0    2    0    2    0    0    MELB_URBAN    MELB_URBAN    KNOX    METROPOLITAN SOUTH EAST REGION            Arterial Highway    Local Road,Arterial Highway    Divided    Undivided,Divided    Metro
     XXXXXXXXXX     XXXXXXXXXX    22    T XXXXXXXXXX    ABS to receive accident    Finished    7/1/14    18:28:00    Yes    Struck Pedestrian    Tuesday    PED NEAR SIDE. PED HIT BY VEHICLE FROM THE RIGHT.    No    Dark Street lights on    Yes    T intersection    Other injury accident    60 km/hr    No    40434    -1    -1    Intersection    BOROONDARA    METROPOLITAN SOUTH EAST REGION     XXXXXXXXXX     XXXXXXXXXX    2    1    0    0    1    1    1    1    0    0    1    1    0    0    0    0    0    0    0    0    No    0    1    0    1    0    0    MELB_URBAN    MELB_URBAN    BOROONDARA    METROPOLITAN SOUTH EAST REGION            Arterial Other    Arterial Other,Local Road    Undivided    Undivided    Metro
     XXXXXXXXXX     XXXXXXXXXX    23    T XXXXXXXXXX    ABS to receive accident    Finished    7/1/14    19:35:00    Yes    Struck Pedestrian    Tuesday    PED NEAR SIDE. PED HIT BY VEHICLE FROM THE RIGHT.    No    Dark Street lights on    Yes    T intersection    Serious injury accident    60 km/hr    No    243678     XXXXXXXXXX     XXXXXXXXXX    Non-Intersection    KINGSTON    METROPOLITAN SOUTH EAST REGION     XXXXXXXXXX     XXXXXXXXXX    2    1    0    1    0    1    1    1    0    0    1    1    0    0    0    0    1    0    0    0    No    0    1    0    1    0    0    MELB_URBAN    MELB_URBAN    KINGSTON    METROPOLITAN SOUTH EAST REGION            Arterial Other    Arterial Other,Local Road    Undivided    Undivided    Metro
     XXXXXXXXXX     XXXXXXXXXX    24    T XXXXXXXXXX    ABS to receive accident    Finished    7/2/14    15:41:00    No    Collision with a fixed object    Wednesday    LEFT OFF CARRIAGEWAY INTO OBJECT/PARKED VEHICLE    No    Day    Yes    Not at intersection    Serious injury accident    50 km/hr    Yes    272511            Non-Intersection    KNOX    METROPOLITAN SOUTH EAST REGION     XXXXXXXXXX     XXXXXXXXXX    1    1    0    1    0    0    1    0    0    0    1    0    0    0    0    0    0    0    0    0    Yes    1    1    0    1    0    0    MELB_URBAN    MELB_URBAN    KNOX    METROPOLITAN SOUTH EAST REGION            Local Road    Local Road    Undivided    Undivided    Metro
     XXXXXXXXXX     XXXXXXXXXX    25    T XXXXXXXXXX    ABS to receive accident    Finished    7/2/14    15:14:00    No    Struck Pedestrian    Wednesday    PED NEAR SIDE. PED HIT BY VEHICLE FROM THE RIGHT.    No    Day    Yes    Cross intersection    Other injury accident    50 km/hr    No    29754    -1    -1    Intersection    MELTON    METROPOLITAN NORTH WEST REGION     XXXXXXXXXX     XXXXXXXXXX    2    1    0    0    1    1    1    1    0    0    1    1    0    0    0    0    0    0    0    0    No    0    1    0    1    0    0    SMALL_CITIES    SMALL_CITIES    MELTON    METROPOLITAN NORTH WEST REGION    C    C    Arterial Other    Arterial Other,Local Road    Divided    Divided    Metro
     XXXXXXXXXX     XXXXXXXXXX    26    T XXXXXXXXXX    ABS to receive accident    Finished    7/2/14    7:00:00    No    Vehicle overturned (no collision)    Wednesday    OFF CARRIAGEWAY TO LEFT    No    Day    Yes    Not at intersection    Other injury accident    100 km/hr    Yes    272596            Non-Intersection    PYRENEES    WESTERN REGION     XXXXXXXXXX     XXXXXXXXXX    2    2    0    0    2    0    1    1    0    1    1    0    0    0    0    0    0    0    0    0    No    0    1    0    1    0    0    RURAL_VICTORIA    RURAL_VICTORIA    PYRENEES    WESTERN REGION            Local Road    Local Road    Undivided    Undivided    Country
     XXXXXXXXXX     XXXXXXXXXX    27    T XXXXXXXXXX    ABS to receive accident    Finished    7/1/14    20:50:00    Yes    Collision with vehicle    Tuesday    RIGHT NEAR (INTERSECTIONS ONLY)    No    Dark Street lights off    Yes    T intersection    Other injury accident    80 km/hr    No    231516     XXXXXXXXXX     XXXXXXXXXX    Intersection    KINGSTON    METROPOLITAN SOUTH EAST REGION     XXXXXXXXXX     XXXXXXXXXX    2    1    0    0    1    1    0    2    0    0    2    0    0    0    0    0    0    0    0    0    No    0    2    0    2    0    0    MELB_URBAN    MELB_URBAN    KINGSTON    METROPOLITAN SOUTH EAST REGION            Arterial Highway    Arterial Highway    Divided    Undivided,Divided    Metro
     XXXXXXXXXX     XXXXXXXXXX    28    T XXXXXXXXXX    ABS to receive accident    Finished    7/3/14    13:50:00    No    Collision with vehicle    Thursday    RIGHT THROUGH    No    Day    Yes    Not at intersection    Serious injury accident    50 km/hr    No    55991    -1    -1    Intersection    FRANKSTON    METROPOLITAN SOUTH EAST REGION     XXXXXXXXXX     XXXXXXXXXX    2    1    0    1    0    1    1    1    0    0    1    0    0    0    1    0    0    0    0    0    No    0    2    0    1    0    0    MELB_URBAN    MELB_URBAN    FRANKSTON    METROPOLITAN SOUTH EAST REGION            Local Road    Local Road    Undivided    Undivided    Metro
     XXXXXXXXXX     XXXXXXXXXX    29    T XXXXXXXXXX    ABS to receive accident    Finished    7/3/14    17:37:00    No    Collision with vehicle    Thursday    RIGHT THROUGH    No    Dusk/Dawn    Yes    Cross intersection    Serious injury accident    60 km/hr    No    37986     XXXXXXXXXX     XXXXXXXXXX    Intersection    DAREBIN    METROPOLITAN NORTH WEST REGION     XXXXXXXXXX     XXXXXXXXXX    2    1    0    1    0    1    2    0    1    0    1    0    0    0    0    0    0    0    1    0    No    0    2    0    1    0    0    MELB_URBAN    MELB_URBAN    DAREBIN    METROPOLITAN NORTH WEST REGION            Local Road    Local Road    Undivided    Undivided    Metro
     XXXXXXXXXX     XXXXXXXXXX    30    T XXXXXXXXXX    ABS to receive accident    Finished    7/3/14    17:00:00    No    Collision with vehicle    Wednesday    RIGHT NEAR (INTERSECTIONS ONLY)    No    Dusk/Dawn    Yes    T intersection    Other injury accident    60 km/hr    No    278706     XXXXXXXXXX     XXXXXXXXXX    Intersection    BAW BAW    EASTERN REGION     XXXXXXXXXX     XXXXXXXXXX    3    1    0    0    1    2    2    1    0    1    2    0    0    0    0    0    0    0    0    0    No    0    2    0    2    0    0    SMALL_CITIES    SMALL_CITIES    BAW BAW    EASTERN REGION,EASTERN REGION    C    C    Arterial Other    Local Road,Arterial Other    Undivided    Undivided    Country
     XXXXXXXXXX     XXXXXXXXXX    31    T XXXXXXXXXX    ABS to receive accident    Finished    7/3/14    20:59:00    Yes    Collision with vehicle    Thursday    HEAD ON (NOT OVERTAKING)    No    Dark No street lights    Yes    Not at intersection    Serious injury accident    100 km/hr    No    275287    -1    -1    Non-Intersection    WELLINGTON    EASTERN REGION     XXXXXXXXXX     XXXXXXXXXX    2    2    0    2    0    0    1    1    0    0    2    0    0    0    0    0    0    0    0    0    Yes    1    2    0    2    0    0    RURAL_VICTORIA    RURAL_VICTORIA    WELLINGTON    EASTERN REGION,EASTERN REGION    A    A    Arterial Highway    Arterial Highway    Undivided    Undivided    Country
     XXXXXXXXXX     XXXXXXXXXX    32    T XXXXXXXXXX    ABS to receive accident    Unfinished    7/3/14    21:15:00    Yes    Collision with vehicle    Wednesday    RIGHT THROUGH    No    Dark Street lights on    Yes    Unknown    Other injury accident    60 km/hr    No    41249     XXXXXXXXXX     XXXXXXXXXX    Intersection    GLEN EIRA    METROPOLITAN SOUTH EAST REGION     XXXXXXXXXX     XXXXXXXXXX    2    1    0    0    1    1    0    2    0    0    2    0    0    0    0    0    0    0    0    0    No    0    2    0    2    0    0    MELB_URBAN    MELB_URBAN    GLEN EIRA    METROPOLITAN SOUTH EAST REGION            Arterial Other    Arterial Other,Local Road    Undivided    Undivided    Metro
     XXXXXXXXXX     XXXXXXXXXX    33    T XXXXXXXXXX    ABS to receive accident    Finished    7/1/14    1:11:00    Yes    Collision with a fixed object    Tuesday    LEFT OFF CARRIAGEWAY INTO OBJECT/PARKED VEHICLE    No    Dark Street lights on    Yes    Not at intersection    Fatal accident    60 km/hr    Yes    272364    -1    -1    Non-Intersection    NILLUMBIK    METROPOLITAN NORTH WEST REGION     XXXXXXXXXX     XXXXXXXXXX    2    2    1    0    1    0    2    0    0    1    1    0    0    0    0    0    0    0    0    0    No    0    1    0    1    0    0    MELB_URBAN    MELB_URBAN    NILLUMBIK    METROPOLITAN NORTH WEST REGION            Local Road    Local Road    Undivided    Undivided    Metro
     XXXXXXXXXX     XXXXXXXXXX    34    T XXXXXXXXXX    ABS to receive accident    Finished    7/1/14    13:30:00    No    Struck Pedestrian    Tuesday    PED STRUCK WALKING TO/FROM OR BOARDING/ALIGHTING VEHICLE.    Yes    Day    No    T intersection    Serious injury accident    Not known    No    39301    -1    -1    Intersection    MANNINGHAM    METROPOLITAN SOUTH EAST REGION     XXXXXXXXXX     XXXXXXXXXX    2    1    0    1    0    1    1    0    0    0    0    1    0    0    1    0    0    0    0    0    No    0    1    0    0    0    0    MELB_URBAN    MELB_URBAN    MANNINGHAM    METROPOLITAN SOUTH EAST REGION            Arterial Other    Arterial Other    Divided    Divided,Undivided    Metro
     XXXXXXXXXX     XXXXXXXXXX    35    T XXXXXXXXXX    ABS to receive accident    Finished    7/2/14    15:40:00    No    Collision with vehicle    Wednesday    OTHER ON PATH    No    Day    Yes    Not at intersection    Fatal accident    50 km/hr    No    272589    -1    -1    Non-Intersection    BALLARAT    WESTERN REGION     XXXXXXXXXX     XXXXXXXXXX    1    1    1    0    0    0    1    0    0    0    1    0    0    0    0    0    0    0    1    0    No    0    2    0    2    0    0    LARGE_PROVINCIAL_CITIES    LARGE_PROVINCIAL_CITIES    BALLARAT    WESTERN REGION            Local Road    Local Road    Undivided    Undivided    Country
     XXXXXXXXXX     XXXXXXXXXX    36    T XXXXXXXXXX    ABS to receive accident    Finished    7/2/14    16:50:00    No    Collision with vehicle    Wednesday    CROSS TRAFFIC(INTERSECTIONS ONLY)    No    Day    No    Cross intersection    Other injury accident    Not known    No    40974            Intersection    KNOX    METROPOLITAN SOUTH EAST REGION     XXXXXXXXXX     XXXXXXXXXX    2    1    0    0    1    1    2    0    1    0    1    0    0    0    0    0    0    0    0    0    No    0    2    0    1    0    0    MELB_URBAN    MELB_URBAN    KNOX    METROPOLITAN SOUTH EAST REGION            Arterial Other    Arterial Other,Local Road    Undivided    Undivided    Metro
     XXXXXXXXXX     XXXXXXXXXX    37    T XXXXXXXXXX    Non ABS accident    Unfinished    7/3/14    2:45:00    Yes    Collision with a fixed object    Wednesday    RIGHT OFF CARRIAGEWAY INTO OBJECT/PARKED VEHICLE    Yes    Dark Street lights on    Yes    Unknown    Other injury accident    50 km/hr    Yes    356197     XXXXXXXXXX     XXXXXXXXXX    Off Road    DANDENONG    METROPOLITAN SOUTH EAST REGION     XXXXXXXXXX     XXXXXXXXXX    1    1    0    0    1    0    0    1    0    0    1    0    0    0    0    0    0    0    0    0    No    0    1    0    1    0    0    MELB_URBAN    MELB_URBAN    DANDENONG    METROPOLITAN SOUTH EAST REGION                            Metro
     XXXXXXXXXX     XXXXXXXXXX    38    T XXXXXXXXXX    ABS to receive accident    Finished    7/3/14    11:45:00    No    Struck Pedestrian    Thursday    FAR SIDE. PED HIT BY VEHICLE FROM THE LEFT    No    Day    Yes    Cross intersection    Serious injury accident    60 km/hr    No    45186    -1    -1    Intersection    SHEPPARTON    NORTH EASTERN REGION     XXXXXXXXXX     XXXXXXXXXX    2    1    0    1    0    1    0    2    0    0    1    1    0    0    0    0    0    0    1    0    No    0    1    0    1    0    0    SMALL_CITIES    SMALL_CITIES    SHEPPARTON    NORTH EASTERN REGION    A    A    Arterial Highway    Local Road,Arterial Highway    Divided    Divided,Undivided    Country
     XXXXXXXXXX     XXXXXXXXXX    39    T XXXXXXXXXX    ABS to receive accident    Finished    7/2/14    12:20:00    No    Collision with vehicle    Wednesday    RIGHT REAR.    No    Day    No    Cross intersection    Other injury accident    60 km/hr    No    29867    -1    -1    Intersection    MAROONDAH    METROPOLITAN SOUTH EAST REGION     XXXXXXXXXX     XXXXXXXXXX    3    1    0    0    1    2    2    1    0    1    2    0    0    0    0    0    0    0    1    0    No    0    2    0    2    0    0    MELB_URBAN    MELB_URBAN    MAROONDAH    METROPOLITAN SOUTH EAST REGION            Arterial Highway    Arterial Highway,Arterial Other,Local Road    Divided    Undivided,Divided    Metro
     XXXXXXXXXX     XXXXXXXXXX    40    T XXXXXXXXXX    ABS to receive accident    Finished    7/1/14    12:00:00    No    Collision with vehicle    Tuesday    CROSS TRAFFIC(INTERSECTIONS ONLY)    No    Day    Yes    Cross intersection    Other injury accident    50 km/hr    No    140    -1    -1    Intersection    MARIBYRNONG    METROPOLITAN NORTH WEST REGION     XXXXXXXXXX     XXXXXXXXXX    3    1    0    0    1    2    1    2    0    1    2    0    0    0    0    0    0    0    0    1    No    0    2    0    2    0    0    MELB_URBAN    MELB_URBAN    MARIBYRNONG    METROPOLITAN NORTH WEST REGION            Local Road    Local Road    Undivided    Undivided    Metro
     XXXXXXXXXX     XXXXXXXXXX    41    T XXXXXXXXXX    ABS to receive accident    Finished    7/1/14    17:45:00    No    Struck Pedestrian    Tuesday    PED NEAR SIDE. PED HIT BY VEHICLE FROM THE RIGHT.    No    Dusk/Dawn    No    T intersection    Other injury accident    Not known    No    65785    -1    -1    Intersection    WHITEHORSE    METROPOLITAN SOUTH EAST REGION     XXXXXXXXXX     XXXXXXXXXX    2    1    0    0    1    1    1    1    0    0    1    1    0    0    0    0    0    0    0    0    No    0    1    0    1    0    0    MELB_URBAN    MELB_URBAN    WHITEHORSE    METROPOLITAN SOUTH EAST REGION            Arterial Other    Arterial Other,Local Road    Undivided    Undivided    Metro
     XXXXXXXXXX     XXXXXXXXXX    42    T XXXXXXXXXX    ABS to receive accident    Finished    7/2/14    3:54:00    Yes    Collision with a fixed object    Wednesday    RIGHT OFF CARRIAGEWAY INTO OBJECT/PARKED VEHICLE    No    Dark No street lights    Yes    Not at intersection    Serious injury accident    110 km/hr    Yes    286564     XXXXXXXXXX     XXXXXXXXXX    Non-Intersection    MACEDON RANGES    NORTHERN REGION     XXXXXXXXXX     XXXXXXXXXX    1    1    0    1    0    0    1    0    0    0    1    0    0    0    0    0    0    0    0    0    No    0    1    0    1    0    0    TOWNS    RURAL_VICTORIA,TOWNS    MACEDON RANGES    NORTHERN REGION    M    M    Freeway    Freeway    Divided    Divided    Country
     XXXXXXXXXX     XXXXXXXXXX    43    T XXXXXXXXXX    ABS to receive accident    Finished    7/2/14    11:35:00    No    No collision and no object struck    Wednesday    OUT OF CONTROL ON CARRIAGEWAY (ON STRAIGHT)    No    Day    Yes    Not at intersection    Serious injury accident    70 km/hr    No    272597            Non-Intersection    NILLUMBIK    METROPOLITAN NORTH WEST REGION     XXXXXXXXXX     XXXXXXXXXX    1    1    0    1    0    0    1    0    0    0    0    0    0    1    0    0    0    0    0    0    No    0    1    0    0    1    0    MELB_URBAN    MELB_URBAN    NILLUMBIK    METROPOLITAN NORTH WEST REGION    C    C    Arterial Other    Arterial Other    Divided    Divided    Metro
     XXXXXXXXXX     XXXXXXXXXX    44    T XXXXXXXXXX    ABS to receive accident    Finished    7/2/14    13:30:00    No    Collision with vehicle    Wednesday    VEHICLE STRIKES ANOTHER VEH WHILE EMERGING FROM DRIVEWAY    No    Day    Yes    Not at intersection    Serious injury accident    50 km/hr    No    272879     XXXXXXXXXX     XXXXXXXXXX    Non-Intersection    MONASH    METROPOLITAN SOUTH EAST REGION     XXXXXXXXXX     XXXXXXXXXX    2    2    0    1    1    0    1    1    0    0    2    0    0    0    0    0    0    0    0    1    No    0    3    0    3    0    0    MELB_URBAN    MELB_URBAN    MONASH    METROPOLITAN SOUTH EAST REGION            Local Road    Local Road    Undivided    Undivided    Metro
     XXXXXXXXXX     XXXXXXXXXX    45    T XXXXXXXXXX    ABS to receive accident    Finished    7/2/14    14:20:00    No    Collision with vehicle    Wednesday    REAR END(VEHICLES IN SAME LANE)    No    Day    Yes    Not at intersection    Serious injury accident    80 km/hr    No    272881    -1     XXXXXXXXXX    Non-Intersection    CASEY    METROPOLITAN SOUTH EAST REGION     XXXXXXXXXX     XXXXXXXXXX    7    2    0    1    1    5    4    3    0    3    4    0    0    0    0    0    0    0    0    0    No    0    4    0    4    0    0    MELB_URBAN    MELB_URBAN    CASEY    METROPOLITAN SOUTH EAST REGION            Arterial Other    Arterial Other    Undivided    Undivided    Metro
     XXXXXXXXXX     XXXXXXXXXX    46    T XXXXXXXXXX    ABS to receive accident    Finished    7/2/14    18:30:00    Yes    Collision with vehicle    Wednesday    RIGHT NEAR (INTERSECTIONS ONLY)    No    Dark Street lights on    Yes    Cross intersection    Other injury accident    60 km/hr    No    37193            Intersection    YARRA    METROPOLITAN NORTH WEST REGION     XXXXXXXXXX     XXXXXXXXXX    2    1    0    0    1    1    1    1    1    0    1    0    0    0    0    0    0    0    0    0    No    0    2    0    1    0    0    MELB_URBAN    MELB_URBAN    YARRA    METROPOLITAN NORTH WEST REGION            Arterial Other    Arterial Other,Local Road    Undivided    Undivided    Metro
     XXXXXXXXXX     XXXXXXXXXX    47    T XXXXXXXXXX    ABS to receive accident    Finished    7/2/14    11:30:00    No    Collision with vehicle    Wednesday    REAR END(VEHICLES IN SAME LANE)    No    Day    No    Cross intersection    Other injury accident    80 km/hr    No    42744            Intersection    KINGSTON    METROPOLITAN SOUTH EAST REGION     XXXXXXXXXX     XXXXXXXXXX    2    1    0    0    1    1    1    1    0    0    2    0    0    0    0    0    0    0    0    1    No    0    2    0    2    0    0    MELB_URBAN    MELB_URBAN    KINGSTON    METROPOLITAN SOUTH EAST REGION            Arterial Highway    Arterial Other,Local Road,Arterial Highway    Divided    Divided,Undivided    Metro
     XXXXXXXXXX     XXXXXXXXXX    48    T XXXXXXXXXX    ABS to receive accident    Finished    7/3/14    7:15:00    No    Collision with vehicle    Thursday    CROSS TRAFFIC(INTERSECTIONS ONLY)    No    Dusk/Dawn    Yes    Cross intersection    Other injury accident    50 km/hr    No    29972            Intersection    MURRINDINDI    NORTH EASTERN REGION     XXXXXXXXXX     XXXXXXXXXX    2    1    0    0    1    1    2    0    0    0    2    0    0    0    0    0    0    0    0    0    No    0    2    0    2    0    0    TOWNS    TOWNS    MURRINDINDI,MURRINDINDI    NORTH EASTERN REGION    B    B    Arterial Highway    Local Road,Arterial Highway    Divided    Divided,Undivided    Country
     XXXXXXXXXX     XXXXXXXXXX    49    T XXXXXXXXXX    ABS to receive accident    Finished    7/3/14    14:01:00    No    collision with some other object    Thursday    STRUCK OBJECT ON CARRIAGEWAY    No    Day    Yes    Not at intersection    Other injury accident    100 km/hr    No    273151    -1    -1    Non-Intersection    YARRA RANGES    METROPOLITAN SOUTH EAST REGION     XXXXXXXXXX     XXXXXXXXXX    2    1    0    0    1    1    2    0    0    1    1    0    0    0    0    0    0    0    0    0    No    0    1    0    1    0    0    RURAL_VICTORIA    RURAL_VICTORIA    YARRA RANGES    METROPOLITAN SOUTH EAST REGION    B    B    Arterial Highway    Arterial Highway    Undivided    Undivided    Metro
     XXXXXXXXXX     XXXXXXXXXX    50    T XXXXXXXXXX    ABS to receive accident    Finished    7/3/14    14:25:00    No    Struck Pedestrian    Thursday    PED NEAR SIDE. PED HIT BY VEHICLE FROM THE RIGHT.    No    Day    Yes    Cross intersection    Other injury accident    60 km/hr    No    41275    -1    -1    Intersection    GLEN EIRA    METROPOLITAN SOUTH EAST REGION     XXXXXXXXXX     XXXXXXXXXX    2    1    0    0    1    1    1    1    0    0    1    1    0    0    0    0    0    1    0    0    No    0    1    0    1    0    0    MELB_URBAN    MELB_URBAN    GLEN EIRA    METROPOLITAN SOUTH EAST REGION            Arterial Other    Arterial Other,Local Road    Undivided    Undivided    Metro
     XXXXXXXXXX     XXXXXXXXXX    51    T XXXXXXXXXX    ABS
Answered Same Day Jun 05, 2022

Solution

Mohd answered on Jun 05 2022
93 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 Fe
uary 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
Novembe
Decembe
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