How many different number of reported crimes types

Assignment Help Other Subject
Reference no: EM132114817

Big Data and Analytics Assignment - ANALYTIC REPORT

Analytic Report:

Purpose: The purpose of this task is to provide students with practical experience in working in teams to write a Data Analytical report to provide useful insights, pattern and trends in the chosen/given dataset. This activity will give students the opportunity to show innovation and creativity in applying Watson Analytics and designing useful visualization solutions and predictive solutions for various analytics problems.

Group Presentation:

Purpose: The purpose of the oral presentation is to provide an opportunity for students to present the results of DATA Analysis and to share this knowledge while practicing their verbal communication skills

Project Details: Your task for this analytical project is to use analytical tool (i.e Watson Analytics) to explore, analyze and visualize one of the two given dataset. Your tutor will assign you the dataset. This dataset reflects reported incidents of crime (with the exception of murders where data exists for each victim) that occurred in the City of Chicago from 2012. Data is extracted from the Chicago Police Department's CLEAR (Citizen Law Enforcement Analysis and Reporting) system. In order to protect the privacy of crime victims, addresses are shown at the block level only and specific locations are not identified.Your intended audience is a law enforcement agency's middle and top middle management. Your primary goal is to provide different and interesting insights in the lights of 20 questions listed below.

The Questions

Your job is to examine one of the available datasets and present it in a set of informative graphs and text by answering the following questions.

Guided Questions for Dataset 1

1. How many total number of reported crimes?

2. How many different number of reported crimes types? (Primary type)

3. Provide a list of top 21 location descriptions with respect to crimes.

4. Provide a list of least 10 location descriptions with respect to crimes.

5. What is the top three most common primary type?

6. What are the three least common primary types?

7. How many years of Years of reported crimes is in the data file?

8. How many number of reported crimes were logged every year in December?

9. Which year generated the most reported crime in Chicago?

10. Which month generated the most reported crime in Chicago?

11. How many number of reported crimes whether an arrest was made? (Arrest)

12. How many number of district in this dataset?

13. What are the top 3 districts in terms of reported crimes?

14. What are the least 3 districts in terms of reported crimes?

15. What was the primary type that reported most crimes from district "8" in 2014?

16. How many number of domestic reported crimes made in Chicago?

17. How many domestic number of reported crimes were made in 2012 to 2014?

18. Which day is the busiest day of the week in terms of committed crimes?

19. Which location description has the most number of crime reported on Weekends?

20. Which location description has the least number of crime reported on weekends?

Guided Questions for Dataset 2

1. How many total number of reported crimes?

2. How many different number of reported crimes types? (primary type)

3. How many location descriptions of reported crimes? (location description)

4. What are the top three most common primary type that reported crimes?

5. What are the three least common primary types?

6. How many years of Years of reported crimes is in the data file?

7. How many number of reported crimes were logged in the last week of the dataset? Considered (11 of January 2017 , 18th of January 2017)

8. Which year generated the most reported crime in Chicago?

9. Which month generated the most reported crime in Chicago?

10. How many number of reported crimes whether an arrest was made? (arrest)

11. How many number of district in this dataset.

12. Which District in Chicago reported most crimes in the last year? (last year of dataset)

13. Which District in Chicago reported least crimes in the last year? (last year of dataset)

14. What was the primary type that reported most crimes from district "8" last year?

15. How many number of domestic reported crimes made in Chicago?

16. How many domestic number of reported crimes were made over the past month? (last year of dataset)

17. Which location description has the most number of crime reported in Chicago?

18. Which location description has the least number of crime reported in Chicago?

19. Which location description has the most number of crime reported on Weekends?

20. Which location description has the least number of crime reported on weekends?

Task 1- Background information

Write a description of the selected dataset and project, and its importance for the firm. Information must be appropriately referenced. [1 Page]

Task 2 - Reporting / Dashboards

For your project, perform the relevant data analysis tasks by answering the above questions and, identify the visualization and dashboards you need to develop for the operational manager of the indicated firm. [2-3 Pages]

Task 3 - Advanced Insights: In addition to the guided questions, it is expected to provide at least five (5) insights of the data. These insights will be judged in terms of quality and complexity.

Task 4 - Research

Justify why these BI reporting solution/dashboards are chosen in Task 2 (Reporting / Dashboards) and why those data sets attributes are present and laid out in the fashion you proposed (feel free to include all other relevant justifications). Note: To ensure that you discuss this task properly, you must include visual samples of the reports you produce (i.e. the screenshots of the BI report/dashboard must be presented and explained in the written report; use 'Snipping tool'), and also include any assumptions that you may have made about the analysis in your Task2 (i.e. the report to the operational team of the company).[1-2 Pages]

Task 5 - Recommendations for POLICE CHIEF

The POLICE CHIEF would like to improve the operations. Based on your BI analysis and the insights gained from "Data Set" in the lights of analysis performed in previous tasks, make some logical recommendations to the POLICE CHIEF, and justify why/how your proposal could enhance company operations and could assist in achieving operational/strategic objectives with the help of appropriate references from peer-reviewed sources. [1-2 Pages]

