University Tableau Assignment: American Trends Panel Wave 35 Analysis

This assignment focuses on using Tableau to analyze and visualize data from the Pew Research Center's American Trends Panel Wave 35 survey. The student utilized Tableau to create interactive dashboards, including histograms, horizontal bar graphs, and stacked bar charts, to explore relationships between various variables such as gender, education, income, and political affiliations. The technical approach involved transferring variables to columns and rows, using both frequency counts and percentages to present the findings. The analysis identified key themes and presented them through strategic, analytical, and operational dashboards to facilitate decision-making. The assignment also acknowledged the limitations of Tableau regarding report refreshing and concluded that Tableau enhances decision-making through easily interpretable visuals. The dataset was quantitative, with null observations filtered. The dashboards showcase the distribution of data, identify trends, and uncover potential abnormalities within the dataset, aiding in effective data interpretation.

Running head: TABLEAU 1
Tableau
<Name>
<University Name>

TABLEAU 2
Tableau
Introduction
Generally, tableau software helps in data visualizations that enhances decision making. On this
note, various interactive dashboards have been used. These visualizations include but not limited
to histograms, horizontal bar graphs and stacked charts. Here is the link to the dashboards
created.
https://public.tableau.com/views/Tableauassignmentinformationsystem/
Sheet6?:display_count=y&:origin=viz_share_link
Dashboard purpose
Generally, dashboards play an important role in analytical work. For example, dashboards
present summarized data which can easily be understood and interpreted. As a result, decision
making processes are simplified. In addition, dashboards are used to enhance visualization of the
results which can be seen by anybody by just having a glance of the findings. Furthermore,
different dashboards such as bars and histograms can be presented in ascending and descending
order hence easily to summarize and describe the results without necessarily indicating the
frequency counts or percentages on the bars, (Shmueli, et, al, 2017).
Key themes identified in the current analytical work include but not limited to association
between gender and political parties, proportions of the educational status among the
participants, income status, Language, marital status, religion, born final and weight have been
explored.
Technical approach
Well, to present the findings, different bars have been used to present the findings. Some of the
technical approach utilized include transferring of some variable lists to columns while others to
rows as shown in the charts. In addition, both frequency counts and percentages were used to
present the results.
Data description
The dataset used is quantitative in nature with ability to be edited, explored, summarized and
described. In addition, null observations were filtered from the overall presentations of the
findings. However, no transformation was done on the findings.
Architecture design
Dashboard includes three interactive visualizations
1. Histograms

TABLEAU 3
The results above show the histogram drawn to indicate how region, education category and age
category varies by responses of the final borns. From the results, majority of the born final 2 are
leading in all the three categories followed by born final 1. On the other hand, born final 99
which most probably indicate missing variables are the lowest as indicated by the above
findings.
2. Horizontal bar graghs.
Similarly, the horizontal bar graph below was also used to visualize the results. Similarly, second
ecimph w35 are leading in the sampled variables followed by the option three and one
respectively.
Moreover, stacked bar chart was also drawn to visualize the results as shown below:

TABLEAU 4
From the results, still the F partfinal 2 emerged top for the three sampled variable categories as
shown. Well, looking at the results, it can be assumed that the second categories with option 2
are obtained highest responses for the variables than any other options.
The Dashboard includes all three types of interactions
Strategic dashboard:
First type of interaction dashboard is strategic which is majorly used to visualize the results so
that management can make effective decisions. From the results below, majority of the born final
are option 2 while option 1 became second. However, still some respondents failed to show their
gender.
Analytical dashboard:

TABLEAU 5
Identification of the type of distribution is one of the analytical dashboards that helps the
management to identify the patterns and trends of dataset. For example, with the findings in the
graph below, weight is positively skewed hence large median than mean thus affecting the
distribution of weight.
Operational dashboard:
Basically, operation dashboard is used to identify abnormalities within the interactions of the
visuals. For example, it is normally expected gender, education and political parties should not
influence participants and that it is normally expected the proportions of the participants in either
party or gender should be the same.

TABLEAU 6
From the results, one gender category is top in both edication and party final. Therefore, the
management can find out why one gender category is doing well than the other category so that
decision making can be taken to improve the operations within the organization.
Limitations
As much as tableau have the ability to handle large sum of dataset, it is limited by the fact that
tableaus are not having rescheduling or refreshing reports generated but instead all new reports
or previous reports must be reproduced a fresh.
Conclusion
In conclusion, tableau data analytics including presenting results by use of visuals enhances
decision making. This is because the visuals are easy to understand and interpret by just having a
glance at the visuals.

TABLEAU 7
References
Shmueli, G., Bruce, P. C., Yahav, I., Patel, N. R., & Lichtendahl Jr, K. C. (2017). Data mining for business
analytics: concepts, techniques, and applications in R. John Wiley & Sons.