User Account

All Pages

How many total number of reported crimes

Assignment Help Other Subject
Reference no: EM132109840

Learning Outcomes

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.

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 dataset could be downloaded from the following link

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

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

Attachment:- Analytic Assignment.rar

Verified Expert

The solution has been done by using the Harvard referencing style & contains in total 1500 words. The solution has been completed by using Watson Analytics as one of the main tools for data analysis. The solution contains seven tasks based on analysing the crime scenario in Chicago.

Reference no: EM132109840

Questions Cloud

True about undue influence : Which of the following is true about undue influence?
Continues to lead the market for all natural products : What should Clorox do with the Burt's Bees brand to make sure the Burt's Bees brand continues to lead the market for all natural products?
Meeting the design standard at four-sigma quality : If the process capability index is 1.276 and the process capability ratio is 1.132 , is the process capable of meeting the design standard at four-sigma quality
What is meant by the term level of assurance : What is meant by the term level of assurance? How does the level of assurance differ for an audit of historical financial statements, a review, and compilation
How many total number of reported crimes : ITECH1103- Big Data and Analytics - ANALYTIC REPORT - PRESENTATION - show innovation and creativity in applying Watson Analytics and designing
What is the amount of the common fixed expense : The West Division's divisional segment margin is $200,000. What is the amount of the common fixed expense not traceable to the individual divisions
What was the absorption costing net operating income : Last year, Junco Corporation's variable costing net operating income was $100,000. What was the absorption costing net operating income last year
Calculate the departmental overhead rate : Handy Display Company manufactures display cases to be sold to retail stores. Calculate the departmental overhead rate for each of the three departments listed
What is the cost of goods manufactured : Fred Co. incurred costs of $800,000 for direct materials (raw) purchased. What is the cost of goods manufactured

Reviews

inf2109840

11/15/2018 2:04:23 AM

Great service served by Experts Mind.com, the solution was handed in time and quality of the work was excellent. I recommend Experts Mind.com services to everyone looking for authentic and affordable help...

len2109840

9/11/2018 1:31:22 AM

7- Cover letter (Format, key findings and recommendation ) [1+1+3] 5 8- Other Tasks Report is well-written and presented professionally, containing: • Title page • Table of Contents • Introduction • Appropriate use of headings within report • Appropriate use of figures (i.e. graphs, summary tables) and reference to calculations and summaries to justify all observations and recommendations • Overall structure, presentation and formatting. Note that the report has to be presented formally. It must include discussion of calculations, observations and recommendations with graphs and/or tables. 1 1 2 1 1 2 2 Total Marks 100 Total Marks out of 20 20% You MUST produce the actual visuals in Watson using the sample dataset. If you think the best presentation above is to use, say, only a pie chart, then discuss using a pie chart and indicate what the pie chart would show, why you picked the pie chart, and so on. It may be useful to try with various BI reporting/dashboards/presentations before rushing to conclusion.

len2109840

9/11/2018 1:31:11 AM

5- Recommendations - 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 assist in achieving operational/strategic objectives. 15 [Key data insights, recommendations to achieve organisational objectives with theoretical justifications with proper references. [2+3+5] 6- The Reflection: Each Team member is expected to write a brief reflection about this project in terms of challenges, learning and contribution. 10

len2109840

9/11/2018 1:00:25 AM

Tasks Max Marks 1- Background of the Project: Description of Project, Datasets and firm. The important of project for the firm [1+1+1+2] 5 2- Dashboard/Reports What are the BI reporting solution/dashboards you will need to develop for operational manager of chosen in the light of Questions of your Data analysis - [Quality and complexity of the analysis – 30 3- Advanced Work: The quality and complexity of additional five (5) insights provided other than the guided questions. 10 4- Research - Justify why these BI reporting solution/dashboards are chosen and why those attributes are present and laid out in the fashion you proposed (feel free to include all other relevant justifications).

len2109840

9/11/2018 1:00:03 AM

Assessment Criteria: Criteria Marks Introduction /05 Content – Guided & Advanced Questions – /50 Conclusion /10 Presentation Style e.g. clarity, engagement /20 Team participation /10 Timing (10-15 minutes) /05 Subtotal- /100 General Comments:

Write a Review

Other Subject Questions & Answers

  Finalize the literature review section must be in apa format

Finalize the literature review section must be in apa format and cite all sources 5 to 7 pages. the topic is Ethics and Accountability.

  Explain how you would use swot and bsc together

Briefly compare SWOT and BSC and the unique value of each to strategic management. Explain how you would use SWOT and BSC together. Explain how one tool complements the other.

  Explain premises listed under either the pro or con section

From the Procon Website, identify three premises (reasons) listed under either the Pro or Con section -- whichever section opposesyour position.

  What do you perceive to be the physical demands of your job

Prior to being hired were you asked to take any physical ability tests?What do you perceive to be the physical demands of your job?On a scale of 1 to 5, with 5 meaning very physically demanding and 1 meaning not at all physically demanding, how phy..

  One important way a speaker gains extrinsic credibility

One important way a speaker gains extrinsic credibility is through:

  Describe a behavior that you have tried to change

Describe a behavior that you have tried to change in the past or that you might want to change now or in the future

  How does the leader engage with others through talk

How does this leader create a connection with others through talk? How does this leader raise the level of morality in a group through talk?

  How do you feel about the topic in the article

How do you feel about the topic in the article? Do you agree with the author's conclusion based on the presentation of facts

  Examine effects of psychological contract breach on employee

Examine the effects of psychological contract breach on employee attitude and behavioural job outcomes such as job satisfaction, intention to quit, organizational support, motivation, organizational citizenship behaviour and employees' job perform..

  Prepare an executive summary to present to the board

Prepare an executive summary (850-1,000 words) to present to the board, from which they will make their decision to fund your program or project.

  What percentage of population was affected by the disease

Using the Internet conduct an independent research on the selected disease. What percentage of population was affected by the disease

  Although the independent variable had an effect

Explain whether the researcher has made a correct decision or has made a Type 1 or Type 2 error. Explain why. (a) Although the independent variable had an effect, Dr. E does not reject the null hypothesis

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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