Abstract: A system for automatically detecting relationships in spreadsheet data is disclosed. The system may be configured to analyze data items in the spreadsheet to determine whether two or more data items are unrelated. If the two or more data items are unrelated, then the system may notify a user of a need to define the relationship, and automatically defines the relationship for the two or more data items, or suggests the relationship to the user.

Abstract: A system for automatically detecting relationships in spreadsheet data is disclosed. The system may be configured to analyze data items in the spreadsheet to determine whether two or more data items are unrelated. If the two or more data items are unrelated, then the system may notify a user of a need to define the relationship, and automatically defines the relationship for the two or more data items, or suggests the relationship to the user.

Abstract: A system and method for creating a report in a spreadsheet is disclosed. The system and method identifies a source of data items associated with the spreadsheet. The data items that are associated with the report that is generated in the spreadsheet are identified. A display including a field pane with an active tab and an all tab. The active tab displaying those data items that are determined to be associated with the report that is being generated in the spreadsheet. The all tab displaying all of the data items associated with the spreadsheet.

Abstract: A system for automatically detecting relationships in spreadsheet data is disclosed. The system may be configured to analyze data items in the spreadsheet to determine whether two or more data items are unrelated. If the two or more data items are unrelated, then the system may notify a user of a need to define the relationship, and automatically defines the relationship for the two or more data items, or suggests the relationship to the user.

Abstract: Technologies are described herein for generating field sets of a data summary table. Multiple fields in a spreadsheet document are identified. Multiple field scores for each field of the plurality of fields are determined. A field set incorporating two or more of the plurality of fields is generated based on the plurality of field scores. The field set is inserted into the data summary table, thereby transforming the data summary table without the field set to the data summary table with the field set.

Abstract: Technologies are described herein for generating field sets of a data summary table. Multiple fields in a spreadsheet document are identified. Multiple field scores for each field of the plurality of fields are determined. A field set incorporating two or more of the plurality of fields is generated based on the plurality of field scores. The field set is inserted into the data summary table, thereby transforming the data summary table without the field set to the data summary table with the field set.

Abstract: Data displayed on a spreadsheet and data from one or more data sources are used to create a model within the spreadsheet. The data may be obtained from many types of data sources, such as: relational databases, multidimensional sources, cloud services, data feeds, spreadsheet files, text files, data from the Web, and the like. A modeling engine of the spreadsheet application creates the model that structures the data, relates different pieces of data, and provides context for the data. The model that may be stored within the spreadsheet includes the raw data and metadata that describes the data and provides the context for the data. The model may be automatically updated based on performed operations of the spreadsheet. The model may be examined using a query language (e.g. MDX, DAX, SQL, Spreadsheet Functions and Formulas, . . . ) to examine the data and the relationships obtained from the spreadsheet and data sources.

Abstract: A system for creating a report in a spreadsheet includes a data source module programmed to identify sources of data items associated with the spreadsheet, an active module programmed to identify which of the data items are associated with the report that is generated in the spreadsheet, and a display module programmed to display on a field pane with an active tab and an all tab, the active tab displaying those data items that are determined to be associated with the report that is being generated in the spreadsheet, and the all tab displaying all of the data items associated with the spreadsheet.

Abstract: A system for creating a report in a spreadsheet includes: a central processing unit; and a memory encoding instructions that, when executed by the central processing unit, cause the central processing unit to create: a data source module programmed to identify tables associated with the spreadsheet; a relationship module programmed to analyze the tables and identify relationships between the items; and a display module programmed to display the relationships between the tables.

Abstract: A user interface is programmed to create a scorecard. The interface includes a scorecard module including a column area and a row area, and a key performance indicator area including a plurality of key performance indicators. A key performance indicator from the key performance indicator area can be dragged and dropped onto one of the column area and the row area to add indicia associated with the key performance indicator to the scorecard.

Abstract: A user interface programmed to create a digital dashboard includes a dashboard workspace including one or more zones, and a dashboard elements area including a plurality of dashboard elements. A dashboard element of the dashboard elements is dragged and dropped onto one of the zones to add the dashboard element to the digital dashboard.

Abstract: A user interface programmed to create a digital dashboard includes a dashboard workspace including one or more zones, and a dashboard elements area including a plurality of dashboard elements. A dashboard element of the dashboard elements is dragged and dropped onto one of the zones to add the dashboard element to the digital dashboard.

Abstract: A user interface is programmed to create a scorecard. The interface includes a scorecard module including a column area and a row area, and a key performance indicator area including a plurality of key performance indicators. A key performance indicator from the key performance indicator area can be dragged and dropped onto one of the column area and the row area to add indicia associated with the key performance indicator to the scorecard.

Abstract: A user interface programmed to create a digital dashboard includes a dashboard workspace including one or more zones, and a dashboard elements area including a plurality of dashboard elements. A dashboard element of the dashboard elements is dragged and dropped onto one of the zones to add the dashboard element to the digtal dashboard.