In previous posts we saw how to integrate tableau with Hive and visualise & Integrate Tableau and Apache drill(JSON data source). Here we will use CSV data source to visualise using Tableau.
1. Download CSV datasource.
2. Click Text file form connect section and import CSV file & visualise CSV data in tabular form.
Click on Sheet 1 and open dashboard. Under data tab we have two sections (Dimension and Measures) which contains columns from data source.
Dimension : Independent variable (Order Date, Region, Item and Rep)
Measures:Dependent variable (Unit price and Units)
Visualisation-1: Total Number of Units Sold by representative in each region
Drag and drop Region & Rep from dimension to working area, which acts columns data. Similarly drag and drop Units from Measures in working area.
![]() |
Number of units per region and representative (In decreasing order per region) |
Alex sold maximum units in Central, Richard in East and James in west region. Does any company interested in number of units sold by their representative or total amount in $.
Visualisation-2: Total amount(In $) Sold by representative in each region
Lets create new field Total from dependent fields (Units and Unit price). Do right click in Measures section and select "Create Calculated field". Using Units and unit price compute TotalSales which listed in Measures section.
![]() |
Custom field TotalSales computed from Units and Unit Price |
![]() |
Representative VS TotalSales(In $) |
Colourful chart: Drag and drop Region & Rep in Color pallet. It modifies chart and each bar is coloured. If Rep is dragged- each rep is f different color, when Region is dragged - each region is represented with different color.
![]() |
Colourful grouped representation: By Rep and By Region |
Format Labels: Drag TotoalSales in Label pallet (beside Color). It brings total sales value on each bar of chart. Format of currency representation can be changed.
Export worksheet as Image : Go to Worksheet -> Export -> Image...
Try Yourself: Modify existing worksheet and compute bonus for each Rep as 5% of individual's TotalSell and display at top of each Rep.
Next: Create a bar chart Representative and TotalSell along with there yearly bonus. (Yes, Solution of above question)
ReplyDeleteWow, what a great information. I am sure the info on your blog will help others.Thanks.
SAS Training in Chennai
SAS Analytics Training in Chennai
clinical sas training in chennai
clinical sas course
clinical sas training fees
Placement Training in Chennai
soft skills training institutes in chennai
SAS Training in Chennai
Great Article. As I read the blog I felt a tug on the heartstrings. it exhibits how much effort has been put into this.
ReplyDeleteIEEE Projects for CSE in Big Data
Spring Framework Corporate TRaining
Final Year Project Centers in Chennai
JavaScript Training in Chennai