Where to use Box Plots in Tableau

Box Plots
  •  We use Box plots to analyze how data is spread across the data set.
  •  Every set can be divided into 3 quartiles. Q1 =0-25%(Lower Quartile), Q2 = 25-50% (Median), Q3=50-75%(Upper Quartile)
  •  In this example, Pull Sub- Category onto Columns and Sum(Profit) onto rows. Database used is Sample Superstore and Tableau 10.3.
  •  Change the marks type from line to Circle. we can see the profit of each sub-Category.


  •  Now pull the State onto details, we can see the distribution of Profit different states.
  • We can format by increasing the transparency of the circle and the borders for the circle to better dentify the data. Sort the data, such that it shows highest to least.


  •  Right click on the Profit Axis, Add Reference Line, Select Box Plots.
  •  Give the Plot Options as ‘Data Within 1.5 times the IQR’. The data will spread as in the below pic. Format the necessary, Select Hide Underlying Marks (expect Outliers), Style, Fill, Modern, Borders, Whiskers as in below pic.
  • Note: IQR is the Inter Quartile Range (Q3-Q1) (75%-25%=50%)


  •  Now, Give the Plot Options as ‘Maximum extent of data’. We can see the Whiskers covering even the Upper and Lower Quartiles and hiding the underlying Marks.
  •  Box Plots helps us to analyze the data in different ways. We can find which Sub-Category made the least Profits(Binders), which Sub-Category made the Highest Profits(Machines). Which Sub-Category is having overall lowest profits (Tables), as it has negative values even in Median whereas the others gradually increased even initially when they are in negative values in Lower Quartile. Please see the below pic.


Comments

Post a Comment

Popular posts from this blog

Types of Sorts

Image
Sorts Sorts are of different types, 1.      Simple Sort 2.      Complex sorts 3.      Advanced Sort using Calculated field 1.      Simple Sort ·        Pull Region onto Columns, Sub-Category onto Rows and Sales on the Text on Marks card. Database used is Sample Superstore and Tableau 10.3. ·        We can find the highest ‘Sales’ in each ‘Region’ by clicking on the ‘Sort’ Button beside each Region. Here the Sub-category ‘Phones’ has the ‘highest Sales’ in ‘East Region’. ·        Note: The default sort type is Descending. ·        We can sort the Sub-Category too, it will be ascending and Descending according to alphabetical order. ·        We can also sort the Sales ‘Row-Wise’, this give the sales from high to low Sales for that particular Sub-Category. ·        Now Pull Category onto Rows, Click on the Category, goto Sort, we can see the window as shown in the below pic. We have options for Sort Order Ascending, Descending. ·        Sort By : Da
Read more

HOW TO USE RANKS IN REAL TIME SCENARIOS IN TABLEAU

Image
HOW TO USE RANKS IN REAL TIME SCENARIOS   In this example, let’s find the Top 3 selling Sub-Categories in each State. We would be using Sample superstore database and Tableau 10.3. Pull Sales onto columns and State and Sub-category onto rows.   Create a Calculated field, call it ‘Rank’ and give ‘Index ()’. Index returns the row position. Pull the Rank onto Rows, in between State and Sub-Category. Change it from ‘Continuous’ to ‘Discrete’. You can find the Rank created, giving 1, 2,3 ... 656 across the whole table starting from Alabama to Wyoming.   Let’s change the Rank such that it gives Rank Only State wise. It should start giving Ranks from 1, 2,3...n in each state.   Right click on Rank, go to Compute Using, Choose the Option ‘Pane (Down)’ instead of ‘Table(Down)’. This action helps restart Rank (1 to n) in every State.       Now, Let’s give the Ranks 1 to N to Sub-Categories such that the highest sales holds 1 and next highest 2 ..  to do this, Right click on Rank, go
Read more
Tableau Desktop Vs Tableau Server Tableau Desktop:-   All your development is done here. From creating reports, charts,  formatting them, putting them together as a dashboard all the work is done on Tableau Desktop. 1. Data Source Connection 2. Extractions 3. Analysis Process 4. Statistical Analytics 5. Visual Analytics 6.Designing, Creating, Publishing and Scheduling Tableau Server:-   The dashboards you create are shared with other users using Tableau Server. When you upload(publish) a Dashboard to Tableau Server from Tableau Desktop, other users can access those Dashboards by logging on Tableau Server. 1. Data Source, Sheets/Workbook Management (Content) 2. User Management 3. Performance Management (Load balancing, Server Management) 4. Scheduling Activities What is the difference between core-based and user-based licenses 1 User-Based Server License:    If your Server Software license is designated as User-Based, the Named Author
Read more