1.2 Open Tableau Workbook and Connect to SQLite Database

  • Open Tableau Desktop.

  • Go to File -> Open..., and select the latest version of the Tableau workbook file as shared in this link which has the .twb suffix.

  • By default, the Tableau workbook file as provided will connect to the example SQLite database file Chicago_1_monthly.sql as provided. The dashboard building loads which contains just a textbox, or any other dashboard/sheet openning during the previous save, will be shown.

  • Click the Data Source tab at the lower-left corner, on the Connections tab, click the triangle to the right of SQLite3 ODBC Driver (ODBC), select Edit Connection...

  • On the Other Databases (ODBC) panel, make sure that SQLite3 ODBC Driver is selected for Driver. Copy and past the full path and name of the SQLite database (the file with the .sql suffix in the EnergyPlus project folder) to be connected to in the Database: field, then click Sign In.

  • Past the name of the SQLite database, or any other name preferred, in the field to the right of the data source icon.

  • Click the Update Now button below, and the data retrieved from the tables that have been connected in the SQLite database will be shown.

  • Click the Show Sheet Sorter button at the lower-right corner.

  • The message window pop out reminds user the limitations of the ODBC driver in Tableau. Click OK to proceed.

  • Right-click any of the thumbnails and select Refresh Thumbnail to refresh its image.

  • Double-click any of the thumbnails to open a dashboard/sheet. The time that it might take to refresh each of the customized dashboards/sheets ranges from 1 to 5 minutes, depending on the size of the SQLite database and the hardware configuration of the computer.

  • In my own test, it took about 5 minutes to refresh some of the dashboards which read an SQLite database of 925MB generated from an hourly simulation for a building with 52 zones with 39 output variables as specified on the EP Output Honeybee component on a desktop computer (Xeon CPU @2.4GHz, 64GB RAM, Windows 10).
  • Monthly and annual simulation results shall be relatively faster to read.
  • Once the data querying is finished the selected dashboard or sheet will be shown.

  • The next section explains the contents of each of the customized dashboards.

results matching ""

    No results matching ""