MS Access SQL Query Essay Paper
Write SQL queries based on the database in excel.
Cyber Crimes and Data Analysis and Visualization Worksheet
Review the attached FBI 2019 & 2020 Annual Internet Crimes Reports and use the following link to create a data or graph table: https://www.tableau.com/academic/students
So, the main idea in this activity if for you to create an excel sheet first to include all the data elements about the computer or cyber crime you selected from 2019 and 2020 from the reports. You would try to identify as much information as you can on the one crime that you selected for both years and that includes identifying data elements “data sets” such as number of people impacted, amount of money to fix or address the crime, the amount of money damage caused by the crime, the number of people or cities or states etc impacted by the crime, the gender and background and so on. You would then import your excel sheet with the data selected from both years into Tableau and start questioning your data by selecting and dropping different fields as columns or rows for both years into the Tableau view and then changing them around looking at different visuals of your data as displayed by different types of graphs.