Data Visualization Assignment - Data Analysis, Reporting, and Insights

This assignment focuses on data visualization using Tableau, analyzing a dataset to extract meaningful insights. The solution addresses various questions related to data analysis, including the number of tables, rows, and columns in the dataset. It explores the impact of aggregation on bar graphs, identifying sub-categories with the highest sales and profits. The assignment also examines specific sub-categories, such as Phones, Chairs, and Copiers, and their respective sales and profit values. The solution demonstrates an understanding of data analysis techniques and the ability to interpret data visualizations to identify trends and patterns. The assignment showcases the use of Tableau to analyze and visualize data, including the identification of key performance indicators and the comparison of different categories to identify the most and least profitable sub-categories.

Data Visualization – Assignment-2
Question 1: Paste the screenshot of the resulting screen.

Question 2: Total how many tables are there in the loaded dataset? What is the total number of
rows in the orders table? What is the total number of columns in the Orders table?
There are three tables loaded into the loaded dataset. There are 10000 rows in the orders
table. There are 21 columns in the orders table.

Question 3: Paste a screenshot of your relationship between the Orders, the People and the
Returns table.

Question 4: Paste a screenshot of the renamed worksheet.
Question 5: What is the default aggregation in Tableau?
a) Mean
b) Sum
c) Median
d) Count
Answer: The default aggregation in Tableau is B) Sum.

Question 6: Paste the screenshot of your screen showing the entire view.
Question 7: What changes were observed in the bar graph when aggregation was changed from
sum to average?
Answer:
When the aggregation was changed from sum to average, the length of the bars changed. The
most noticeable alteration was a significant reduction in the Office Supplies bar. This would
imply that a large number of office supplies were sold, but the profit margin on each was rather
low in comparison to the other categories.

Question 8: Paste the screenshot of your screen showing the “Entire View”
Question 9: Which sub-category has sales greater than $140,000? Which sub-category has
Profit greater than $10,000?
Answer:
Phones, Chairs, Storage, Tables, Machines, Binders, Accessories, and Copiers are all sub categories with
sales above $140,000. Phones, Chairs, Storage, Binders, Accessories, Furnishing, Appliances, Paper and
Copiers are all sub categories with profit above $10,000.

Question 10: Paste the screenshot of your current screen showing the “Entire View”.
Question 11: Paste the screenshot of your screen.

Question 12: Which sub-categories are making the most profit? Which sub-categories are
making the least profit? List 3 sub-categories with their corresponding values for each with your
answers.
Answer:
Copiers, Phones, and Accessories are sub categories that make the most profit, making $56094,
$45051, and $41937correspondingly. Tables, Bookcases, and Supplies are sub categories making the
least profit, making -$17753, -$3632, and -$1171 correspondingly.

Question 13: Paste the screenshot of your screen showing the “Entire View”.
Question 14: Which sub-categories have the highest sales? Which sub-categories have the
highest profits? List 3 sub-categories for each with their respective values.
Answer:
Phones, Chairs, and storage are sub categories that make the most sales, making $331843,
$335768, and $224645 correspondingly. Copiers, Phones, and Accessories are sub categories that make
the most profit, making $56094, $45051, and $41937 correspondingly.