Task 6 - Cover letter

Write a cover letter to the POLICE CHIEF with the important data insights and recommendation to achieve operational/strategic objectives [1 page].

Task 7 - The Reflection: Each Team member is expected to write a brief reflection about this project in terms of challenges, learning and contribution.

Other Tasks - Please refer to marking scheme at the end of the assignment for other tasks and expectations.

Note - NEED SOLUTION ON DATASET 1.

Attachment:- Assignment File.rar

Verified Expert

In this assignment we have done analysis using Watson analytic .here we have created different discovery for guideline question and finally create the dashboard.Here we have analysis whole dataset and write a one cover letter for Chicago police and send some recommendation for control and monitor Chicago

Reference no: EM132114817

Questions Cloud

Which approach is preferable : Choose a culture and research how that culture treats their elderly population. Which approach is preferable? Support your response.
Marginal utility of consumption : This utility function implies that the individual's marginal utility of leisure is C and her marginal utility of consumption is L.
Utility function of form : individual has a utility function of this form U(C, L) = 6 + CxL endowment of V in non-labor income. T = 16 hours to either work
Discuss sqlmap- an automated tool for sql injection : How does it work? Where do you get it? How much does it cost? Who developed it? For what purpose?
How many different number of reported crimes types : Big Data and Analytics Assignment - ANALYTIC REPORT. Questions for Dataset 1 - How many different number of reported crimes types
Discuss what you learned from this project : Discuss how your topic and scenario relates to a real-world scenario. Discuss what you learned from this project.
Describe the major activities that are on the critical path : Describe the major activities that are on the critical path - Describe the activities or groups of activities with significant float, and include the number
Why is it the most significant take-away : Why is it the most significant take-away? What has changed or will change due to this take-away?
Research and present to your group three technology options : This assignment is one that is based on teamwork and your ability to collaborate in the on-line environment.

Reviews

inf2114817

11/5/2018 2:07:00 AM

I need like this format of entire assignment before because i need to prepare the ppt and report today night and I need present tomorrow morning. I want a brief reflection on the assignment itech1103 Bigdata n analytics about 500 words. I want a reflection and conclusion for itech1103 (bigdata and analytics) in a seperate word doc. We are just 2 in a group. It was so arduous for me to devise of information for my assignment. You made my assignment simple. I am able to complete my assignment without any worry. Hats off to you guys !!!

len2114817

9/17/2018 4:07:45 AM

Note - NEED SOLUTION ON DATASET 1. PLEASE FULFILL ALL MARKING CRITERIA AND DELIVER TILL. NEED IN WATSON ONLY. Reports are to be presented in hard copy in size 12 Arial Font and double spaced. Your report should include a list of references used in the essay and a bibliography of the wider reading you have done to familiarize yourself on the topic. A passing grade will be awarded to assignments adequately addressing all assessment criteria. Higher grades require better quality and more effort. For example, a minimum is set on the wider reading required. A student reading vastly more than this minimum will be better prepared to discuss the issues in depth and consequently their report is likely to be of a higher quality. So before submitting, please read through the assessment criteria very carefully.

Write a Review

Other Subject Questions & Answers

  Explain aspects of emerging adulthood

Describe theories and research that explain aspects of emerging adulthood, focusing on either relationships or the career/vocational context.

  Identify characteristics that make this population unique

Select one of the four special populations discussed in this module (youthful offenders, domestic violence offenders, female offenders, and the elderly) and complete the following: Identify the characteristics that make this population unique

  Choose a retailer or e-tailer in an industry

Implementation Process: Discussed how the retailer will manage its operations and implement the plan to ensure results with diagrams.

  Discuss the five methods of conflict resolution

Discuss the five methods of conflict resolution discussed by DuBrin (2001). What are the pros and cons of each of the following?

  How does the writer connect these themes in the text

How does the writer connect these themes in the text. What images of self are projected through the writer's treatment of these themes

  Summary- hardware reliability margining for dark silicon era

Summarizing an article Hardware Reliability Margining for the Dark Silicon Era by Liangzhen Lai and Puneet Gupta.

  What were the prevailing characteristics of the team leader

The Williams, Parker, and Turner (2010) article discusses teams that perform proactively. What were the prevailing characteristics of the team leader and team members in each of those situations

  Implement the concept of incorporating community

Assess two techniques by which teachers can implement the concept of incorporating community knowledge into the curriculum in terms of the likelihood of advancing school reform in a multicultural and global fashion.

  What should abc insurance company do, why, how

A number of obstetrics and gynecology physicians, as well as cardiologists, who reside in one of the 14 counties do not have privileges

  International issue to argue using the rogerian method

the Rogerian method of argumentation to not only win over those who agreed with their viewpoints

  Problems related to social work issues

What information or circumstances might move your decision one direction or another?

  What supports or services might maximize the outcome

Provide a hypothesis of Jefferson's likely prognosis. What supports or services might maximize this outcome? Evaluate what Jefferson's future might have been.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd