Here’s with a new simple tutorial for analysing a dataset.
In this case i’ve taken the Italian dataset of patients positive to COVID-19 aka Corona virus provided by the official Protezione civile GitHub repository:
The dataset is as simple as possible without useless columns (Many times i’ve seen raw…
What a good data engineer must do once on a while, is for sure to maintain a good overall performance of your ETL tools.
You need not only to check if your database is in good health like:
In this story i’m going to tell you why and when you need to write your own ETL flow to feed your data warehouse.
ETL is an acronym it stands for:
Extract the information from sources
Transform those information in any data type
Load into your data warehouse
You can change the order of…
Hi all, as a data scientist or looking for to be one of us, this kind of analysis could have a serious impact on your career because allows you to understand, first of all, the basis of statistics, how to model your statistic and how to predict behaviour.
I’ve worked with many kinds of data, from clinical data to logistic and supply chain data passing through pharmaceutical data.
Each of them is different and should be treated in different manners.
Let’s what we can learn with each of them.
This is the most difficult kind of data you…
This is that kind of article in which i try to explain some best practises (some acquired from my experience) to upgrade your database.
Today we are talking about: PERFORMANCES (Read/write).
Talking about database performance is a serious topic, because there are many ways to improve its overall performances.
Working all day with PostgreSQL for BigData analysis i always encounter many problems.
Sometimes those problems are really annoying, just like query slow performance.
Performance is a key aspect in Business intelligence
you always need a fresh and fast algorithm that allows you to retrieve many data in few seconds.
it’s been a while since my last post, many things have changed since then see it as an another life.
Well today i was thinking: “Is there any chance that OLAP cubes are dead?”
You’re certainly are saying: “What’s wrong with you? I’m using them obviously are not!” and i’m not…