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. 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
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 covered by the health insurance. In 2011, population of people below 65 years increases to 267.3 Million. However, the number of people not covered by the health insurance is 47.9 Million. It decreases to 47.3 Million in 2012. Although, the number of people not covered by the health insurance decline between 2010 and 2012, however, there is no significant difference in the number of uninsured people. As being revealed in the Table 1, number of people not covered by the health insurance declines from 49.15% in 2010 to 47.3% in 2012. Similarly, the number of people covered by the private and government health insurance increases between 2010 and 2012. In 2010, 81.6% of people aged 65 or below are insured,…
Business Intelligence Creating, Implementing and Using Business Intelligence in Clinic and Resort Cases In the process of effective decision making for improving opportunities and performance of a business, a vital role is played by Business Intelligence (BI). Business Intelligence Systems understand the environments of organizations and follow a systematic information process. These systems have huge development costs but are widely created, implemented and used in mid-sized organizations, hospitals, resorts and hotels. The
Although intranet pages may provide links to the Internet, an intranet is not a site accessed by the general public" (Housel and Hom, 1999). Aside from the intranet, the company also uses a wide array of anti-virus programs, firewalls and virtual private networks. The scope of these software applications is that of screening the information which flows between all the organizational computers (Answers, 2011). At the level of the organization,
Data Mining Businesses can receive many benefits from data mining. Which benefits they receive, however, can also depend on the way in which their data mining is undertaken. Predictive analytics are used to understand customer behavior, and businesses use the behavior of the customer in the past to attempt to determine what the customer will do in the future (Cabena, et al., 1997). While it is not an exact science, many
Another advantage provided by Oracle business intelligence software is represented by the fact that such products are built in order to transform financial management processes. This is useful in order help companies adapt faster to the financial challenges that the business environment provides. Also, the company's business intelligence products are guaranteed to deliver consistent and reliable insights, as characterized by the company. This is intended to facilitate the actions taken by
Business Intelligence Unlike its Military counterpart, Business Intelligence is not an oxymoron. There are many examples of successful implementations of Business Intelligence despite the challenges. This paper explores the purposes for and the complexities of data processing systems that are designed to provide tools for top managers in their task of wading through swamps of unrelated information as they hone in on supports for taking critical business decisions. A possible confusion of
Business Intelligence Review Lessons Learned: BI Creates Less System Redundancy Provides Increased Responsiveness Improves Efficiency with More Accurate and Timely Access to records Produces Timely Reporting Affects Bottom Line with Reduced Human Resource Costs due to training or staffing IT professionals Reviewing Marshfield Clinic Lesson Learned for the Marshfield Clinic that has a staff of 6,500 and over 50 sites and 800+ medical professionals, it treats over a quarter of a million patients annually (Konitzer and Cummens,2011). With
Our semester plans gives you unlimited, unrestricted access to our entire library of resources —writing tools, guides, example essays, tutorials, class notes, and more.
Get Started Now