-
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
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
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
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 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…
-
Picking the right visualisation
When choosing the correct data visualisation, it is important to consider the data you have, the stakeholders that will be consuming the data and the message the data needs to convey. General guidelines for choosing the right visualisation are: 1) Understanding the data: Before a visualisation can be chosen it is important to…
-
5 Benefits of dashboards
1. Data visualisation: Dashboards provide a way to visually represent data using charts, graphs, and tables making it easy to understand as well as identify patterns, trends, and anomalies at a quick glance. 2. Real-time monitoring: Dashboards often represent data in real-time or near-real time making monitoring those KPI metrics more…
-
The difference between dashboards and reports
When it comes to representing data analysis for stakeholder consumption, one of two routes are usually considered, dashboards or reports. How do analysts know which one to use and when. This article will cover the differences between the two. What is a dashboard? A dashboard typically displays real-time or near real-time data which provides a…
-
Simplest Database Solution to Implement
In today’s digital age, data lies at the heart of every successful business operation. Whether you’re managing customer information, tracking inventory, or analyzing sales trends, having a robust database solution is crucial. But with so many options available, ranging from complex enterprise systems to lightweight, user-friendly solutions, it can be challenging to determine which one…
-
Cleaning your Data (and 5 steps to ensure it stays that way)
Steps you can take to clean your data and maintain it 1. Governance: Establishing Clear Policies and Procedures Effective data governance is essential for maintaining clean and reliable data. By establishing clear policies and procedures, businesses can ensure consistency, accuracy, and compliance across their datasets. Key elements of data governance include: 2. Infrastructure: Creating a…
