Creating descriptors for business analytics applications
A computer-implemented method, system and computer program product for creating a descriptor for a dashboard template. The column-to-visualization mappings are extracted from a dashboard of a created or modified dashboard (or a created or modified dashboard template). Furthermore, the concept combinations from each visualization of the dashboard are extracted. Additionally, topics from the dashboard are extracted. The concept combinations, topics and column-to-visualization mappings are aggregated into a dashboard template descriptor. The dashboard template descriptor is then stored. In this manner, the dashboard template descriptor captures how concept combinations are used in the visualizations of the dashboard as well as how high-level concepts (topics) are incorporated in the dashboard. Furthermore, the dashboard template descriptor captures how the concepts of the columns of a dataset are mapped to the visualizations of the dashboard. As a result, the most appropriate dashboard/dashboard template may be selected to visualize the user's dataset.
1. A computer-implemented method for creating a descriptor for a dashboard template, the method comprising:
extracting column-to-visualization mappings from a dashboard;
extracting concept combinations from each visualization of said dashboard;
extracting a list of topics from said dashboard;
aggregating said concept combinations, said list of topics and said column-to-visualization mappings into a dashboard template descriptor; and
storing said dashboard template descriptor in a database.
2. The method as recited in claim 1 further comprising:
identifying concepts in columns of a dataset used in each visualization of said dashboard; and
collecting statistical attributes of said columns of said dataset used in each visualization of said dashboard.
3. The method as recited in claim 1 further comprising:
resolving columns used in each visualization of said dashboard to ontological concepts; and
grouping said ontological concepts into combinations based on their usage in visualizations of said dashboard.
4. The method as recited in claim 1 further comprising:
identifying concepts in columns of a dataset used in each visualization of said dashboard to form a list of concepts; and
converting said list of concepts to a distinct set of concepts.
5. The method as recited in claim 4 further comprising:
performing a lexical analysis on text in said dashboard to extract a second list of concepts and concept combinations.
6. The method as recited in claim 5 further comprising:
scoring concepts listed in said second list of concepts and in said distinct set of concepts based on one or more of the following: occurrence frequency of a concept in visualizations of said dashboard, usage of a concept in a visualization of said dashboard, results of said lexical analysis, context-based weighting and relationships between concepts across multiple visualizations.
7. The method as recited in claim 6 further comprising:
returning concepts with a score above a threshold value as corresponding to said list of topics extracted from said dashboard.
8. The method as recited in claim 1 further comprising:
storing said dashboard template descriptor alongside layout and visual metadata.
9. The method as recited in claim 1 further comprising:
extracting column-to-visualization mappings from said dashboard in response to receiving an indication of creating or modifying said dashboard or said dashboard template.
10. A computer program product for creating a descriptor for a dashboard template, the computer program product comprising one or more computer readable storage mediums having program code embodied therewith, the program code comprising the programming instructions for:
extracting column-to-visualization mappings from a dashboard;
extracting concept combinations from each visualization of said dashboard;
extracting a list of topics from said dashboard;
aggregating said concept combinations, said list of topics and said column-to-visualization mappings into a dashboard template descriptor; and
storing said dashboard template descriptor in a database.
11. The computer program product as recited in claim 10 , wherein the program code further comprises the programming instructions for:
identifying concepts in columns of a dataset used in each visualization of said dashboard; and
collecting statistical attributes of said columns of said dataset used in each visualization of said dashboard.
12. The computer program product as recited in claim 10 , wherein the program code further comprises the programming instructions for:
resolving columns used in each visualization of said dashboard to ontological concepts; and
grouping said ontological concepts into combinations based on their usage in visualizations of said dashboard.
13. The computer program product as recited in claim 10 , wherein the program code further comprises the programming instructions for:
identifying concepts in columns of a dataset used in each visualization of said dashboard to form a list of concepts; and
converting said list of concepts to a distinct set of concepts.
14. The computer program product as recited in claim 13 , wherein the program code further comprises the programming instructions for:
performing a lexical analysis on text in said dashboard to extract a second list of concepts and concept combinations.
15. The computer program product as recited in claim 14 , wherein the program code further comprises the programming instructions for:
scoring concepts listed in said second list of concepts and in said distinct set of concepts based on one or more of the following: occurrence frequency of a concept in visualizations of said dashboard, usage of a concept in a visualization of said dashboard, results of said lexical analysis, context-based weighting and relationships between concepts across multiple visualizations.
16. The computer program product as recited in claim 15 , wherein the program code further comprises the programming instructions for:
returning concepts with a score above a threshold value as corresponding to said list of topics extracted from said dashboard.
17. The computer program product as recited in claim 10 , wherein the program code further comprises the programming instructions for:
storing said dashboard template descriptor alongside layout and visual metadata.
18. A system, comprising:
a memory for storing a computer program for creating a descriptor for a dashboard template; and
a processor connected to said memory, wherein said processor is configured to execute the program instructions of the computer program comprising:
extracting column-to-visualization mappings from a dashboard;
extracting concept combinations from each visualization of said dashboard;
extracting a list of topics from said dashboard;
aggregating said concept combinations, said list of topics and said column-to-visualization mappings into a dashboard template descriptor; and
storing said dashboard template descriptor in a database.
19. The system as recited in claim 18 , wherein the program instructions of the computer program further comprise:
identifying concepts in columns of a dataset used in each visualization of said dashboard; and
collecting statistical attributes of said columns of said dataset used in each visualization of said dashboard.
20. The system as recited in claim 18 , wherein the program instructions of the computer program further comprise:
resolving columns used in each visualization of said dashboard to ontological concepts; and
grouping said ontological concepts into combinations based on their usage in visualizations of said dashboard.
21. The system as recited in claim 18 , wherein the program instructions of the computer program further comprise:
identifying concepts in columns of a dataset used in each visualization of said dashboard to form a list of concepts; and
converting said list of concepts to a distinct set of concepts.
22. The system as recited in claim 21 , wherein the program instructions of the computer program further comprise:
performing a lexical analysis on text in said dashboard to extract a second list of concepts and concept combinations.
23. The system as recited in claim 22 , wherein the program instructions of the computer program further comprise:
scoring concepts listed in said second list of concepts and in said distinct set of concepts based on one or more of the following: occurrence frequency of a concept in visualizations of said dashboard, usage of a concept in a visualization of said dashboard, results of said lexical analysis, context-based weighting and relationships between concepts across multiple visualizations.
24. The system as recited in claim 23 , wherein the program instructions of the computer program further comprise:
returning concepts with a score above a threshold value as corresponding to said list of topics extracted from said dashboard.
25. The system as recited in claim 18 , wherein the program instructions of the computer program further comprise:
storing said dashboard template descriptor alongside layout and visual metadata.