Explore NYC Open Data and your ETL output with open source BI solutions.
Apache Superset™ is an open-source modern data exploration and visualization platform.
Official documentation: https://superset.apache.org/docs/intro.
Source code: https://github.com/apache/superset.
Start the rails app.
docker-compose up web
Follow Apache Superset's instructions for downloading and starting superset locally:
https://superset.apache.org/docs/quickstart/
Sign into superset:
username: admin
password: admin
Click Settings -> Databases Connections -> + Database.
Select PostgreSQL.
Run the following command to find the host:
ip addr show | grep docker0
Enter the following values for the remaining fields:
| Port | Database name | Username | Password | Display Name |
|---|---|---|---|---|
| 5432 | nyc_open_data_development | postgres | password | <can be anything> |
Click connect.
You should now be able to query and build charts on top of your copy of NYC Open Data.
Click Settings -> Databases Connections -> + Database.
Select PostgreSQL
Run the following command to find the host:
ip addr show | grep docker0
Enter the following values for the remaining fields:
| Port | Database name | Username | Password | Display Name |
|---|---|---|---|---|
| 5432 | nyc_open_data_analytics_development | postgres | password | <can be anything> |
Click connect.
You should now be able to query and build charts on top of your ETL output.
Preset delivers open-source Apache Superset™ with a scalable, enterprise-grade hosted solution, extending it with key features and offering a broad platform that allows you to deliver modern Business Intelligence, embedded analytics, and tailored data experiences.
Website: https://preset.io/