Discussion Question

User Generated

Xvatpuhpx

Programming

Description

1. What are some of the limitations of using Excel for pivot tables/charts? Why does that make software like Tableau more appealing in the workplace?


2. Plotting summarized data will almost always help to convey results more easily. However, there are situations where plotting the summarized data instead of creating a simple table makes data interpretation more difficult. Provide two examples of poor charts/graphs and explain why they are difficult to interpret.

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

The files above contain complete work of your assignment. Kindly check it and let me know if you need clarification. Thank you.

Running head: EXCEL FOR PIVOT TABLES/CHARTS
1

EXCEL FOR PIVOT TABLES/CHARTS
Institutional affiliation:
Date:

2
EXCEL FOR PIVOT TABLES/CHARTS

Excel is complex and thus intimidating to users. This makes the process of creating pivot tables seem
complex and thus makes the users especially the once who are unfamiliar with pivot tables feel
intimidated. Before creating pivot tables, one must familiarize with the source data in excel before
beginning. It forces users to spend more time massaging the source data in order to remove blank
entries which may cause errors in pivot tables. If the data in excel doesn’t have headings, a user will
have to create headings which will be used as field names when creating pivot tables. These make the
process tasking and complex.

Sharing data is another major limitation of using excels to create pivot tables this is because for
one to share useful, functional pivot tables with others require saving the workbook in Excel format.
This poses a great challenge as users who do not have Excel may not be able to access the specific
workbook that has pivot tables.

Excel pivot tables do not reflect data changes immediately, this is because it works with the data
available during their creation. When dat...


Anonymous
Nice! Really impressed with the quality.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags