In any data analytics exercise, it is important to understand the underlying data as an aid in interpreting the results of any analysis undertaken, In this comprehensive problem that covers multiple chapters of the textbook, five cities in the state of New York are the basis for the analysis. The five cities are: - City of Elmira - City of Poughkeepsie - City of Rome - City of Saratoga Springs - City of Watertown These five cities were selected because they are all in one state, thus governed by the same state reporting and audit requirements. The fact that the cities are governed by one set of reporting requirements means that the data reported follows the same chart of accounts and rules for what should be reported in each account. As you will see, state requirements may not always follow GAAP requirements or the recommendations of the text. Cities selected are fairly comparable in population size, but they are geographically dispersed within the state, which has an impact on their economy. A data set including information for the five cities has been provided. The data set includes: - Five years of data from 2014-2018 - Modified accrual information for the General Fund, Capital Projects Funds, and Debt Service Funds - Budget information for the General Fund Click here to download the data set Substantial detail is provided for some types of data. Although the assignments do not require the use of all data detail, your professor may ask for additional support for analysis that could include you preparing additional reports and analysis relating to the detail provided. charts/graphs or Tableau, Using Excel to create graphs/charts can be accomplished by using pivot tables (click on insert). Once in your pivot table, filter the data to include only those items you would like charted (click on insert and then recommended charts or create your own chart). Some calculations may require you to create a new column and/or row and/or table that includes the calculations you will graph. The purpose of this assignment is to have you build a profile of each of the five cities involved in this project. An increased understanding of the cities will allow you to better interpret the results of comparisons you make among the cities in subsequent assignments. Required 1. Build a brief profile of each city that could include information such as: - Per capita income - Median home values - Wealth Index - Unemployment rate - Information about the local economy - Location of each city You may find other information that is also useful, but the above items provide a basic understanding of the city. Your report should be approximately one page in length. You may be able to find data for the most recent year only, however, it will still provide relevant information to help better understand the city. Some sources that are helpful: - https:/ewyork, hometownlocator.com/census/sorted-demographics.cfm - https:/hwwwcensus, gov/data/datasets/fime-series/demo/pepest/2010s-total-cities-and-towns.htm|\#ds - City/county websites In any data analytics exercise, it is important to understand the underlying data as an aid in interpreting the results of any analysis undertaken, In this comprehensive problem that covers multiple chapters of the textbook, five cities in the state of New York are the basis for the analysis. The five cities are: - City of Elmira - City of Poughkeepsie - City of Rome - City of Saratoga Springs - City of Watertown These five cities were selected because they are all in one state, thus governed by the same state reporting and audit requirements. The fact that the cities are governed by one set of reporting requirements means that the data reported follows the same chart of accounts and rules for what should be reported in each account. As you will see, state requirements may not always follow GAAP requirements or the recommendations of the text. Cities selected are fairly comparable in population size, but they are geographically dispersed within the state, which has an impact on their economy. A data set including information for the five cities has been provided. The data set includes: - Five years of data from 2014-2018 - Modified accrual information for the General Fund, Capital Projects Funds, and Debt Service Funds - Budget information for the General Fund Click here to download the data set Substantial detail is provided for some types of data. Although the assignments do not require the use of all data detail, your professor may ask for additional support for analysis that could include you preparing additional reports and analysis relating to the detail provided. charts/graphs or Tableau, Using Excel to create graphs/charts can be accomplished by using pivot tables (click on insert). Once in your pivot table, filter the data to include only those items you would like charted (click on insert and then recommended charts or create your own chart). Some calculations may require you to create a new column and/or row and/or table that includes the calculations you will graph. The purpose of this assignment is to have you build a profile of each of the five cities involved in this project. An increased understanding of the cities will allow you to better interpret the results of comparisons you make among the cities in subsequent assignments. Required 1. Build a brief profile of each city that could include information such as: - Per capita income - Median home values - Wealth Index - Unemployment rate - Information about the local economy - Location of each city You may find other information that is also useful, but the above items provide a basic understanding of the city. Your report should be approximately one page in length. You may be able to find data for the most recent year only, however, it will still provide relevant information to help better understand the city. Some sources that are helpful: - https:/ewyork, hometownlocator.com/census/sorted-demographics.cfm - https:/hwwwcensus, gov/data/datasets/fime-series/demo/pepest/2010s-total-cities-and-towns.htm|\#ds - City/county websites