One thing that always and again gets my attention is date handling in ETL jobs, especially in Talend and when using file input. It seems to me that sometimes there is no clarity about the concept of date fields and formatting. This post tries to clear things up.
Posts in "Business Intelligence"
Why meta data is one of the single most important topics in Business Intelligence
Have you ever been working with an internal or external customer who said he just needs this simple Excel into a report? When investigating the process, you find out that there are many undiscovered steps in this process? And you told them that this implementation might take a few days which in turn didn’t make… Continue reading
Using the Eric 6 IDE for Python development – on Windows
It could have been so easy. I have been using Eclipse for a long time when I was still developing Java application. Now I wanted to setup an IDE for Python and to challenge me, I would try a different one – namely Eric. Oh boy, this was a bit more complicated. Took me actually… Continue reading
Accessing the Open Data Portal Hamburg with Python
In a few tutorials which I tried was a very specific dataset being used – the NYC 311 calls dataset. 311 calls in NYC are some sort of support calls to easen the caller rate on the emergency number 911. There are a lot of people calling this number over the time. The city of… Continue reading
MySQL for Data Vault 2.0 – End Dating Satellites and Performance Measurement
A while ago I wrote about using MySQL as a database for Data Vault 2.0. Now, after some time passed and the dataset grew, it is time for a new evaluation.
Is Data Warehousing Declining? Yes, But!
Technologies and definitions inside of the Business Intelligence trade are changing. Data Warehouses are traditionally the way to generate data for evaluations and reports. But is this changing – and how?
Why SQL Is a Horrible Language (When Analyzing It)
I like patterns. One of the first patterns I learned about was MVC, or Model-View-Controller. For those who don’t know, very roughly: it separates storage logic from presentation logic. When you use it, you have inevitably separate storage and business logic. SQL does all at once. Oh, boy.
5 Safe Ways How To Guaranteed Sabotage Your Business Intelligence Project
You thought it would be hard to go through a Business Intelligence project in an organization. Maybe it is easier than thought… when you change focus!
Why Talend ETL is not the same as Tableau
In the current past I see a lot of questions about Talend ETL and how to use it to map to dimensions and fact tables. Is that really feasible?
Data Vault 2.0 and MySQL – Is MySQL enough?
To implement Data Vault and its modelling technique, a database is required. Can MySQL cut it? What are important settings?
Is Data Modelling still important?
One question I read and talk a lot about is if it is neccessary at all to use a schema with data. So, is it important to model?
What is Business Intelligence?
Ever wondered what Business Intelligence is? Is it important for your company? Find out here.