Category: Case Studies

  • World map visualisation: Crude Oil Trade

    World map visualisation: Crude Oil Trade

    This interactive world map visualisation was built from the ground up in order to showcase the exports and imports of crude oil across the globe AND cos we were looking for a cooler way to show global networking. Getting the data: The data behind the visualisation was retrieved from oec.world. The ETL pipeline was written…

  • Understanding Air Quality

    Understanding Air Quality

    Enhancing Awareness and Insight through Innovative Dashboards – A Case Study Air quality stands at the forefront of global concerns, intertwined with the intricate web of climate change, public health, and environmental sustainability. At Appy Insights, we recognize the pivotal role of accessible data visualization in fostering understanding and action. That’s why we’ve developed dynamic…

  • Crime Stats SA

    Crime Stats SA

    The South African Police Service (SAPS) collates a crime statistics report once every quarter of the fiscal year. The report and data are stored in a downloadable excel file for the end user to view and investigate as shown in the image below. The data compares the past 5 quarters to each other grouped by…

  • Shedding Light on Energy

    Shedding Light on Energy

    In South Africa, energy production has long been a topic of concern, especially with the recurring issue of load shedding. Faced with this challenge, we embarked on a journey to better understand and visualise energy dynamics, leading to the creation of a comprehensive data dashboard. This article delves into the genesis of our Power Compare…

  • Eskom Se Push

    Eskom Se Push

    Eskom se Push stores and updates a Google Sheet with the national load shedding level and timestamp. This dataset has only 2 columns namely “created_at” and “stage”. We used this data to create a dashboard visualising the historical load shedding for the country. The goal was to extract as much value out of a simple…