This blog post explains a short analysis I did about the global temperature trends and temperature changes in Stockholm. My goal was to create a simple visualization and draw insights on the similarities between global temperature trends and Stockholm’s temperature trends. I followed the following steps: Wrote an SQL query…

Recently, I decided to do a project and build a proof of concept out of it. I sketched a draft of what processes to follow to achieve this and below are the steps I followed; Decide on a topic Decide on the data source and how to get the data …

Recently, I created a visualization in tableau that uses a bar chart to represent multiple information across several fields. The bar chart was supposed to work in such a way that selecting a field changes information on the bar chart and updates the bar labels to show the correct data. …

This article explains the difference between the where and Having clause in PostgreSQL . While they both have similar function, they both serve different purposes. Where clause A where clause allows us to filter rows based on specific conditions. The filtering occurs before any groupings are made. The conditions in the Where…

I recently stumbled on the Fetch clause in PostgreSQL which is functionally the same as the Limit clause, and this short article tries to explain these two clauses and make a distinction between them. Limit Clause This SQL clause is used when you want to limit the number of rows returned by…

An Entity Relationship Diagram(ERD) is a database blueprint that shows us collection of entities and their relationships. It can also be called an Entity Relationship Model or a Data Model. It is made up of entities, attributes and the relationships between the entities. Entities: An entity is a business object…

A join in SQL is used to combine columns from one or more tables. It can be used to access information from multiple tables that have overlapping datasets or just merge information from two tables. To join two tables we need a column of intersection and this is done by…

Recently, I stumbled on MakeOverMonday and their weekly challenge that centers around creating visualizations of datasets which cuts across several topics. I joined the challenge on the 34th week and the dataset this time was about access to contraceptives by women in the Lower-Middle income countries(LMICs). It was titled Sexual…