STRUCTURED MODELING OF DATA IN A SPREADSHEET

摘要

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.