Ojoswi On Tableau

Friends, built this Viz on top of Great Lakes water data from NOAA site. The submission has been made for round 3 of the IronViz feeder contest leading to #TC18 . This Viz is published to Tableau Public  and embedded to this blog

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 ...

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.