User Account

All Pages

Write a data analytical report to provide useful insights

Assignment Help Other Subject
Reference no: EM132129019

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.

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

Attachment:- Samples.zip

Verified Expert

Data collection technique has two popular categories in it and it was widely used to collect the samples based on these two categories, namely, primary and secondary data collection methods and this study is an example of secondary data collection technique

Reference no: EM132129019

Questions Cloud

Negative exponential distributions appear to be relevant : The Poisson and negative exponential distributions appear to be relevant in this situation.
Critically evaluates drug and alcohol screening programs : Evaluating a screening program - critically evaluates drug and alcohol screening programs generally, and the likely implications such a program in workplace
What are the server-side attacks : What are the server-side attacks? What are the techniques a developer can employ to minimize these attacks?
Determine the link efficiency for each type of link : A series of information frames with a mean length of 100 bits is to be transmitted across the following data links using an idle RQ protocol.
Write a data analytical report to provide useful insights : Write a Data Analytical report to provide useful insights, pattern and trends in the chosen/given dataset - Your task for this analytical project
Will services follow the trend of manufacturing : Will services follow the trend of manufacturing in being outsourced and offshored from industrial countries to developing countries?
How would you measure the effect of the change : How would you measure the effect of the change? For example, consider the number of counselors used and the arrival pattern of students.
Discuss which design or interface you prefer and why : Compare the pros and cons of designing the application using the three different interfaces with respect to conducting group projects online.
What was the purpose of the software : You may choose one discussed in class or research one yourself. In your analysis, identify the following: What was the purpose of the software?

Reviews

urv2129019

10/25/2018 4:33:19 AM

DATASET 1ST YOU HAVE TO DO. In Below attached zip folder there are samples watson analytics. Hey there, ExpertsMind I would like to say that I had the best experience ever of getting my assignment done and submitted before the deadline. If I had to do it then obviously I would have never been able to secure such good marks and also the assignment would have resulted in me getting a zero. It was because of your experts, only that I was able to score the perfect grade.

urv2129019

10/25/2018 4:29:21 AM

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. and contribution.Cover letter (Format, key findings and recommendation )

urv2129019

10/25/2018 4:29:10 AM

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).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.The Reflection: Each Team member is expected to write a brief reflection about this project in terms of challenges, learning.

urv2129019

10/25/2018 4:26:46 AM

Tasks: Background of the Project: Description of Project, Datasets and firm. The important of project for the firm 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 –Advanced Work: The quality and complexity of additional five (5) insights provided other than the guided questions.

urv2129019

10/25/2018 4:25:14 AM

This location is shifted from the actual location for partial redaction but falls on the same block. Location - The location where the incident occurred in a format that allows for creation of maps and other geographic operations on this data portal. This location is shifted from the actual location for partial redaction but falls on the same block. You are expected to present the data findings in a visual forms (i.e., charts and graphs). This is a group assignment. You will complete it with your team (max 3 members enrolled in the same laboratory). It is expected that each team member will contribute equally in the project. Each team will turn in one joint document and give a joint presentation in Timetabled Laboratory class in Week 10. In addition, each individual team member will write a short reflection as part of the report. You will receive feedback on the draft about presentation choices, content, analysis, and style.

urv2129019

10/25/2018 4:24:59 AM

X Coordinate - The x coordinate of the location where the incident occurred in State Plane Illinois East NAD 1983 projection. This location is shifted from the actual location for partial redaction but falls on the same block. Y Coordinate - The y coordinate of the location where the incident occurred in State Plane Illinois East NAD 1983 projection. This location is shifted from the actual location for partial redaction but falls on the same block. Year - Year the incident occurred. Month- Month the incident occurred. Day – Day the incident occurred Updated On - Date and time the record was last updated. Latitude - The latitude of the location where the incident occurred. This location is shifted from the actual location for partial redaction but falls on the same block. Longitude - The longitude of the location where the incident occurred.

urv2129019

10/25/2018 4:24:41 AM

Domestic - Indicates whether the incident was domestic-related as defined by the Illinois Domestic Violence Act. Beat - Indicates the beat where the incident occurred. A beat is the smallest police geographic area – each beat has a dedicated police beat car. Three to five beats make up a police sector, and three sectors make up a police district. The Chicago Police Department has 22 police districts. See the beats District - Indicates the police district where the incident occurred. See the districts Ward - The ward (City Council district) where the incident occurred. See the wards Community Area - Indicates the community area where the incident occurred. Chicago has 77 community areas. See the community areas FBI Code - Indicates the crime classification as outlined in the FBI's National Incident- Based Reporting System (NIBRS). See the Chicago Police Department listing of these classifications

urv2129019

10/25/2018 4:22:44 AM

ID - Unique identifier for the record. Case Number - The Chicago Police Department RD Number (Records Division Number), which is unique to the incident. Date - Date when the incident occurred. this is sometimes a best estimate. Block - The partially redacted address where the incident occurred, placing it on the same block as the actual address. IUCR - The Illinois Unifrom Crime Reporting code. This is directly linked to the Primary Type and Description. See the list of IUCR codes Primary Type - The primary description of the IUCR code. Description - The secondary description of the IUCR code, a subcategory of the primary description. Location Description - Description of the location where the incident occurred. Arrest - Indicates whether an arrest was made.

Write a Review

Other Subject Questions & Answers

  What type of disaster is your local hospital likely to face

How might your response plan for an epidemic such as the avian flu differ from your response plan for a natural disaster? Are there resources to plan for that would be different? Are there resources that would be impacted regardless of the type of..

  Do you think that computers can think

Do you think that computers can think? Do you think one could ever be programmed that would have the ability to think? Why or why not?

  Discuss if the sales tax is a good or bad move for the city

Discuss if the sales tax is a good or bad move for the city of Lawsona. Make sure to clearly state your stance on the situation, and explain in detail your reasoning behind your decision.

  Risk management includes remedial action but not prevention

Part of risk assessment is having scientific certainty that an agent or activity causes harm before action is taken to limit exposure. Risk management includes remedial action but not prevention.

  Will you need any additional training or schooling

Does the career you want pay a salary that meets your needs? Will you need any additional training or schooling? Will it offer you opportunities to advance?

  Identify health care cost for consumers

Describe current and potential challenges with the health care system. Identify health care cost for consumers. What are consumers' reactions

  Problems based on measurement scale

Identify 6 to 8 trends facing the industry within which your company operates.

  The conceptual frameworks of the ethical constructs

Introduce the conceptual frameworks of the ethical constructs of ethics, moral, or legal standards and the purpose of the paper.

  Ethical implications of disclosure and nondisclosure

Consider the ethical implications of disclosure and nondisclosure. Research federal and state laws for advanced practice nurses. Reflect on the legal implications of disclosure and nondisclosure for you and the health clinic

  Early child development and services

What are some ways in which effective means of emotional expression is used to engage with a client experiencing a problem?

  Sex differences in depression emerging during adolescence

With regard to mental health, what are some reasons for sex differences in depression emerging during adolescence?

  Explain the behavior of the woman in the media program

Select and describe one of the women in the media program exhibiting either positive self-esteem or narcissism.

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