Icon

02_​Tableau_​BIRT_​JS

BIRT and Tableau: will they blend?

This workflow uses restaurant inspection scores from Austin, TX to produce several visualizations in KNIME. It also exports the data into Tableau TDE format so that the same visualizations can be produced within Tableau. The challenge is to produce three similar visualizations in each environment.

Execution of this workflow requires the following KNIME extensions:

-KNIME Tableau Integration (along with configuration of the Tableau Java SDK - see https://www.knime.com/reporting/tableau).
-KNIME Open Street Map Integration

Data obtained on April 16, 2018 from this URL:

https://data.austintexas.gov/Health-and-Community-Services/Restaurant-Inspection-Scores/ecmv-9xxi

Pie Charts to Tableau to JavaScript to BIRT Blending JavaScript, BIRT, and TableauThis workflow uses restaurant inspection scores from Austin, TX to produce severalvisualizations in KNIME.For more information see the workflow metadata. Find it here: View -> Description Filter on ZIP code > 78750 Bar Charts to Tableau to JavaScript to BIRT Geo Maps to BIRT to Tableau Aggregate # scores in bins by ZIP Codes Symbol Map - Geolocation Create BinsCount Scoresby ZIP and BinAverage Score by ZIPPivot forBar ChartResort forcorrect orderKeep ZIP>= 78750(N CentralAustin)Sort byZIP CodePlot 1Circles for all pointsColor by average scoreSize by average scorePlot 3PieChartBarChartOSMChartBarChartDataRename for clarityPieChartDataConvert ZIPto stringConvert scoreto numberLat/Lonsfor ZIP centroidMerge withLat/Lon Numeric Binner GroupBy GroupBy Pivoting Bar Chart Column Resorter Row Filter Sorter Pie/Donut Chart Shape Manager Color Manager Size Manager Preprocess Data OSM Map to Image Image to Report Image to Report Image to Report Data to Report Column Rename(Regex) Data to Report Number To String String To Number Tableau Writer Tableau Writer Tableau Writer Excel Reader Joiner Pie Charts to Tableau to JavaScript to BIRT Blending JavaScript, BIRT, and TableauThis workflow uses restaurant inspection scores from Austin, TX to produce severalvisualizations in KNIME.For more information see the workflow metadata. Find it here: View -> Description Filter on ZIP code > 78750 Bar Charts to Tableau to JavaScript to BIRT Geo Maps to BIRT to Tableau Aggregate # scores in bins by ZIP Codes Symbol Map - Geolocation Create BinsCount Scoresby ZIP and BinAverage Score by ZIPPivot forBar ChartResort forcorrect orderKeep ZIP>= 78750(N CentralAustin)Sort byZIP CodePlot 1Circles for all pointsColor by average scoreSize by average scorePlot 3PieChartBarChartOSMChartBarChartDataRename for clarityPieChartDataConvert ZIPto stringConvert scoreto numberLat/Lonsfor ZIP centroidMerge withLat/Lon Numeric Binner GroupBy GroupBy Pivoting Bar Chart Column Resorter Row Filter Sorter Pie/Donut Chart Shape Manager Color Manager Size Manager Preprocess Data OSM Map to Image Image to Report Image to Report Image to Report Data to Report Column Rename(Regex) Data to Report Number To String String To Number Tableau Writer Tableau Writer Tableau Writer Excel Reader Joiner

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: sfincher
Created at: 2018-05-21
On NodePit since: 2024-09-01
Last update: 2024-11-18
Created with KNIME version: v4.5.1
Tags: BIRTTableauReportingJavaScriptwill they blend

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!