Graded Lab Vehicle & Pedestrian Investigations Data Analysis

• Data Source - OpenDataPhily
• Dataset: car_ped_stops.csv - IN SHARED FILES
• Open QlikView - we will load data together
• Save QlikView File as March16_YourName
• The objectives of this lab is to explore data and create Vehicle & Pedestrian Investigations Visualizations. Refer to Vehicle & Pedestrian Investigations Visualization
• Grading Rubrichs:
  • Design at least 3 charts of different types displaying DIFFERENT visualisations.

    DON'T design same visualization using different type of charts. For example, displaying the number of investigations per weekday in bar chart and pie chart will count as ONE chart!!!

    IMPORTANT: At LEAST ONE CHART MUST BE DIFFERENT FROM THE CHARTS SHOWN ON THE OpenDataPhily WEBSITE

    IMPORTANT: Don't build Line chart to display Number of Investigations by Date/Time.

    Instead, you can do analysis of Number of Investigations by Date/Time using List Box (sort it by NUMERIC VALUE) or/and Straight Table (you can sort the columns to find the date and time with maximal number of investigations, for example), or you can try to build a BAR chart, sort it by Y-value if you would like to find the date and time with maximal number of investigations, for example.

    But in all cases, do it as a last step if time permits and SAVE your application before trying to build these charts.

  • Define and use at least ONE variable
  • Design at least ONE text object that displaying results of calculations
  • Design Statistics Box
  • Design at least 3 analysis questions and write an answer to your questions