The BI industry has been evolving over the last five years to place more emphasis on self-service, end-user-driven analytical reporting. In response to market needs, many vendors have been broadening their portfolios to offer a wide range of tools th...
A data warehouse is a relational database just like any other relational database. However, the database model is designed in a different way. It should facilitate business users querying large amounts of data, but also let them explore the data from...
Imagine your client gives you an Excel file as the SSIS source for a new project. When you load the data you find that the data type is not aligning as expected and some of the rows are not filled with the data provided. You then try to change the in...
Data driven worden behelst meer dan de inzet van nieuwe tools en technologie. Het grijpt in op business modellen, processen en vooral datamanagement. Dit seminar door Nigel Turner schetst de praktische stappen die nodig zijn om een haalbare datastrategie en aanpak op te stellen. Praktisch seminar op 16 mei in Utrecht, schrijf nu in.
Situation For a proof of concept I was asked to make a connection from Excel powerquery to an IBM DB2 database. Since I didn’t have a server somewhere with DB2 installed on it, so I went searching for a solution. A thing to keep in mind is that...
There is a large variety in possible data sources from which we can extract and that number is not likely to decrease. The ETL path that has to be taken for each source can vary heavily depending on all kinds of factors including application architec...