Apparatus and method for filtering data from or across different analytics platforms
A system and method for combining data from disparate business intelligence systems and data sources. The method includes aggregating data in real-time across multiple, disparate data platforms of more than one third party, by mapping nonmatching data parameters used in the different platforms to a common data field. The business intelligence systems are queried to identify responsive data fields, which are then meshed in a translation and/or unification module into the common data field for display. The meshing of the data allows for efficient filtering according to user inputs. The system and method further include applications to allow users to create parameter mappings for the data meshing.
1. A method for aligning results with a data processor system, from disparate analytics sources, the method comprising:
receiving an analysis request from a user;
automatically executing a first analytics platform of a first entity for a first data visualization;
automatically executing a second analytics platform of a second entity for a second data visualization;
displaying the first data visualization adjacent the second data visualization in real-time in a user interface, wherein the first data visualization and the second data visualization have nonmatching parameters for corresponding analysis parameters;
automatically matching into a common parameter field a first nonmatching parameter of the first analytics platform and a corresponding second nonmatching parameter of the second analytics platform;
filtering the first and second visualizations in the user interface according to a user input received through the user interface, wherein the filtering comprises:
converting the user input into an application programming interface (API) connector for each of the first and second analytics platforms;
connecting a first API connector to the first analytics platform using the first nonmatching parameter of the common parameter field and requesting a rerendering of the first data visualization according to the first nonmatching parameter;
connecting a second API connector to the second analytics platform using the second nonmatching parameter of the common parameter field and requesting a rerendering of the second data visualization according to the second nonmatching parameter;
automatically receiving a rerendered first data visualization from the first analytics platform and a rerendered second data visualization from the second analytics platform; and
displaying the rerendered first data visualization adjacent the rerendered second data visualization in real-time in the user interface.
2. The method of claim 1 , wherein the user input is a time input, a location input, an entity input, or combinations thereof.
3. The method of claim 1 , wherein the first analytics platform is a first business intelligence visualization platform and the second analytics platform is a second business intelligence visualization platform.
4. The method of claim 1 , wherein each of the first and second data visualizations comprises a report, a table a chart, a graph, or a list.
5. The method of claim 4 , wherein each of the rerendered first and second data visualizations comprises the report, the table the chart, the graph, or the list, updated according to the user input.
6. The method of claim 1 , wherein the user interface comprises a first report window for the first data visualization and the rerendered first data visualization, and a second report window for the second data visualization and the rerendered second data visualization.
7. The method of claim 6 , wherein a user input in the first report window triggers the rerendering of both of the first and second data visualizations.
8. The method of claim 1 , wherein a user selection through the user interface for the first data visualizations triggers the rerendering of both of the first and second data visualizations from the first and second analytics platforms.