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

Reference no: EM132233859

Questions Cloud

Discuss the strategy-driven talent managemen : Strategy-driven talent management is considered the most effective way to acquire and maintain top talent. Develop three possible ways that senior leadership.

What is fermi level energy : What is Fermi level energy? Explain in detail.

Appeals court deny workers compensation benefits for wolfe : Why did the appeals court deny workers’ compensation benefits for Wolfe?

Functional conflict from dysfunctional conflict : What differentiates functional conflict from dysfunctional conflict? Within groups, negotiations usually center around either the task

Compare the use of Excel and Tableau in data visualization : In 250 words, compare and contrast the use of Excel and Tableau in data visualization. Include - Software ease of use and Software limitations

Evaluate the effectiveness of the roles : Evaluate the effectiveness of the roles that the strategic leaders played in the formation of the performance management strategy.

How are work perks different from work benefits : What are the variables that influence an employee's decision to leave or stay at an organization and How are work perks different from work benefits

How you would facilitate post-project meetings : Now the event is over. Imagine you were the project manager on the project. Describe how you would facilitate post-project meetings with staff, customers.

How talent management strategy attract a diverse workforce : Considering the vast number of diverse groups represented in the workforce, create a brief research agenda that addresses how talent management strategy.

User Account

All Pages