Skip to content

[SQL, Django & Heroku] Deployed a Heroku app that visualizes Maritime Energy Efficiency statistics.

Notifications You must be signed in to change notification settings

salimwid/Visualizing_Maritime_Energy_Efficiency_Statistics

Repository files navigation

Visualizing_Maritime_Energy_Efficiency_Statistics

Deployment on Heroku can be found here .

App Deployed

Django application on Heroku

Techniques Employed

Advanced SQL queries (e.g: Roll-Up, Partition, Rank, Percentile), Star Schema, Dimension Table, Dynamic Website Design

Context

International Maritime Organisation oversees the regulation of the energy efficiency of different ships in order to avoid overpollution. By collecting ship, verifier and date data, interesting insights and visualization can be done.

Among others, the following use cases were explored:
(i) Fuel consumption of each ship type and engine vs its performance or features
(ii) Most polluting Maritime Verifiers
(iii) Reported efficiency of ships built in different years

We examined the best way to present the data inside a Star Schema & Dimension Table (see report).

Collaborators

Rachel Sng (@rachelsng)
Widya Salim (@salimwid)
Gino Martelli Tiu (@ginosytiu)
Susan Koruthu (@skoruthu)

About

[SQL, Django & Heroku] Deployed a Heroku app that visualizes Maritime Energy Efficiency statistics.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published