Data profiling in Python

date_range 27/10/2018

Featured image

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

Featured image

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

Featured image

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

Featured image

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.

Install Your Own Wiki with Mediawiki on RHEL/CentOS 7

date_range 09/10/2018

Featured image

It does not matter whether you are employed in a real estate company or a restaurant. Every company needs a wiki. A wiki is a tool for managing knowledge. And as a manager you will want to perpetuate and promote the rapid transmission of knowledge among collaborators, so you will need an operational manual aka wiki. A wiki is critical for competitive business but it is also incredibly useful for an individual to manage and organize knowledge.

In short, whether you are a company or an individual wishing to manage a knowledge a wiki is the tool you have to have.

Here, we'll see how to install MediaWiki on RHEL/CentOS 7 supported by PostgreSQL and Apache that makes it working like a charm.

Install MetaTrader 5 64-bit on RHEL/CentOS 7

date_range 19/09/2018

Featured image

MetaTrader 5 is a free application for traders allowing to perform technical analysis and trading operations in the Forex and exchange markets. A reason why you would choose MetaTrader 5 over MetaTrader 4 is that the new MQL5 compiler has been optimized for the 64-bit version.

MetaTrader can be installed and run on computers with Linux using Wine. Wine is a free software that allows users of the Unix-based systems to run an application developed for the Microsoft Windows systems. Even if the documentation explains how to install it on Ubuntu, doing so can be a bit tricky. So, let's see how to have MeatTrader 5 64-bit operational on RHEL/CentOS 7.