Dynamic dashboard with guided discovery
Embodiments include methods and systems for configuring a dashboard with a plurality of components. Data sets populated by a plurality of data attributes and associated data attribute values can be received, where the dashboard is configured to display data from the data sets. A plurality of components can be provided on the dashboard including a guided discovery component that displays suggested filters for the dashboard according to one or more of the received data sets. A selection of a filter for the dashboard can be received at one of the components and the components can be dynamically filtered based on the received filter. The suggested filters displayed by the guided discovery component can also be dynamically adjusted based on the received filter, where one or more suggested filters are dynamically hidden and one or more suggested filters are dynamically displayed based on the received filter.
1. A method for configuring a dashboard with a plurality of components, the method comprising:
storing dashboard data at a database;
ingesting, based on data load rules, a plurality of data sets populated by a plurality of data attributes and associated data attribute values, and updating the database using the ingested data sets, wherein,
a data load rule for a first ingested data set comprises an incremental load and a data load rule for a second ingested data set comprises a full load,
ingesting the first data set using the incremental load comprises updating data stored in the database for the first data set with new data from the first data set being ingested, and
ingesting the second data set using the full load comprises overwriting data stored in the database for the second data set with data from the second data set being ingested;
providing a plurality of components on a dashboard, wherein at least a first component displays data from the first ingested data set and a second component displays data from the second ingested data set;
receiving, at one of the components, a selection of at least one filter for the dashboard, wherein the selected filter corresponds to a given data attribute or data attribute value from the first ingested data set; and
dynamically filtering the first component and the second component using the selected filter, wherein the second component is filtered based on one or more data association rules between the first ingested data set and the second ingested data set.
2. The method of claim 1 , wherein dynamically filtering the first component and the second component using the selected filter comprises:
dynamically filtering data from the first ingested data set displayed in the first component using the given data attribute or data attribute value from the first ingested data set; and
dynamically filtering data from the second ingested data set displayed in the second component using the given data attribute or data attribute value from the second ingested data set.
3. The method of claim 1 , wherein the data attributes of the first ingested data set and the second ingested data set comprise a numerical attribute type or a categorical attribute type.
4. The method of claim 1 , wherein at least one of the first component or the second component comprises a graph or chart component that is dynamically filtered according to the selected filter.
5. The method of claim 4 , wherein the selected filters comprise a selection of a portion of the graph or chart component that corresponds to the given data attribute or data attribute value from the first ingested data set and the graph or chart component is filtered according to the selection.
6. The method of claim 1 , wherein data displayed by the first component is retrieved from the first ingested data set using one or more SQL commands defined for the first component, and data displayed by the second component is retrieved from the second ingested data set using one or more SQL commands defined for the second component.
7. The method of claim 1 , wherein the plurality of provided components on the dashboard comprise a guided discovery component that displays suggested filters for the dashboard based on data attributes of the first and second ingested data sets.
8. The method of claim 7 , further comprising:
generating, after ingesting the first and second data sets, a dynamic attribute derived from one or more attributes of the first ingested data set and the second ingested data set, wherein the guided discovery component displays the derived dynamic attribute as a suggested filter.
9. A non-transitory computer readable medium having instructions stored thereon that, when executed by a processor, cause the processor to configure a dashboard with a plurality of components, the configuring comprising:
storing dashboard data at a database;
ingesting, based on data load rules, a plurality of data sets populated by a plurality of data attributes and associated data attribute values, and updating the database using the ingested data sets, wherein a data load rule for a first ingested data set comprises an incremental load and a data load rule for a second ingested data set comprises a full load;
providing a plurality of components on a dashboard, wherein at least a first component displays data from the first ingested data set and a second component displays data from the second ingested data set;
receiving, at one of the components, a selection of at least one filter for the dashboard, wherein the selected filter corresponds to a given data attribute or data attribute value from the first ingested data set; and
dynamically filtering the first component and the second component using the selected filter by:
dynamically filtering data from the first ingested data set displayed in the first component using the given data attribute or data attribute value, and
dynamically filtering data from the second ingested data set displayed in the second component using one or more data association rules between the first ingested data set and the second ingested data set, and the given data attribute or data attribute value.
10. The non-transitory computer readable medium of claim 9 , wherein, ingesting the first data set using the incremental load comprises updating data stored in the database for the first data set with new data from the first data set being ingested, and
ingesting the second data set using the full load comprises overwriting data stored in the database for the second data set with data from the second data set being ingested.
11. The non-transitory computer readable medium of claim 9 , wherein the data attributes of the first ingested data set and the second ingested data set comprise a numerical attribute type or a categorical attribute type.
12. The non-transitory computer readable medium of claim 9 , wherein at least one of the first component or the second component comprises a graph or chart component that is dynamically filtered according to the selected filter.
13. The non-transitory computer readable medium of claim 12 , wherein the selected filters comprise a selection of a portion of the graph or chart component that corresponds to the given data attribute or data attribute value from the first ingested data set and the graph or chart component is filtered according to the selection.
14. The non-transitory computer readable medium of claim 9 , wherein data displayed by the first component is retrieved from the first ingested data set using one or more SQL commands defined for the first component, and data displayed by the second component is retrieved from the second ingested data set using one or more SQL commands defined for the second component.
15. The non-transitory computer readable medium of claim 9 , wherein the plurality of provided components on the dashboard comprise a guided discovery component that displays suggested filters for the dashboard based on data attributes of the first and second ingested data sets.
16. The non-transitory computer readable medium of claim 15 , further comprising:
generating, after ingesting the first and second data sets, a dynamic attribute derived from one or more attributes of the first ingested data set and the second ingested data set, wherein the guided discovery component displays the derived dynamic attribute as a suggested filter.
17. A system for configuring a dashboard with a plurality of components, the system comprising:
a memory; and
a processor, coupled to the memory, configured to:
store dashboard data at a database;
ingest, based on data load rules, a plurality of data sets populated by a plurality of data attributes and associated data attribute values, and updating the database using the ingested data sets, wherein,
a data load rule for a first ingested data set comprises an incremental load and a data load rule for a second ingested data set comprises a full load,
ingesting the first data set using the incremental load comprises updating data stored in the database for the first data set with new data from the first data set being ingested, and
ingesting the second data set using the full load comprises overwriting data stored in the database for the second data set with data from the second data set being ingested;
provide a plurality of components on a dashboard, wherein at least a first component displays data from the first ingested data set and a second component displays data from the second ingested data set;
receive, at one of the components, a selection of at least one filter for the dashboard, wherein the selected filter corresponds to a given data attribute or data attribute value from the first ingested data set; and
dynamically filter the first component and the second component using the selected filter, wherein the second component is filtered based on one or more data association rules between the first ingested data set and the second ingested data set.
18. The method of claim 17 , wherein the data attributes of the first ingested data set and the second ingested data set comprise a numerical attribute type or a categorical attribute type.
19. The method of claim 17 , wherein the plurality of provided components on the dashboard comprise a guided discovery component that displays suggested filters for the dashboard based on data attributes of the first and second ingested data sets.
20. The method of claim 19 , wherein the processor is further configured to:
generate, after ingesting the first and second data sets, a dynamic attribute derived from one or more attributes of the first ingested data set and the second ingested data set, wherein the guided discovery component displays the derived dynamic attribute as a suggested filter.