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...
Met o.a. Alec Sharp, Nicola Askham, Winfried Etzel, Sjoukje Zaal, Victor de Graaff en Linda Terlouw. Enkele topics: Cloud Data Architecture, Testen van Data, Data Mesh & Federated Data Governance, Datamodelleren, DWH design met Gen-AI. 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...
