Tuesday, August 6, 2013

Visualizations

For our visualizations we ended up using the metrics and attributes explained in our previous post. We compared each county in the visualizations below by their gross incomes, lowest wages and salaries, number of tax exemptions, lowest amount of interest earned per anum, and lowest number of dividends before exclusions.


Vertical Bar- Clustered has being selected here because it is the simplest and best way to differentiate between given set of data and especially when you have to show highest or lowest figures. In above graph you can see the difference of gross incomes between different states. California is the county with highest adjusted gross incomes amongst the rest.


As explained in the above post the bar graphs are the simplest way to explain data so horizontal bar graphs has a dependent variable on the horizontal scale. This type of bar graph is typically referred to as a horizontal bar graph. Otherwise the layout is similar to the vertical bar graph. In this micro strategy we can see that Kalawao County is the County with lowest wages and salary incomes rest than others.


 A ring chart, or multilevel pie chart, is used to visualize hierarchical data, depicted by concentric circles. The circle in the center represents the root node, with the hierarchy moving outward from the center. Over here which states that DC has lowest number of Taxes exemption.


Line chart explain best about the decline or rise in the growth in some years and over here it explains about variation in the amount of Interest earned per annum. Over here accoding to this line chart  AK is County of USA which has lowest mount of interest earned per annum.


The Bubble Grid widget conveys information in such a way that an analyst can, at a glance, identify important trends or anomalies in data, relative to the total contribution of accompanying data. In the widget, metric values are plotted as bubbles of different colors and sizes; the colors and sizes of the bubbles represent the values of two distinct metrics on the Grid/Graph. Over here explains that Kalawao County in USA is the County which has lowest percent of dividends before exclusion.

 In conclusion, each of these visualizations shows the difference in all of our information in an easy to view way. 
  • The first graph shows how California's gross incomes rise very high above the others. While Florida, Illinois, Texas, and New York stay relatively close to one other, California shows a great difference. 
  • The second graph shows lowest wages and salary incomes. The two lowest are Loving County in Texas and Kalawao County in Hawaii, which does not even make an impact on the graph because of their low rates.
  • The third graph shows the lowest number of tax exemptions. They are all relatively close to one another, but DC in the lowest while Arkansas is the highest out of these lower tax exemptions.
  • The fourth graph shows the lowest amount of interest earned per anum, as shown, Arkansas has the lowest while South Dakota has the highest.
  • The last graph shows the lowest number of dividend before exclusions. Arthur County has the largest as shown by the large green square in the graph, while Loving County and Kalawao County both have the lowest shown by the smaller red squares. 
Sarah Piercey
Melynnda O'Donnell
Natasha Majeed
Ansh Jhatta

Monday, July 22, 2013

Dashboards/About our Dataset

A. Dashboards serve the purpose of giving businesses a easy and simple look at a grouping of information. Businesses can use these dashboards to determine whether or not their business is on track and successfully completely the businesses goals. Dashboards can be used in many different ways to benefit a business. Examples include:
  • to see if sales and market share targets are being reached on an easy to read interface
  • to track the businesses finances (can also be used for personal finance)
Overall, dashboards give businesses with a great amount of data an easy to read graph/table that they can reference and check up on at a glance. Dashboards change the way businesses view their big data/business information.


B. The dataset that we were given to study represents the American government as an enterprise trying to collect data about specific counties and/or states around the country and the activity the dataset represents is organizing and manipulating statistics about American income tax, tax returns, tax exemptions, gross wages and salaries, etc.
  • Which 5 counties have the highest adjusted gross incomes out of all American counties?
The attributes that we are using to compare in regards to this question are the various County names within America and the metric that we have decided to gather the appropriate data from is the adjusted gross income figures per County.
  • Which 5 counties have the lowest wages and salary incomes overall?
The attributes that we are using to compare in regards to this question are the various County names within America and the metric that we have decided to gather the appropriate data from is the wages and salary incomes per County.
  • What are the 5 states that have the lowest number of tax exemptions?
The attributes that we are using to compare in regards to this question are the various State names within America and the metric that we have decided to gather the appropriate data from is the number of tax exemptions per State.
  • Which 5 states have the lowest amount of interest earned per annum?
The attributes that we are using to compare in regards to this question are the various State names within America and the metric that we have decided to gather the appropriate data from is the amount of interest earned per State.
  • What 5 counties have the lowest number of dividends before exclusions in America?
The attributes that we are using to compare in regards to this question are the various County names within America and the metric that we have decided to gather the appropriate data from is the number of tax exemptions per State.

Sarah Piercey
Melynnda O'Donnell
Natasha Majeed