Data vizualization fundamentals-tableau

Assignment Help Financial Management

Reference no: EM131891684

Assignment: Data Vizualization Fundamentals - Tableau

Read the brief case below. Using Tableau Desktop Profession Edition, complete the questions.

Atlas 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:

Import the excel file - ATLAS_BIKES_TABLEAU_XLS.xlsx

Create an innerjoin between Sales table and the rest of the tables as shown below [Hint: Drag and Drop the tables in the Data Source space]

Click on “Goto Worksheet” at the bottom to insert a blank worksheet for your questions

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 TreeMap and give the ability to the management to filter on the year, country name and Product Category Name. Required Components: 1.) Use a TreeMap 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.

To make the presentation more appealing, put together your visualizations as a storyboard. Required Components: 1.) Create a storyboard. 2.) Insert a cover page to highlight what the report is about. 3.) On each page add text to explain the visualization/findings.

Reference no: EM131891684

Questions Cloud

Gross income with respect to foregoing transaction : What must X include in gross income with respect to the foregoing transaction in 2015?

How the four communication flows : What are some examples of how the four communication flows (down, up, horizontal, external) are used for communication?

How do you plan to communicate with your stakeholders : You schedule a meeting with managers from the impacted departments, and only seven of the 13 you invited show up to discuss the project.

Describe the purpose of a wbs : Project Work Breakdown Structures (WBS) play an important role when defining the scope of a project and developing a project schedule.

Data vizualization fundamentals-tableau : Atlas Bikes has been selling their bikes since 1975 in the United States. Senior Management wants to review numbers and come up with their expansion strategy.

Discuss common issues in the contracting process : Discuss common issues in the contracting process.Describe four provider obligations commonly included in managed care contracts.

Describing three different social media platforms : Write a 350- to 700-word summary describing using three different social media platforms with the objective of networking within your career field.

Discuss the impacts of p4p on provider payment reform : Provide incentives to physicians and health care provider organizations to achieve improved performance by increasing quality of care and reducing costs.

Sharing healthcare information from the patient : What benefits and challenges are there in sharing healthcare information from the patient as well as the clinician perspective?

User Account

All Pages