Tableau Project 2

Overview

This assignment taught me valuable hands-on experience using Tableau to analyze and visualize data from the Adventure Works dataset. I explored business questions related to bike sales in Australia and used various visualization types to present clear insights. I learned how to apply data filters to narrow down results based on criteria like date and country, and I created calculated fields to extract new measures, such as Profit Ratio. These tasks helped me strengthen my business intelligence skills by identifying customer demographics and tracking sales trends to support data-driven marketing strategies. This assignment also helped me build technical proficiency with Tableau and SQL Server Analysis Services (SSAS), giving me more confidence in working with multidimensional databases and visualization tools. I also worked on creating clear, readable visualizations that effectively communicated my findings.

In the past 3 years (2012-2014), which product yielded the most revenue in Australia?

·   Visualization: Bar Chart (Total Revenue v. Product Category)

·   Helps identify which product category made the most revenue between 2012-2014

What is the profit ratio in each country for each product in the past 3 years (2012-2014)?

·   Visualization: Highlight Tables (Country v. Product Category & Subcategory)

·   Helps identify the profit ratio (Total Profit/Total Revenue) for each individual product in each country

Which countries had yielded more revenue in bikes than Australia in the past 3 years (2012-2014)?

·   Visualization: Map (Heat map of total revenue in bike sales in each country)

·   Helps identify the total revenue of bike sales in other countries compared to Australia