### Compare the use of Excel and Tableau in data visualization

Assignment Help Applied Statistics
##### Reference no: EM132233859

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.

Instructions: 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.

Attachment:- Assignment Files.rar

#### Assignment-workforce 2020 executive report

Both leadership and organizational strategy in the next decade will see major trends affecting the way organizations conduct business. These include the deployment of more t

#### The result is a sample size beyond

Assume that the result is a sample size beyond what you can obtain. Use the compromise function to compute alpha and beta for a sample half the size. Indicate the resulting al

#### What is the difference between a bernoulli distribution

What is the difference between a bernoulli distribution and a poisson distribution? How can they be applied to a standardized normal distribution, specifically when looking at

#### Pearson correlation coefficient is a measure of the strength

The text tells us that a Pearson correlation coefficient is a measure of the strength and direction of a linear relationship between two variables. A scatter plot provides a v

#### A company is considering producing two new products

A company is considering producing two new products. Based on past records, management believes that there is 70% chance that the first product will be successful, and a 5

#### What does the r-value mean

Using simple linear regression, test whether age when first married (agewed) related to total family income (income91). Report the R-Value. What does the R-Value mean? Wha

#### A teacher gives a third grade class

A teacher gives a third grade class of n=16 a vocabulary test at the beginning of the school year. To evaluate the changes that occur during the year, students are tested agai

#### The manager of a company wants to investigate job

The manager of a company wants to investigate job satisfaction among its employees. One morning after a meeting, she talks to all 25 employees who attend. Does this sampli

### Write a Review

#### Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd