1 / 20

Business Intelligence Assignment

Business Intelligence Assignment. Shannon Costin , Roger Sims, Zachary Southerland, Pravesh Thaiba, & Ying Zhou. To develop a non-working prototype of an application for the St. Louis Police Department. This presentation will demonstrate how Group #2’s prototype:

yeva
Download Presentation

Business Intelligence Assignment

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Business Intelligence Assignment Shannon Costin, Roger Sims, Zachary Southerland, Pravesh Thaiba, & Ying Zhou

  2. To develop a non-working prototype of an application for the St. Louis Police Department. • This presentation will demonstrate how Group #2’s prototype: • How BI might be used to better understand the problem • Decisions supported with BI • Maintained data • Analytics that will be provided • DASHBOARDS Objectives

  3. Our application starts after a common log-in, found on a police department’s computer St. Louis Police Department UserName: Password:

  4. Excluded Districts: Amount of Time: Prediction Date: Basic Information Providing information about the location, time, & date to predict

  5. Excluded Districts: Amount of Time: Prediction Date: Basic Information An example of what it might look like, when the user is editing the ‘Basic Information’

  6. Time: Date: Race: Population: Economy: Special Event: Variable Importance Weight Default setting will weigh variables equally

  7. Time: Date: Race: Population: Economy: Special Event: Variable Importance Weight Example of what it would look like, if a user wanted to change any setting

  8. Decision Data Summary User: John Smith ExcludedDistricts: #1, #2 Amount of Time Evaluated: 1 Year, 8 Months, 16 Days Prediction for: October 3, 2012 Time: 20 Date: 90 Race: 50 Population: 30 Economy: 55 Special Event: 60 Variable Weight: Enables a “save-able” or “print-able” summary for records, sharing, etc...

  9. The purposes of this application: • Enable the user to visually see the impact of different variables/factors • Give the user an opportunity to view the data in many different visually appealing ways. • Provide the user with an estimate of the approximate # of homicides (during a specific timeframe, using STL’s districts as location) • The actual computation of the data (algorithm) will be hard-coded into the application • The user will be given the opportunity to change the variable weight used in the algorithm What Exactly is Happening?

  10. All of the data presented to the users will be the same, however the default view (setting/preference) will be different based on the particular user. • The user level will be determined by the user’s log-in. The users will be divided into 3 default setting groups: Decision Information: Piaget’s Influence User Novice Experienced Average

  11. Decision Information: Novice High Crime: RED Med. Crime: PINK Low Crime: YELLOW 6 8 5 7 4 9 2 Modeled after The Weather Channel 3 1

  12. Decision Information: Average *All pictures, graphs, charts, etc. will be magnified as the user drags the mouse over it, & when double-clicked will pop-out into a separate window

  13. Decision Information: Experienced With Intent Slightly weighted with more past results

  14. Chart A chart/excel visual, if a user just wants to looks @ the raw data

  15. Additional Variable #1 Graphs Additional Variable #2 All graphs have ‘magnify’ & ‘pop-out’ feature Additional Variable #2 With Intent

  16. Interactive Map Balloon A Address: Street Name St. Louis, MO 63102 Homicide Gauge: Homicide with Intent Gauge: As you click/move the balloon: the address and gauge sections will automatically refresh

  17. District Map High Crime: RED Med. Crime: PINK Low Crime: YELLOW 6 8 5 7 4 9 2 Information changes based on the information/criteria provided earlier in the application 3 1

  18. The “Factor Analysis” page (a.k.a. “Variable Analysis” page) is designed to help the user understand the importance of how the variables/factors determine the results. • Variables/Factors: • Economy • Time • Race • Population • Special Event • An example of what this page will look like is demonstrated next. Variable/Factor Analysis

  19. Variable/Factor Analysis Economy 3 Year Factor Filter

  20. Questions, Comments? THE END

More Related