Solution-Examine one of the available datasets

Examine one of the available datasets

Reference no: EM132139371

Big Data and Analytics Assignment - ANALYTIC REPORT and PRESENTATION

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.

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.

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 peerreviewed 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 - Use Dataset 2 in this assignment.

Attachment:- Assignment File.rar

Verified Expert

The solution file is delivered in word and ppt. The statistical analysis was performed using IBM watson analytical software. Chicago criminal records were analysed and few strategic recommendations were provided to the police cheif in this report for further crime reduction.

Reference no: EM132139371

Questions Cloud

Explain change strategies : Explain change strategies. Give an example of change strategy that a company could implement.

Describe the case including the parties respective arguments : Antitrust laws are designed to promote competition. Outside of college athletics, economic competition is considered good for society.

Can these challenges be overcome : Evaluate the challenges and opportunities of an expatriate position. How can these challenges be overcome?

How architecting systems provide a means to deliver product : Explain how architecting systems provide a means to deliver a product that was in line with the requirements based on the information you gathered.

Examine one of the available datasets : How many number of reported crimes were logged every year in December - How many number of reported crimes whether an arrest was made

Assess the organizational dimensions : Assess the organizational dimensions that must be considered when selecting organizational structures.

Outline the capital structure choices open to international : Outline the capital structure choices open to international firms. Give an example using XYZ company.

How defense-in-depth and awareness complimentary techniques : Your final research paper assignment is to write a research paper that explains how defense-in-depth (chapter 6) and awareness (chapter 10) are complimentary.

Congestion of transportation and logistics : Discuss how we need to look into new technology and methodology to improve the congestion of transportation and logistics?

Reviews

urv2139371

11/21/2018 1:23:26 AM

I am very very pleased with the work done, thank you very much for your assistant. the writer did a very good job. I would like to get make my assignment from u in future. Yes, It is perfect work. thanks a lot.

len2139371

10/12/2018 11:52:17 PM

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

10/12/2018 11:52:07 PM

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%

10/12/2018 11:51:56 PM

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

10/12/2018 11:51:33 PM

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). 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 assignment report (i.e. the report to the operational team of the company). [Each analysis/dashboard and report explanation with relevant research papers, complexity and in- depth of the justification, use of peer-reviewed sources] 15

10/12/2018 11:51:25 PM

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

Write a Review

Required(*) Message

User Account

All Pages

Examine one of the available datasets

Reference no: EM132139371

Reference no: EM132139371

Questions Cloud

Reviews

urv2139371

len2139371

len2139371

len2139371

len2139371

len2139371

Write a Review

Other Subject Questions & Answers

Explaining about the "collective bargaining"

Discuss the restaurant discovers that the customers

Where should she begin to prepare such a document

Is a gang a subculture

What is the new jim crow

How is material culture related to nonmaterial culture

Partial computer output for the data

Define organizational effectiveness

Explain the main concepts of cloud computing

History of philosophy

Calculate the actual volumetric flow rate of air to furnace

Considering financial profitability

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT