Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Atlas Bikes has been selling their bikes since 1975 in the United States. They expanded to Australia and Germany in the year 2015. The bikes

Atlas Bikes has been selling their bikes since 1975 in the United States. They expanded to Australia and Germany in the year 2015. The bikes are sold via a trusted network of sales outlets, which are not owned by Atlas Bikes. As a measure to improve their footprint in the market, Atlas sales wants to open new stores which will be owned by them. To do this, the Senior Management wants to review the numbers and come up with their expansion strategy.


Instructions:

Login to Tableau
Import the excel file - ATLAS_BIKES_TABLEAU_XLS.xlsx
Create an inner join between Sales table and the rest of the tables as shown below[ Hint: Drag and Drop the tables in the Data Source space]


Management wants to see how the countries are located on the World Map. On hovering over the counties, each one should show the Total Population, Revenue and Quantity sold in the tooltip. 

Required Components: 1.) A world map with colors representing the different countries 2.) total sales and revenue values displayed when hover over. 3.) values displayed above the bars.


Management is eager to know the numbers for each of the sales outlets. Display the Revenue and Quantity Sold for each of the Sales Outlet as a Bar Chart. Required Components: 1.) A bar chart for sales quantity. 2.) A bar chart for sales revenue. 3.) values displayed above the bars. 4.) the name of the sales outlets represented by bars.


Historically the revenue from each sales outlet has been between 30-70 million USD. Management wants to see how many sales outlets fell in that bracket and in which year. Also add a filter so that they can segregate the data based on the year Required Components: 1.) Use packed bubbles to display your results. 2.) Outlet name is represented by color. 3.) Add a filter to include only years 2014-2015. 4.) Add a filter to include sales in the range of 30-70 million USD. 5). Display the Sales outlet name, sales year, and sales revenue in the circle.


Management wants to see how the sales outlets across the 3 countries performed for each of the Product Categories. Use a Tree Map and give the ability to the management to filter on the year, country name and Product Category Name. Required Components: 1.) Use a Tree Map to display your results. 2.) Add a filter for product category. 3.) Add a filter for sales year of 2014, 2015. 4.) Add a filter to allow the ability to filter by country. 5). Display the product category name. 6). Display the product name. 7). Display the sales year.


Step by Step Solution

There are 3 Steps involved in it

Step: 1

Unfortunately I cant access or use Tableau to import files or create visualizations directly However ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

International Marketing And Export Management

Authors: Gerald Albaum , Alexander Josiassen , Edwin Duerr

8th Edition

1292016922, 978-1292016924

More Books

Students also viewed these Accounting questions

Question

4 Describe how effective organizations manage their culture.

Answered: 1 week ago