Data integration hub

A computer-implemented method for integrating data from a plurality of sources into a centralized database including fact tables with data related to observable events and dimensional tables with attributes for the data contained in the fact tables, the method comprising the following steps performed by at least one processor:

• receiving an external dataset from an external data source, the external data source storing data according to an external database schema;
• translating the external dataset into a first importable format compatible with the centralized database, wherein the external dataset is translated using one or more scripts that parse the external dataset, extracting data from the parsed dataset, and generating one or more insert statements to add the extracted data to the centralized database;
• importing the extracted data into the centralized database using the one or more insert statements;
• receiving online platform data from an online platform comprising a server associated with a website that sends the online platform data for storage in the centralized database;
• translating the online platform data into a second importable format compatible with the centralized database;
• and
• importing the translated online platform data into the centralized database;
• wherein the dimensional tables provide data identifying a context surrounding each observable event, the context including information relating to at least two of the following types:
• who is in the observable event, what is the observable event, where the observable event occurs, when the observable event occurs, why the observable event occurs, and how the observable event occurs;
• wherein the plurality of dimensional tables contain grains that represent processes associated with the observable events, each grain being determined before receiving the external data set or the online platform data, each grain being mapped to separate fact tables of the plurality of fact tables;
• wherein the at least one processor generates a client profile or a client list based on the data in the fact tables related to observable events and the data in the dimensional tables that identify a context for each observable event;
• and
• wherein the at least one processor performs a query of inventory availability and generates, in real time and based on a result of the query, a message that is transmitted through at least one communication channel, wherein at least one of the query or the message is based on data in the client profile or client list.