|
|
| Tableau Workbook Name: Superstore.tds |
|
|
|
|
| Tableau Workbook Name: Superstore.tds |
|
Table of Contents
|
Counts
|
|
|---|---|
| Data Source # | 1 |
| Data Source Filters # | 0 |
| Custom Sql # | 0 |
| Fields # | 25 |
| Calculated Fields # | 10 |
| Groups # | 0 |
| Hierarchies # | 2 |
| Parameters # | 2 |
| Sets # | 0 |
| Bins # | 0 |
|
Data Source
|
Data Source Type
|
Source
|
Connection Info
|
Joins
|
|---|---|---|---|---|
| federated.10nnk8d1vgmw8q17yu76u06pnbcj | Live | excel-direct | DB: D:/Rushi/Sample Files/TDS/Superstore I.tds Files/Data/Superstore/Sample - Superstore.xls; File: D:/Rushi/Sample Files/TDS/Superstore I.tds Files/Data/Superstore/Sample - Superstore.xls | None |
|
Source Database
|
Table Name
|
Field Name
|
Remote Field
|
Data Type
|
Dimension/ Measure
|
Hidden
|
|---|---|---|---|---|---|---|
| excel-direct | Orders | Row ID | Row ID | integer | Dimension | No |
| excel-direct | Orders | Order ID | Order ID | string | Dimension | No |
| excel-direct | Orders | Order Date | Order Date | date | Dimension | No |
| excel-direct | Orders | Ship Date | Ship Date | date | Dimension | No |
| excel-direct | Orders | Ship Mode | Ship Mode | string | Dimension | No |
| excel-direct | Orders | Customer ID | Customer ID | string | Dimension | No |
| excel-direct | Orders | Customer Name | Customer Name | string | Dimension | No |
| excel-direct | Orders | Segment | Segment | string | Dimension | No |
| excel-direct | Orders | Country/Region | Country/Region | string | Dimension | No |
| excel-direct | Orders | City | City | string | Dimension | No |
| excel-direct | Orders | State/Province | State/Province | string | Dimension | No |
| excel-direct | Orders | Postal Code | Postal Code | string | Dimension | No |
| excel-direct | Orders | Region | Region | string | Dimension | No |
| excel-direct | Orders | Product ID | Product ID | string | Dimension | No |
| excel-direct | Orders | Category | Category | string | Dimension | No |
| excel-direct | Orders | Sub-Category | Sub-Category | string | Dimension | No |
| excel-direct | Orders | Product Name | Product Name | string | Dimension | No |
| excel-direct | Orders | Sales | Sales | real | Measure | No |
| excel-direct | Orders | Quantity | Quantity | integer | Measure | No |
| excel-direct | Orders | Discount | Discount | real | Measure | No |
| excel-direct | Orders | Profit | Profit | real | Measure | No |
| excel-direct | People | Regional Manager | Regional Manager | string | Dimension | No |
| excel-direct | People | Region (People) | Region | string | Dimension | Yes |
| excel-direct | Returns | Returned | Returned | string | Dimension | No |
| excel-direct | Returns | Order ID (Returns) | Order ID | string | Dimension | Yes |
|
Calculated Field Name
|
Tableau Field Name
|
Formula
|
Dimension/Measure
|
|---|---|---|---|
| Days to Ship Actual | Calculation_0831103151444568 | DATEDIFF('day',[Order Date],[Ship Date]) | Measure |
| Sales Forecast | Calculation_5421109230915137 | [Sales]*(1-[Churn Rate])*(1+[Parameters].[New Business Growth]) | Measure |
| Ship Status | Calculation_6401103171259723 | if [Days to Ship Actual]> [Days to Ship Scheduled] then "Shipped Late" elseIF [Days to Ship Actual]= [Days to Ship Scheduled] then "Shipped On Time" Else "Shipped Early" end | Dimension |
| Days to Ship Scheduled | Calculation_6861103170623145 | CASE [Ship Mode] WHEN "Same Day" THEN 0 WHEN "First Class" THEN 1 WHEN "Second Class" THEN 3 WHEN "Standard Class" THEN 6 END | Measure |
| Order Profitable? | Calculation_9060122104947471 | {fixed [Order ID]:sum([Profit])}>0 // calculates the profit at the order level | Dimension |
| Sales per Customer | Calculation_9321103144526191 | Sum([Sales])/countD([Customer Name]) | Measure |
| Profit Ratio | Calculation_9921103144103743 | sum([Profit])/sum([Sales]) | Measure |
| Sales above Target? | Calculation_9951107165644870 | If Sum([Sales])>SUM([federated.0hgpf0j1fdpvv316shikk0mmdlec].[Sales Target]) then "Above Target" else "Below Target" end | Measure |
| Units estimate | Sales est (copy) | ROUND([Quantity]*(1-[Churn Rate])*(1+[Parameters].[New Business Growth]),0) | Measure |
| Profit per Order | Sales per Customer (copy) | Sum([Profit])/countD([Order ID]) | Measure |
|
Hierarchy Name
|
Fields
|
|---|---|
| Location | Country/Region, Region, State/Province, City, Postal Code |
| Product | Category, Sub-Category, Product Name |
|
Parameter Name
|
Data Type
|
Allowable Value Type
|
Current Value
|
Values
|
|---|---|---|---|---|
| New Business Growth | Float | Range | 60% | Min: 0%, Max: 100%, Step size: 1% |
| Churn Rate | Float | Range | 6.40% | Min: 0.00%, Max: 25.00%, Step size: 0.10% |