Data Islands for Data Reconciliation

Imagine access to data offering valuable insights into public data, if there is open access, this would enabling companies to amass a diverse range of data on subjects spanning economy, health, or energy usage.

To optimize the efficacy of this data and transcend mere consumption, especially for in-depth analysis, utilizing Data Islands becomes essential. Traditionally, the process involves preparing a table for data import, followed by running a manual import wizard. However, with data islands, this workflow is streamlined. The import step can be executed, automatically generating a table, and the entire process can be automated to run at predetermined intervals.

Data reconciliation within Data Islands allows cross-matching based on columns in different tables. This is achieved by identifying a field in each table that serves as an exact match, such as a company or product name. Additionally, partial matches are feasible, as well as comparisons based on dates. For instance, you might want to correlate products sold in August with August’s Covid incidences, exploring potential connections. The versatility of Data Islands opens avenues for nuanced and insightful analyses.