User Account

All Pages

Perform the relevant data analysis tasks

Assignment Help Other Subject
Reference no: EM132123294

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.

Note: choose the "DATA SET-1"

Attachment:- Analytic Assignment.rar

Verified Expert

Exploratory research design will identify the causes at the back of the incidence of a particular problem. Exploratory research design helps in defining a problem in a precise manner, gathering data or information that is relevant to the research problem and identifying alternative actions that helps in dealing with the research problem.

Reference no: EM132123294

Questions Cloud

Utilize an agile approach to performance management : What are the compelling reasons or rationale for business to move to and utilize an agile approach to Performance Management?
Why is ethical behavior important in business management : Why is ethical behavior important in business management? Give examples of businesses that acted unethically and caused problems in the economy.
What were the risk factors : What types of risks or opportunities did the project face (be specific)? What were the risk factors?
Write a formal academic report : Students are required to write an academic report as per the format outlined in chapter 5 of the textbook - stimulate critical thinking outside of the classroom
Perform the relevant data analysis tasks : For your project, perform the relevant data analysis tasks by answering the above questions and, identify the visualization and dashboards you need to develop
Examine one of the available datasets : 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
Managing its risk and maximising wealth for shareholders : In your response critically evaluate the extent to which the firm has been successful in managing its risk and maximising wealth for shareholders in the past
Investment parameters set by saturn group global : Prepare an excel spreadsheet calculating whether this product will satisfy the investment parameters set by Saturn Group global
Entrepreneurial intensity and social entrepreneurial : What are the differences between entrepreneurial orientation, entrepreneurial intensity and social entrepreneurial orientation?

Reviews

urv2123294

11/16/2018 1:29:15 AM

The report that you sent me on crimes in Chicago. There are some changes which i want in the report as they are demanded by the teacher. The main thing to add in the report was dashboards. You have added graphs of single questions but we want dashboards consisting of combination of 3-4 questions which are relevant to each other. Please make the required changes before this Wednesday as we have to submit the assignment by Friday. For your reference, i have attached the presentation in this mail in which we have created the dashboards. You can use these dashboards or you can also make new according to your wish. Just want to know was possible Thanks you Expect. I will try to provide more next time detail I was reluctant the first time I submitted my homework to ExpertsMind. Overall, I am satisfied with the confidence of their writing. What will I do without your help? Thank a lot!

urv2123294

11/16/2018 1:26:45 AM

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

urv2123294

11/16/2018 1:26:21 AM

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 and contribution.

urv2123294

11/16/2018 1:26:03 AM

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. 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).

urv2123294

11/16/2018 1:25:24 AM

Report Submission: • Hard-copy to tutors/lecturers assignment box in week 10. Double- sided printing for the hard-copy is encouraged in order to save paper. • You will also submit a 7-8 pages report (about 1500 words not counting cover page and references) of this project. At least 15 references in your report must be from peer-reviewed sources. Include any and all sources of information including any person(s) you interviewed for this project. • Please note that all references must adhere to APA style. See http://owl.english.purdue.edu/owl/resource/560/01 and http://www.apastyle.org/ for details on how to format a report and how to cite references. Make sure your follow formal report structure with cover page, introduction, use of headings, subheadings, conclusion sand reference section. Marking Scheme: Background of the Project: Description of Project, Datasets and firm. The important of project for the firm

len2123294

9/26/2018 5:56:22 AM

We only need you to prepare report for the subject . Below attached are the documents for the report. We have chosen Data Set 1 and we have attached a sample report for your reference. Please consider the marking scheme mentioned in the assignment document and everything should be according to that.

Write a Review

Other Subject Questions & Answers

  Theory about personal self-control

I need help on a example of how i would further study a theory about Personal Self-Control?? but it has to be a empirical conclusion?? any ideas on how i would do this??

  Write an essay about perfume effects on physiology

Write an essay about Perfume Effects on Physiology.

  Explain the cause of digital-crime and non-digital crime

Determine one (1) additional theory that a researcher could use to explain the cause of digital-crime and non-digital crime.

  How you will teach for social justice

Create a short video or digital presentation that you could share with students and their families that discusses why and how you will teach for social justice.

  Write a paper on how zappos

Write a 1 -2 page paper on how Zappos (company) connects to customers through social media, such as Pinterest and Instagram, to achieve customer loyalty

  Do you think we have become a culture of photographs

How has the ability to take a photograph changed from Daguerre to today (with phones)? Do you think we have become a culture of photographs? How?

  Discuss contemporary issue or case law related to force

The Bill of Rights finds its roots in documents such as the British Magna Carta of 1215 AD.

  What is arielys point about enron leaders

What is Ariely's point about Enron leaders

  Explain debited to owner''s capital and credited to cash

A debit posting to Advertising Expense of $300 was omitted. A $3,200 cash drawing by the owner was debited to Owner's Capital and credited to Cash

  How international law has controlled the production

Discuss how international law has controlled production, distribution, use of, and access to WMD. Discuss development and use of specific WMD during World Wars.

  Explain how selected economic principles apply to the health

Explain how selected economic principles apply to the health care market and the provisions of health care services

  Introducing the new procedure with physicians

You have been asked to investigate a new procedure that physicians would like nurses to adopt in the hospital. Discuss the process you would apply to determine whether the procedure falls within the RN scope of practice and how you would go about int..

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