Published in: 20 Oct

Data

Data extraction from a web source with Python + Pandas

By Javier Andújar, in Data

For the following example we are going to use Python with Pandas in a Windows environment to do a daily load to a SQL Server database from a web source.

Read more
Published in: 02 Jul

Data

Understanding ETL

By Javier Andújar, in Data

The reason for having a staging area between the source system and the Data Warehouse database is, on one hand, to impair as little as possible the performance and response time of our data source.

Read more