Ojoswi On Tableau

Created an example, where User can choose the starting Month and the report dynamically updates to show corresponding Fiscal Months, QTR and YR

This Tableau dashboard would automatically adjust its presentation based on the screen size used to view this report Example embedded below:

The Tableau dashboard published is used to analyze Crimes in Detroit. Raw data taken from Public domain data published to City of Detroit website:  https://data.detroitmi.gov/Public-Safety/DPD-All-Crime-Incidents-2009-Present-Provisional-/b4hw-v6w2 The Report has two Dashboards A. Crime Listed by Year, Council and Neighborhood/Address B. Count of Crime over Time colored by Crime category (with Analytics) Dashboard A:  Crime Listed by Year, Council and Neighborhood/Address has the following components/Viz: A1. Count of Crime over Month-Year A2. Crime by Neighborhood and shaped by Council for the selected Month-Year A3. Detailed Crime Count by Crime-Spots in selected Neighborhood above Dashboard B: Count of Crime Analysis by Category B1. Box and Whisker plot of the Census, colored by Category over Council on X Axis B2. Filled Area chart for different Neighborhood over distinct Crime Spot Count (X Axis) colored by Category B3: Count of Crime over Time col

Observe: When the parameter is set to State all the LOD values across the sate remains same (even if the report is drilled to city) across Category and Segment When Category is selected, the LOD values are constant for each of the columnar Category for all States and Segments When Segment is selected, the Colored Segments same across all states and Categories Two Calculated Fields and a Parameter 1. LOD Avg Sales 2. LOD Values Parameter LOD The drop-down Parameter LOD controls the calculated fields LOD Values and the LOD Avg Sales based on the choice made by the user

This report is based on the calculated field called Shipping Time, where 'Time to Ship' formula is as below: The two charts 'Ship Time by Year' and 'Ship Time by Month' are a Filled Area map of the - Number of Orders (Y Axis) - Days to Ship (X Axis) Colored By - Year - Months The 'Timely Shipment' chart is colored by whether 'Ship Mode' is 'Early', 'On-Time' or 'Late' Based on a business Logic per formula below: The report below is interactive using Dashboard Action filters.  Uses OOTB retail data that comes with Tableau installer.

At the very onset, this Tableau report is based on a Calculated field. After Left joining Orders table to Returns table on Order ID, only those orders that were returned were marked accordingly and the rest were left as 'Sales Retained'  Above calculated field is used on the color pill to render Viz in the example below.  The published report starts with a  1. Summary viz with the Returned Sales $ are calculated as a percentage of the Sales $ on that day and plotted over time series. Once can infer that Q1 of both 2012 and 2013, majority of the retail transactions have been Returns 2. Area chart on the top left plots running total of the Returned Sales $ as a percentage of total Sales (for the entire data set). This viz is particularly useful is concluding that there is a considerable surge in returns on the last week of March 2014. Also some comfort from the fact that Returned Sales $ is merely 8% of Total Sales 3. The Correlations bubble chart plots the Sales $

The Published report presents an analysis of Flight Delay focussing on the following features of Tableau: 1. Heat maps 2. Geo Maps colored by type of delay 3. Dual Axis Trend The user-interactive report has been published to Tableau Public and embedded below:

The embedded Tableau Report focusing on the following features: 1. Gantt chart for displaying a duration viz over time scale 2. Area chart to viz metrics over time scale with calculated dimension on Color pill to call out if the order was shipped in time 3. A Bar chart for the rank by Shipping time at the Order ID granularity The report is interactive by means of the following: a. A year picker drop-down (parameter) b. A Top N variable (slider parameter) c. Dashboard Action filters

Created a Tableau Viz using the OOTB Data Set to do a Yea over Year metric comparison, where the two years to be compared are user interactive choice. Incorporates the following features: 1. Trend Charts YoY using color marks at a Monthly granularity 2. Box and Whisker Viz with YoY using color marks at a Monthly granularity 3. Trend and 4. Histogram YoY using color