Data Analysis and Business Intelligence Essay

Total Length: 1362 words ( 5 double-spaced pages)

Total Sources: 8

Page 1 of 5

Business Intelligence and Data Analysis

Tableau Project

Dashboard

Health insurance coverage for people below 65 among states

Graphical features used

Descriptive and predictive analytics used

Population of Insured and Uninsured People aged 65 and below

The project evaluates the rates of insurance coverage for people aged 65 and below between 2010 and 2012 in all states in the United States. The report analyzes the data using several statistical tools such as descriptive statistics, predictive statistics, and linear treadline . The report identifies that the number of uninsured in this age category declines between 2010 and 2012. However, the number of insured in this age category increases between 2010 and 2012. Additionally, the rates of insured and uninsured vary between states. The twenty-five states recorded an increase in the number of uninsured between 2010 and 2012, and the rest recorded a decline in the number of uninsured.

Executive summary

Objective of this project is to evaluate the health insurance coverage for people less than 65 years between 2010 and 2012. Starting from 2008, ability of people to have access to private insurance is limited because of the economic downturn during the period. In essence, health insurance coverage was limited for people under 65 years of age because many people lost their jobs during the period. This report collects data of health insurance coverage between 2010 and 2012 for people below 65 years in all states in the United States. The data collected reveals the level of health insurance problem in the United States. The paper uses the two different websites to complete the study. They are:

http://www.census.gov/hhes/www/hlthins/data/index.html

http://www.tableausoftware.com/

The report chooses the age category of people under 65 years because these categories of people represent largest number of population in the United States. Based on the U.S. population estimates in 2013, people less than 65 years of age represent 85.5% of the total population.

Stuck Writing Your "Data Analysis and Business Intelligence" Essay?

The table 1 reveals the total population of people in this age group and the number of people covered and not covered by the health insurance (Census. 2014).

Year

All People (Thousand)

Not Covered (Thousand)

Covered by Private or Government Health Insurance (Thousand)

Number

Standard Error

Percent

Standard Error

Number

Standard Error

Percent

Standard Error

United States

2012

267,829

47,312

17.7

0.2

220,517

82.3

0.2

2011

267,320

47,923

17.9

0.1

219,397

82.1

0.1

2010 (10)

266,776

49,159

18.4

0.2

217,617

81.6

0.2

Table 1: Number of People Covered and Not Covered by Health Insurance

Dashboard

The dashboard reveals the dataset of the health insurance coverage for people aged 65 and below. The data reveal that people 65 years and above increase between 2010 and 2012, and population people aged 65 years and below are 266.7 million in 2010 and increase to 267.8 million in 2012. The dashboard also reveals number of insured and uninsured group in this age category. The data reveal that the number of uninsured decrease between 2010 and 2012. In 2010, the number of uninsured people are 49.1 Million and decrease to 47.3 Million in 2012. However, the number of insured people increase between 2010 and 2012. In 2010, the insured people were 217.6. Million in 2010 and increased to 220.5 Million in 2012. In essence, the chart reveals that uninsured decrease between 2010 and 2012, however, insured people increase between 2010 and 2012.

Based on the data from the Census (2014), the total number of the U.S. population is approximately 316 million where the population of people 65 years or below in 2010 are approximately 266.8 Million. The data in the dashboard shows that 49.15 million people in this age group are not covered by the health insurance in 2010, which is approximately 18.4% of people not.....

Show More ⇣


     Open the full completed essay and source list


OR

     Order a one-of-a-kind custom essay on this topic


sample essay writing service

Cite This Resource:

Latest APA Format (6th edition)

Copy Reference
"Data Analysis And Business Intelligence" (2014, November 20) Retrieved June 13, 2026, from
https://www.aceyourpaper.com/essays/data-analysis-business-intelligence-2153311

Latest MLA Format (8th edition)

Copy Reference
"Data Analysis And Business Intelligence" 20 November 2014. Web.13 June. 2026. <
https://www.aceyourpaper.com/essays/data-analysis-business-intelligence-2153311>

Latest Chicago Format (16th edition)

Copy Reference
"Data Analysis And Business Intelligence", 20 November 2014, Accessed.13 June. 2026,
https://www.aceyourpaper.com/essays/data-analysis-business-intelligence-2153311