Homework answers / question archive / Requirements include analysis with visualization components 1

Requirements include analysis with visualization components 1

Business

Share With

Requirements include analysis with visualization components 1. Detailed analysis of an identified dataset a. Selection of dataset which provides sufficient information for a comparative analysis of identified factors b. Identification of specific objectives/questions related to data which the analysis will address/answer c. Development of workbook (containing multiple worksheets) which contains organized worksheets that logically develop analysis step by step (including documentation) d. Development of analytical short report which provides descriptive analysis, including appropriate visualization components 2. Submission should include: a. Analysis workbook (Excel) b. Short report (Word) c. Peer Evaluation form completed by each member. Select a dataset which provides sufficient data/detail for solving a business problem Review available sites where datasets are available. You must critique the available data based on comparative detail that would allow you to identify at least three analysis objectives/statements of problem which can be answered by analyzing the data. For example, you may find data reporting crimes throughout Arkansas, county by county. You design researchable questions: Where within an identified geographic area is XX crime most prevalent? What crimes are solved within one year? How do the crime scene stats compare county by county in a specific area of the state? YOU develop solvable objectives based on the data you find. (I realize in research you should identify your objectives of analysis first, then locate the data source to solve the problem. Here we are simulating the situation based on the data you can identify.) 
Here are sites where you can find downloadable datasets:  
(1)  Kaggle: http://kaggle.com
(2) Arkansas State Government: http://transparency.arkansas.gov/Pages/default.aspx
Click on tabs Expenditures, Revenues, Employee Salaries. b. Download complete data as an Excel file. c. Observe fields of data; what problems of analysis can you identify? 
(3) Federal Government: http://www.data.gov/ 
a. Click on links to Climate, Health, Geospatial, Jobs and Careers, etc. b. Large datasets downloadable. 
(4) City of Chicago: https://data.cityofchicago.org/
Identify problems of interest to you! Extremely interesting data are available. 
Identify objectives of analysis/questions to solve with the analysis State researchable questions (based on your selected data). Use the skills you have developed in BINS 3380 Business Communication. State these objectives in form of questions. Develop a user-friendly (documented) workbook Your first sheet should be your documentation sheet (which you will likely construct last). The documentation gives identification information but more importantly shows the user how to use the workbook: sections of the analysis, where to go to access what. 1. Identify your team members. 2. State purposes of analysis, including research questions. 3. Identify source of data. 4. Identify each area of analysis (worksheet by worksheet). a. Provide text that explains the analysis and how to use the tool used in that sheet. b. Add buttons to which you add go-to macros that when clicked takes the user to that sheet/area of sheet where that particular analysis can be seen. (include on each sheet a button that takes the user back to the documentation sheet) c. Add "print" buttons (print macro attached) for each chart or other area the user might want to print—button to print the sheet/print a segment of the sheet. d. Assure you explain how the worksheet is used. It must be user friendly. Your dataset is provided, but likely moved to last sheet. Provide named sheet tabs that take your analysis step by step. Make sure the analysis flows in a logical manner. Throughout your analysis, add textbox/comments that explain what you are doing on the sheet—what the user can see from that particular segment of analysis. Use arrows that point to "interesting" findings from graphical analysis (place oval around focal point), for example. (Make sure your macros are saved in this workbook, so they work when another is sent the workbook— test this out!) Integrate required data analysis components into your worksheet Use the analytics tools you have experienced in this class. Be creative in seeing what tools provide the most complete/understandable analysis. Remember that individuals relate to varied types of data presentation. Some people can see relationships in tabular form; others need a graphic visualization— provide a combination. Incorporate the following: 1. Sheet background coloring to make interesting 2. Functions/formulas 3. Formatting: be consistent throughout 4. Conditional formatting as needed 5. Sparklines or Databars 6. Charting 7. Table tools: total row, subtotals, filtering (with instructions for filtering in a textbox as needed) 8. PivotTable, PowerPivot, Power View a. Slicer 9. Trend projections a. Linear/growth trends 10. Data Protection: Protect cells that should be unchangeable (DO NOT password protect in this project, since your instructor needs to be able to remove protection) Make sure your final product looks very professional! Document your project and findings in the form of an analytical short report Your project should be documented in a short report, containing the following components (see example reports provided in Blackboard): 1. Write in direct order (beginning with your recommendations/summary conclusions. 2. Write using a personal writing style (you can use "I," "you," and "we" in the text. 3. Use talking captions—captions like you see in this assignment in which the captions state the major point/conclusion of the section. (see example short reports, use as a pattern.) Make sure your captions are parallel—all sentences (but with no period at end, such as ones in this report) or all beginning with a verb, for example. 4. The flow of the report will following this design: a. Section 1: State your recommendation/conclusions drawn from the analysis. Summarize findings using a bullet list. Answer your research questions. b. Section 2: Identify your problem/research questions, identify source(s) of data, and your approach to solving the problem. This background explains what you did and makes clear what you did not do— paragraph or two. c. Sections 3-XX: Summarize your analysis. Each section should begin with a talking caption that states your most important finding/conclusion for that section. Make sure each section presents the summary information and makes a specific statement(s) of conclusion. Integrate appropriate visualization tool: charting. Make sure charts have a box around them, name of chart and chart number below each. Note: Should you link or embed the charts in the report? Consider advantages of each approach. What is appropriate in this assignment? d. End with a short summary statement, so the report doesn't just end or something appear missing. But remember, your summary, conclusion, recommendations are provided at the beginning of the report and do not need to be restated here. Assign project responsibilities among your team members Each team member must have specific responsibilities. You will be assessed by your other team members regarding your individual participation in this project. Note that this project is a major component of your course grade. If your team has a member who is nonresponsive, notify your instructor immediately—the team member will be removed from the team! Your team must decide how to proceed in dividing responsibilities among yourselves. In Blackboard you have a link to your team (My Group) and team communication resources: file exchange, project discussion board (other teams cannot see), wiki, email (within the team). I suggest you begin with a group meeting via a service such as freeconferencecall.com or a similar tool. All team members should be involved in choosing which dataset to use and in constructing the researchable questions. You could use the wiki tool for this step. Decide what tools to use. You can split the responsibilities for some of the data analysis, design of the workbook documentation, and drafting of the written report. I suggest you share your workbook in OneDrive , Google Drive or similar cloud site. Use the course discussion board if you need to communicate with other teams for brainstorming.