Eric Villafranca
Tableau Take Home Assignment
max points: 100
INFM 220
Name
: ________________________________________
Project Details
You will work with Orders&Sales.xlsx file that contains three sheets
: (1) ListOfOrders, (2) OrderBreakdown, and (3) SalesTarget.
Complete the tasks below (6 tasks total) and submit your work to the dropbox folder on OAKS. Make sure you keep everything in one Word file.
1.
Connect Tableau to a dataset [8 points]
o
Download the following Excel file and save it on your desktop: Orders&Sales.xlsx
o
Create a new Tableau project and connect it to all three tabs in the Excel file. Make sure that all three tables are connected properly: ListOfOrders with OrderBreakdown on Order ID, and OrderBreakdown on SalesTargets on Category.
o
Insert a screenshot of Data Source tab. The screenshot should show the connection among the data tables.
2.
Create a bar chart [8 points]
o
Create a bar chart that displays countries and their total profit. o
Change the color of the bars to any shade of yellow. o
Rename the sheet as Profit by Country
o
Insert a screenshot of the chart below
1