Create a dashboard describing the data by age group

Assignment Help Applied Statistics

Reference no: EM132233880

Assignment -

You need to have the software "Tableau" Your assignment will have a Tableau file showing the dashboard and a word document for the part 2.

Assignment - For this assignment, you will use the "Claims 2" dataset. You will use Tableau to replicate the dashboard you created in the Topic 3 assignment. In addition, you will compare and contrast the Excel and Tableau software.

Part 1: Create a dashboard describing the data by age group (e.g., 21-30 yrs, 31-40 yrs, 41-50 yrs, 51-60 yrs, and 61-70 yrs). The dashboard should include the graphs and charts listed in the locations described. The dashboard should be submitted as a Tableau file. A sample layout is provided in the resource, "Data Visualization With Tableau Screenshot: Preview of the Tableau Dashboard."

1. Top Left: Bar graph showing the average number of ER visits for each of the five age groups. Show the actual average values above each bar.

2. Middle Left: Bar graph showing the average number of procedures for each of the five age groups. Show the actual average values above each bar.

3. Bottom Left: Bar graph showing the average claim cost for each of the five age groups. Show the actual average values above each bar.

4. Top Right: Pie chart showing the percent of the total sum of all claim costs for each of the five age groups. Show the actual percent values of each slice.

5. Bottom Right: Line graph showing the percent of each age group that has one or more ER visits. Show the actual percent values of each group. To create this chart, first create a new calculated column, named "Has ER Visit," that is equal to 1 when the patient has had one or more ER visits; otherwise 0. HINT: The average of a 0-1 column is a percent.

Part 2: In 250 words, compare and contrast the use of Excel and Tableau in data visualization. Include specific discussion about the following in your summary.

1. Software ease of use.

2. Software visualization capabilities.

3. Software limitations.

4. Discussion of when each of these software programs is most appropriate for use.

APA format is not required, but solid academic writing is expected.

Attachment:- Assignment Files.rar

Reference no: EM132233880

Questions Cloud

In what situations is the given method most effective : A reference that discusses the method. How this can be applied to managing people in organizations? In what situations is this method most effective?

What challenges did boeing face in building the dreamliner : What was different about the Dreamliner? What challenges did Boeing face in building the Dreamliner?

Should managers automatically be at the top of the pay scale : Imagine that you manage human resources for a small business. You have recently prepared a report on the market rate of pay for salespeople, and the company's.

Discusses the potential ethical and legal issues raised : Select a theoretical approach you most align with, discuss why the approach appeals to you and how the theory explains how change happens

Create a dashboard describing the data by age group : Create a dashboard describing the data by age group. The dashboard should include the graphs and charts listed in the locations described

Discuss the overall quality of customer service : HA540 Discuss the overall quality of customer service offered at the nursing home (as evident by customer complaint inspection results)

Improvement in project when task perform multiple times : How do you define improvement in a project when task perform multiple times? ?

Company total ordering and holding cost per year : What is the company's total ordering and holding cost per year?

Sin portfolios consistent with efficient markets hypothesis : Are faith-based or sin portfolios consistent with the Efficient Markets Hypothesis? why

User Account

All Pages