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...
Datamodelleren in de praktijk vanuit een non-technisch perspectief. Contextuele, conceptuele en gedetailleerde modelleertechnieken waarbij maximale betrokkenheid van de gebruiker centraal staat. Alec Sharp staat garant voor een interactieve cursus datamodelleren op 3 t/m 5 november 2025 in Utrecht.
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...
