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...
Deze workshop met Panos Alexopoulos behandelt de implementatie van Knowledge Graphs en Large Language Models en biedt een uitgebreid raamwerk waarin geavanceerde technieken worden gecombineerd met praktijkcases en oefeningen. Praktische workshop op 20 en 21 mei in Utrecht - schrijf snel 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...