Install Last PgAdmin 4 on RHEL/CentOS 7

date_range 19/03/2019

PgAdmin 4 is a rewrite of the popular pgAdmin3 management tool for the PostgreSQL ( database. Installing the last version under CentOS 7 can be a bit tricky, here it is one way how to do it.

Set Up an OSRM Server on Ubuntu 16

date_range 08/12/2018

The Open Source Routing Machine or OSRM is a C++ implementation of a high-performance routing engine for shortest paths in road networks. Licensed under the permissive 2-clause BSD license, OSRM is a free network service hosting the following services: nearest, route, table, match, trip, tile.

We will see in this post how to deploy your own OSRM service in case you want to use it on your own data or just to not be limited by the number requests with responses like: {'message': 'Too Many Requests'}.

Data profiling in Python

date_range 27/10/2018

Data profiling is intended to help understand data leading to a better data prepping and data quality.

Data profiling is the systematic up front analysis of the content of a data source, all the way from counting the bytes and checking cardinalities up to the most thoughtful diagnosis of whether the data can meet the high level goals of the data warehouse. Ralph Kimball

Install Python on Windows and Deal with Corporate Network Constraints

date_range 26/10/2018

Using Python in a Microsoft corporate environment can rise various issues. This article introduce 3 different options hoping that one of them will fit to your situation.

Build Vector Tiles and Customize Their Rendering in the Web Browser

date_range 20/10/2018

Mapbox GL JS is a web mapping library based on WebGL.

Using Mapbox GL JS for serving tilesets is an interesting option especially if rendering a map on the fly in the client web browser is what you are looking for. This ability allows you to render efficiently data-driven map.

Power BI Good Practices

date_range 15/10/2018

Power BI is a great tool for making reports from a wide variety of data sources accessible to as many people as possible.
By applying a few principles during report design, report response times can be significantly increased and their subsequent maintenance easier.

Although knowledge of SQL is not necessary for the use of Power BI, the learning of minimal knowledge of this language should nevertheless be seriously considered to fully benefit from the capabilities of Power BI.