Looking at identifying data trends using Tableau, creating a form in Excel, and creating a dash board in Excel this week based on the data you selected.
Analysis Requirements:
Based on your readings and peer reviewed literature use the template provided to complete this assignment
Review the video below and the handout on Tableau basics to assist you in making a bar chart in Tableau.
To obtain data for this case:
Download a data set from data.gov. How to Download from data gov.docx How to Download from data gov.docx - Alternative Formats
Use Tableau to identify any trends in the data set you downloaded by creating a bar chart. Be sure you have some correlation in your chart. Ex. temperature
and amount of snow fall.
Based on the trends you identified with the data you selected design a spreadsheet in Excel to obtain additional information you feel is needed. Be sure the
spreadsheet incorporates the necessary data entry controls for the data you identified. You must use advance features like data validation, drop down boxes,
conditional formatting, etc. Test your spreadsheet with 3-5 entries.
Going back to your original data set create a dashboard in Excel to better visualize the data you downloaded, be sure to keep proper data visualization
techniques in mind. Include 2 items on your dashboard.
As part of your discussion identify how the spreadsheet you created will improve overall data input controls as far as the accuracy or consistency of the
needed data and how the dashboard will provide for further data analysis.
Writing/Presentation Requirements:
The body of this paper should be 2-3 pages (not including cover page, abstract or references) but not more than 4 pages.
This research paper requires a minimum of two scholarly references: academic journals, professional journals, and/or appropriate authoritative references
such as FASB Codification System, COSO, COBIT, Audit Standards, etc.
Be sure to provide specific examples throughout your paper to back up your statements
All research papers are submitted in APA format for sources and citations.
Please remember to run your documents through Plagiarism Checks (Weeks 1-8) to review the percentage taken from other sources prior to uploading here
for final grading and the final plagiarism check.
View the grading rubric
Assignment Due This Week:
Analysis with the charts, worksheets, and dashboard embedded into the Word Document
Watch Video
How To… Create a Basic Bar Chart in Tableau
Duration: 7:40
How to create a Dashboard in Excel How to create a Dashboard in Excel item options
http://www.youtube.com/watch?v=lyNYPMw-ANs
https://keiseruniversity.blackboard.com/webapps/blackboard/content/contentWrapper.jsp?
content_id=_18671772_1&displayName=Linked+File&navItem=content&attachment=true&course_id=_276048_1&tab_group=courses&href=http%3A%2F%2Fw
Sample Solution