US20140043325A1 - Facetted browsing - Google Patents
Facetted browsing Download PDFInfo
- Publication number
- US20140043325A1 US20140043325A1 US13/906,343 US201313906343A US2014043325A1 US 20140043325 A1 US20140043325 A1 US 20140043325A1 US 201313906343 A US201313906343 A US 201313906343A US 2014043325 A1 US2014043325 A1 US 2014043325A1
- Authority
- US
- United States
- Prior art keywords
- visualization
- data
- computer
- overlay
- geospatial
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Abandoned
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
- G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
- G06F3/048—Interaction techniques based on graphical user interfaces [GUI]
- G06F3/0487—Interaction techniques based on graphical user interfaces [GUI] using specific features provided by the input device, e.g. functions controlled by the rotation of a mouse with dual sensing arrangements, or of the nature of the input device, e.g. tap gestures based on pressure sensed by a digitiser
- G06F3/0488—Interaction techniques based on graphical user interfaces [GUI] using specific features provided by the input device, e.g. functions controlled by the rotation of a mouse with dual sensing arrangements, or of the nature of the input device, e.g. tap gestures based on pressure sensed by a digitiser using a touch-screen or digitiser, e.g. input of commands through traced gestures
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06T—IMAGE DATA PROCESSING OR GENERATION, IN GENERAL
- G06T15/00—3D [Three Dimensional] image rendering
- G06T15/10—Geometric effects
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2477—Temporal data queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/26—Visual data mining; Browsing structured data
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/29—Geographical information databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/40—Information retrieval; Database structures therefor; File system structures therefor of multimedia data, e.g. slideshows comprising image and additional audio data
- G06F16/43—Querying
- G06F16/438—Presentation of query results
- G06F16/4387—Presentation of query results by the use of playlists
- G06F16/4393—Multimedia presentations, e.g. slide shows, multimedia albums
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/40—Information retrieval; Database structures therefor; File system structures therefor of multimedia data, e.g. slideshows comprising image and additional audio data
- G06F16/44—Browsing; Visualisation therefor
- G06F16/444—Spatial browsing, e.g. 2D maps, 3D or virtual spaces
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/50—Information retrieval; Database structures therefor; File system structures therefor of still image data
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/903—Querying
- G06F16/9038—Presentation of query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/95—Retrieval from the web
- G06F16/953—Querying, e.g. by the use of web search engines
- G06F16/9537—Spatial or temporal dependent retrieval, e.g. spatiotemporal queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
- G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
- G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
- G06F3/048—Interaction techniques based on graphical user interfaces [GUI]
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
- G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
- G06F3/048—Interaction techniques based on graphical user interfaces [GUI]
- G06F3/0481—Interaction techniques based on graphical user interfaces [GUI] based on specific properties of the displayed interaction object or a metaphor-based environment, e.g. interaction with desktop elements like windows or icons, or assisted by a cursor's changing behaviour or appearance
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
- G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
- G06F3/048—Interaction techniques based on graphical user interfaces [GUI]
- G06F3/0481—Interaction techniques based on graphical user interfaces [GUI] based on specific properties of the displayed interaction object or a metaphor-based environment, e.g. interaction with desktop elements like windows or icons, or assisted by a cursor's changing behaviour or appearance
- G06F3/04815—Interaction with a metaphor-based environment or interaction object displayed as three-dimensional, e.g. changing the user viewpoint with respect to the environment or object
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
- G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
- G06F3/048—Interaction techniques based on graphical user interfaces [GUI]
- G06F3/0481—Interaction techniques based on graphical user interfaces [GUI] based on specific properties of the displayed interaction object or a metaphor-based environment, e.g. interaction with desktop elements like windows or icons, or assisted by a cursor's changing behaviour or appearance
- G06F3/0482—Interaction with lists of selectable items, e.g. menus
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
- G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
- G06F3/048—Interaction techniques based on graphical user interfaces [GUI]
- G06F3/0484—Interaction techniques based on graphical user interfaces [GUI] for the control of specific functions or operations, e.g. selecting or manipulating an object, an image or a displayed text element, setting a parameter value or selecting a range
- G06F3/04842—Selection of displayed objects or displayed text elements
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
- G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
- G06F3/048—Interaction techniques based on graphical user interfaces [GUI]
- G06F3/0484—Interaction techniques based on graphical user interfaces [GUI] for the control of specific functions or operations, e.g. selecting or manipulating an object, an image or a displayed text element, setting a parameter value or selecting a range
- G06F3/04847—Interaction techniques to control parameter settings, e.g. interaction with sliders or dials
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/169—Annotation, e.g. comment data or footnotes
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06T—IMAGE DATA PROCESSING OR GENERATION, IN GENERAL
- G06T11/00—2D [Two Dimensional] image generation
- G06T11/20—Drawing from basic elements, e.g. lines or circles
- G06T11/206—Drawing of charts or graphs
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06T—IMAGE DATA PROCESSING OR GENERATION, IN GENERAL
- G06T13/00—Animation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06T—IMAGE DATA PROCESSING OR GENERATION, IN GENERAL
- G06T15/00—3D [Three Dimensional] image rendering
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06T—IMAGE DATA PROCESSING OR GENERATION, IN GENERAL
- G06T19/00—Manipulating 3D models or images for computer graphics
Definitions
- a spreadsheet application, reporting application, or other data presentation application may support presentation of data in two-dimensional and/or three-dimensional pie charts, graphs, bar charts, or the like.
- users can chart or graph some data to gain insight into the data, relationships among data points, trends, or the like.
- Some data may include various data components that are not readily susceptible to graphing and therefore may not be appreciated and/or viewable by users.
- some data may include a geographical component.
- Charts and graphs in spreadsheet applications may present geographical information, but typically the display of this information is limited to a color code or data label.
- the color code or data label can specify, for example, a ZIP code, city name, country, or the like associated with the data points charted or graphed in the spreadsheet application.
- a computer system can execute a visualization component.
- the visualization component can be included in a spreadsheet application and/or can be configured to present visualizations of spreadsheet data.
- the visualizations can include geospatial visualizations and overlay visualizations.
- a “geospatial visualization” can include an animation scene or tour of multiple scenes that represent spreadsheet data on a globe, map, or other three-dimensional representation of location.
- an “overlay visualization” can be linked to a geospatial visualization so as to enable a user to perform various actions to interact with spreadsheet data in a two-dimensional space and to see results of the interaction reflected in a three-dimensional space provided by the geospatial visualization.
- An overlay visualization can include a chart such as, but not limited to, a column chart, line chart, pie chart, bar chart, area chart, scatter plot, stock chart, surface chart, doughnut chart, bubble chart, radar chart, histogram, any variation thereof, any combination thereof, and/or the like.
- An overlay visualization can alternatively or additionally include one or more graphical user interface (“GUI”) elements such as buttons tabs, scroll bars, icons, menus, combinations thereof, and/or the like.
- GUI graphical user interface
- An overlay visualization may overlay a geospatial visualization. Alternatively, an overlay visualization may be positioned above, below, or adjacent to a geospatial visualization.
- the computer system can obtain data.
- the data can include spreadsheet data.
- the data can include data values and geographic location information.
- the data also includes temporal information.
- the computer system can access one or more geocoding services to obtain geographic mapping data.
- the computer system can use the geographic mapping data to map the geographic location information included in the data to geographic coordinates and/or other geocoded information.
- the computer system also can obtain map data, for example, from a map server.
- the map data can include map images that are joined together by the computer system and visually wrapped onto a virtual globe to provide the geospatial visualization.
- the computer system can obtain data that includes data values and geographic location information.
- the computer system also can generate a geospatial visualization of the data based, at least partially, upon the data values and the geographic location information.
- the computer system also can generate an overlay visualization of the data based, at least partially, upon the data values.
- the computer system can also output the geospatial visualization and the overlay visualization.
- the computer system can obtain spreadsheet data that includes data values and geographic location information.
- the computer system also can generate a geospatial visualization of the spreadsheet data based, at least partially, upon the data values and the geographic location information.
- the geospatial visualization can include a three-dimensional visualization that represents a plurality of data points associated with the spreadsheet data in three-dimensional space.
- the computer system also can output the geospatial visualization.
- the computer system also can generate an overlay visualization of the spreadsheet data based, at least partially, upon the data values.
- the overlay visualization can include a two-dimensional visualization that represents the plurality of data points associated with the spreadsheet data in two-dimensional space.
- the computer system also can output the overlay visualization. In some embodiments, the computer system outputs the overlay visualization so that the overlay visualization overlays at least a portion of the geospatial visualization.
- the computer system can obtain spreadsheet data that includes data values, temporal information, and geographic location information.
- the computer system also can generate a geospatial visualization of the spreadsheet data based, at least partially, upon the data values, the temporal information, and the geographic location information.
- the geospatial information can include a three-dimensional visualization that represents a plurality of data points associated with the spreadsheet data in three-dimensional space.
- the computer system also can output the geospatial visualization to a user computing device that is in communication with the computer system.
- the computer system also can generate an overlay visualization of the spreadsheet data based, at least partially, upon the data values and the temporal information.
- the overlay visualization can include a two-dimensional chart that represents the plurality of data points associated with the spreadsheet data in two-dimensional space.
- the computer system also can output the overlay visualization to the user computing device such that the overlay visualization at least partially overlays the geospatial visualization.
- the computer system also can receive an input to select a portion of the spreadsheet data via the two-dimensional chart included in the overlay visualization. In response to the input, the computer system can select the portion of the spreadsheet data in the two-dimensional chart and a corresponding portion of the spreadsheet data in the three-dimensional visualization.
- the computer system also can receive an input to select a portion of the spreadsheet data via the three-dimensional visualization included in the geospatial visualization. In response to the input, the computer system can select the portion of the spreadsheet data in the three-dimensional visualization and a corresponding portion of the spreadsheet data in the two-dimensional chart.
- FIG. 1 is a system diagram illustrating an illustrative operating environment for the various embodiments disclosed herein.
- FIG. 2 is a block diagram showing aspects of a visualization component, according an illustrative embodiment.
- FIG. 3 is a flow diagram showing aspects of a method for facetted browsing, according to an illustrative embodiment.
- FIG. 4 is a flow diagram showing aspects of a method for filtering data via an overlay visualization that is linked to a geospatial visualization, according to an illustrative embodiment.
- FIG. 5 is a flow diagram showings aspects of a method for filtering data via a geospatial visualization that is linked to an overlay visualization.
- FIGS. 6A-6C are user interface diagrams showing aspects of user interfaces for facetted browsing, according to various illustrative embodiments.
- FIG. 7 is a computer architecture diagram illustrating an illustrative computer hardware and software architecture for a computing system capable of implementing aspects of the embodiments presented herein.
- FIG. 8 is a diagram illustrating a distributed computing environment capable of implementing aspects of the embodiments presented herein.
- FIG. 9 is a computer architecture diagram illustrating a computing device architecture capable of implementing aspects of the embodiments presented herein.
- a computer system can execute a visualization component.
- the visualization component can be included in a spreadsheet application and/or can be configured to present visualizations of spreadsheet data.
- the visualizations can include geospatial visualizations and overlay visualizations.
- a “geospatial visualization” can include an animation scene or tour of multiple scenes that represent spreadsheet data on a globe, map, or other three-dimensional representation of location.
- an “overlay visualization” can be linked to a geospatial visualization so as to enable a user to perform various actions to interact with spreadsheet data in a two-dimensional space and to see results of the interaction reflected in a three-dimensional space provided by the geospatial visualization.
- An overlay visualization can include a chart such as, but not limited to, a column chart, line chart, pie chart, bar chart, area chart, scatter plot, stock chart, surface chart, doughnut chart, bubble chart, radar chart, histogram, any variation thereof, any combination thereof, and/or the like.
- An overlay visualization can alternatively or additionally include one or more graphical user interface (“GUI”) elements such as buttons tabs, scroll bars, icons, menus, combinations thereof, and/or the like.
- GUI graphical user interface
- An overlay visualization may overlay a geospatial visualization. Alternatively, an overlay visualization may be positioned above, below, or adjacent to a geospatial visualization.
- program modules include routines, programs, components, data structures, and other types of structures that perform particular tasks or implement particular abstract data types.
- program modules include routines, programs, components, data structures, and other types of structures that perform particular tasks or implement particular abstract data types.
- program modules include routines, programs, components, data structures, and other types of structures that perform particular tasks or implement particular abstract data types.
- the subject matter described herein may be practiced with other computer system configurations, including hand-held devices, multiprocessor systems, microprocessor-based or programmable consumer electronics, minicomputers, mainframe computers, and the like.
- the operating environment 100 shown in FIG. 1 includes a computer system 102 operating as a part of and/or in communication with a communications network (“network”) 104 .
- network a communications network
- the functionality of the computer system 102 can be provided by a cloud-based computing platform that can be provided by one or more application servers, Web servers, data storage systems, network appliances, dedicated hardware devices, and/or other server computers or computing devices.
- the computer system 102 can include a user computing device, such as a tablet computing device, a personal computer (“PC”), a desktop computer, a laptop computer, a notebook computer, a cellular phone or smartphone, other mobile computing devices, a personal digital assistant (“PDA”), or the like.
- a user computing device such as a tablet computing device, a personal computer (“PC”), a desktop computer, a laptop computer, a notebook computer, a cellular phone or smartphone, other mobile computing devices, a personal digital assistant (“PDA”), or the like.
- PDA personal digital assistant
- the computer system 102 can be configured to execute an operating system 106 and one or more application programs such as, for example, a spreadsheet application 108 , a visualization component 110 , and/or other application programs.
- the operating system 106 is a computer program for controlling the operation of the computer system 102 .
- the application programs are executable programs configured to execute on top of the operating system 106 to provide the functionality described herein for facetted browsing.
- the spreadsheet application 108 can be configured to create, manipulate, store, and/or otherwise interact with tabular or other structured data such as spreadsheets.
- the functionality of the spreadsheet application 108 can be provided by a member of the MICROSOFT EXCEL family of spreadsheet applications from Microsoft Corporation of Redmond, Wash.
- the functionality of the spreadsheet application 108 can be provided by a database application, a data reporting application, a data presentation application, combinations thereof, or the like.
- the spreadsheet application 108 can be executed by one or more server computers in the computer system 102 , such as application servers and/or Web servers.
- the functionality of the spreadsheet application 108 can be accessed by other computing devices and/or accessed at the computer system 102 .
- the functionality of the spreadsheet application 108 can be accessed and/or interacted with by a user computing device 112 .
- the functionality of the user computing device 112 can be provided by, for example, a tablet computing device, a smartphone, a laptop computer, a desktop computer, other computing devices, combinations thereof, or the like.
- the user computing device 112 can communicate with the computer system 102 over one or more links or networks such as, for example, the network 104 , a private network, a direct wireless or wired connection, the Internet, and/or combinations of these and other networks and/or communication links.
- links or networks such as, for example, the network 104 , a private network, a direct wireless or wired connection, the Internet, and/or combinations of these and other networks and/or communication links.
- the user computing device 112 can execute one or more client applications.
- the client applications can include Web browser applications and/or other applications for accessing the spreadsheet application 108 executing on the computer system 102 .
- the spreadsheet application 108 can be executed locally on the user computing device 112 or other devices that can include the functionality of the computer system 102 described herein.
- the spreadsheet application 108 can be implemented as hardware, software, and/or a combination of the two.
- the spreadsheet application 108 can include one or more application program modules and other components on the user computing device 112 , the computer system 102 , and/or other computing platforms.
- the computer system 102 and/or the user computing device 112 can generate and/or present one or more user interfaces (“UIs”) 114 .
- the UIs 114 can be provided to the user computing device 112 for presentation to a user 116 .
- the spreadsheet application 108 can be configured to generate, manipulate, and/or store tabular or other structured data that can be included in spreadsheet data 118 .
- the spreadsheet data 118 also can be stored in tables of a database, objects stored in an object store, or the like. While the spreadsheet data 118 is illustrated, the spreadsheet application 108 and/or the visualization component 110 can be configured to generate, manipulate, and/or other types of data and metadata. Because the functionality of the spreadsheet application 108 is generally understood, the spreadsheet application 108 will not be described in additional detail herein.
- the spreadsheet data 118 includes data that has been modeled in accordance with one or more data models.
- the spreadsheet data 118 can include data modeled in accordance with a relational model that defines a relational organization among data tables.
- the spreadsheet data 118 can be obtained by the computer system 102 from a local or remote data source 120 .
- the data source 120 can include a memory, disk drive, or other data storage element of or associated with the computer system 102 .
- the data source 120 can include a network drive, a server computer operating as a part of and/or in communication with the network 104 , a database or other real or virtual data storage elements, and/or other data storage devices. As such, it should be understood that the data source 120 can include almost any type of data storage device that is local to and/or remote from the computer system 102 .
- the visualization component 110 can be configured to obtain the spreadsheet data 118 from the spreadsheet application 108 and/or directly from the data source 120 , and to generate, based upon the spreadsheet data 118 , three-dimensional visualizations of the spreadsheet data 118 in a geographical and/or temporal context.
- the visualization component 110 can be implemented as a component of the spreadsheet application 108 , and in some embodiments, the visualization component 110 can be implemented as a component separate from the spreadsheet application. In some embodiments, the visualization component 110 can be provided as a stand-alone application.
- spreadsheet application 108 and the visualization component 110 are illustrated as components of the computer system 102 , it should be understood that each of these components, or combinations thereof, may be embodied as or in stand-alone devices or components thereof operating on or in communication with the network 104 and/or the computer system 102 .
- the illustrated embodiment is illustrative, and should not be construed as being limiting in any way.
- the visualization component 110 may be implemented as a plugin or add-in for the spreadsheet application 108 .
- the visualization component 110 can include a service and/or set of application programming interfaces (“APIs”) that can provide the functionality described herein.
- APIs application programming interfaces
- the visualization component 110 can be implemented as hardware, software, or a combination thereof.
- the visualization component 110 can be configured to access one or more geocoding services 122 .
- the geocoding services 122 can be configured to map geographical data included in the spreadsheet data 118 to geographic information.
- the visualization component 110 can provide geographical data included in the spreadsheet data 118 such as, for example, a street address, a city, a state, a ZIP code, or the like, to the geocoding services 122 .
- the geocoding services 122 can map this geographical data to latitude and longitude information and/or other geocoded location data.
- the geocoding services 122 can be called by the computer system 102 via one or more APIs exposed by the geocoding services 122 , though this is not necessarily the case.
- the geocoding services 122 can be configured to provide geographic mapping data 124 representing mappings of the geographical data to the geocoded location data to the computer system 102 , though this is not necessarily the case.
- the visualization component 110 can access the geocoding services 122 via one or more networks such as, for example, the network 104 , the Internet, other networks, and/or a combination thereof.
- the geocoding services 122 can be implemented on the computer system 102 .
- the geocoding services 122 are implemented as a component of the visualization component 110 . It should be understood that this embodiment is illustrative, and should not be construed as being limiting in any way.
- the visualization component 110 also can be configured to obtain and/or access map data 126 .
- the map data 126 can be used to provide geolocation and/or graphical data for the creation of the three-dimensional geographical maps as described herein.
- the visualization component 110 may be configured to obtain or access the map data 126 from or at a computing device such as, for example, a map server 128 .
- the functionality of the map server 128 can be provided by a mapping application executed by a search engine such as the BING search engine from Microsoft Corporation in Redmond, Wash. Because the functionality of the map server 128 can be provided by additional and/or other devices and/or applications, it should be understood that this embodiment is illustrative, and should not be construed as being limiting in any way.
- the computer system 102 can access the map server 128 via one or more networks such as, for example, the network 104 .
- the visualization component 110 can be configured to access map tiles from the map data 126 , and to stich the map tiles together over a three-dimensional globe armature to create a three-dimensional geographic globe.
- the visualization component 110 can be configured to use geocoded location data such as latitude and longitude data from the geocoding services 122 to place visualizations of data included in the spreadsheet data 118 on the three-dimensional geographic globe.
- various embodiments of the visualization component 110 can be configured to generate displays of geographic data in three-dimensional geospatial visualizations.
- a “geospatial visualization” can include an animation scene or tour of multiple scenes that represent the spreadsheet data 118 on a globe, map, or other three-dimensional representation of location.
- the spreadsheet data 118 can be displayed on the globe, map, or the like at points corresponding to geographic location data included in the spreadsheet data 118 .
- the geospatial visualization also can show data changes over time.
- the visualization component 110 also can be configured to generate one or more two-dimensional visualizations of the spreadsheet data 118 .
- the user 116 can more easily browse the spreadsheet data 118 displayed within a geospatial visualization by interacting with at least a portion of the spreadsheet data 118 displayed within a two-dimensional space provided by one or more two-dimensional visualizations that overlay the geospatial visualization.
- An “overlay visualization” can be linked to a geospatial visualization so as to enable a user to perform various actions to interact with the spreadsheet data 118 in a two-dimensional space and to see results of the interaction reflected in a three-dimensional space provided by the geospatial visualization.
- An overlay visualization can include a chart such as, but not limited to, a column chart, line chart, pie chart, bar chart, area chart, scatter plot, stock chart, surface chart, doughnut chart, bubble chart, radar chart, histogram, any variation thereof, any combination thereof, and/or the like.
- An overlay visualization can alternatively or additionally include one or more graphical user interface (“GUI”) elements such as buttons tabs, scroll bars, icons, menus, combinations thereof, and/or the like. It should be understood that while an overlay visualization can represent the spreadsheet data 118 in a two-dimensional space, elements of the overlay visualization, such as bars in a bar chart, might be generated to appear three-dimensional, have shadow effects, or to have other effects that enhance the visual appeal of the overlay visualization.
- An overlay visualization may overlay a geospatial visualization. Alternatively, an overlay visualization may be positioned above, below, or adjacent to a geospatial visualization.
- the visualization component 110 also can be configured to provide the functionality described herein for facetted browsing.
- facetted browsing can generally include a selection or other interaction with at least a portion of the spreadsheet data 118 that is represented within two-dimensional space via one or more overlay visualizations to easily interact with at least a corresponding portion of the spreadsheet data 118 that is represented within three-dimensional space via a geospatial visualization. Facetted browsing can enable the user 116 to browse the spreadsheet data 118 in two-dimensional space and three-dimensional space spatially, temporarily, and categorically.
- the user 116 may interact with the spreadsheet application 108 and the visualization component 110 to create and/or navigate a three-dimensional visualization of the spreadsheet data 118 through a display of the user computing device 112 .
- the user 116 also may interact with the spreadsheet application 108 and the visualization component 110 to create and/or navigate an overlay visualization of the spreadsheet data 118 through a display of the user computing device 112 .
- the user 116 can interact with the spreadsheet application 108 and the visualization component 110 to perform actions to at least a portion of the spreadsheet data 118 presented on an overlay visualization and see results of the action on corresponding representations of the portion of the spreadsheet data 118 presented on the geospatial visualization.
- the user 116 may use one or more input devices of the user computing device 112 such as a touchscreen, a keyboard, a mouse, a game controller, combinations thereof, or the like.
- the UIs 114 can be presented on the touchscreen, a monitor, a display, other display surfaces or devices, combinations thereof, or the like.
- a user can interact with one or more overlay visualizations through actions such as, but not limited to, brushing, selection, filtering, and comparison.
- a “brushing action” can include a mouse click, touch, touch gesture, or other user input directed to an item on an overlay visualization that is representative of at least a portion of the spreadsheet data 118 (e.g., a bar of a bar chart) to emphasize a corresponding portion of the spreadsheet data 118 that is represented on a geospatial visualization.
- a brushing action can emphasize a brushed over item or a portion thereof within the overlay visualization as well as the corresponding portion of the spreadsheet data 118 associated with the item within the geospatial visualization.
- the emphasis applied to the portion of the spreadsheet data 118 shown in the overlay visualization can be the same as or different from the emphasis applied to the corresponding portion of the spreadsheet data 118 shown in the geospatial visualization.
- An emphasis can include, but is not limited to, a highlight, an animation, a color change, a size change, an embossment, any other visually emphatic item, or any combination thereof.
- an emphasis can include an accompanying sound such as, for example, a pre-defined sound that is associated with the application of an emphasis to at least a portion of the spreadsheet data 118 .
- an emphasis is not directly applied but inherent because other data (e.g., surrounding data points on a geospatial visualization) is deemphasized or no longer displayed.
- data shown in a geospatial visualization and/or in an overlay visualization is shown in aggregated or summary form.
- an action performed on one of the visualizations that shows aggregated data may not reflect a one-to-one change on the other visualization, and instead may reflect a one-to-many change to account for the aggregated data that may span multiple categories, for example.
- a “selection” can include a mouse click, touch, touch gesture, speech input, or other user input used to choose an item from an overlay visualization for receipt of another action to be applied to the chosen item, such as, for example, the application or removal of one or more filters.
- a “filter” can include one or more conditions that are to be applied to the spreadsheet data 118 so that only a portion of the spreadsheet data 118 is displayed on one or more overlay visualizations and the geospatial visualization.
- an overlay visualization might include a bar chart.
- the bar chart can include one or more bars, each of which is associated with a portion of the spreadsheet data 118 that is displayed on a geospatial visualization that is linked to the bar chart.
- the user 116 can brush over a bar of the bar chart, and in response, the visualization component 110 can cause the overlay visualization to emphasize the brushed over bar and the corresponding portion of the spreadsheet data 118 that is displayed on the geospatial visualization.
- the user 116 can then choose one or more filters to apply to the selected bar and the corresponding portion of the spreadsheet data 118 , thereby filtering the spreadsheet data 118 displayed on the geospatial visualization via the overlay visualization.
- a filtered portion of the spreadsheet data 118 can be emphasized on the geospatial visualization to distinguish the filtered portion of the spreadsheet data 118 from a remaining portion of the spreadsheet data 118 .
- the spreadsheet data 118 might include arrest data for a particular city over a particular time period, and each data point represented within a geospatial visualization might represent an arrest.
- the user 116 may desire to filter the spreadsheet data 118 so that only certain types of arrests, such as drug arrests, are displayed on the geospatial visualization.
- the user 116 can select a filter to cause the computer system 102 to execute the visualization component 110 to display only a portion of the spreadsheet data 118 that is related to drug arrests.
- the result of applying such a filter might be the visualization component 110 applying an emphasis to the drug-related arrests within the geospatial visualization to distinguish the drug-related arrests from arrests associated with other arrest categories, such as homicide or robbery.
- the overlay visualization might display the drug-related arrests as different drug categories that the user 116 can select to further filter the spreadsheet data 118 represented within the geospatial visualization.
- Each of these categories may be displayed within the overlay visualization, for example, as bars within a bar chart.
- the brushed-over bar can become emphasized and the corresponding portion of the spreadsheet data 118 that is represented on the geospatial visualization also can be emphasized so as to distinguish drug arrests of the drug category associated with the brushed-over bar from the other drug categories displayed within the overlay visualization.
- the user 116 may also desire to further filter the spreadsheet data 118 to show drug arrests within a particular drug category that occurred on a specific date or during a specific date range.
- the user 116 may also desire to further filter the spreadsheet data 118 to show drug arrests within a particular drug category that occurred on a specific date or during a specific date range and at a specific time or during a specific time range.
- the spreadsheet data 118 that adheres to the condition(s) specified by the filters can be emphasized on the geospatial visualization.
- a “time range” can be used herein to refer to a time duration of the data points that is to be represented in the visualization.
- the time range can be determined based upon an analysis of the spreadsheet data 118 and/or can be specified by a user or other entity.
- a user can specify a time range based upon a determination a duration of time over which the user wishes to present the data.
- a user may specify a time range of particular interest such as, for example, a particular hour, day, week, month, quarter, year, decade, century, or the like. Because the time range can be specified as additional and/or alternative amounts of time, it should be understood that this embodiment is illustrative, and should not be construed as being limiting in any way.
- the computer system 102 can determine the time range over which to show the visualization based upon the spreadsheet data 118 .
- the computer system can be configured to determine an earliest time included in the spreadsheet data 118 and a latest time included in the spreadsheet data 118 , and to define the time range as being bound by these two times.
- the computer system 102 can determine that the time range is to correspond to one year beginning on Jan. 1, 2014.
- the computer system 102 can determine a time range based upon an analysis of the spreadsheet data 118 and assumptions as to what time ranges are likely to be of interest to a user or other entity. For example, if a data set includes one hundred data points, with ninety of the data points occurring within a one month range and the remainder of the data points occurring over a year period before and/or after the one month range, the computer system 102 may determine that the one month range is to be defined as the time range, and that the other data points are not to be represented in the visualization. This example is illustrative and should not be construed as being limiting in any way.
- “Animation speed” can refer to a rate at which data points are presented in the visualization.
- the computer system 102 can be configured to present the spreadsheet data 118 in a visualization over a default time.
- the default time can correspond to ten seconds, twenty seconds, thirty seconds, other times, or the like.
- the default time can be specified by a user, application setting, preferences, or the like, and/or can be based upon an assumption that a user or other viewer wishes to watch an animated sequence for a time corresponding to the default time.
- the animation can last the defined duration.
- the computer system 102 and/or a user can adjust the animation speed.
- the animation speed can correspond to ten data points (or animation frames) per second.
- the animation speed can correspond to one hundred data points per second. It should be understood that these embodiments are illustrative, and should not be construed as being limiting in any way.
- the computer system 102 can be configured to impose a maximum animation speed such as, for example, fifteen milliseconds.
- the animation speed can be limited by the computer system 102 , in some embodiments, to approximately sixty-six data points per second. In some implementations, this maximum animation speed can be imposed to allow the computer system 102 resources to draw each animation frame without negatively impacting performance of the computer system 102 . Because the maximum animation speed can be omitted and/or can correspond to other rates, it should be understood that this embodiment is illustrative, and should not be construed as being limiting in any way.
- the computer system 102 can obtain spreadsheet data 118 from a data source such as the data source 120 .
- the spreadsheet data 118 can include a set of data points (“data set”) having values, temporal values such as time stamps, and location information.
- data set can include a value, a corresponding location, and a corresponding time.
- the computer system 102 can identify a time component of the spreadsheet data 118 , and generate a visualization of the spreadsheet data 118 based upon at least the time component.
- the application of one or more filters is incremental so that the user 116 can explore various facets (e.g., categories, categories within categories, temporal aspects, and/or other aspects) of the spreadsheet data 118 to discover potential insights, which might lead the user 116 to identify patterns within the spreadsheet data 118 and/or might lead the user 116 to further explore within selected facets or other facets of the spreadsheet data 118 .
- facets e.g., categories, categories within categories, temporal aspects, and/or other aspects
- the application of one or more filters is incremental so that the user 116 can explore various facets (e.g., categories, categories within categories, temporal aspects, and/or other aspects) of the spreadsheet data 118 to discover potential insights, which might lead the user 116 to identify patterns within the spreadsheet data 118 and/or might lead the user 116 to further explore within selected facets or other facets of the spreadsheet data 118 .
- the difficulty of browsing data points within a three-dimensional space is mitigated or eliminated, but the user 116 maintains the benefits of viewing
- FIG. 1 illustrates one computer system 102 , one network 104 , one user computing device 112 , one data source 120 , one instance of geocoding services 122 , and one map server 128 . It should be understood, however, that some implementations of the operating environment 100 can include multiple computer systems 102 , multiple networks 104 , multiple user computing devices 112 , multiple data sources 120 , multiple instances of the geocoding services 122 , and/or multiple map servers 128 . As such, the illustrated embodiment of the operating environment should be understood as being illustrative, and should not be construed as being limiting in any way.
- the visualization component 110 can include a number of components and/or subsystems including, but not limited to, a visualization control 200 , a visualization engine 202 , a spreadsheet plugin core 204 , and/or other components and/or subsystems.
- the visualization control 200 can include functionality for representing data, performing searches and/or providing search services, a globe control for visualizing and/or presenting representations of the globe, video recording functionality for recording animations and/or videos of illustrated tours, and a client.
- the visualization engine 202 can include functionality for generating a tour including multiple scenes, images, and/or animation sequences; functionality for measuring and/or representing time in the visualization space; an engine core for providing the visualization component functionality described herein; annotations functionality for generating and/or rendering two-dimensional and/or three-dimensional annotations; spatial indexing functionality; and camera functionality.
- the visualization engine 202 also can include globe models and/or functionality for representing the globe; input and touch modules for interpreting touch and/or multi-touch commands as input; visual layers functionality for representing and/or interacting with layers of a visualization space; a tile cache for storing map tiles; a three-dimensional graphics module for generating and/or rendering three-dimensional visualizations; and shaders for providing shading of generated and/or rendered three-dimensional objects.
- a “layer” of a scene can correspond to a set of data having data values, geographic information, and time information.
- a particular scene may include multiple layers corresponding to, for example, household income and income tax rate over time at a number of geographic locations.
- a user or other entity may view changes in both types of data over time and with respect to location. It should be understood that this embodiment is illustrative, and should not be construed as being limiting in any way.
- a layer includes a geospatial visualization and one or more overlay visualizations.
- the one or more overlay visualizations may overlay at least a portion of the geospatial visualization.
- the shaders can include or implement a number of algorithms to facilitate the rendering of the three-dimensional geographical visualizations of data described herein.
- the visualization component 110 can implement a dark aura effect for disambiguating visualization of a number of similarly colored objects.
- a dark aura effect can include a visual treatment that allows a viewer, for example the user 116 , to differentiate between items in a three-dimensional visualization space.
- some of these columns may be next to and/or behind one another in the three-dimensional view.
- the multiple columns may appear to be grouped together and/or may look like a single polygon.
- the dark aura effect can be added around one or more of the columns, thereby allowing the one or more columns to appear to stand out from one another. Because other visual effects are possible and are contemplated, it should be understood that this example is illustrative, and should not be construed as being limiting in any way.
- the visualization component 110 may implement a GPU-based framework for asynchronous hit testing for large number of arbitrary three-dimensional elements. This may comprise adding “out-of-channel” color information to pixels of the objects rendered in the three-dimensional visualization that may be invisible to the viewer, but can contain information identifying the object. Thus, if a user taps, clicks, or otherwise interacts with a point in the three-dimensional visualization, the identity of the object represented by the selected pixel can be known without deconstructing the three-dimensional visualization and determining the object rendered at the selected location. This may be implemented in the GPU.
- the spreadsheet plugin core 204 can include functionality for storing workbook state information, as well as a query engine for generating and/or executing queries against various data sources.
- the query engine can be configured to generate a query based upon data stored in the spreadsheet data 118 , and to submit the queries to a query engine. It should be understood that this embodiment is illustrative, and should not be construed as being limiting in any way.
- the visualization component 110 also can include various other components and/or subsystems such as, for example, a spreadsheet program native plugin and a spreadsheet program command object model (“COM”) API.
- the visualization component 110 also can include various graphics plugins and/or APIs such as the illustrated DIRECTX APIs, API call emulators such as the illustrated DIRECTX WRAPPER, a WINDOWS Presentation Foundation (“WPF”) subsystem, combinations thereof, or the like.
- the visualization component 110 also can include analytics engines such as the illustrated VERTIPAQ engine and/or modules associated with other data providers, if desired. It should be appreciated that the visualization component 110 can include additional and/or alternative functionality not shown in FIG. 2 . As such, the embodiment illustrated in FIG. 2 should be understood as being illustrative and should not be construed as being limiting in any way
- FIG. 3 aspects of a method 300 for facetted browsing will be described in detail. It should be understood that the operations of the methods disclosed herein are not necessarily presented in any particular order and that performance of some or all of the operations in an alternative order(s) is possible and is contemplated. The operations have been presented in the demonstrated order for ease of description and illustration. Operations may be added, omitted, and/or performed simultaneously, without departing from the scope of the appended claims.
- the logical operations described herein are implemented (1) as a sequence of computer implemented acts or program modules running on a computing system and/or (2) as interconnected machine logic circuits or circuit modules within the computing system.
- the implementation is a matter of choice dependent on the performance and other requirements of the computing system.
- the logical operations described herein are referred to variously as states, operations, structural devices, acts, or modules. These operations, structural devices, acts, and modules may be implemented in software, in firmware, in special purpose digital logic, and any combination thereof.
- the methods disclosed herein are described as being performed by the computer system 102 via execution of one or more software modules such as, for example, the visualization component 110 . It should be understood that additional and/or alternative devices and/or network nodes can provide the functionality described herein via execution of one or more modules, applications, and/or other software including, but not limited to, the visualization component 110 . Thus, the illustrated embodiments are illustrative, and should not be viewed as being limiting in any way.
- the method 300 begins at operation 302 , wherein the computer system 102 obtains data such as the spreadsheet data 118 .
- the spreadsheet data 118 can include various types of information or content such as, for example, spreadsheet files, database application data, and/or other types of information.
- the spreadsheet data 118 corresponds to a spreadsheet file such as a file generated by a member of the MICROSOFT EXCEL family of spreadsheet application software products from Microsoft Corporation in Redmond, Wash.
- the spreadsheet data 118 can be obtained from a data storage device or component associated with the computer system 102 . Some examples of data storage devices are described in more detail below with reference to FIGS. 7-9 .
- the spreadsheet data 118 can be stored at or hosted by a remote storage device or resource such as the data source 120 described herein.
- the spreadsheet data 118 can be obtained by the computer system 102 via communications with the data source 120 .
- the spreadsheet data 118 can be obtained from any real or virtual device via a direct connection, via one or more networks, and/or via other nodes, devices, and/or device components.
- the method 300 proceeds to operation 304 , wherein the computer system 102 generates one or more geospatial visualizations of the data obtained at operation 302 .
- the computer system 102 can determine, based upon preferences, options, configuration settings, user input, combinations thereof, or the like, what should be displayed within the geospatial visualization. For example, the default portion of a globe or other three-dimensional location that is to be displayed, how the data is to be displayed on the geospatial visualization, the color theme to be utilized, whether or not the data has a time component, and the like.
- the computer system 102 can generate one or more data labels for the geospatial visualization.
- the data labels can include text, images, or other representations that specify what the data represent in the geospatial visualization.
- the labels can include, for example, a data type, a data name, location information, color information, data value labels, combinations thereof, or the like.
- a geospatial visualization can be presented in or as a UI 114 presented at the user computing device 112 and/or other computing devices.
- the UI 114 can be presented by or on a display, a touchscreen, a monitor, a projector, and/or other display device.
- an overlay visualization can be presented in or as a UI 114 presented at the user computing device 112 and/or other computing devices.
- the UI 114 can be presented by or on a display, a touchscreen, a monitor, a projector, and/or other display device.
- the method 300 proceeds to operation 314 , wherein the computer system 102 receives an input via the one or more overlay visualizations to perform an action.
- the input can be to perform an action such as brushing, selection, filtering, and/or comparison, as described in further detail above.
- the method 300 proceeds to operation 316 , wherein the computer system 102 updates the one or more geospatial visualizations in response to the input. For example, if the input received by the computer system 102 at operation 314 is a brushing action over a bar of bar chart included in the overlay visualization, the data associated with the brushed over bar can be emphasized on the geospatial visualization. In some embodiments, one, some, or all of the geospatial visualizations are updated.
- a geospatial visualization can be presented in or as a UI 114 presented at the user computing device 112 and/or other computing devices.
- the UI 114 can be presented by or on a display, a touchscreen, a monitor, a projector, and/or other display device.
- the method 300 proceeds to operation 320 .
- the method 300 ends at operation 320 .
- the computer system 102 can receive an input via the one or more geospatial visualizations to perform an action.
- the input can be to perform an action such as, for example, brushing, selection, filtering, and/or comparison.
- the computer system 102 can update the one or more overlay visualizations and present the one or more updated overlay visualizations.
- the illustrated embodiment of FIG. 3 wherein the computer system 102 receives an input via the one or more overlay visualizations is illustrative, and should not be construed as being limiting in any way.
- the method 400 begins at operation 402 , wherein the computer system 102 presents a geospatial visualization of data, such as the spreadsheet data 118 . From operation 402 , the method 400 proceeds to operation 404 , wherein the computer system 102 presents an overlay visualization of the data.
- the geospatial visualization and the overlay visualization can be presented in or as a UI 114 presented at the user computing device 112 and/or other computing devices.
- the UI 114 can be presented by or on a display, a touchscreen, a monitor, a projector, and/or other display device.
- the method 400 proceeds to operation 406 , wherein the computer system 102 receives an input via the overlay visualization to filter the data. From operation 406 , the method 400 proceeds to operation 408 , wherein the computer system 102 filters the data according to the input received at operation 406 . From operation 408 , the method 400 proceeds to operation 410 , wherein the computer system 102 presents the geospatial visualization and the overlay visualization of the filtered data.
- the method 400 proceeds to operation 412 , wherein the computer system 102 determines if an input to further filter the data is received. If the computer system 102 does not receive an input to further filter the data, the method 400 proceeds to operation 414 . The method 400 ends at operation 414 .
- the method 400 proceeds to operation 416 , wherein the computer system 102 further filters the data according to the input. From operation 416 , the method 400 proceeds to operation 418 , wherein the computer system 102 presents the geospatial visualization and the overlay visualization of the further filtered data. The method 400 then returns to operation 412 , wherein the computer system 102 again determines if an input to further filter the data is received. Operation 412 , operation 416 , and operation 418 can be repeated any number of times to accommodate the application of any number of filters to the data. After no further filter is to be applied, the method 400 ends at operation 414 .
- the computer system 102 can take additional actions to remove previously applied filters. For example, after the filter is applied at operation 408 or a further filter is applied at operation 416 , the computer system 102 can receive another input to remove one or more previously applied filters. It is contemplated that the computer system 102 can receive inputs to apply and remove inputs any number of filters. As such, the illustrated embodiment of FIG. 4 , wherein the computer system 102 applies filters but does not then remove filters is illustrative, and should not be construed as being limiting in any way.
- the method 500 begins at operation 502 , wherein the computer system 102 presents a geospatial visualization of data, such as the spreadsheet data 118 . From operation 502 , the method 500 proceeds to operation 504 , wherein the computer system 102 presents an overlay visualization of the data.
- the geospatial visualization and the overlay visualization can be presented in or as a UI 114 presented at the user computing device 112 and/or other computing devices.
- the UI 114 can be presented by or on a display, a touchscreen, a monitor, a projector, and/or other display device.
- the method 500 proceeds to operation 506 , wherein the computer system 102 receives an input via the geospatial visualization to filter the data. From operation 506 , the method 500 proceeds to operation 508 , wherein the computer system 102 filters the data according to the input received at operation 506 . From operation 508 , the method 500 proceeds to operation 510 , wherein the computer system 102 presents the geospatial visualization and the overlay visualization of the filtered data.
- the method 500 proceeds to operation 512 , wherein the computer system 102 determines if an input to further filter the data is received. If the computer system 102 does not receive an input to further filter the data, the method 500 proceeds to operation 514 . The method 500 ends at operation 514 .
- the method 500 proceeds to operation 516 , wherein the computer system 102 further filters the data according to the input. From operation 516 , the method 500 proceeds to operation 518 , wherein the computer system 102 presents the geospatial visualization and the overlay visualization of the further filtered data. The method 500 then returns to operation 512 , wherein the computer system 102 again determines if an input to further filter the data is received. Operation 512 , operation 516 , and operation 518 can be repeated any number of times to accommodate the application of any number of filters to the data. After no further filter is to be applied, the method 500 ends at operation 514 .
- the computer system 102 can take additional actions to remove previously applied filters. For example, after the filter is applied at operation 508 or a further filter is applied at operation 516 , the computer system 102 can receive another input to remove one or more of the applied filters. It is contemplated that the computer system 102 can receive inputs to apply and remove inputs any number of filters. As such, the illustrated embodiment of FIG. 5 , wherein the computer system 102 applies filters but does not then remove filters is illustrative and should not be construed as being limiting in any way.
- FIG. 6A shows an illustrative screen display 600 A generated by a device such as the computer system 102 and/or the user computing device 112 .
- the screen display 600 A can correspond to the UI 114 displayed by the user computing device 112 , as shown in FIG. 1 , though this is not necessarily the case.
- the UI diagram illustrated in FIG. 6A is illustrative of one contemplated example, and therefore should not be construed as being limited in any way.
- the screen display 600 A can include a three-dimensional geospatial visualization (“geospatial visualization”) 602 and a two-dimensional overlay visualization (“overlay visualization”) 604 of data such as the spreadsheet data 118 described herein. More particularly, the screen display 600 A is illustrated as displaying a globe with multiple data points illustrated on the globe in their corresponding locations and/or magnitudes as data points 606 . The data points 606 are also represented at least in part by the overlay visualization 604 . The geospatial visualization 602 and the overlay visualization 606 are linked together so that interaction with the spreadsheet data 118 via the overlay visualization 606 is reflected on the geospatial visualization 602 , and vice versa. Because the spreadsheet data 118 can be illustrated in additional and/or alternative structures other than the illustrated data points 606 , it should be understood that the illustrated example is illustrative.
- the overlay visualization 604 can include a chart such as, but not limited to, a column chart, line chart, pie chart, bar chart, area chart, scatter plot, stock chart, surface chart, doughnut chart, bubble chart, radar chart, histogram, any variation thereof, any combination thereof, and/or the like.
- the overlay visualization 64 can alternatively or additionally include one or more GUI elements such as buttons tabs, scroll bars, icons, menus, combinations thereof, and/or the like.
- the overlay visualization 604 includes a bar chart 608 and a UI control 610 .
- the illustrated bar chart 608 includes a plurality of bars, each of which can represent a portion of the data points 604 shown on the geospatial visualization 602 .
- the UI control 610 can allow a user to access settings, properties, controls, and/or other information regarding the geospatial visualization 602 and the overlay visualization 604 via a visualization component properties or settings bar (“settings bar”) 612 .
- the settings bar 612 can be presented, for example, in response to a user or other entity selecting the UI control 610 .
- the settings bar 612 is illustrated as displaying various properties associated with the geospatial visualization 602 and the overlay visualization 604 presented on the screen display 600 A.
- a user or other entity has selected an option 614 to filter and display the spreadsheet data 118 based upon categories associated with the spreadsheet data 118 .
- Each bar of the bar chart 608 can represent a category.
- the spreadsheet data 118 might be drug arrest data within which there are a plurality of categories that are each representative of a type of drug.
- each bar of the bar chart 608 might represent a type of drug.
- the settings bar 612 also includes overlay options 616 .
- the illustrated embodiment shows the overlay options 616 including a show/hide overlay option 618 , a show/hide overlay labels option 620 , and an overlay type option 622 .
- the show/hide overlay option 618 is shown in a selected state so that the overlay visualization 604 is presented on the screen display 600 A. In an unselected state, the show/hide overlay option 618 causes the overlay visualization 604 to be hidden from the screen display 600 A. It is contemplated that other means to show/hide the overlay visualization 604 may be used, including, for example, keyboard shortcuts, touch gestures, speech recognition, or the selection of other GUI elements (not shown).
- the show/hide labels option 620 is shown in an unselected state so that labels associated with the bar chart 608 are not shown. In a selected state, the show/hide labels option 620 causes labels to be shown within the overlay visualization 604 .
- the labels can provide additional details about the data represented in the overlay visualization 604 .
- the labels may label the axes of the bar chart 608 and/or provide additional details about the data represented in the bars of the bar chart 608 . It is contemplated that other means to show/hide labels within the overlay visualization 604 may be used, including, for example, keyboard shortcuts, touch gestures, speech recognition, or the selection of other GUI elements (not shown).
- the overlay type option 622 allows a user or other entity to select the type of chart or other visualization that is to be shown within the overlay visualization 604 .
- a user has selected a bar chart overlay type, and the spreadsheet data 118 is shown in the bar chart 608 as a result.
- the screen display 600 A can be presented on a touch-sensitive and/or multi-touch-sensitive display associated with a device such as the computer system 102 and/or the user computing device 112 .
- a user's finger 624 is illustrated proximate to the screen display 600 A as if about to initiate an interaction with the screen display 600 A.
- FIG. 6B shows a screen display 600 B generated by a device such as the computer system 102 and/or the user computing device 112 .
- the screen display 600 B corresponds to one or more of the UIs 114 shown in FIG. 1 and described above with reference to FIGS. 1-6A .
- the UI diagram illustrated in FIG. 6B is illustrative of one contemplated embodiment, and therefore should not be construed as being limited in any way.
- FIG. 6B a user or other entity has selected or brushed over a bar 626 of the bar chart 608 .
- the screen display 600 B shows the bar 626 in an emphasized state, which is illustrated by the bar 626 having a different hatching pattern than that of the other bars of the bar chart 608 .
- a subset 628 of the data points 606 is also shown in the same emphasized state to convey to the user that the subset 628 is associated with the bar 626 .
- the user can brush over any of the other bars to emphasize other subsets of the data points 606 on the overlay visualization 604 and the geospatial visualization 602 .
- FIG. 6C shows a screen display 600 C generated by a device such as the computer system 102 and/or the user computing device 112 .
- the screen display 600 C corresponds to one or more of the UIs 114 shown in FIG. 1 and described above with reference to FIGS. 1-6B .
- the UI diagram illustrated in FIG. 6C is illustrative of one contemplated embodiment, and therefore should not be construed as being limited in any way.
- FIG. 6C another way in which a user can select the subset 628 is illustrated.
- the user's finger 624 is positioned at a point 630 , and another finger 632 is dragged outward from the point 630 to define a radius of a circular area 632 , thereby selecting and emphasizing each data point of the subset 628 .
- the bar 626 that is associated with the subset 628 of data points is also emphasized. It should be appreciated that other touch gestures, mouse inputs, speech inputs, or other inputs can be used to provide similar functionality for the selection of at least a portion of the data points 606 via the geospatial visualization 602 .
- FIG. 7 illustrates an illustrative computer architecture 700 for a device capable of executing the software components described herein for facetted browsing.
- the computer architecture 700 illustrated in FIG. 7 illustrates an architecture for a server computer, mobile phone, a PDA, a smart phone, a desktop computer, a netbook computer, a tablet computer, and/or a laptop computer.
- the computer architecture 700 may be utilized to execute any aspects of the software components presented herein.
- the computer architecture 700 illustrated in FIG. 7 includes a central processing unit 702 (“CPU”), a system memory 704 , including a random access memory 706 (“RAM”) and a read-only memory (“ROM”) 708 , and a system bus 710 that couples the memory 704 to the CPU 702 .
- the computer architecture 700 further includes a mass storage device 712 for storing the operating system 107 and one or more application programs including, but not limited to, the spreadsheet application 108 , the visualization component 110 , other application programs, or the like.
- the mass storage device 712 also can be configured to store the spreadsheet data 118 , the geographic mapping data 124 , the map data 127 , and/or graphical data corresponding to one or more of the UIs 114 described herein, if desired.
- the mass storage device 712 is connected to the CPU 702 through a mass storage controller (not shown) connected to the bus 710 .
- the mass storage device 712 and its associated computer-readable media provide non-volatile storage for the computer architecture 700 .
- computer-readable media can be any available computer storage media or communication media that can be accessed by the computer architecture 700 .
- Communication media includes computer readable instructions, data structures, program modules, or other data in a modulated data signal such as a carrier wave or other transport mechanism and includes any delivery media.
- modulated data signal means a signal that has one or more of its characteristics changed or set in a manner as to encode information in the signal.
- communication media includes wired media such as a wired network or direct-wired connection, and wireless media such as acoustic, RF, infrared and other wireless media. Combinations of the any of the above should also be included within the scope of computer-readable media.
- computer storage media may include volatile and non-volatile, removable and non-removable media implemented in any method or technology for storage of information such as computer-readable instructions, data structures, program modules or other data.
- computer media includes, but is not limited to, RAM, ROM, EPROM, EEPROM, flash memory or other solid state memory technology, CD-ROM, digital versatile disks (“DVD”), HD-DVD, BLU-RAY, or other optical storage, magnetic cassettes, magnetic tape, magnetic disk storage or other magnetic storage devices, or any other medium that can be used to store the desired information and which can be accessed by the computer architecture 700 .
- DVD digital versatile disks
- HD-DVD high definition digital versatile disks
- BLU-RAY blue ray
- magnetic cassettes magnetic tape
- magnetic disk storage magnetic disk storage devices
- the computer architecture 700 may operate in a networked environment using logical connections to remote computers through a network such as the network 104 .
- the computer architecture 700 may connect to the network 104 through a network interface unit 714 connected to the bus 710 .
- the network interface unit 714 also may be utilized to connect to other types of networks and remote computer systems such as, for example, the data source 120 , the geocoding services 122 , the map server 128 , the user computing device 112 , and/or other systems or devices.
- the computer architecture 700 also may include an input/output controller 716 for receiving and processing input from a number of other devices, including a keyboard, mouse, or electronic stylus (not shown in FIG. 7 ). Similarly, the input/output controller 716 may provide output to a display screen, a printer, or other type of output device (also not shown in FIG. 7 ).
- the software components described herein may, when loaded into the CPU 702 and executed, transform the CPU 702 and the overall computer architecture 700 from a general-purpose computing system into a special-purpose computing system customized to facilitate the functionality presented herein.
- the CPU 702 may be constructed from any number of transistors or other discrete circuit elements, which may individually or collectively assume any number of states. More specifically, the CPU 702 may operate as a finite-state machine, in response to executable instructions contained within the software modules disclosed herein. These computer-executable instructions may transform the CPU 702 by specifying how the CPU 702 transitions between states, thereby transforming the transistors or other discrete hardware elements constituting the CPU 702 .
- Encoding the software modules presented herein also may transform the physical structure of the computer-readable media presented herein.
- the specific transformation of physical structure may depend on various factors, in different implementations of this description. Examples of such factors may include, but are not limited to, the technology used to implement the computer-readable media, whether the computer-readable media is characterized as primary or secondary storage, and the like.
- the computer-readable media is implemented as semiconductor-based memory
- the software disclosed herein may be encoded on the computer-readable media by transforming the physical state of the semiconductor memory.
- the software may transform the state of transistors, capacitors, or other discrete circuit elements constituting the semiconductor memory.
- the software also may transform the physical state of such components in order to store data thereupon.
- the computer-readable media disclosed herein may be implemented using magnetic or optical technology.
- the software presented herein may transform the physical state of magnetic or optical media, when the software is encoded therein. These transformations may include altering the magnetic characteristics of particular locations within given magnetic media. These transformations also may include altering the physical features or characteristics of particular locations within given optical media, to change the optical characteristics of those locations. Other transformations of physical media are possible without departing from the scope and spirit of the present description, with the foregoing examples provided only to facilitate this discussion.
- the computer architecture 700 may include other types of computing devices, including hand-held computers, embedded computer systems, personal digital assistants, and other types of computing devices known to those skilled in the art. It is also contemplated that the computer architecture 700 may not include all of the components shown in FIG. 7 , may include other components that are not explicitly shown in FIG. 7 , or may utilize an architecture completely different than that shown in FIG. 7 .
- FIG. 8 illustrates an illustrative distributed computing environment 800 capable of executing the software components described herein for facetted browsing.
- the distributed computing environment 800 illustrated in FIG. 8 can be used to provide the functionality described herein with respect to the computer system 102 .
- the distributed computing environment 800 thus may be utilized to execute any aspects of the software components presented herein.
- the distributed computing environment 800 includes a computing environment 802 operating on, in communication with, or as part of the network 804 .
- the network 804 also can include various access networks.
- the functionality of the network 804 can be provided by the network 104 illustrated in FIG. 1 .
- client devices 806 A- 806 N (hereinafter referred to collectively and/or generically as “clients 806 ”) can communicate with the computing environment 802 via the network 804 and/or other connections (not illustrated in FIG. 8 ).
- the clients 806 include a computing device 806 A such as a laptop computer, a desktop computer, or other computing device; a slate or tablet computing device (“tablet computing device”) 806 B; a mobile computing device 806 C such as a mobile telephone, a smart phone, or other mobile computing device; a server computer 806 D; and/or other devices 806 N. It should be understood that any number of clients 806 can communicate with the computing environment 802 . Two example computing architectures for the clients 806 are illustrated and described herein with reference to FIGS. 7 and 9 . It should be understood that the illustrated clients 806 and computing architectures illustrated and described herein are illustrative, and should not be construed as being limited in any way.
- the computing environment 802 includes application servers 808 , data storage 810 , and one or more network interfaces 812 .
- the functionality of the application servers 808 can be provided by one or more server computers that are executing as part of, or in communication with, the network 804 .
- the application servers 808 can host various services, virtual machines, portals, and/or other resources.
- the application servers 808 host one or more virtual machines 814 for hosting applications or other functionality.
- the virtual machines 814 host one or more applications and/or software modules for providing the functionality described herein for facetted browsing. It should be understood that this embodiment is illustrative, and should not be construed as being limiting in any way.
- the application servers 808 also host or provide access to one or more Web portals, link pages, Web sites, and/or other information (“Web portals”) 816 .
- Web portals Web portals
- the application servers 808 also include one or more mailbox services 818 and one or more messaging services 820 .
- the mailbox services 818 can include electronic mail (“email”) services.
- the mailbox services 818 also can include various personal information management (“PIM”) services including, but not limited to, calendar services, contact management services, collaboration services, and/or other services.
- PIM personal information management
- the messaging services 820 can include, but are not limited to, instant messaging services, chat services, forum services, and/or other communication services.
- the application servers 808 also can include one or more social networking services 822 .
- the social networking services 822 can include various social networking services including, but not limited to, services for sharing or posting status updates, instant messages, links, photos, videos, and/or other information; services for commenting or displaying interest in articles, products, blogs, or other resources; and/or other services.
- the social networking services 822 are provided by or include the FACEBOOK social networking service, the LINKEDIN professional networking service, the MYSPACE social networking service, the FOURSQUARE geographic networking service, the YAMMER office colleague networking service, and the like.
- the social networking services 822 are provided by other services, sites, and/or providers that may or may not explicitly be known as social networking providers.
- some web sites allow users to interact with one another via email, chat services, and/or other means during various activities and/or contexts such as reading published articles, commenting on goods or services, publishing, collaboration, gaming, and the like.
- Examples of such services include, but are not limited to, the WINDOWS LIVE service and the XBOX LIVE service from Microsoft Corporation in Redmond, Wash. Other services are possible and are contemplated.
- the social networking services 822 also can include commenting, blogging, and/or microblogging services. Examples of such services include, but are not limited to, the YELP commenting service, the KUDZU review service, the OFFICETALK enterprise microblogging service, the TWITTER messaging service, the GOOGLE BUZZ service, and/or other services. It should be appreciated that the above lists of services are not exhaustive and that numerous additional and/or alternative social networking services 822 are not mentioned herein for the sake of brevity. As such, the above embodiments are illustrative, and should not be construed as being limited in any way.
- the application servers 808 also can host other services, applications, portals, and/or other resources (“other resources”) 824 .
- the other resources 824 can include, but are not limited to, the geocoding services 122 , the map server 128 , the data source 120 , and/or other services and/or resources.
- the computing environment 802 can provide integration of the concepts and technologies disclosed herein provided herein for facetted browsing with various mailbox, messaging, social networking, and/or other services or resources.
- the concepts and technologies disclosed herein can support sharing visualizations with social network users, mail recipients, message recipients or the like.
- users or other entities can share visualizations and/or spreadsheet data 118 with social networking users, friends, connections, mail recipients, systems or devices, combinations thereof, or the like.
- the computing environment 802 can include the data storage 810 .
- the functionality of the data storage 810 is provided by one or more databases operating on, or in communication with, the network 804 .
- the functionality of the data storage 810 also can be provided by one or more server computers configured to host data for the computing environment 802 .
- the data storage 810 can include, host, or provide one or more real or virtual datastores 826 A- 826 N (hereinafter referred to collectively and/or generically as “datastores 826 ”).
- the datastores 826 are configured to host data used or created by the application servers 808 and/or other data.
- the datastores 826 also can host or store the operating system 106 , the spreadsheet application 108 , the visualization component 110 , graphics data corresponding to one or more UIs 114 , the spreadsheet data 118 , the geographic mapping data 124 , the map data 126 , combinations thereof, or the like.
- the computing environment 802 can communicate with, or be accessed by, the network interfaces 812 .
- the network interfaces 812 can include various types of network hardware and software for supporting communications between two or more computing devices including, but not limited to, the clients 806 and the application servers 808 . It should be appreciated that the network interfaces 812 also may be utilized to connect to other types of networks and/or computer systems.
- the distributed computing environment 800 described herein can provide any aspects of the software elements described herein with any number of virtual computing resources and/or other distributed computing functionality that can be configured to execute any aspects of the software components disclosed herein.
- the distributed computing environment 800 provides the software functionality described herein as a service to the clients 806 .
- the clients 806 can include real or virtual machines including, but not limited to, server computers, web servers, personal computers, mobile computing devices, smart phones, and/or other devices.
- various embodiments of the concepts and technologies disclosed herein enable any device configured to access the distributed computing environment 800 to utilize the functionality described herein for facetted browsing.
- an illustrative computing device architecture 900 for a computing device that is capable of executing various software components described herein for facetted browsing is applicable to computing devices that facilitate mobile computing due, in part, to form factor, wireless connectivity, and/or battery-powered operation.
- the computing devices include, but are not limited to, mobile telephones, tablet devices, slate devices, portable video game devices, and the like.
- the computing device architecture 900 is applicable to any of the clients 906 shown in FIG. 8 .
- aspects of the computing device architecture 900 may be applicable to traditional desktop computers, portable computers (e.g., laptops, notebooks, ultra-portables, and netbooks), server computers, and other computer systems, such as described herein with reference to FIG. 7 .
- portable computers e.g., laptops, notebooks, ultra-portables, and netbooks
- server computers e.g., server computers, and other computer systems, such as described herein with reference to FIG. 7 .
- the single touch and multi-touch aspects disclosed herein below may be applied to desktop computers that utilize a touchscreen or some other touch-enabled device, such as a touch-enabled track pad or touch-enabled mouse.
- the computing device architecture 900 illustrated in FIG. 9 includes a processor 902 , memory components 904 , network connectivity components 906 , sensor components 908 , input/output components 910 , and power components 912 .
- the processor 902 is in communication with the memory components 904 , the network connectivity components 906 , the sensor components 908 , the input/output (“I/O”) components 910 , and the power components 912 .
- I/O input/output
- the components can interact to carry out device functions.
- the components are arranged so as to communicate via one or more busses (not shown).
- the processor 902 includes a central processing unit (“CPU”) configured to process data, execute computer-executable instructions of one or more application programs, and communicate with other components of the computing device architecture 900 in order to perform various functionality described herein.
- the processor 902 may be utilized to execute aspects of the software components presented herein and, particularly, those that utilize, at least in part, a touch-enabled input.
- the processor 902 includes a graphics processing unit (“GPU”) configured to accelerate operations performed by the CPU, including, but not limited to, operations performed by executing general-purpose scientific and engineering computing applications, as well as graphics-intensive computing applications such as high resolution video (e.g., 720p, 1090p, and greater), video games, three-dimensional modeling applications, and the like.
- the processor 902 is configured to communicate with a discrete GPU (not shown).
- the CPU and GPU may be configured in accordance with a co-processing CPU/GPU computing model, wherein the sequential part of an application executes on the CPU and the computationally-intensive part is accelerated by the GPU.
- the processor 902 is, or is included in, a system-on-chip (“SoC”) along with one or more of the other components described herein below.
- SoC may include the processor 902 , a GPU, one or more of the network connectivity components 906 , and one or more of the sensor components 908 .
- the processor 902 is fabricated, in part, utilizing a package-on-package (“PoP”) integrated circuit packaging technique.
- PoP package-on-package
- the processor 902 may be a single core or multi-core processor.
- the processor 902 may be created in accordance with an ARM architecture, available for license from ARM HOLDINGS of Cambridge, United Kingdom. Alternatively, the processor 902 may be created in accordance with an x96 architecture, such as is available from INTEL CORPORATION of Mountain View, Calif. and others.
- the processor 902 is a SNAPDRAGON SoC, available from QUALCOMM of San Diego, Calif., a TEGRA SoC, available from NVIDIA of Santa Clara, Calif., a HUMMINGBIRD SoC, available from SAMSUNG of Seoul, South Korea, an Open Multimedia Application Platform (“OMAP”) SoC, available from TEXAS INSTRUMENTS of Dallas, Tex., a customized version of any of the above SoCs, or a proprietary SoC.
- SNAPDRAGON SoC available from QUALCOMM of San Diego, Calif.
- TEGRA SoC available from NVIDIA of Santa Clara, Calif.
- a HUMMINGBIRD SoC available from SAMSUNG of Seoul, South Korea
- OMAP Open Multimedia Application Platform
- the memory components 904 include a random access memory (“RAM”) 914 , a read-only memory (“ROM”) 916 , an integrated storage memory (“integrated storage”) 918 , and a removable storage memory (“removable storage”) 920 .
- the RAM 914 or a portion thereof, the ROM 916 or a portion thereof, and/or some combination the RAM 914 and the ROM 916 is integrated in the processor 902 .
- the ROM 916 is configured to store a firmware, an operating system or a portion thereof (e.g., operating system kernel), and/or a bootloader to load an operating system kernel from the integrated storage 918 or the removable storage 920 .
- the integrated storage 918 can include a solid-state memory, a hard disk, or a combination of solid-state memory and a hard disk.
- the integrated storage 918 may be soldered or otherwise connected to a logic board upon which the processor 902 and other components described herein also may be connected. As such, the integrated storage 918 is integrated in the computing device.
- the integrated storage 918 is configured to store an operating system or portions thereof, application programs, data, and other software components described herein.
- the removable storage 920 can include a solid-state memory, a hard disk, or a combination of solid-state memory and a hard disk. In some embodiments, the removable storage 920 is provided in lieu of the integrated storage 918 . In other embodiments, the removable storage 920 is provided as additional optional storage. In some embodiments, the removable storage 920 is logically combined with the integrated storage 918 such that the total available storage is made available and shown to a user as a total combined capacity of the integrated storage 918 and the removable storage 920 .
- the removable storage 920 is configured to be inserted into a removable storage memory slot (not shown) or other mechanism by which the removable storage 920 is inserted and secured to facilitate a connection over which the removable storage 920 can communicate with other components of the computing device, such as the processor 902 .
- the removable storage 920 may be embodied in various memory card formats including, but not limited to, PC card, CompactFlash card, memory stick, secure digital (“SD”), miniSD, microSD, universal integrated circuit card (“UICC”) (e.g., a subscriber identity module (“SIM”) or universal SIM (“USIM”)), a proprietary format, or the like.
- the memory components 904 can store an operating system.
- the operating system includes, but is not limited to, SYMBIAN OS from SYMBIAN LIMITED, WINDOWS MOBILE OS from Microsoft Corporation of Redmond, Wash., WINDOWS PHONE OS from Microsoft Corporation, WINDOWS from Microsoft Corporation, PALM WEBOS from Hewlett-Packard Company of Palo Alto, Calif., BLACKBERRY OS from Research In Motion Limited of Waterloo, Ontario, Canada, IOS from Apple Inc. of Cupertino, Calif., and ANDROID OS from Google Inc. of Mountain View, Calif. Other operating systems are contemplated.
- the network connectivity components 906 include a wireless wide area network component (“WWAN component”) 922 , a wireless local area network component (“WLAN component”) 924 , and a wireless personal area network component (“WPAN component”) 926 .
- the network connectivity components 906 facilitate communications to and from a network 928 , which may be a WWAN, a WLAN, or a WPAN. Although a single network 928 is illustrated, the network connectivity components 906 may facilitate simultaneous communication with multiple networks. For example, the network connectivity components 906 may facilitate simultaneous communications with multiple networks via one or more of a WWAN, a WLAN, or a WPAN.
- the network 928 can correspond to the network 104 and/or the network 704 illustrated and described in FIGS. 1 and 6 - 7 .
- the network 928 can include the network 104 illustrated and described with reference to FIGS. 1 and 6 and/or the network 704 illustrated and described in FIG. 7 .
- the network 928 can provide access to the network 104 illustrated and described with reference to FIGS. 1 and 7 and/or the network 804 illustrated and described in FIG. 8 .
- the network 928 may be a WWAN, such as a mobile telecommunications network utilizing one or more mobile telecommunications technologies to provide voice and/or data services to a computing device utilizing the computing device architecture 900 via the WWAN component 922 .
- the mobile telecommunications technologies can include, but are not limited to, Global System for Mobile communications (“GSM”), Code Division Multiple Access (“CDMA”) ONE, CDMA2000, Universal Mobile Telecommunications System (“UMTS”), Long Term Evolution (“LTE”), and Worldwide Interoperability for Microwave Access (“WiMAX”).
- GSM Global System for Mobile communications
- CDMA Code Division Multiple Access
- UMTS Universal Mobile Telecommunications System
- LTE Long Term Evolution
- WiMAX Worldwide Interoperability for Microwave Access
- the network 928 may utilize various channel access methods (which may or may not be used by the aforementioned standards) including, but not limited to, Time Division Multiple Access (“TDMA”), Frequency Division Multiple Access (“FDMA”), CDMA, wideband CDMA (“W-CDMA”), Orthogonal Frequency Division Multiplexing (“OFDM”), Space Division Multiple Access (“SDMA”), and the like.
- TDMA Time Division Multiple Access
- FDMA Frequency Division Multiple Access
- CDMA Code Division Multiple Access
- W-CDMA wideband CDMA
- OFDM Orthogonal Frequency Division Multiplexing
- SDMA Space Division Multiple Access
- Data communications may be provided using General Packet Radio Service (“GPRS”), Enhanced Data rates for Global Evolution (“EDGE”), the High-Speed Packet Access (“HSPA”) protocol family including High-Speed Downlink Packet Access (“HSDPA”), Enhanced Uplink (“EUL”) or otherwise termed High-Speed Uplink Packet Access (“HSUPA”), Evolved HSPA (“HSPA+”), LTE, and various other current and future wireless data access standards.
- GPRS General Packet Radio Service
- EDGE Enhanced Data rates for Global Evolution
- HSPA High-Speed Packet Access
- HSPA High-Speed Downlink Packet Access
- EUL Enhanced Uplink
- HSPA+ High-Speed Uplink Packet Access
- LTE Long Term Evolution
- various other current and future wireless data access standards may be provided using General Packet Radio Service (“GPRS”), Enhanced Data rates for Global Evolution (“EDGE”), the High-Speed Packet Access (“HSPA”) protocol family including High-Speed Downlink Packet Access (“HSD
- the WWAN component 922 is configured to provide dual-multi-mode connectivity to the network 928 .
- the WWAN component 922 may be configured to provide connectivity to the network 928 , wherein the network 928 provides service via GSM and UMTS technologies, or via some other combination of technologies.
- multiple WWAN components 922 may be utilized to perform such functionality, and/or provide additional functionality to support other non-compatible technologies (i.e., incapable of being supported by a single WWAN component).
- the WWAN component 922 may facilitate similar connectivity to multiple networks (e.g., a UMTS network and an LTE network).
- the network 928 may be a WLAN operating in accordance with one or more Institute of Electrical and Electronic Engineers (“IEEE”) 902.11 standards, such as IEEE 902.11a, 902.11b, 902.11 g, 902.11n, and/or future 902.11 standard (referred to herein collectively as WI-FI). Draft 902.11 standards are also contemplated.
- the WLAN is implemented utilizing one or more wireless WI-FI access points.
- one or more of the wireless WI-FI access points are another computing device with connectivity to a WWAN that are functioning as a WI-FI hotspot.
- the WLAN component 924 is configured to connect to the network 928 via the WI-FI access points. Such connections may be secured via various encryption technologies including, but not limited, WI-FI Protected Access (“WPA”), WPA2, Wired Equivalent Privacy (“WEP”), and the like.
- WPA WI-FI Protected Access
- WEP Wired Equivalent Privacy
- the network 928 may be a WPAN operating in accordance with Infrared Data Association (“IrDA”), BLUETOOTH, wireless Universal Serial Bus (“USB”), Z-Wave, ZIGBEE, or some other short-range wireless technology.
- the WPAN component 926 is configured to facilitate communications with other devices, such as peripherals, computers, or other computing devices via the WPAN.
- the sensor components 908 include a magnetometer 930 , an ambient light sensor 932 , a proximity sensor 934 , an accelerometer 936 , a gyroscope 938 , and a Global Positioning System sensor (“GPS sensor”) 940 . It is contemplated that other sensors, such as, but not limited to, temperature sensors or shock detection sensors, also may be incorporated in the computing device architecture 900 .
- the magnetometer 930 is configured to measure the strength and direction of a magnetic field.
- the magnetometer 930 provides measurements to a compass application program stored within one of the memory components 904 in order to provide a user with accurate directions in a frame of reference including the cardinal directions, north, south, east, and west. Similar measurements may be provided to a navigation application program that includes a compass component. Other uses of measurements obtained by the magnetometer 930 are contemplated.
- the ambient light sensor 932 is configured to measure ambient light.
- the ambient light sensor 932 provides measurements to an application program stored within one the memory components 904 in order to automatically adjust the brightness of a display (described below) to compensate for low-light and high-light environments. Other uses of measurements obtained by the ambient light sensor 932 are contemplated.
- the proximity sensor 934 is configured to detect the presence of an object or thing in proximity to the computing device without direct contact.
- the proximity sensor 934 detects the presence of a user's body (e.g., the user's face) and provides this information to an application program stored within one of the memory components 904 that utilizes the proximity information to enable or disable some functionality of the computing device.
- a telephone application program may automatically disable a touchscreen (described below) in response to receiving the proximity information so that the user's face does not inadvertently end a call or enable/disable other functionality within the telephone application program during the call.
- Other uses of proximity as detected by the proximity sensor 934 are contemplated.
- the accelerometer 936 is configured to measure proper acceleration.
- output from the accelerometer 936 is used by an application program as an input mechanism to control some functionality of the application program.
- the application program may be a video game in which a character, a portion thereof, or an object is moved or otherwise manipulated in response to input received via the accelerometer 936 .
- output from the accelerometer 936 is provided to an application program for use in switching between landscape and portrait modes, calculating coordinate acceleration, or detecting a fall. Other uses of the accelerometer 936 are contemplated.
- the gyroscope 938 is configured to measure and maintain orientation.
- output from the gyroscope 938 is used by an application program as an input mechanism to control some functionality of the application program.
- the gyroscope 938 can be used for accurate recognition of movement within a three-dimensional environment of a video game application or some other application.
- an application program utilizes output from the gyroscope 938 and the accelerometer 936 to enhance control of some functionality of the application program. Other uses of the gyroscope 938 are contemplated.
- the GPS sensor 940 is configured to receive signals from GPS satellites for use in calculating a location.
- the location calculated by the GPS sensor 940 may be used by any application program that requires or benefits from location information.
- the location calculated by the GPS sensor 940 may be used with a navigation application program to provide directions from the location to a destination or directions from the destination to the location.
- the GPS sensor 940 may be used to provide location information to an external location-based service, such as E911 service.
- the GPS sensor 940 may obtain location information generated via WI-FI, WIMAX, and/or cellular triangulation techniques utilizing one or more of the network connectivity components 906 to aid the GPS sensor 940 in obtaining a location fix.
- the GPS sensor 940 may also be used in Assisted GPS (“A-GPS”) systems.
- A-GPS Assisted GPS
- the I/O components 910 include a display 942 , a touchscreen 944 , a data I/O interface component (“data I/O”) 946 , an audio I/O interface component (“audio I/O”) 948 , a video I/O interface component (“video I/O”) 950 , and a camera 952 .
- the display 942 and the touchscreen 944 are combined.
- two or more of the data I/O component 946 , the audio I/O component 948 , and the video I/O component 950 are combined.
- the I/O components 910 may include discrete processors configured to support the various interface described below, or may include processing functionality built-in to the processor 902 .
- the display 942 is an output device configured to present information in a visual form.
- the display 942 may present graphical user interface (“GUI”) elements, text, images, video, notifications, virtual buttons, virtual keyboards, messaging data, Internet content, device status, time, date, calendar data, preferences, map information, location information, and any other information that is capable of being presented in a visual form.
- GUI graphical user interface
- the display 942 is a liquid crystal display (“LCD”) utilizing any active or passive matrix technology and any backlighting technology (if used).
- the display 942 is an organic light emitting diode (“OLED”) display. Other display types are contemplated.
- the touchscreen 944 is an input device configured to detect the presence and location of a touch.
- the touchscreen 944 may be a resistive touchscreen, a capacitive touchscreen, a surface acoustic wave touchscreen, an infrared touchscreen, an optical imaging touchscreen, a dispersive signal touchscreen, an acoustic pulse recognition touchscreen, or may utilize any other touchscreen technology.
- the touchscreen 944 is incorporated on top of the display 942 as a transparent layer to enable a user to use one or more touches to interact with objects or other information presented on the display 942 .
- the touchscreen 944 is a touch pad incorporated on a surface of the computing device that does not include the display 942 .
- the computing device may have a touchscreen incorporated on top of the display 942 and a touch pad on a surface opposite the display 942 .
- the touchscreen 944 is a single-touch touchscreen. In other embodiments, the touchscreen 944 is a multi-touch touchscreen. In some embodiments, the touchscreen 944 is configured to detect discrete touches, single touch gestures, and/or multi-touch gestures. These are collectively referred to herein as gestures for convenience. Several gestures will now be described. It should be understood that these gestures are illustrative and are not intended to limit the scope of the appended claims. Moreover, the described gestures, additional gestures, and/or alternative gestures may be implemented in software for use with the touchscreen 944 . As such, a developer may create gestures that are specific to a particular application program.
- the touchscreen 944 supports a tap gesture in which a user taps the touchscreen 944 once on an item presented on the display 942 .
- the tap gesture may be used for various reasons including, but not limited to, opening or launching whatever the user taps.
- the touchscreen 944 supports a double tap gesture in which a user taps the touchscreen 944 twice on an item presented on the display 942 .
- the double tap gesture may be used for various reasons including, but not limited to, zooming in or zooming out in stages.
- the touchscreen 944 supports a tap and hold gesture in which a user taps the touchscreen 944 and maintains contact for at least a pre-defined time.
- the tap and hold gesture may be used for various reasons including, but not limited to, opening a context-specific menu.
- the touchscreen 944 supports a pan gesture in which a user places a finger on the touchscreen 944 and maintains contact with the touchscreen 944 while moving the finger on the touchscreen 944 .
- the pan gesture may be used for various reasons including, but not limited to, moving through screens, images, or menus at a controlled rate. Multiple finger pan gestures are also contemplated.
- the touchscreen 944 supports a flick gesture in which a user swipes a finger in the direction the user wants the screen to move. The flick gesture may be used for various reasons including, but not limited to, scrolling horizontally or vertically through menus or pages.
- the touchscreen 944 supports a pinch and stretch gesture in which a user makes a pinching motion with two fingers (e.g., thumb and forefinger) on the touchscreen 944 or moves the two fingers apart.
- the pinch and stretch gesture may be used for various reasons including, but not limited to, zooming gradually in or out of a website, map, or picture.
- the data I/O interface component 946 is configured to facilitate input of data to the computing device and output of data from the computing device.
- the data I/O interface component 946 includes a connector configured to provide wired connectivity between the computing device and a computer system, for example, for synchronization operation purposes.
- the connector may be a proprietary connector or a standardized connector such as USB, micro-USB, mini-USB, or the like.
- the connector is a dock connector for docking the computing device with another device such as a docking station, audio device (e.g., a digital music player), or video device.
- the audio I/O interface component 948 is configured to provide audio input and/or output capabilities to the computing device.
- the audio I/O interface component 946 includes a microphone configured to collect audio signals.
- the audio I/O interface component 946 includes a headphone jack configured to provide connectivity for headphones or other external speakers.
- the audio interface component 948 includes a speaker for the output of audio signals.
- the audio I/O interface component 946 includes an optical audio cable out.
- the video I/O interface component 950 is configured to provide video input and/or output capabilities to the computing device.
- the video I/O interface component 950 includes a video connector configured to receive video as input from another device (e.g., a video media player such as a DVD or BLURAY player) or send video as output to another device (e.g., a monitor, a television, or some other external display).
- the video I/O interface component 950 includes a High-Definition Multimedia Interface (“HDMI”), mini-HDMI, micro-HDMI, DisplayPort, or proprietary connector to input/output video content.
- the video I/O interface component 950 or portions thereof is combined with the audio I/O interface component 948 or portions thereof.
- the camera 952 can be configured to capture still images and/or video.
- the camera 952 may utilize a charge coupled device (“CCD”) or a complementary metal oxide semiconductor (“CMOS”) image sensor to capture images.
- CCD charge coupled device
- CMOS complementary metal oxide semiconductor
- the camera 952 includes a flash to aid in taking pictures in low-light environments.
- Settings for the camera 952 may be implemented as hardware or software buttons.
- one or more hardware buttons may also be included in the computing device architecture 900 .
- the hardware buttons may be used for controlling some operational aspect of the computing device.
- the hardware buttons may be dedicated buttons or multi-use buttons.
- the hardware buttons may be mechanical or sensor-based.
- the illustrated power components 912 include one or more batteries 954 , which can be connected to a battery gauge 956 .
- the batteries 954 may be rechargeable or disposable. Rechargeable battery types include, but are not limited to, lithium polymer, lithium ion, nickel cadmium, and nickel metal hydride. Each of the batteries 954 may be made of one or more cells.
- the battery gauge 956 can be configured to measure battery parameters such as current, voltage, and temperature. In some embodiments, the battery gauge 956 is configured to measure the effect of a battery's discharge rate, temperature, age and other factors to predict remaining life within a certain percentage of error. In some embodiments, the battery gauge 956 provides measurements to an application program that is configured to utilize the measurements to present useful power management data to a user. Power management data may include one or more of a percentage of battery used, a percentage of battery remaining, a battery condition, a remaining time, a remaining capacity (e.g., in watt hours), a current draw, and a voltage.
- Power management data may include one or more of a percentage of battery used, a percentage of battery remaining, a battery condition, a remaining time, a remaining capacity (e.g., in watt hours), a current draw, and a voltage.
- the power components 912 may also include a power connector, which may be combined with one or more of the aforementioned I/O components 910 .
- the power components 912 may interface with an external power system or charging equipment via a power I/O component 944 .
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Human Computer Interaction (AREA)
- Computational Linguistics (AREA)
- Computer Graphics (AREA)
- Multimedia (AREA)
- Software Systems (AREA)
- Computer Hardware Design (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Health & Medical Sciences (AREA)
- General Health & Medical Sciences (AREA)
- Remote Sensing (AREA)
- Geometry (AREA)
- Mathematical Physics (AREA)
- Probability & Statistics with Applications (AREA)
- Fuzzy Systems (AREA)
- User Interface Of Digital Computer (AREA)
- Processing Or Creating Images (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Concepts and technologies are described herein for facetted browsing. In accordance with the concepts and technologies disclosed herein, data can be obtained at a computer system. The data can include data values and geographic information. The computer system can generate a geospatial visualization of the data based, at least partially, upon the data values and the geographic location information. The computer system can also generate an overlay visualization of the data based, at least partially, upon the data values. The computer system can also output the geospatial visualization and the overlay visualization.
Description
- This application claims priority to U.S. Provisional Patent Application No. 61/681,851 entitled “3D Visualization of Data in Geographical and Temporal Contexts,” filed Aug. 10, 2012, which is incorporated herein by reference in its entirety.
- A spreadsheet application, reporting application, or other data presentation application may support presentation of data in two-dimensional and/or three-dimensional pie charts, graphs, bar charts, or the like. Thus, users can chart or graph some data to gain insight into the data, relationships among data points, trends, or the like. Some data, however, may include various data components that are not readily susceptible to graphing and therefore may not be appreciated and/or viewable by users.
- In particular, some data may include a geographical component. Charts and graphs in spreadsheet applications may present geographical information, but typically the display of this information is limited to a color code or data label. The color code or data label can specify, for example, a ZIP code, city name, country, or the like associated with the data points charted or graphed in the spreadsheet application.
- It is with respect to these and other considerations that the disclosure made herein is presented.
- Concepts and technologies are described herein for facetted browsing. In accordance with the concepts and technologies disclosed herein, a computer system can execute a visualization component. The visualization component can be included in a spreadsheet application and/or can be configured to present visualizations of spreadsheet data. The visualizations can include geospatial visualizations and overlay visualizations. As used herein, a “geospatial visualization” can include an animation scene or tour of multiple scenes that represent spreadsheet data on a globe, map, or other three-dimensional representation of location. As used herein, an “overlay visualization” can be linked to a geospatial visualization so as to enable a user to perform various actions to interact with spreadsheet data in a two-dimensional space and to see results of the interaction reflected in a three-dimensional space provided by the geospatial visualization. An overlay visualization can include a chart such as, but not limited to, a column chart, line chart, pie chart, bar chart, area chart, scatter plot, stock chart, surface chart, doughnut chart, bubble chart, radar chart, histogram, any variation thereof, any combination thereof, and/or the like. An overlay visualization can alternatively or additionally include one or more graphical user interface (“GUI”) elements such as buttons tabs, scroll bars, icons, menus, combinations thereof, and/or the like. An overlay visualization may overlay a geospatial visualization. Alternatively, an overlay visualization may be positioned above, below, or adjacent to a geospatial visualization.
- According to one aspect, the computer system can obtain data. The data can include spreadsheet data. The data can include data values and geographic location information. In some embodiments, the data also includes temporal information. The computer system can access one or more geocoding services to obtain geographic mapping data. The computer system can use the geographic mapping data to map the geographic location information included in the data to geographic coordinates and/or other geocoded information. The computer system also can obtain map data, for example, from a map server. The map data can include map images that are joined together by the computer system and visually wrapped onto a virtual globe to provide the geospatial visualization.
- According to another aspect, the computer system can obtain data that includes data values and geographic location information. The computer system also can generate a geospatial visualization of the data based, at least partially, upon the data values and the geographic location information. The computer system also can generate an overlay visualization of the data based, at least partially, upon the data values. The computer system can also output the geospatial visualization and the overlay visualization.
- According to another aspect, the computer system can obtain spreadsheet data that includes data values and geographic location information. The computer system also can generate a geospatial visualization of the spreadsheet data based, at least partially, upon the data values and the geographic location information. The geospatial visualization can include a three-dimensional visualization that represents a plurality of data points associated with the spreadsheet data in three-dimensional space. The computer system also can output the geospatial visualization. The computer system also can generate an overlay visualization of the spreadsheet data based, at least partially, upon the data values. The overlay visualization can include a two-dimensional visualization that represents the plurality of data points associated with the spreadsheet data in two-dimensional space. The computer system also can output the overlay visualization. In some embodiments, the computer system outputs the overlay visualization so that the overlay visualization overlays at least a portion of the geospatial visualization.
- According to another aspect, the computer system can obtain spreadsheet data that includes data values, temporal information, and geographic location information. The computer system also can generate a geospatial visualization of the spreadsheet data based, at least partially, upon the data values, the temporal information, and the geographic location information. The geospatial information can include a three-dimensional visualization that represents a plurality of data points associated with the spreadsheet data in three-dimensional space. The computer system also can output the geospatial visualization to a user computing device that is in communication with the computer system. The computer system also can generate an overlay visualization of the spreadsheet data based, at least partially, upon the data values and the temporal information. The overlay visualization can include a two-dimensional chart that represents the plurality of data points associated with the spreadsheet data in two-dimensional space. The computer system also can output the overlay visualization to the user computing device such that the overlay visualization at least partially overlays the geospatial visualization.
- In some embodiments, the computer system also can receive an input to select a portion of the spreadsheet data via the two-dimensional chart included in the overlay visualization. In response to the input, the computer system can select the portion of the spreadsheet data in the two-dimensional chart and a corresponding portion of the spreadsheet data in the three-dimensional visualization.
- In some other embodiments, the computer system also can receive an input to select a portion of the spreadsheet data via the three-dimensional visualization included in the geospatial visualization. In response to the input, the computer system can select the portion of the spreadsheet data in the three-dimensional visualization and a corresponding portion of the spreadsheet data in the two-dimensional chart.
- It should be appreciated that the above-described subject matter may be implemented as a computer-controlled apparatus, a computer process, a computing system, or as an article of manufacture such as a computer-readable storage medium. These and various other features will be apparent from a reading of the following Detailed Description and a review of the associated drawings.
- This Summary is provided to introduce a selection of concepts in a simplified form that are further described below in the Detailed Description. This Summary is not intended to identify key features or essential features of the claimed subject matter, nor is it intended that this Summary be used to limit the scope of the claimed subject matter. Furthermore, the claimed subject matter is not limited to implementations that solve any or all disadvantages noted in any part of this disclosure.
-
FIG. 1 is a system diagram illustrating an illustrative operating environment for the various embodiments disclosed herein. -
FIG. 2 is a block diagram showing aspects of a visualization component, according an illustrative embodiment. -
FIG. 3 is a flow diagram showing aspects of a method for facetted browsing, according to an illustrative embodiment. -
FIG. 4 is a flow diagram showing aspects of a method for filtering data via an overlay visualization that is linked to a geospatial visualization, according to an illustrative embodiment. -
FIG. 5 is a flow diagram showings aspects of a method for filtering data via a geospatial visualization that is linked to an overlay visualization. -
FIGS. 6A-6C are user interface diagrams showing aspects of user interfaces for facetted browsing, according to various illustrative embodiments. -
FIG. 7 is a computer architecture diagram illustrating an illustrative computer hardware and software architecture for a computing system capable of implementing aspects of the embodiments presented herein. -
FIG. 8 is a diagram illustrating a distributed computing environment capable of implementing aspects of the embodiments presented herein. -
FIG. 9 is a computer architecture diagram illustrating a computing device architecture capable of implementing aspects of the embodiments presented herein. - The following detailed description is directed to concepts and technologies for facetted browsing. Concepts and technologies are described herein for facetted browsing. In accordance with the concepts and technologies disclosed herein, a computer system can execute a visualization component. The visualization component can be included in a spreadsheet application and/or can be configured to present visualizations of spreadsheet data. The visualizations can include geospatial visualizations and overlay visualizations. As used herein, a “geospatial visualization” can include an animation scene or tour of multiple scenes that represent spreadsheet data on a globe, map, or other three-dimensional representation of location. As used herein, an “overlay visualization” can be linked to a geospatial visualization so as to enable a user to perform various actions to interact with spreadsheet data in a two-dimensional space and to see results of the interaction reflected in a three-dimensional space provided by the geospatial visualization. An overlay visualization can include a chart such as, but not limited to, a column chart, line chart, pie chart, bar chart, area chart, scatter plot, stock chart, surface chart, doughnut chart, bubble chart, radar chart, histogram, any variation thereof, any combination thereof, and/or the like. An overlay visualization can alternatively or additionally include one or more graphical user interface (“GUI”) elements such as buttons tabs, scroll bars, icons, menus, combinations thereof, and/or the like. An overlay visualization may overlay a geospatial visualization. Alternatively, an overlay visualization may be positioned above, below, or adjacent to a geospatial visualization.
- While the subject matter described herein is presented in the general context of program modules that execute in conjunction with the execution of an operating system and application programs on a computer system, those skilled in the art will recognize that other implementations may be performed in combination with other types of program modules. Generally, program modules include routines, programs, components, data structures, and other types of structures that perform particular tasks or implement particular abstract data types. Moreover, those skilled in the art will appreciate that the subject matter described herein may be practiced with other computer system configurations, including hand-held devices, multiprocessor systems, microprocessor-based or programmable consumer electronics, minicomputers, mainframe computers, and the like.
- In the following detailed description, references are made to the accompanying drawings that form a part hereof, and in which are shown by way of illustration specific embodiments or examples. Referring now to the drawings, in which like numerals represent like elements throughout the several figures, aspects of a computing system, computer-readable storage medium, and computer-implemented methodology for facetted browsing will be presented.
- Referring now to
FIG. 1 , aspects of oneoperating environment 100 for the various embodiments presented herein will be described. The operatingenvironment 100 shown inFIG. 1 includes acomputer system 102 operating as a part of and/or in communication with a communications network (“network”) 104. According to various implementations of the concepts and technologies disclosed herein, the functionality of thecomputer system 102 can be provided by a cloud-based computing platform that can be provided by one or more application servers, Web servers, data storage systems, network appliances, dedicated hardware devices, and/or other server computers or computing devices. - According to some other embodiments, the
computer system 102 can include a user computing device, such as a tablet computing device, a personal computer (“PC”), a desktop computer, a laptop computer, a notebook computer, a cellular phone or smartphone, other mobile computing devices, a personal digital assistant (“PDA”), or the like. Some example architectures of thecomputer system 102 are illustrated and described below with reference toFIGS. 7-9 . For purposes of illustrating and describing the concepts and technologies disclosed herein, the functionality of thecomputer system 102 is described herein as being provided by a server computer. In light of the above alternative embodiments of thecomputer system 102 described above, it should be understood that this example is illustrative, and should not be construed as being limiting in any way. - The
computer system 102 can be configured to execute anoperating system 106 and one or more application programs such as, for example, aspreadsheet application 108, avisualization component 110, and/or other application programs. Theoperating system 106 is a computer program for controlling the operation of thecomputer system 102. The application programs are executable programs configured to execute on top of theoperating system 106 to provide the functionality described herein for facetted browsing. - In particular, the
spreadsheet application 108 can be configured to create, manipulate, store, and/or otherwise interact with tabular or other structured data such as spreadsheets. According to some embodiments of the concepts and technologies disclosed herein, the functionality of thespreadsheet application 108 can be provided by a member of the MICROSOFT EXCEL family of spreadsheet applications from Microsoft Corporation of Redmond, Wash. In some other embodiments, the functionality of thespreadsheet application 108 can be provided by a database application, a data reporting application, a data presentation application, combinations thereof, or the like. - According to some implementations, the
spreadsheet application 108 can be executed by one or more server computers in thecomputer system 102, such as application servers and/or Web servers. Thus, the functionality of thespreadsheet application 108 can be accessed by other computing devices and/or accessed at thecomputer system 102. In the illustrated embodiment, the functionality of thespreadsheet application 108 can be accessed and/or interacted with by auser computing device 112. The functionality of theuser computing device 112 can be provided by, for example, a tablet computing device, a smartphone, a laptop computer, a desktop computer, other computing devices, combinations thereof, or the like. Theuser computing device 112 can communicate with thecomputer system 102 over one or more links or networks such as, for example, thenetwork 104, a private network, a direct wireless or wired connection, the Internet, and/or combinations of these and other networks and/or communication links. - Although not visible in
FIG. 1 , theuser computing device 112 can execute one or more client applications. The client applications can include Web browser applications and/or other applications for accessing thespreadsheet application 108 executing on thecomputer system 102. In some embodiments, thespreadsheet application 108 can be executed locally on theuser computing device 112 or other devices that can include the functionality of thecomputer system 102 described herein. Thespreadsheet application 108 can be implemented as hardware, software, and/or a combination of the two. Furthermore, thespreadsheet application 108 can include one or more application program modules and other components on theuser computing device 112, thecomputer system 102, and/or other computing platforms. As will be explained in more detail herein, thecomputer system 102 and/or theuser computing device 112 can generate and/or present one or more user interfaces (“UIs”) 114. TheUIs 114 can be provided to theuser computing device 112 for presentation to auser 116. - According to various embodiments, the
spreadsheet application 108 can be configured to generate, manipulate, and/or store tabular or other structured data that can be included inspreadsheet data 118. Thespreadsheet data 118 also can be stored in tables of a database, objects stored in an object store, or the like. While thespreadsheet data 118 is illustrated, thespreadsheet application 108 and/or thevisualization component 110 can be configured to generate, manipulate, and/or other types of data and metadata. Because the functionality of thespreadsheet application 108 is generally understood, thespreadsheet application 108 will not be described in additional detail herein. - In some embodiments, the
spreadsheet data 118 includes data that has been modeled in accordance with one or more data models. For example, thespreadsheet data 118 can include data modeled in accordance with a relational model that defines a relational organization among data tables. - According to various implementations, the
spreadsheet data 118 can be obtained by thecomputer system 102 from a local orremote data source 120. In some embodiments, thedata source 120 can include a memory, disk drive, or other data storage element of or associated with thecomputer system 102. In some other embodiments, such as the embodiment illustrated inFIG. 1 , thedata source 120 can include a network drive, a server computer operating as a part of and/or in communication with thenetwork 104, a database or other real or virtual data storage elements, and/or other data storage devices. As such, it should be understood that thedata source 120 can include almost any type of data storage device that is local to and/or remote from thecomputer system 102. - The
visualization component 110 can be configured to obtain thespreadsheet data 118 from thespreadsheet application 108 and/or directly from thedata source 120, and to generate, based upon thespreadsheet data 118, three-dimensional visualizations of thespreadsheet data 118 in a geographical and/or temporal context. In some embodiments, thevisualization component 110 can be implemented as a component of thespreadsheet application 108, and in some embodiments, thevisualization component 110 can be implemented as a component separate from the spreadsheet application. In some embodiments, thevisualization component 110 can be provided as a stand-alone application. Thus, while thespreadsheet application 108 and thevisualization component 110 are illustrated as components of thecomputer system 102, it should be understood that each of these components, or combinations thereof, may be embodied as or in stand-alone devices or components thereof operating on or in communication with thenetwork 104 and/or thecomputer system 102. Thus, the illustrated embodiment is illustrative, and should not be construed as being limiting in any way. - In some embodiments, the
visualization component 110 may be implemented as a plugin or add-in for thespreadsheet application 108. In some other embodiments, thevisualization component 110 can include a service and/or set of application programming interfaces (“APIs”) that can provide the functionality described herein. Thus, it should be appreciated that thevisualization component 110 can be implemented as hardware, software, or a combination thereof. - According to various embodiments of the concepts and technologies disclosed herein, the
visualization component 110 can be configured to access one ormore geocoding services 122. Thegeocoding services 122 can be configured to map geographical data included in thespreadsheet data 118 to geographic information. Thus, for example, thevisualization component 110 can provide geographical data included in thespreadsheet data 118 such as, for example, a street address, a city, a state, a ZIP code, or the like, to the geocoding services 122. Thegeocoding services 122 can map this geographical data to latitude and longitude information and/or other geocoded location data. Thus, it can be appreciated that thegeocoding services 122 can be called by thecomputer system 102 via one or more APIs exposed by thegeocoding services 122, though this is not necessarily the case. Furthermore, thegeocoding services 122 can be configured to providegeographic mapping data 124 representing mappings of the geographical data to the geocoded location data to thecomputer system 102, though this is not necessarily the case. - In some embodiments, the
visualization component 110 can access thegeocoding services 122 via one or more networks such as, for example, thenetwork 104, the Internet, other networks, and/or a combination thereof. In some other embodiments, thegeocoding services 122 can be implemented on thecomputer system 102. In one contemplated embodiment, thegeocoding services 122 are implemented as a component of thevisualization component 110. It should be understood that this embodiment is illustrative, and should not be construed as being limiting in any way. - The
visualization component 110 also can be configured to obtain and/oraccess map data 126. Themap data 126 can be used to provide geolocation and/or graphical data for the creation of the three-dimensional geographical maps as described herein. Thevisualization component 110 may be configured to obtain or access themap data 126 from or at a computing device such as, for example, amap server 128. In some embodiments, the functionality of themap server 128 can be provided by a mapping application executed by a search engine such as the BING search engine from Microsoft Corporation in Redmond, Wash. Because the functionality of themap server 128 can be provided by additional and/or other devices and/or applications, it should be understood that this embodiment is illustrative, and should not be construed as being limiting in any way. - The
computer system 102 can access themap server 128 via one or more networks such as, for example, thenetwork 104. In some embodiments, thevisualization component 110 can be configured to access map tiles from themap data 126, and to stich the map tiles together over a three-dimensional globe armature to create a three-dimensional geographic globe. Thevisualization component 110 can be configured to use geocoded location data such as latitude and longitude data from thegeocoding services 122 to place visualizations of data included in thespreadsheet data 118 on the three-dimensional geographic globe. As such, various embodiments of thevisualization component 110 can be configured to generate displays of geographic data in three-dimensional geospatial visualizations. - As used herein, a “geospatial visualization” can include an animation scene or tour of multiple scenes that represent the
spreadsheet data 118 on a globe, map, or other three-dimensional representation of location. Thespreadsheet data 118 can be displayed on the globe, map, or the like at points corresponding to geographic location data included in thespreadsheet data 118. The geospatial visualization also can show data changes over time. - The
visualization component 110 also can be configured to generate one or more two-dimensional visualizations of thespreadsheet data 118. Theuser 116 can more easily browse thespreadsheet data 118 displayed within a geospatial visualization by interacting with at least a portion of thespreadsheet data 118 displayed within a two-dimensional space provided by one or more two-dimensional visualizations that overlay the geospatial visualization. An “overlay visualization” can be linked to a geospatial visualization so as to enable a user to perform various actions to interact with thespreadsheet data 118 in a two-dimensional space and to see results of the interaction reflected in a three-dimensional space provided by the geospatial visualization. An overlay visualization can include a chart such as, but not limited to, a column chart, line chart, pie chart, bar chart, area chart, scatter plot, stock chart, surface chart, doughnut chart, bubble chart, radar chart, histogram, any variation thereof, any combination thereof, and/or the like. An overlay visualization can alternatively or additionally include one or more graphical user interface (“GUI”) elements such as buttons tabs, scroll bars, icons, menus, combinations thereof, and/or the like. It should be understood that while an overlay visualization can represent thespreadsheet data 118 in a two-dimensional space, elements of the overlay visualization, such as bars in a bar chart, might be generated to appear three-dimensional, have shadow effects, or to have other effects that enhance the visual appeal of the overlay visualization. An overlay visualization may overlay a geospatial visualization. Alternatively, an overlay visualization may be positioned above, below, or adjacent to a geospatial visualization. - The
visualization component 110 also can be configured to provide the functionality described herein for facetted browsing. As used herein, “facetted browsing” can generally include a selection or other interaction with at least a portion of thespreadsheet data 118 that is represented within two-dimensional space via one or more overlay visualizations to easily interact with at least a corresponding portion of thespreadsheet data 118 that is represented within three-dimensional space via a geospatial visualization. Facetted browsing can enable theuser 116 to browse thespreadsheet data 118 in two-dimensional space and three-dimensional space spatially, temporarily, and categorically. - The
user 116 may interact with thespreadsheet application 108 and thevisualization component 110 to create and/or navigate a three-dimensional visualization of thespreadsheet data 118 through a display of theuser computing device 112. Theuser 116 also may interact with thespreadsheet application 108 and thevisualization component 110 to create and/or navigate an overlay visualization of thespreadsheet data 118 through a display of theuser computing device 112. Theuser 116 can interact with thespreadsheet application 108 and thevisualization component 110 to perform actions to at least a portion of thespreadsheet data 118 presented on an overlay visualization and see results of the action on corresponding representations of the portion of thespreadsheet data 118 presented on the geospatial visualization. In some embodiments, theuser 116 may use one or more input devices of theuser computing device 112 such as a touchscreen, a keyboard, a mouse, a game controller, combinations thereof, or the like. TheUIs 114 can be presented on the touchscreen, a monitor, a display, other display surfaces or devices, combinations thereof, or the like. - A user can interact with one or more overlay visualizations through actions such as, but not limited to, brushing, selection, filtering, and comparison. As used herein, a “brushing action” can include a mouse click, touch, touch gesture, or other user input directed to an item on an overlay visualization that is representative of at least a portion of the spreadsheet data 118 (e.g., a bar of a bar chart) to emphasize a corresponding portion of the
spreadsheet data 118 that is represented on a geospatial visualization. A brushing action can emphasize a brushed over item or a portion thereof within the overlay visualization as well as the corresponding portion of thespreadsheet data 118 associated with the item within the geospatial visualization. The emphasis applied to the portion of thespreadsheet data 118 shown in the overlay visualization can be the same as or different from the emphasis applied to the corresponding portion of thespreadsheet data 118 shown in the geospatial visualization. An emphasis can include, but is not limited to, a highlight, an animation, a color change, a size change, an embossment, any other visually emphatic item, or any combination thereof. In some embodiments, an emphasis can include an accompanying sound such as, for example, a pre-defined sound that is associated with the application of an emphasis to at least a portion of thespreadsheet data 118. In some embodiments, an emphasis is not directly applied but inherent because other data (e.g., surrounding data points on a geospatial visualization) is deemphasized or no longer displayed. - In some embodiments, data shown in a geospatial visualization and/or in an overlay visualization is shown in aggregated or summary form. In these embodiments, an action performed on one of the visualizations that shows aggregated data may not reflect a one-to-one change on the other visualization, and instead may reflect a one-to-many change to account for the aggregated data that may span multiple categories, for example.
- As used herein, a “selection” can include a mouse click, touch, touch gesture, speech input, or other user input used to choose an item from an overlay visualization for receipt of another action to be applied to the chosen item, such as, for example, the application or removal of one or more filters. As used herein, a “filter” can include one or more conditions that are to be applied to the
spreadsheet data 118 so that only a portion of thespreadsheet data 118 is displayed on one or more overlay visualizations and the geospatial visualization. - As explained above, an overlay visualization might include a bar chart. For ease of explanation and not limitation, the following example describes an overlay visualization that includes a bar chart. The bar chart can include one or more bars, each of which is associated with a portion of the
spreadsheet data 118 that is displayed on a geospatial visualization that is linked to the bar chart. Theuser 116 can brush over a bar of the bar chart, and in response, thevisualization component 110 can cause the overlay visualization to emphasize the brushed over bar and the corresponding portion of thespreadsheet data 118 that is displayed on the geospatial visualization. Theuser 116 can then choose one or more filters to apply to the selected bar and the corresponding portion of thespreadsheet data 118, thereby filtering thespreadsheet data 118 displayed on the geospatial visualization via the overlay visualization. In response to the application of one or more filters to the selected bar, a filtered portion of thespreadsheet data 118 can be emphasized on the geospatial visualization to distinguish the filtered portion of thespreadsheet data 118 from a remaining portion of thespreadsheet data 118. - As a more concrete, real-world example, the
spreadsheet data 118 might include arrest data for a particular city over a particular time period, and each data point represented within a geospatial visualization might represent an arrest. Theuser 116 may desire to filter thespreadsheet data 118 so that only certain types of arrests, such as drug arrests, are displayed on the geospatial visualization. Theuser 116 can select a filter to cause thecomputer system 102 to execute thevisualization component 110 to display only a portion of thespreadsheet data 118 that is related to drug arrests. The result of applying such a filter might be thevisualization component 110 applying an emphasis to the drug-related arrests within the geospatial visualization to distinguish the drug-related arrests from arrests associated with other arrest categories, such as homicide or robbery. - In the above example, the overlay visualization might display the drug-related arrests as different drug categories that the
user 116 can select to further filter thespreadsheet data 118 represented within the geospatial visualization. Each of these categories may be displayed within the overlay visualization, for example, as bars within a bar chart. When theuser 116 brushes over any of the bars, the brushed-over bar can become emphasized and the corresponding portion of thespreadsheet data 118 that is represented on the geospatial visualization also can be emphasized so as to distinguish drug arrests of the drug category associated with the brushed-over bar from the other drug categories displayed within the overlay visualization. Theuser 116 may also desire to further filter thespreadsheet data 118 to show drug arrests within a particular drug category that occurred on a specific date or during a specific date range. Theuser 116 may also desire to further filter thespreadsheet data 118 to show drug arrests within a particular drug category that occurred on a specific date or during a specific date range and at a specific time or during a specific time range. As theuser 116 selects filters, thespreadsheet data 118 that adheres to the condition(s) specified by the filters can be emphasized on the geospatial visualization. - A “time range” can be used herein to refer to a time duration of the data points that is to be represented in the visualization. The time range can be determined based upon an analysis of the
spreadsheet data 118 and/or can be specified by a user or other entity. For example, a user can specify a time range based upon a determination a duration of time over which the user wishes to present the data. Thus, a user may specify a time range of particular interest such as, for example, a particular hour, day, week, month, quarter, year, decade, century, or the like. Because the time range can be specified as additional and/or alternative amounts of time, it should be understood that this embodiment is illustrative, and should not be construed as being limiting in any way. - In some embodiments, the
computer system 102 can determine the time range over which to show the visualization based upon thespreadsheet data 118. In particular, the computer system can be configured to determine an earliest time included in thespreadsheet data 118 and a latest time included in thespreadsheet data 118, and to define the time range as being bound by these two times. Thus, for example, if the earliest time data associated with thespreadsheet data 118 corresponds to Jan. 1, 2014 and the latest time data associated with thespreadsheet data 118 corresponds to Jan. 1, 2015, thecomputer system 102 can determine that the time range is to correspond to one year beginning on Jan. 1, 2014. - In yet other embodiments, the
computer system 102 can determine a time range based upon an analysis of thespreadsheet data 118 and assumptions as to what time ranges are likely to be of interest to a user or other entity. Thus, for example, if a data set includes one hundred data points, with ninety of the data points occurring within a one month range and the remainder of the data points occurring over a year period before and/or after the one month range, thecomputer system 102 may determine that the one month range is to be defined as the time range, and that the other data points are not to be represented in the visualization. This example is illustrative and should not be construed as being limiting in any way. - “Animation speed” can refer to a rate at which data points are presented in the visualization. In particular, the
computer system 102 can be configured to present thespreadsheet data 118 in a visualization over a default time. In some embodiments, the default time can correspond to ten seconds, twenty seconds, thirty seconds, other times, or the like. The default time can be specified by a user, application setting, preferences, or the like, and/or can be based upon an assumption that a user or other viewer wishes to watch an animated sequence for a time corresponding to the default time. Thus, whether thespreadsheet data 118 includes three hundred records or three thousand records, the animation can last the defined duration. - To meet the defined duration, the
computer system 102 and/or a user can adjust the animation speed. In the above example of a thirty second duration and three hundred data points, the animation speed can correspond to ten data points (or animation frames) per second. In the other example of three thousand data points and thirty seconds, the animation speed can correspond to one hundred data points per second. It should be understood that these embodiments are illustrative, and should not be construed as being limiting in any way. - In some embodiments, however, the
computer system 102 can be configured to impose a maximum animation speed such as, for example, fifteen milliseconds. Thus, the animation speed can be limited by thecomputer system 102, in some embodiments, to approximately sixty-six data points per second. In some implementations, this maximum animation speed can be imposed to allow thecomputer system 102 resources to draw each animation frame without negatively impacting performance of thecomputer system 102. Because the maximum animation speed can be omitted and/or can correspond to other rates, it should be understood that this embodiment is illustrative, and should not be construed as being limiting in any way. - According to various embodiments, the
computer system 102 can obtainspreadsheet data 118 from a data source such as thedata source 120. Thespreadsheet data 118 can include a set of data points (“data set”) having values, temporal values such as time stamps, and location information. As such, a particular data point of the data set can include a value, a corresponding location, and a corresponding time. Thecomputer system 102 can identify a time component of thespreadsheet data 118, and generate a visualization of thespreadsheet data 118 based upon at least the time component. - In some embodiments, the application of one or more filters is incremental so that the
user 116 can explore various facets (e.g., categories, categories within categories, temporal aspects, and/or other aspects) of thespreadsheet data 118 to discover potential insights, which might lead theuser 116 to identify patterns within thespreadsheet data 118 and/or might lead theuser 116 to further explore within selected facets or other facets of thespreadsheet data 118. By linking one or more overlay visualizations to a geospatial visualization, the difficulty of browsing data points within a three-dimensional space is mitigated or eliminated, but theuser 116 maintains the benefits of viewing a visual representation of thespreadsheet data 118 within a geospatial visualization. -
FIG. 1 illustrates onecomputer system 102, onenetwork 104, oneuser computing device 112, onedata source 120, one instance ofgeocoding services 122, and onemap server 128. It should be understood, however, that some implementations of the operatingenvironment 100 can includemultiple computer systems 102,multiple networks 104, multipleuser computing devices 112,multiple data sources 120, multiple instances of thegeocoding services 122, and/ormultiple map servers 128. As such, the illustrated embodiment of the operating environment should be understood as being illustrative, and should not be construed as being limiting in any way. - Turning now to
FIG. 2 , additional aspects of thevisualization component 110 will be presented, according to one illustrative embodiment. In particular,FIG. 2 provides further details regarding architecture and subcomponents of thevisualization component 110, according to some embodiments. Thevisualization component 110 can include a number of components and/or subsystems including, but not limited to, avisualization control 200, avisualization engine 202, aspreadsheet plugin core 204, and/or other components and/or subsystems. - The
visualization control 200 can include functionality for representing data, performing searches and/or providing search services, a globe control for visualizing and/or presenting representations of the globe, video recording functionality for recording animations and/or videos of illustrated tours, and a client. Thevisualization engine 202 can include functionality for generating a tour including multiple scenes, images, and/or animation sequences; functionality for measuring and/or representing time in the visualization space; an engine core for providing the visualization component functionality described herein; annotations functionality for generating and/or rendering two-dimensional and/or three-dimensional annotations; spatial indexing functionality; and camera functionality. Thevisualization engine 202 also can include globe models and/or functionality for representing the globe; input and touch modules for interpreting touch and/or multi-touch commands as input; visual layers functionality for representing and/or interacting with layers of a visualization space; a tile cache for storing map tiles; a three-dimensional graphics module for generating and/or rendering three-dimensional visualizations; and shaders for providing shading of generated and/or rendered three-dimensional objects. - As used herein, a “layer” of a scene can correspond to a set of data having data values, geographic information, and time information. Thus, a particular scene may include multiple layers corresponding to, for example, household income and income tax rate over time at a number of geographic locations. Thus, by showing multiple layers in a visualization, a user or other entity may view changes in both types of data over time and with respect to location. It should be understood that this embodiment is illustrative, and should not be construed as being limiting in any way.
- In some embodiments, a layer includes a geospatial visualization and one or more overlay visualizations. The one or more overlay visualizations may overlay at least a portion of the geospatial visualization.
- In some embodiments, the shaders can include or implement a number of algorithms to facilitate the rendering of the three-dimensional geographical visualizations of data described herein. For example, the
visualization component 110 can implement a dark aura effect for disambiguating visualization of a number of similarly colored objects. A dark aura effect can include a visual treatment that allows a viewer, for example theuser 116, to differentiate between items in a three-dimensional visualization space. When there are multiple, similarly colored columns in a three-dimensional visualization or view, some of these columns may be next to and/or behind one another in the three-dimensional view. Thus, the multiple columns may appear to be grouped together and/or may look like a single polygon. In some embodiments of the concepts and technologies disclosed herein, the dark aura effect can be added around one or more of the columns, thereby allowing the one or more columns to appear to stand out from one another. Because other visual effects are possible and are contemplated, it should be understood that this example is illustrative, and should not be construed as being limiting in any way. - In another example, the
visualization component 110 may implement a GPU-based framework for asynchronous hit testing for large number of arbitrary three-dimensional elements. This may comprise adding “out-of-channel” color information to pixels of the objects rendered in the three-dimensional visualization that may be invisible to the viewer, but can contain information identifying the object. Thus, if a user taps, clicks, or otherwise interacts with a point in the three-dimensional visualization, the identity of the object represented by the selected pixel can be known without deconstructing the three-dimensional visualization and determining the object rendered at the selected location. This may be implemented in the GPU. - The
spreadsheet plugin core 204 can include functionality for storing workbook state information, as well as a query engine for generating and/or executing queries against various data sources. In some embodiments, the query engine can be configured to generate a query based upon data stored in thespreadsheet data 118, and to submit the queries to a query engine. It should be understood that this embodiment is illustrative, and should not be construed as being limiting in any way. - The
visualization component 110 also can include various other components and/or subsystems such as, for example, a spreadsheet program native plugin and a spreadsheet program command object model (“COM”) API. Thevisualization component 110 also can include various graphics plugins and/or APIs such as the illustrated DIRECTX APIs, API call emulators such as the illustrated DIRECTX WRAPPER, a WINDOWS Presentation Foundation (“WPF”) subsystem, combinations thereof, or the like. Thevisualization component 110 also can include analytics engines such as the illustrated VERTIPAQ engine and/or modules associated with other data providers, if desired. It should be appreciated that thevisualization component 110 can include additional and/or alternative functionality not shown inFIG. 2 . As such, the embodiment illustrated inFIG. 2 should be understood as being illustrative and should not be construed as being limiting in any way - Turning now to
FIG. 3 , aspects of amethod 300 for facetted browsing will be described in detail. It should be understood that the operations of the methods disclosed herein are not necessarily presented in any particular order and that performance of some or all of the operations in an alternative order(s) is possible and is contemplated. The operations have been presented in the demonstrated order for ease of description and illustration. Operations may be added, omitted, and/or performed simultaneously, without departing from the scope of the appended claims. - It also should be understood that the illustrated methods disclosed herein can be ended at any time and need not be performed in their respective (or collective) entireties. Some or all operations of the methods disclosed herein, and/or substantially equivalent operations, can be performed by execution of computer-readable instructions included on a computer-storage media, as defined herein. The term “computer-readable instructions,” and variants thereof, as used in the description and claims, is used expansively herein to include routines, applications, application modules, program modules, programs, components, data structures, algorithms, and the like. Computer-readable instructions can be implemented on various system configurations, including single-processor or multiprocessor systems, minicomputers, mainframe computers, personal computers, hand-held computing devices, microprocessor-based, programmable consumer electronics, combinations thereof, and the like.
- Thus, it should be appreciated that the logical operations described herein are implemented (1) as a sequence of computer implemented acts or program modules running on a computing system and/or (2) as interconnected machine logic circuits or circuit modules within the computing system. The implementation is a matter of choice dependent on the performance and other requirements of the computing system. Accordingly, the logical operations described herein are referred to variously as states, operations, structural devices, acts, or modules. These operations, structural devices, acts, and modules may be implemented in software, in firmware, in special purpose digital logic, and any combination thereof.
- For purposes of illustrating and describing the concepts of the present disclosure, the methods disclosed herein are described as being performed by the
computer system 102 via execution of one or more software modules such as, for example, thevisualization component 110. It should be understood that additional and/or alternative devices and/or network nodes can provide the functionality described herein via execution of one or more modules, applications, and/or other software including, but not limited to, thevisualization component 110. Thus, the illustrated embodiments are illustrative, and should not be viewed as being limiting in any way. - The
method 300 begins atoperation 302, wherein thecomputer system 102 obtains data such as thespreadsheet data 118. As explained above, thespreadsheet data 118 can include various types of information or content such as, for example, spreadsheet files, database application data, and/or other types of information. In one contemplated embodiment, thespreadsheet data 118 corresponds to a spreadsheet file such as a file generated by a member of the MICROSOFT EXCEL family of spreadsheet application software products from Microsoft Corporation in Redmond, Wash. Thespreadsheet data 118 can be obtained from a data storage device or component associated with thecomputer system 102. Some examples of data storage devices are described in more detail below with reference toFIGS. 7-9 . In some other embodiments, thespreadsheet data 118 can be stored at or hosted by a remote storage device or resource such as thedata source 120 described herein. Thus, thespreadsheet data 118 can be obtained by thecomputer system 102 via communications with thedata source 120. As such, it should be understood that thespreadsheet data 118 can be obtained from any real or virtual device via a direct connection, via one or more networks, and/or via other nodes, devices, and/or device components. - From
operation 302, themethod 300 proceeds tooperation 304, wherein thecomputer system 102 generates one or more geospatial visualizations of the data obtained atoperation 302. Atoperation 304, thecomputer system 102 can determine, based upon preferences, options, configuration settings, user input, combinations thereof, or the like, what should be displayed within the geospatial visualization. For example, the default portion of a globe or other three-dimensional location that is to be displayed, how the data is to be displayed on the geospatial visualization, the color theme to be utilized, whether or not the data has a time component, and the like. Moreover, atoperation 304, thecomputer system 102 can generate one or more data labels for the geospatial visualization. The data labels can include text, images, or other representations that specify what the data represent in the geospatial visualization. Thus, the labels can include, for example, a data type, a data name, location information, color information, data value labels, combinations thereof, or the like. - From
operation 304, themethod 300 proceeds tooperation 306, wherein thecomputer system 102 presents the one or more geospatial visualizations of the data. As explained above, a geospatial visualization can be presented in or as aUI 114 presented at theuser computing device 112 and/or other computing devices. TheUI 114 can be presented by or on a display, a touchscreen, a monitor, a projector, and/or other display device. - From
operation 306, themethod 300 proceeds tooperation 308, wherein thecomputer system 102 receives an input to view one or more overlay visualizations. Fromoperation 308, themethod 300 proceeds tooperation 310, wherein thecomputer system 102 generates one or more overlay visualizations of the data obtained atoperation 302. Fromoperation 310, themethod 300 proceeds tooperation 312, wherein thecomputer system 102 presents the one or more overlay visualizations of the data. As explained above, an overlay visualization can be presented in or as aUI 114 presented at theuser computing device 112 and/or other computing devices. TheUI 114 can be presented by or on a display, a touchscreen, a monitor, a projector, and/or other display device. - From
operation 312, themethod 300 proceeds tooperation 314, wherein thecomputer system 102 receives an input via the one or more overlay visualizations to perform an action. The input can be to perform an action such as brushing, selection, filtering, and/or comparison, as described in further detail above. Fromoperation 314, themethod 300 proceeds tooperation 316, wherein thecomputer system 102 updates the one or more geospatial visualizations in response to the input. For example, if the input received by thecomputer system 102 atoperation 314 is a brushing action over a bar of bar chart included in the overlay visualization, the data associated with the brushed over bar can be emphasized on the geospatial visualization. In some embodiments, one, some, or all of the geospatial visualizations are updated. Fromoperation 316, themethod 300 proceeds tooperation 318, wherein thecomputer system 102 presents one or more updated geospatial visualizations of the data. As explained above, a geospatial visualization can be presented in or as aUI 114 presented at theuser computing device 112 and/or other computing devices. TheUI 114 can be presented by or on a display, a touchscreen, a monitor, a projector, and/or other display device. - From
operation 318, themethod 300 proceeds tooperation 320. Themethod 300 ends atoperation 320. - Although not shown in
FIG. 3 , it should be understood that thecomputer system 102 can receive an input via the one or more geospatial visualizations to perform an action. The input can be to perform an action such as, for example, brushing, selection, filtering, and/or comparison. In response to receiving the input, thecomputer system 102 can update the one or more overlay visualizations and present the one or more updated overlay visualizations. As such, the illustrated embodiment ofFIG. 3 , wherein thecomputer system 102 receives an input via the one or more overlay visualizations is illustrative, and should not be construed as being limiting in any way. - Turning now to
FIG. 4 , aspects of amethod 400 for filtering data via an overlay visualization that is linked to a geospatial visualization will be described in detail. Themethod 400 begins atoperation 402, wherein thecomputer system 102 presents a geospatial visualization of data, such as thespreadsheet data 118. Fromoperation 402, themethod 400 proceeds tooperation 404, wherein thecomputer system 102 presents an overlay visualization of the data. As explained above, the geospatial visualization and the overlay visualization can be presented in or as aUI 114 presented at theuser computing device 112 and/or other computing devices. TheUI 114 can be presented by or on a display, a touchscreen, a monitor, a projector, and/or other display device. - From
operation 404, themethod 400 proceeds tooperation 406, wherein thecomputer system 102 receives an input via the overlay visualization to filter the data. Fromoperation 406, themethod 400 proceeds tooperation 408, wherein thecomputer system 102 filters the data according to the input received atoperation 406. Fromoperation 408, themethod 400 proceeds tooperation 410, wherein thecomputer system 102 presents the geospatial visualization and the overlay visualization of the filtered data. - From
operation 410, themethod 400 proceeds tooperation 412, wherein thecomputer system 102 determines if an input to further filter the data is received. If thecomputer system 102 does not receive an input to further filter the data, themethod 400 proceeds tooperation 414. Themethod 400 ends atoperation 414. - If the
computer system 102 receives an input to further filter the data, themethod 400 proceeds tooperation 416, wherein thecomputer system 102 further filters the data according to the input. Fromoperation 416, themethod 400 proceeds tooperation 418, wherein thecomputer system 102 presents the geospatial visualization and the overlay visualization of the further filtered data. Themethod 400 then returns tooperation 412, wherein thecomputer system 102 again determines if an input to further filter the data is received.Operation 412,operation 416, andoperation 418 can be repeated any number of times to accommodate the application of any number of filters to the data. After no further filter is to be applied, themethod 400 ends atoperation 414. - Although not shown in
FIG. 4 , it should be understood that thecomputer system 102 can take additional actions to remove previously applied filters. For example, after the filter is applied atoperation 408 or a further filter is applied atoperation 416, thecomputer system 102 can receive another input to remove one or more previously applied filters. It is contemplated that thecomputer system 102 can receive inputs to apply and remove inputs any number of filters. As such, the illustrated embodiment ofFIG. 4 , wherein thecomputer system 102 applies filters but does not then remove filters is illustrative, and should not be construed as being limiting in any way. - Turning now to
FIG. 5 , aspects of amethod 500 for filtering data via a geospatial visualization that is linked to an overlay visualization will be described in detail. Themethod 500 begins atoperation 502, wherein thecomputer system 102 presents a geospatial visualization of data, such as thespreadsheet data 118. Fromoperation 502, themethod 500 proceeds tooperation 504, wherein thecomputer system 102 presents an overlay visualization of the data. As explained above, the geospatial visualization and the overlay visualization can be presented in or as aUI 114 presented at theuser computing device 112 and/or other computing devices. TheUI 114 can be presented by or on a display, a touchscreen, a monitor, a projector, and/or other display device. - From
operation 504, themethod 500 proceeds tooperation 506, wherein thecomputer system 102 receives an input via the geospatial visualization to filter the data. Fromoperation 506, themethod 500 proceeds tooperation 508, wherein thecomputer system 102 filters the data according to the input received atoperation 506. Fromoperation 508, themethod 500 proceeds tooperation 510, wherein thecomputer system 102 presents the geospatial visualization and the overlay visualization of the filtered data. - From
operation 510, themethod 500 proceeds tooperation 512, wherein thecomputer system 102 determines if an input to further filter the data is received. If thecomputer system 102 does not receive an input to further filter the data, themethod 500 proceeds tooperation 514. Themethod 500 ends atoperation 514. - If the
computer system 102 receives an input to further filter the data, themethod 500 proceeds tooperation 516, wherein thecomputer system 102 further filters the data according to the input. Fromoperation 516, themethod 500 proceeds tooperation 518, wherein thecomputer system 102 presents the geospatial visualization and the overlay visualization of the further filtered data. Themethod 500 then returns tooperation 512, wherein thecomputer system 102 again determines if an input to further filter the data is received.Operation 512,operation 516, andoperation 518 can be repeated any number of times to accommodate the application of any number of filters to the data. After no further filter is to be applied, themethod 500 ends atoperation 514. - Although not shown in
FIG. 5 , it should be understood that thecomputer system 102 can take additional actions to remove previously applied filters. For example, after the filter is applied atoperation 508 or a further filter is applied atoperation 516, thecomputer system 102 can receive another input to remove one or more of the applied filters. It is contemplated that thecomputer system 102 can receive inputs to apply and remove inputs any number of filters. As such, the illustrated embodiment ofFIG. 5 , wherein thecomputer system 102 applies filters but does not then remove filters is illustrative and should not be construed as being limiting in any way. - Turning now to
FIGS. 6A-6C , UI diagrams showing various aspects of the concepts and technologies disclosed herein for facetted browsing will be described according to various illustrative embodiments.FIG. 6A shows anillustrative screen display 600A generated by a device such as thecomputer system 102 and/or theuser computing device 112. In some embodiments, thescreen display 600A can correspond to theUI 114 displayed by theuser computing device 112, as shown inFIG. 1 , though this is not necessarily the case. It should be appreciated that the UI diagram illustrated inFIG. 6A is illustrative of one contemplated example, and therefore should not be construed as being limited in any way. - As shown in
FIG. 6A , thescreen display 600A can include a three-dimensional geospatial visualization (“geospatial visualization”) 602 and a two-dimensional overlay visualization (“overlay visualization”) 604 of data such as thespreadsheet data 118 described herein. More particularly, thescreen display 600A is illustrated as displaying a globe with multiple data points illustrated on the globe in their corresponding locations and/or magnitudes as data points 606. The data points 606 are also represented at least in part by theoverlay visualization 604. Thegeospatial visualization 602 and theoverlay visualization 606 are linked together so that interaction with thespreadsheet data 118 via theoverlay visualization 606 is reflected on thegeospatial visualization 602, and vice versa. Because thespreadsheet data 118 can be illustrated in additional and/or alternative structures other than the illustrateddata points 606, it should be understood that the illustrated example is illustrative. - The
overlay visualization 604 can include a chart such as, but not limited to, a column chart, line chart, pie chart, bar chart, area chart, scatter plot, stock chart, surface chart, doughnut chart, bubble chart, radar chart, histogram, any variation thereof, any combination thereof, and/or the like. The overlay visualization 64 can alternatively or additionally include one or more GUI elements such as buttons tabs, scroll bars, icons, menus, combinations thereof, and/or the like. In the illustrated embodiment, theoverlay visualization 604 includes abar chart 608 and aUI control 610. The illustratedbar chart 608 includes a plurality of bars, each of which can represent a portion of the data points 604 shown on thegeospatial visualization 602. TheUI control 610 can allow a user to access settings, properties, controls, and/or other information regarding thegeospatial visualization 602 and theoverlay visualization 604 via a visualization component properties or settings bar (“settings bar”) 612. - The settings bar 612 can be presented, for example, in response to a user or other entity selecting the
UI control 610. The settings bar 612 is illustrated as displaying various properties associated with thegeospatial visualization 602 and theoverlay visualization 604 presented on thescreen display 600A. As shown inFIG. 6A , a user or other entity has selected anoption 614 to filter and display thespreadsheet data 118 based upon categories associated with thespreadsheet data 118. Each bar of thebar chart 608 can represent a category. For example, thespreadsheet data 118 might be drug arrest data within which there are a plurality of categories that are each representative of a type of drug. In this example, each bar of thebar chart 608 might represent a type of drug. Other options such as “Zip”, “State”, “Ticket ID”, “Date”, and “Time” are shown. These options can be selected by a user or other entity to apply one or more filters to thespreadsheet data 118. For example, a user might select time to further filter thespreadsheet data 118 based upon time. - The settings bar 612 also includes
overlay options 616. The illustrated embodiment shows theoverlay options 616 including a show/hide overlay option 618, a show/hide overlay labelsoption 620, and anoverlay type option 622. The show/hide overlay option 618 is shown in a selected state so that theoverlay visualization 604 is presented on thescreen display 600A. In an unselected state, the show/hide overlay option 618 causes theoverlay visualization 604 to be hidden from thescreen display 600A. It is contemplated that other means to show/hide theoverlay visualization 604 may be used, including, for example, keyboard shortcuts, touch gestures, speech recognition, or the selection of other GUI elements (not shown). - The show/hide labels
option 620 is shown in an unselected state so that labels associated with thebar chart 608 are not shown. In a selected state, the show/hide labels option 620 causes labels to be shown within theoverlay visualization 604. The labels can provide additional details about the data represented in theoverlay visualization 604. For example, the labels may label the axes of thebar chart 608 and/or provide additional details about the data represented in the bars of thebar chart 608. It is contemplated that other means to show/hide labels within theoverlay visualization 604 may be used, including, for example, keyboard shortcuts, touch gestures, speech recognition, or the selection of other GUI elements (not shown). - The
overlay type option 622 allows a user or other entity to select the type of chart or other visualization that is to be shown within theoverlay visualization 604. In the illustrated example, a user has selected a bar chart overlay type, and thespreadsheet data 118 is shown in thebar chart 608 as a result. - In the illustrated embodiment, the
screen display 600A can be presented on a touch-sensitive and/or multi-touch-sensitive display associated with a device such as thecomputer system 102 and/or theuser computing device 112. For purposes of illustration, and not limitation, a user'sfinger 624 is illustrated proximate to thescreen display 600A as if about to initiate an interaction with thescreen display 600A. Because other input devices or structures can be used in accordance with the concepts and technologies disclosed herein, it should be understood that this embodiment is illustrative, and should not be construed as being limiting in any way. - Referring now to
FIG. 6B , a UI diagram showing additional aspects of the concepts and technologies disclosed herein for facetted browsing is described in detail. In particular,FIG. 6B shows ascreen display 600B generated by a device such as thecomputer system 102 and/or theuser computing device 112. In some embodiments, thescreen display 600B corresponds to one or more of theUIs 114 shown inFIG. 1 and described above with reference toFIGS. 1-6A . It should be appreciated that the UI diagram illustrated inFIG. 6B is illustrative of one contemplated embodiment, and therefore should not be construed as being limited in any way. - In
FIG. 6B , a user or other entity has selected or brushed over abar 626 of thebar chart 608. In response, thescreen display 600B shows thebar 626 in an emphasized state, which is illustrated by thebar 626 having a different hatching pattern than that of the other bars of thebar chart 608. Asubset 628 of the data points 606 is also shown in the same emphasized state to convey to the user that thesubset 628 is associated with thebar 626. In a similar manner, the user can brush over any of the other bars to emphasize other subsets of the data points 606 on theoverlay visualization 604 and thegeospatial visualization 602. - Turning now to
FIG. 6C , a UI diagram showing additional aspects of the concepts and technologies disclosed herein for facetted browsing is described in detail. In particular,FIG. 6C shows ascreen display 600C generated by a device such as thecomputer system 102 and/or theuser computing device 112. In some embodiments, thescreen display 600C corresponds to one or more of theUIs 114 shown inFIG. 1 and described above with reference toFIGS. 1-6B . It should be appreciated that the UI diagram illustrated inFIG. 6C is illustrative of one contemplated embodiment, and therefore should not be construed as being limited in any way. - In
FIG. 6C , another way in which a user can select thesubset 628 is illustrated. In particular, the user'sfinger 624 is positioned at apoint 630, and anotherfinger 632 is dragged outward from thepoint 630 to define a radius of acircular area 632, thereby selecting and emphasizing each data point of thesubset 628. Thebar 626 that is associated with thesubset 628 of data points is also emphasized. It should be appreciated that other touch gestures, mouse inputs, speech inputs, or other inputs can be used to provide similar functionality for the selection of at least a portion of the data points 606 via thegeospatial visualization 602. -
FIG. 7 illustrates anillustrative computer architecture 700 for a device capable of executing the software components described herein for facetted browsing. Thus, thecomputer architecture 700 illustrated inFIG. 7 illustrates an architecture for a server computer, mobile phone, a PDA, a smart phone, a desktop computer, a netbook computer, a tablet computer, and/or a laptop computer. Thecomputer architecture 700 may be utilized to execute any aspects of the software components presented herein. - The
computer architecture 700 illustrated inFIG. 7 includes a central processing unit 702 (“CPU”), asystem memory 704, including a random access memory 706 (“RAM”) and a read-only memory (“ROM”) 708, and asystem bus 710 that couples thememory 704 to theCPU 702. A basic input/output system containing the basic routines that help to transfer information between elements within thecomputer architecture 700, such as during startup, is stored in theROM 708. Thecomputer architecture 700 further includes amass storage device 712 for storing the operating system 107 and one or more application programs including, but not limited to, thespreadsheet application 108, thevisualization component 110, other application programs, or the like. Although not shown inFIG. 7 , themass storage device 712 also can be configured to store thespreadsheet data 118, thegeographic mapping data 124, the map data 127, and/or graphical data corresponding to one or more of theUIs 114 described herein, if desired. - The
mass storage device 712 is connected to theCPU 702 through a mass storage controller (not shown) connected to thebus 710. Themass storage device 712 and its associated computer-readable media provide non-volatile storage for thecomputer architecture 700. Although the description of computer-readable media contained herein refers to a mass storage device, such as a hard disk or CD-ROM drive, it should be appreciated by those skilled in the art that computer-readable media can be any available computer storage media or communication media that can be accessed by thecomputer architecture 700. - Communication media includes computer readable instructions, data structures, program modules, or other data in a modulated data signal such as a carrier wave or other transport mechanism and includes any delivery media. The term “modulated data signal” means a signal that has one or more of its characteristics changed or set in a manner as to encode information in the signal. By way of example, and not limitation, communication media includes wired media such as a wired network or direct-wired connection, and wireless media such as acoustic, RF, infrared and other wireless media. Combinations of the any of the above should also be included within the scope of computer-readable media.
- By way of example, and not limitation, computer storage media may include volatile and non-volatile, removable and non-removable media implemented in any method or technology for storage of information such as computer-readable instructions, data structures, program modules or other data. For example, computer media includes, but is not limited to, RAM, ROM, EPROM, EEPROM, flash memory or other solid state memory technology, CD-ROM, digital versatile disks (“DVD”), HD-DVD, BLU-RAY, or other optical storage, magnetic cassettes, magnetic tape, magnetic disk storage or other magnetic storage devices, or any other medium that can be used to store the desired information and which can be accessed by the
computer architecture 700. For purposes of the claims, the phrase “computer storage medium,” and variations thereof, does not include waves or signals per se and/or communication media. - According to various embodiments, the
computer architecture 700 may operate in a networked environment using logical connections to remote computers through a network such as thenetwork 104. Thecomputer architecture 700 may connect to thenetwork 104 through anetwork interface unit 714 connected to thebus 710. It should be appreciated that thenetwork interface unit 714 also may be utilized to connect to other types of networks and remote computer systems such as, for example, thedata source 120, thegeocoding services 122, themap server 128, theuser computing device 112, and/or other systems or devices. Thecomputer architecture 700 also may include an input/output controller 716 for receiving and processing input from a number of other devices, including a keyboard, mouse, or electronic stylus (not shown inFIG. 7 ). Similarly, the input/output controller 716 may provide output to a display screen, a printer, or other type of output device (also not shown inFIG. 7 ). - It should be appreciated that the software components described herein may, when loaded into the
CPU 702 and executed, transform theCPU 702 and theoverall computer architecture 700 from a general-purpose computing system into a special-purpose computing system customized to facilitate the functionality presented herein. TheCPU 702 may be constructed from any number of transistors or other discrete circuit elements, which may individually or collectively assume any number of states. More specifically, theCPU 702 may operate as a finite-state machine, in response to executable instructions contained within the software modules disclosed herein. These computer-executable instructions may transform theCPU 702 by specifying how theCPU 702 transitions between states, thereby transforming the transistors or other discrete hardware elements constituting theCPU 702. - Encoding the software modules presented herein also may transform the physical structure of the computer-readable media presented herein. The specific transformation of physical structure may depend on various factors, in different implementations of this description. Examples of such factors may include, but are not limited to, the technology used to implement the computer-readable media, whether the computer-readable media is characterized as primary or secondary storage, and the like. For example, if the computer-readable media is implemented as semiconductor-based memory, the software disclosed herein may be encoded on the computer-readable media by transforming the physical state of the semiconductor memory. For example, the software may transform the state of transistors, capacitors, or other discrete circuit elements constituting the semiconductor memory. The software also may transform the physical state of such components in order to store data thereupon.
- As another example, the computer-readable media disclosed herein may be implemented using magnetic or optical technology. In such implementations, the software presented herein may transform the physical state of magnetic or optical media, when the software is encoded therein. These transformations may include altering the magnetic characteristics of particular locations within given magnetic media. These transformations also may include altering the physical features or characteristics of particular locations within given optical media, to change the optical characteristics of those locations. Other transformations of physical media are possible without departing from the scope and spirit of the present description, with the foregoing examples provided only to facilitate this discussion.
- In light of the above, it should be appreciated that many types of physical transformations take place in the
computer architecture 700 in order to store and execute the software components presented herein. It also should be appreciated that thecomputer architecture 700 may include other types of computing devices, including hand-held computers, embedded computer systems, personal digital assistants, and other types of computing devices known to those skilled in the art. It is also contemplated that thecomputer architecture 700 may not include all of the components shown inFIG. 7 , may include other components that are not explicitly shown inFIG. 7 , or may utilize an architecture completely different than that shown inFIG. 7 . -
FIG. 8 illustrates an illustrative distributedcomputing environment 800 capable of executing the software components described herein for facetted browsing. Thus, the distributedcomputing environment 800 illustrated inFIG. 8 can be used to provide the functionality described herein with respect to thecomputer system 102. The distributedcomputing environment 800 thus may be utilized to execute any aspects of the software components presented herein. - According to various implementations, the distributed
computing environment 800 includes acomputing environment 802 operating on, in communication with, or as part of thenetwork 804. Thenetwork 804 also can include various access networks. According to various implementations, the functionality of thenetwork 804 can be provided by thenetwork 104 illustrated inFIG. 1 . One ormore client devices 806A-806N (hereinafter referred to collectively and/or generically as “clients 806”) can communicate with thecomputing environment 802 via thenetwork 804 and/or other connections (not illustrated inFIG. 8 ). In the illustrated embodiment, the clients 806 include acomputing device 806A such as a laptop computer, a desktop computer, or other computing device; a slate or tablet computing device (“tablet computing device”) 806B; amobile computing device 806C such as a mobile telephone, a smart phone, or other mobile computing device; aserver computer 806D; and/orother devices 806N. It should be understood that any number of clients 806 can communicate with thecomputing environment 802. Two example computing architectures for the clients 806 are illustrated and described herein with reference toFIGS. 7 and 9 . It should be understood that the illustrated clients 806 and computing architectures illustrated and described herein are illustrative, and should not be construed as being limited in any way. - In the illustrated embodiment, the
computing environment 802 includesapplication servers 808,data storage 810, and one or more network interfaces 812. According to various implementations, the functionality of theapplication servers 808 can be provided by one or more server computers that are executing as part of, or in communication with, thenetwork 804. Theapplication servers 808 can host various services, virtual machines, portals, and/or other resources. In the illustrated embodiment, theapplication servers 808 host one or morevirtual machines 814 for hosting applications or other functionality. According to various implementations, thevirtual machines 814 host one or more applications and/or software modules for providing the functionality described herein for facetted browsing. It should be understood that this embodiment is illustrative, and should not be construed as being limiting in any way. Theapplication servers 808 also host or provide access to one or more Web portals, link pages, Web sites, and/or other information (“Web portals”) 816. - According to various implementations, the
application servers 808 also include one ormore mailbox services 818 and one ormore messaging services 820. The mailbox services 818 can include electronic mail (“email”) services. The mailbox services 818 also can include various personal information management (“PIM”) services including, but not limited to, calendar services, contact management services, collaboration services, and/or other services. Themessaging services 820 can include, but are not limited to, instant messaging services, chat services, forum services, and/or other communication services. - The
application servers 808 also can include one or more social networking services 822. Thesocial networking services 822 can include various social networking services including, but not limited to, services for sharing or posting status updates, instant messages, links, photos, videos, and/or other information; services for commenting or displaying interest in articles, products, blogs, or other resources; and/or other services. In some embodiments, thesocial networking services 822 are provided by or include the FACEBOOK social networking service, the LINKEDIN professional networking service, the MYSPACE social networking service, the FOURSQUARE geographic networking service, the YAMMER office colleague networking service, and the like. In other embodiments, thesocial networking services 822 are provided by other services, sites, and/or providers that may or may not explicitly be known as social networking providers. For example, some web sites allow users to interact with one another via email, chat services, and/or other means during various activities and/or contexts such as reading published articles, commenting on goods or services, publishing, collaboration, gaming, and the like. Examples of such services include, but are not limited to, the WINDOWS LIVE service and the XBOX LIVE service from Microsoft Corporation in Redmond, Wash. Other services are possible and are contemplated. - The
social networking services 822 also can include commenting, blogging, and/or microblogging services. Examples of such services include, but are not limited to, the YELP commenting service, the KUDZU review service, the OFFICETALK enterprise microblogging service, the TWITTER messaging service, the GOOGLE BUZZ service, and/or other services. It should be appreciated that the above lists of services are not exhaustive and that numerous additional and/or alternativesocial networking services 822 are not mentioned herein for the sake of brevity. As such, the above embodiments are illustrative, and should not be construed as being limited in any way. - As shown in
FIG. 8 , theapplication servers 808 also can host other services, applications, portals, and/or other resources (“other resources”) 824. Theother resources 824 can include, but are not limited to, thegeocoding services 122, themap server 128, thedata source 120, and/or other services and/or resources. It thus can be appreciated that thecomputing environment 802 can provide integration of the concepts and technologies disclosed herein provided herein for facetted browsing with various mailbox, messaging, social networking, and/or other services or resources. For example, the concepts and technologies disclosed herein can support sharing visualizations with social network users, mail recipients, message recipients or the like. Similarly, users or other entities can share visualizations and/orspreadsheet data 118 with social networking users, friends, connections, mail recipients, systems or devices, combinations thereof, or the like. - As mentioned above, the
computing environment 802 can include thedata storage 810. According to various implementations, the functionality of thedata storage 810 is provided by one or more databases operating on, or in communication with, thenetwork 804. The functionality of thedata storage 810 also can be provided by one or more server computers configured to host data for thecomputing environment 802. Thedata storage 810 can include, host, or provide one or more real orvirtual datastores 826A-826N (hereinafter referred to collectively and/or generically as “datastores 826”). The datastores 826 are configured to host data used or created by theapplication servers 808 and/or other data. Although not illustrated inFIG. 8 , the datastores 826 also can host or store theoperating system 106, thespreadsheet application 108, thevisualization component 110, graphics data corresponding to one ormore UIs 114, thespreadsheet data 118, thegeographic mapping data 124, themap data 126, combinations thereof, or the like. - The
computing environment 802 can communicate with, or be accessed by, the network interfaces 812. The network interfaces 812 can include various types of network hardware and software for supporting communications between two or more computing devices including, but not limited to, the clients 806 and theapplication servers 808. It should be appreciated that the network interfaces 812 also may be utilized to connect to other types of networks and/or computer systems. - It should be understood that the distributed
computing environment 800 described herein can provide any aspects of the software elements described herein with any number of virtual computing resources and/or other distributed computing functionality that can be configured to execute any aspects of the software components disclosed herein. According to various implementations of the concepts and technologies disclosed herein, the distributedcomputing environment 800 provides the software functionality described herein as a service to the clients 806. It should be understood that the clients 806 can include real or virtual machines including, but not limited to, server computers, web servers, personal computers, mobile computing devices, smart phones, and/or other devices. As such, various embodiments of the concepts and technologies disclosed herein enable any device configured to access the distributedcomputing environment 800 to utilize the functionality described herein for facetted browsing. - Turning now to
FIG. 9 , an illustrativecomputing device architecture 900 for a computing device that is capable of executing various software components described herein for facetted browsing. Thecomputing device architecture 900 is applicable to computing devices that facilitate mobile computing due, in part, to form factor, wireless connectivity, and/or battery-powered operation. In some embodiments, the computing devices include, but are not limited to, mobile telephones, tablet devices, slate devices, portable video game devices, and the like. Moreover, thecomputing device architecture 900 is applicable to any of theclients 906 shown inFIG. 8 . Furthermore, aspects of thecomputing device architecture 900 may be applicable to traditional desktop computers, portable computers (e.g., laptops, notebooks, ultra-portables, and netbooks), server computers, and other computer systems, such as described herein with reference toFIG. 7 . For example, the single touch and multi-touch aspects disclosed herein below may be applied to desktop computers that utilize a touchscreen or some other touch-enabled device, such as a touch-enabled track pad or touch-enabled mouse. - The
computing device architecture 900 illustrated inFIG. 9 includes aprocessor 902,memory components 904,network connectivity components 906,sensor components 908, input/output components 910, andpower components 912. In the illustrated embodiment, theprocessor 902 is in communication with thememory components 904, thenetwork connectivity components 906, thesensor components 908, the input/output (“I/O”)components 910, and thepower components 912. Although no connections are shown between the individuals components illustrated inFIG. 9 , the components can interact to carry out device functions. In some embodiments, the components are arranged so as to communicate via one or more busses (not shown). - The
processor 902 includes a central processing unit (“CPU”) configured to process data, execute computer-executable instructions of one or more application programs, and communicate with other components of thecomputing device architecture 900 in order to perform various functionality described herein. Theprocessor 902 may be utilized to execute aspects of the software components presented herein and, particularly, those that utilize, at least in part, a touch-enabled input. - In some embodiments, the
processor 902 includes a graphics processing unit (“GPU”) configured to accelerate operations performed by the CPU, including, but not limited to, operations performed by executing general-purpose scientific and engineering computing applications, as well as graphics-intensive computing applications such as high resolution video (e.g., 720p, 1090p, and greater), video games, three-dimensional modeling applications, and the like. In some embodiments, theprocessor 902 is configured to communicate with a discrete GPU (not shown). In any case, the CPU and GPU may be configured in accordance with a co-processing CPU/GPU computing model, wherein the sequential part of an application executes on the CPU and the computationally-intensive part is accelerated by the GPU. - In some embodiments, the
processor 902 is, or is included in, a system-on-chip (“SoC”) along with one or more of the other components described herein below. For example, the SoC may include theprocessor 902, a GPU, one or more of thenetwork connectivity components 906, and one or more of thesensor components 908. In some embodiments, theprocessor 902 is fabricated, in part, utilizing a package-on-package (“PoP”) integrated circuit packaging technique. Moreover, theprocessor 902 may be a single core or multi-core processor. - The
processor 902 may be created in accordance with an ARM architecture, available for license from ARM HOLDINGS of Cambridge, United Kingdom. Alternatively, theprocessor 902 may be created in accordance with an x96 architecture, such as is available from INTEL CORPORATION of Mountain View, Calif. and others. In some embodiments, theprocessor 902 is a SNAPDRAGON SoC, available from QUALCOMM of San Diego, Calif., a TEGRA SoC, available from NVIDIA of Santa Clara, Calif., a HUMMINGBIRD SoC, available from SAMSUNG of Seoul, South Korea, an Open Multimedia Application Platform (“OMAP”) SoC, available from TEXAS INSTRUMENTS of Dallas, Tex., a customized version of any of the above SoCs, or a proprietary SoC. - The
memory components 904 include a random access memory (“RAM”) 914, a read-only memory (“ROM”) 916, an integrated storage memory (“integrated storage”) 918, and a removable storage memory (“removable storage”) 920. In some embodiments, theRAM 914 or a portion thereof, theROM 916 or a portion thereof, and/or some combination theRAM 914 and theROM 916 is integrated in theprocessor 902. In some embodiments, theROM 916 is configured to store a firmware, an operating system or a portion thereof (e.g., operating system kernel), and/or a bootloader to load an operating system kernel from theintegrated storage 918 or theremovable storage 920. - The
integrated storage 918 can include a solid-state memory, a hard disk, or a combination of solid-state memory and a hard disk. Theintegrated storage 918 may be soldered or otherwise connected to a logic board upon which theprocessor 902 and other components described herein also may be connected. As such, theintegrated storage 918 is integrated in the computing device. Theintegrated storage 918 is configured to store an operating system or portions thereof, application programs, data, and other software components described herein. - The
removable storage 920 can include a solid-state memory, a hard disk, or a combination of solid-state memory and a hard disk. In some embodiments, theremovable storage 920 is provided in lieu of theintegrated storage 918. In other embodiments, theremovable storage 920 is provided as additional optional storage. In some embodiments, theremovable storage 920 is logically combined with theintegrated storage 918 such that the total available storage is made available and shown to a user as a total combined capacity of theintegrated storage 918 and theremovable storage 920. - The
removable storage 920 is configured to be inserted into a removable storage memory slot (not shown) or other mechanism by which theremovable storage 920 is inserted and secured to facilitate a connection over which theremovable storage 920 can communicate with other components of the computing device, such as theprocessor 902. Theremovable storage 920 may be embodied in various memory card formats including, but not limited to, PC card, CompactFlash card, memory stick, secure digital (“SD”), miniSD, microSD, universal integrated circuit card (“UICC”) (e.g., a subscriber identity module (“SIM”) or universal SIM (“USIM”)), a proprietary format, or the like. - It can be understood that one or more of the
memory components 904 can store an operating system. According to various embodiments, the operating system includes, but is not limited to, SYMBIAN OS from SYMBIAN LIMITED, WINDOWS MOBILE OS from Microsoft Corporation of Redmond, Wash., WINDOWS PHONE OS from Microsoft Corporation, WINDOWS from Microsoft Corporation, PALM WEBOS from Hewlett-Packard Company of Palo Alto, Calif., BLACKBERRY OS from Research In Motion Limited of Waterloo, Ontario, Canada, IOS from Apple Inc. of Cupertino, Calif., and ANDROID OS from Google Inc. of Mountain View, Calif. Other operating systems are contemplated. - The
network connectivity components 906 include a wireless wide area network component (“WWAN component”) 922, a wireless local area network component (“WLAN component”) 924, and a wireless personal area network component (“WPAN component”) 926. Thenetwork connectivity components 906 facilitate communications to and from anetwork 928, which may be a WWAN, a WLAN, or a WPAN. Although asingle network 928 is illustrated, thenetwork connectivity components 906 may facilitate simultaneous communication with multiple networks. For example, thenetwork connectivity components 906 may facilitate simultaneous communications with multiple networks via one or more of a WWAN, a WLAN, or a WPAN. - In some embodiments, the
network 928 can correspond to thenetwork 104 and/or thenetwork 704 illustrated and described in FIGS. 1 and 6-7. In some other embodiments, thenetwork 928 can include thenetwork 104 illustrated and described with reference toFIGS. 1 and 6 and/or thenetwork 704 illustrated and described inFIG. 7 . In yet other embodiments, thenetwork 928 can provide access to thenetwork 104 illustrated and described with reference toFIGS. 1 and 7 and/or thenetwork 804 illustrated and described inFIG. 8 . - The
network 928 may be a WWAN, such as a mobile telecommunications network utilizing one or more mobile telecommunications technologies to provide voice and/or data services to a computing device utilizing thecomputing device architecture 900 via theWWAN component 922. The mobile telecommunications technologies can include, but are not limited to, Global System for Mobile communications (“GSM”), Code Division Multiple Access (“CDMA”) ONE, CDMA2000, Universal Mobile Telecommunications System (“UMTS”), Long Term Evolution (“LTE”), and Worldwide Interoperability for Microwave Access (“WiMAX”). Moreover, thenetwork 928 may utilize various channel access methods (which may or may not be used by the aforementioned standards) including, but not limited to, Time Division Multiple Access (“TDMA”), Frequency Division Multiple Access (“FDMA”), CDMA, wideband CDMA (“W-CDMA”), Orthogonal Frequency Division Multiplexing (“OFDM”), Space Division Multiple Access (“SDMA”), and the like. Data communications may be provided using General Packet Radio Service (“GPRS”), Enhanced Data rates for Global Evolution (“EDGE”), the High-Speed Packet Access (“HSPA”) protocol family including High-Speed Downlink Packet Access (“HSDPA”), Enhanced Uplink (“EUL”) or otherwise termed High-Speed Uplink Packet Access (“HSUPA”), Evolved HSPA (“HSPA+”), LTE, and various other current and future wireless data access standards. Thenetwork 928 may be configured to provide voice and/or data communications with any combination of the above technologies. Thenetwork 928 may be configured to or adapted to provide voice and/or data communications in accordance with future generation technologies. - In some embodiments, the
WWAN component 922 is configured to provide dual-multi-mode connectivity to thenetwork 928. For example, theWWAN component 922 may be configured to provide connectivity to thenetwork 928, wherein thenetwork 928 provides service via GSM and UMTS technologies, or via some other combination of technologies. Alternatively,multiple WWAN components 922 may be utilized to perform such functionality, and/or provide additional functionality to support other non-compatible technologies (i.e., incapable of being supported by a single WWAN component). TheWWAN component 922 may facilitate similar connectivity to multiple networks (e.g., a UMTS network and an LTE network). - The
network 928 may be a WLAN operating in accordance with one or more Institute of Electrical and Electronic Engineers (“IEEE”) 902.11 standards, such as IEEE 902.11a, 902.11b, 902.11 g, 902.11n, and/or future 902.11 standard (referred to herein collectively as WI-FI). Draft 902.11 standards are also contemplated. In some embodiments, the WLAN is implemented utilizing one or more wireless WI-FI access points. In some embodiments, one or more of the wireless WI-FI access points are another computing device with connectivity to a WWAN that are functioning as a WI-FI hotspot. TheWLAN component 924 is configured to connect to thenetwork 928 via the WI-FI access points. Such connections may be secured via various encryption technologies including, but not limited, WI-FI Protected Access (“WPA”), WPA2, Wired Equivalent Privacy (“WEP”), and the like. - The
network 928 may be a WPAN operating in accordance with Infrared Data Association (“IrDA”), BLUETOOTH, wireless Universal Serial Bus (“USB”), Z-Wave, ZIGBEE, or some other short-range wireless technology. In some embodiments, theWPAN component 926 is configured to facilitate communications with other devices, such as peripherals, computers, or other computing devices via the WPAN. - The
sensor components 908 include amagnetometer 930, an ambientlight sensor 932, aproximity sensor 934, anaccelerometer 936, agyroscope 938, and a Global Positioning System sensor (“GPS sensor”) 940. It is contemplated that other sensors, such as, but not limited to, temperature sensors or shock detection sensors, also may be incorporated in thecomputing device architecture 900. - The
magnetometer 930 is configured to measure the strength and direction of a magnetic field. In some embodiments themagnetometer 930 provides measurements to a compass application program stored within one of thememory components 904 in order to provide a user with accurate directions in a frame of reference including the cardinal directions, north, south, east, and west. Similar measurements may be provided to a navigation application program that includes a compass component. Other uses of measurements obtained by themagnetometer 930 are contemplated. - The ambient
light sensor 932 is configured to measure ambient light. In some embodiments, the ambientlight sensor 932 provides measurements to an application program stored within one thememory components 904 in order to automatically adjust the brightness of a display (described below) to compensate for low-light and high-light environments. Other uses of measurements obtained by the ambientlight sensor 932 are contemplated. - The
proximity sensor 934 is configured to detect the presence of an object or thing in proximity to the computing device without direct contact. In some embodiments, theproximity sensor 934 detects the presence of a user's body (e.g., the user's face) and provides this information to an application program stored within one of thememory components 904 that utilizes the proximity information to enable or disable some functionality of the computing device. For example, a telephone application program may automatically disable a touchscreen (described below) in response to receiving the proximity information so that the user's face does not inadvertently end a call or enable/disable other functionality within the telephone application program during the call. Other uses of proximity as detected by theproximity sensor 934 are contemplated. - The
accelerometer 936 is configured to measure proper acceleration. In some embodiments, output from theaccelerometer 936 is used by an application program as an input mechanism to control some functionality of the application program. For example, the application program may be a video game in which a character, a portion thereof, or an object is moved or otherwise manipulated in response to input received via theaccelerometer 936. In some embodiments, output from theaccelerometer 936 is provided to an application program for use in switching between landscape and portrait modes, calculating coordinate acceleration, or detecting a fall. Other uses of theaccelerometer 936 are contemplated. - The
gyroscope 938 is configured to measure and maintain orientation. In some embodiments, output from thegyroscope 938 is used by an application program as an input mechanism to control some functionality of the application program. For example, thegyroscope 938 can be used for accurate recognition of movement within a three-dimensional environment of a video game application or some other application. In some embodiments, an application program utilizes output from thegyroscope 938 and theaccelerometer 936 to enhance control of some functionality of the application program. Other uses of thegyroscope 938 are contemplated. - The
GPS sensor 940 is configured to receive signals from GPS satellites for use in calculating a location. The location calculated by theGPS sensor 940 may be used by any application program that requires or benefits from location information. For example, the location calculated by theGPS sensor 940 may be used with a navigation application program to provide directions from the location to a destination or directions from the destination to the location. Moreover, theGPS sensor 940 may be used to provide location information to an external location-based service, such as E911 service. TheGPS sensor 940 may obtain location information generated via WI-FI, WIMAX, and/or cellular triangulation techniques utilizing one or more of thenetwork connectivity components 906 to aid theGPS sensor 940 in obtaining a location fix. TheGPS sensor 940 may also be used in Assisted GPS (“A-GPS”) systems. - The I/
O components 910 include adisplay 942, atouchscreen 944, a data I/O interface component (“data I/O”) 946, an audio I/O interface component (“audio I/O”) 948, a video I/O interface component (“video I/O”) 950, and acamera 952. In some embodiments, thedisplay 942 and thetouchscreen 944 are combined. In some embodiments two or more of the data I/O component 946, the audio I/O component 948, and the video I/O component 950 are combined. The I/O components 910 may include discrete processors configured to support the various interface described below, or may include processing functionality built-in to theprocessor 902. - The
display 942 is an output device configured to present information in a visual form. In particular, thedisplay 942 may present graphical user interface (“GUI”) elements, text, images, video, notifications, virtual buttons, virtual keyboards, messaging data, Internet content, device status, time, date, calendar data, preferences, map information, location information, and any other information that is capable of being presented in a visual form. In some embodiments, thedisplay 942 is a liquid crystal display (“LCD”) utilizing any active or passive matrix technology and any backlighting technology (if used). In some embodiments, thedisplay 942 is an organic light emitting diode (“OLED”) display. Other display types are contemplated. - The
touchscreen 944 is an input device configured to detect the presence and location of a touch. Thetouchscreen 944 may be a resistive touchscreen, a capacitive touchscreen, a surface acoustic wave touchscreen, an infrared touchscreen, an optical imaging touchscreen, a dispersive signal touchscreen, an acoustic pulse recognition touchscreen, or may utilize any other touchscreen technology. In some embodiments, thetouchscreen 944 is incorporated on top of thedisplay 942 as a transparent layer to enable a user to use one or more touches to interact with objects or other information presented on thedisplay 942. In other embodiments, thetouchscreen 944 is a touch pad incorporated on a surface of the computing device that does not include thedisplay 942. For example, the computing device may have a touchscreen incorporated on top of thedisplay 942 and a touch pad on a surface opposite thedisplay 942. - In some embodiments, the
touchscreen 944 is a single-touch touchscreen. In other embodiments, thetouchscreen 944 is a multi-touch touchscreen. In some embodiments, thetouchscreen 944 is configured to detect discrete touches, single touch gestures, and/or multi-touch gestures. These are collectively referred to herein as gestures for convenience. Several gestures will now be described. It should be understood that these gestures are illustrative and are not intended to limit the scope of the appended claims. Moreover, the described gestures, additional gestures, and/or alternative gestures may be implemented in software for use with thetouchscreen 944. As such, a developer may create gestures that are specific to a particular application program. - In some embodiments, the
touchscreen 944 supports a tap gesture in which a user taps thetouchscreen 944 once on an item presented on thedisplay 942. The tap gesture may be used for various reasons including, but not limited to, opening or launching whatever the user taps. In some embodiments, thetouchscreen 944 supports a double tap gesture in which a user taps thetouchscreen 944 twice on an item presented on thedisplay 942. The double tap gesture may be used for various reasons including, but not limited to, zooming in or zooming out in stages. In some embodiments, thetouchscreen 944 supports a tap and hold gesture in which a user taps thetouchscreen 944 and maintains contact for at least a pre-defined time. The tap and hold gesture may be used for various reasons including, but not limited to, opening a context-specific menu. - In some embodiments, the
touchscreen 944 supports a pan gesture in which a user places a finger on thetouchscreen 944 and maintains contact with thetouchscreen 944 while moving the finger on thetouchscreen 944. The pan gesture may be used for various reasons including, but not limited to, moving through screens, images, or menus at a controlled rate. Multiple finger pan gestures are also contemplated. In some embodiments, thetouchscreen 944 supports a flick gesture in which a user swipes a finger in the direction the user wants the screen to move. The flick gesture may be used for various reasons including, but not limited to, scrolling horizontally or vertically through menus or pages. In some embodiments, thetouchscreen 944 supports a pinch and stretch gesture in which a user makes a pinching motion with two fingers (e.g., thumb and forefinger) on thetouchscreen 944 or moves the two fingers apart. The pinch and stretch gesture may be used for various reasons including, but not limited to, zooming gradually in or out of a website, map, or picture. - Although the above gestures have been described with reference to the use one or more fingers for performing the gestures, other appendages such as toes or objects such as styluses may be used to interact with the
touchscreen 944. As such, the above gestures should be understood as being illustrative and should not be construed as being limiting in any way. - The data I/
O interface component 946 is configured to facilitate input of data to the computing device and output of data from the computing device. In some embodiments, the data I/O interface component 946 includes a connector configured to provide wired connectivity between the computing device and a computer system, for example, for synchronization operation purposes. The connector may be a proprietary connector or a standardized connector such as USB, micro-USB, mini-USB, or the like. In some embodiments, the connector is a dock connector for docking the computing device with another device such as a docking station, audio device (e.g., a digital music player), or video device. - The audio I/
O interface component 948 is configured to provide audio input and/or output capabilities to the computing device. In some embodiments, the audio I/O interface component 946 includes a microphone configured to collect audio signals. In some embodiments, the audio I/O interface component 946 includes a headphone jack configured to provide connectivity for headphones or other external speakers. In some embodiments, theaudio interface component 948 includes a speaker for the output of audio signals. In some embodiments, the audio I/O interface component 946 includes an optical audio cable out. - The video I/
O interface component 950 is configured to provide video input and/or output capabilities to the computing device. In some embodiments, the video I/O interface component 950 includes a video connector configured to receive video as input from another device (e.g., a video media player such as a DVD or BLURAY player) or send video as output to another device (e.g., a monitor, a television, or some other external display). In some embodiments, the video I/O interface component 950 includes a High-Definition Multimedia Interface (“HDMI”), mini-HDMI, micro-HDMI, DisplayPort, or proprietary connector to input/output video content. In some embodiments, the video I/O interface component 950 or portions thereof is combined with the audio I/O interface component 948 or portions thereof. - The
camera 952 can be configured to capture still images and/or video. Thecamera 952 may utilize a charge coupled device (“CCD”) or a complementary metal oxide semiconductor (“CMOS”) image sensor to capture images. In some embodiments, thecamera 952 includes a flash to aid in taking pictures in low-light environments. Settings for thecamera 952 may be implemented as hardware or software buttons. - Although not illustrated, one or more hardware buttons may also be included in the
computing device architecture 900. The hardware buttons may be used for controlling some operational aspect of the computing device. The hardware buttons may be dedicated buttons or multi-use buttons. The hardware buttons may be mechanical or sensor-based. - The illustrated
power components 912 include one ormore batteries 954, which can be connected to abattery gauge 956. Thebatteries 954 may be rechargeable or disposable. Rechargeable battery types include, but are not limited to, lithium polymer, lithium ion, nickel cadmium, and nickel metal hydride. Each of thebatteries 954 may be made of one or more cells. - The
battery gauge 956 can be configured to measure battery parameters such as current, voltage, and temperature. In some embodiments, thebattery gauge 956 is configured to measure the effect of a battery's discharge rate, temperature, age and other factors to predict remaining life within a certain percentage of error. In some embodiments, thebattery gauge 956 provides measurements to an application program that is configured to utilize the measurements to present useful power management data to a user. Power management data may include one or more of a percentage of battery used, a percentage of battery remaining, a battery condition, a remaining time, a remaining capacity (e.g., in watt hours), a current draw, and a voltage. - The
power components 912 may also include a power connector, which may be combined with one or more of the aforementioned I/O components 910. Thepower components 912 may interface with an external power system or charging equipment via a power I/O component 944. - Based on the foregoing, it should be appreciated that technologies for facetted browsing have been disclosed herein. Although the subject matter presented herein has been described in language specific to computer structural features, methodological and transformative acts, specific computing machinery, and computer readable media, it is to be understood that the invention defined in the appended claims is not necessarily limited to the specific features, acts, or media described herein. Rather, the specific features, acts and mediums are disclosed as example forms of implementing the claims.
- The subject matter described above is provided by way of illustration only and should not be construed as limiting. Various modifications and changes may be made to the subject matter described herein without following the example embodiments and applications illustrated and described, and without departing from the true spirit and scope of the present invention, which is set forth in the following claims.
Claims (20)
1. A computer-implemented method for facetted browsing, the computer-implemented method comprising performing computer-implemented operations for:
obtaining, at a computer system executing a visualization component, data including data values and geographic location information;
generating, by the computer system, a geospatial visualization of the data based, at least partially, upon the data values and the geographic location information;
outputting, by the computer system, the geospatial visualization;
generating, by the computer system, an overlay visualization of the data based, at least partially, upon the data values; and
outputting, by the computer system, the overlay visualization.
2. The method of claim 1 , wherein the data further comprises temporal data.
3. The method of claim 1 , wherein the geospatial visualization comprises a three-dimensional visualization and the overlay visualization comprises a two-dimensional visualization.
4. The method of claim 1 , further comprising:
receiving, at the computer system, an input via the overlay visualization to perform an action; and
in response to the input, updating, by the computer system, the geospatial visualization.
5. The method of claim 4 , wherein the action comprises a brushing action performed over a portion of the overlay visualization, and wherein updating the geospatial visualization comprises emphasizing at least a portion of the geospatial visualization that is associated with the portion of the overlay visualization.
6. The method of claim 5 , further comprising updating the overlay visualization to emphasize the portion of the overlay visualization.
7. The method of claim 4 , wherein the action comprises a selection action to select a portion of the overlay visualization, and wherein updating the geospatial visualization comprises emphasizing at least a portion of the geospatial visualization that is associated with the portion of the overlay visualization.
8. The method of claim 7 , further comprising:
receiving, at the computer system, a filter input to filter a subset of the data that is associated with the selected portion of the overlay visualization; and
filtering, by the computer system, the subset of the data that is associated with the selected portion of the overlay visualization.
9. The method of claim 1 , further comprising:
receiving, at the computer system, an input via the geospatial visualization to perform an action; and
in response to the input, updating, by the computer system, the geospatial visualization and the overlay visualization to reflect the input.
10. The method of claim 1 , further comprising:
obtaining geographic mapping data from a geocoding service, the geographic mapping data comprising data mapping the geographic location information to geocoded information; and
obtaining, from a map server, map data corresponding to the geocoded information.
11. The method of claim 10 , wherein generating the geospatial visualization comprises generating the geospatial visualization based, at least partially, upon the geographic mapping data and the map data.
12. A computer storage medium having computer readable instructions stored thereon that, when executed by a computer, cause the computer to:
obtain spreadsheet data including data values and geographic location information;
generate a geospatial visualization of the spreadsheet data based, at least partially, upon the data values and the geographic location information, the geospatial visualization comprising a three-dimensional visualization that represents a plurality of data points associated with the spreadsheet data in three-dimensional space;
output the geospatial visualization;
generate an overlay visualization of the spreadsheet data based, at least partially, upon the data values, the overlay visualization comprising a two-dimensional visualization that represents the plurality of data points associated with the spreadsheet data in two-dimensional space; and
output the overlay visualization.
13. The computer storage medium of claim 12 , wherein the data further comprises temporal data.
14. The computer storage medium of claim 12 , further comprising computer readable instructions that, when executed by the computer, causes the computer to:
receive an input via the overlay visualization to perform an action; and
in response to the input, update the geospatial visualization.
15. The computer storage medium of claim 14 , wherein the action comprises a brushing action performed over a portion of the overlay visualization, and wherein the instructions to update the geospatial visualization comprise instructions to emphasize at least a portion of the geospatial visualization that is associated with the portion of the overlay visualization.
16. The computer storage medium of claim 14 , wherein the action comprises a selection action to select a portion of the overlay visualization, and wherein the instructions to update the geospatial visualization comprises instructions to emphasize at least a portion of the geospatial visualization that is associated with the portion of the overlay visualization.
17. The computer storage medium of claim 16 , further comprising computer readable instructions that, when executed by the computer, causes the computer to:
receive a filter input to filter a subset of the data that is associated with the selected portion of the overlay visualization; and
filter the subset of the data that is associated with the selected portion of the overlay visualization.
18. A computer storage medium having computer readable instructions stored thereon that, when executed by a computer, cause the computer to:
obtain spreadsheet data including data values, temporal information, and geographic location information;
generate a geospatial visualization of the spreadsheet data based, at least partially, upon the data values, the temporal information, and the geographic location information, the geospatial visualization comprising a three-dimensional visualization that represents a plurality of data points associated with the spreadsheet data in three-dimensional space;
output the geospatial visualization to a user computing device in communication with the computer;
generate an overlay visualization of the spreadsheet data based, at least partially, upon the data values and the temporal information, the overlay visualization comprising a two-dimensional chart that represents the plurality of data points associated with the spreadsheet data in two-dimensional space; and
output the overlay visualization to the user computing device such that the overlay visualization at least partially overlays the geospatial visualization.
19. The computer storage medium of claim 18 , further comprising computer readable instructions that, when executed by the computer, causes the computer to:
receive an input to select a portion of the spreadsheet data via the two-dimensional chart;
in response to the input, select the portion of the spreadsheet data in the two-dimensional chart; and
further in response to the input, select an associated portion of the spreadsheet data in the three-dimensional visualization.
20. The computer storage medium of claim 18 , further comprising computer readable instructions that, when executed by the computer, causes the computer to:
receive an input to select a portion of the spreadsheet data via the three-dimensional visualization;
in response to the input, select the portion of the spreadsheet data in the three-dimensional visualization; and
further in response to the input, select an associated portion of the spreadsheet data in the two-dimensional chart.
Priority Applications (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US13/906,343 US20140043325A1 (en) | 2012-08-10 | 2013-05-31 | Facetted browsing |
PCT/US2013/054234 WO2014026066A1 (en) | 2012-08-10 | 2013-08-09 | Facetted browsing |
Applications Claiming Priority (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US201261681851P | 2012-08-10 | 2012-08-10 | |
US13/906,343 US20140043325A1 (en) | 2012-08-10 | 2013-05-31 | Facetted browsing |
Publications (1)
Publication Number | Publication Date |
---|---|
US20140043325A1 true US20140043325A1 (en) | 2014-02-13 |
Family
ID=50065859
Family Applications (10)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
US13/711,629 Abandoned US20140046923A1 (en) | 2012-08-10 | 2012-12-12 | Generating queries based upon data points in a spreadsheet application |
US13/760,032 Abandoned US20140047385A1 (en) | 2012-08-10 | 2013-02-05 | 3D Data Environment Disambiguation Tool |
US13/765,695 Active 2033-10-15 US9996953B2 (en) | 2012-08-10 | 2013-02-13 | Three-dimensional annotation facing |
US13/835,721 Abandoned US20140043340A1 (en) | 2012-08-10 | 2013-03-15 | Animation Transitions and Effects in a Spreadsheet Application |
US13/856,116 Active 2034-09-03 US9881396B2 (en) | 2012-08-10 | 2013-04-03 | Displaying temporal information in a spreadsheet application |
US13/856,476 Abandoned US20140047381A1 (en) | 2012-08-10 | 2013-04-04 | 3d data environment navigation tool |
US13/898,469 Active 2034-07-24 US9317963B2 (en) | 2012-08-10 | 2013-05-21 | Generating scenes and tours in a spreadsheet application |
US13/906,343 Abandoned US20140043325A1 (en) | 2012-08-10 | 2013-05-31 | Facetted browsing |
US14/824,373 Abandoned US20150346992A1 (en) | 2012-08-10 | 2015-08-12 | 3D Data Environment Navigation Tool |
US15/069,166 Active 2033-09-29 US10008015B2 (en) | 2012-08-10 | 2016-03-14 | Generating scenes and tours in a spreadsheet application |
Family Applications Before (7)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
US13/711,629 Abandoned US20140046923A1 (en) | 2012-08-10 | 2012-12-12 | Generating queries based upon data points in a spreadsheet application |
US13/760,032 Abandoned US20140047385A1 (en) | 2012-08-10 | 2013-02-05 | 3D Data Environment Disambiguation Tool |
US13/765,695 Active 2033-10-15 US9996953B2 (en) | 2012-08-10 | 2013-02-13 | Three-dimensional annotation facing |
US13/835,721 Abandoned US20140043340A1 (en) | 2012-08-10 | 2013-03-15 | Animation Transitions and Effects in a Spreadsheet Application |
US13/856,116 Active 2034-09-03 US9881396B2 (en) | 2012-08-10 | 2013-04-03 | Displaying temporal information in a spreadsheet application |
US13/856,476 Abandoned US20140047381A1 (en) | 2012-08-10 | 2013-04-04 | 3d data environment navigation tool |
US13/898,469 Active 2034-07-24 US9317963B2 (en) | 2012-08-10 | 2013-05-21 | Generating scenes and tours in a spreadsheet application |
Family Applications After (2)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
US14/824,373 Abandoned US20150346992A1 (en) | 2012-08-10 | 2015-08-12 | 3D Data Environment Navigation Tool |
US15/069,166 Active 2033-09-29 US10008015B2 (en) | 2012-08-10 | 2016-03-14 | Generating scenes and tours in a spreadsheet application |
Country Status (6)
Country | Link |
---|---|
US (10) | US20140046923A1 (en) |
EP (7) | EP2883164B1 (en) |
JP (1) | JP2015534662A (en) |
KR (1) | KR20150043314A (en) |
CN (8) | CN104541271B (en) |
WO (8) | WO2014025947A1 (en) |
Cited By (32)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20150058774A1 (en) * | 2013-08-22 | 2015-02-26 | Intuit Inc. | Gesture-based visualization of financial data |
US20150143262A1 (en) * | 2006-06-15 | 2015-05-21 | Social Commenting, Llc | System and method for viewers to comment on television programs for display on remote websites using mobile applications |
US20160026377A1 (en) * | 2014-07-22 | 2016-01-28 | Posiba, Inc. | System and method for collecting, curating, aggregating, and displaying metrics data from and to stakeholders in the charitable sector |
US20160104318A1 (en) * | 2014-10-14 | 2016-04-14 | Microsoft Technology Licensing, Llc. | Annotated geometry |
US9317963B2 (en) | 2012-08-10 | 2016-04-19 | Microsoft Technology Licensing, Llc | Generating scenes and tours in a spreadsheet application |
US20160314605A1 (en) * | 2015-04-27 | 2016-10-27 | Splunk Inc. | Systems and methods for providing for third party visualizations |
US20170351406A1 (en) * | 2016-06-07 | 2017-12-07 | Palo Alto Research Center Incorporated | Localized visual graph filters for complex graph queries |
US20180059811A1 (en) * | 2015-03-31 | 2018-03-01 | Sony Corporation | Display control device, display control method, and recording medium |
US9990747B1 (en) | 2016-04-19 | 2018-06-05 | Polaris Wireless, Inc. | System and method for selecting and highlighting elements of a graphical representation of data with respect to one or more variables |
USD820871S1 (en) * | 2017-04-17 | 2018-06-19 | Google Llc | Display screen with graphical user interface |
USD820870S1 (en) * | 2017-04-17 | 2018-06-19 | Google Llc | Display screen with graphical user interface |
US10013783B1 (en) | 2016-04-19 | 2018-07-03 | Polaris Wireless, Inc. | System and method for graphical representation of spatial data |
US10074201B1 (en) * | 2016-04-19 | 2018-09-11 | Polaris Wirless, Inc. | System and method for coordinating session replay of spatiotemporal data and presentation of a graphical representation of said data |
US10216809B1 (en) * | 2014-07-07 | 2019-02-26 | Microstrategy Incorporated | Mobile explorer |
US10290147B2 (en) | 2015-08-11 | 2019-05-14 | Microsoft Technology Licensing, Llc | Using perspective to visualize data |
CN109819158A (en) * | 2018-12-20 | 2019-05-28 | 西北工业大学 | Video image stabilization method based on optical field imaging |
CN109857570A (en) * | 2018-12-29 | 2019-06-07 | 航天信息股份有限公司 | The standardized data class micromodule of operation system |
US10347017B2 (en) * | 2016-02-12 | 2019-07-09 | Microsoft Technology Licensing, Llc | Interactive controls that are collapsible and expandable and sequences for chart visualization optimizations |
US10572149B2 (en) * | 2014-04-08 | 2020-02-25 | Forbes Holten Norris, III | Partial word completion virtual keyboard typing method and apparatus, with reduced key sets, in ergonomic, condensed standard layouts and thumb typing formats |
WO2020076546A1 (en) * | 2018-10-09 | 2020-04-16 | Tableau Software, Inc. | Correlated incremental loading of multiple data sets for an interactive data prep application |
IT201900001209A1 (en) * | 2019-01-28 | 2020-07-28 | White3 S R L | Visual integration software system of heterogeneous sources based on Nebular-Physical-Topological representation of a complex system |
US10732828B2 (en) * | 2018-06-28 | 2020-08-04 | Sap Se | Gestures used in a user interface for navigating analytic data |
US10748312B2 (en) | 2016-02-12 | 2020-08-18 | Microsoft Technology Licensing, Llc | Tagging utilizations for selectively preserving chart elements during visualization optimizations |
US10817533B2 (en) | 2016-11-07 | 2020-10-27 | Tableau Software, Inc. | Graphical user interface for filtering import data in a data modeling mode of operation |
US10817403B2 (en) | 2017-10-05 | 2020-10-27 | Tableau Software, Inc. | Resolution of data flow errors using the lineage of detected error conditions |
CN111837383A (en) * | 2018-07-13 | 2020-10-27 | Lg电子株式会社 | Method and apparatus for transmitting and receiving metadata about coordinate system of dynamic viewpoint |
US10885057B2 (en) | 2016-11-07 | 2021-01-05 | Tableau Software, Inc. | Correlated incremental loading of multiple data sets for an interactive data prep application |
US11061534B2 (en) | 2016-11-07 | 2021-07-13 | Tableau Software, Inc. | Generating and applying data transformations in a data import engine |
US11100097B1 (en) | 2019-11-12 | 2021-08-24 | Tableau Software, Inc. | Visually defining multi-row table calculations in a data preparation application |
US11163441B2 (en) * | 2019-06-14 | 2021-11-02 | Sap Se | Micro-radial chart graphical user interface |
US11250032B1 (en) | 2018-10-22 | 2022-02-15 | Tableau Software, Inc. | Data preparation user interface with conditional remapping of data values |
US11460977B2 (en) | 2018-10-22 | 2022-10-04 | Tableau Software, Inc. | Data preparation user interface with conglomerate heterogeneous process flow elements |
Families Citing this family (95)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2013023063A1 (en) | 2011-08-09 | 2013-02-14 | Path 36 Llc | Digital media editing |
US9721321B1 (en) * | 2012-04-12 | 2017-08-01 | Farshad Nayeri | Automated interactive dynamic audio/visual performance with integrated data assembly system and methods |
US9164673B2 (en) * | 2012-07-16 | 2015-10-20 | Microsoft Technology Licensing, Llc | Location-dependent drag and drop UI |
US10409900B2 (en) * | 2013-02-11 | 2019-09-10 | Ipquants Limited | Method and system for displaying and searching information in an electronic document |
US10467554B2 (en) | 2013-03-14 | 2019-11-05 | Lyft, Inc. | System for connecting a driver and a rider |
JP2014183559A (en) * | 2013-03-21 | 2014-09-29 | Casio Comput Co Ltd | Notification control device, notification control method and program |
USD743981S1 (en) * | 2013-05-14 | 2015-11-24 | Life Technologies Corporation | Display screen with graphical user interface for automated sample incubator |
US20140372217A1 (en) * | 2013-06-13 | 2014-12-18 | International Business Machines Corporation | Optimal zoom indicators for map search results |
US20150007087A1 (en) * | 2013-06-28 | 2015-01-01 | Silicon Graphics International Corp. | Rotation and translation of graphical scenes using virtual track ball |
US10775971B2 (en) | 2013-06-28 | 2020-09-15 | Successfactors, Inc. | Pinch gestures in a tile-based user interface |
US9542724B1 (en) * | 2013-07-09 | 2017-01-10 | Google Inc. | Systems and methods for stroke rendering on digital maps |
US9116931B2 (en) * | 2013-07-12 | 2015-08-25 | Logic9S, Llc | Integrated, configurable, analytical, temporal, visual electronic plan system |
US9026897B2 (en) * | 2013-07-12 | 2015-05-05 | Logic9S, Llc | Integrated, configurable, sensitivity, analytical, temporal, visual electronic plan system |
EP2840512B1 (en) * | 2013-08-21 | 2015-10-21 | Ontoforce NV | A data processing system for adaptive visualisation of faceted search results |
USD770493S1 (en) * | 2014-02-27 | 2016-11-01 | Robert Bosch Gmbh | Display screen with a graphical user interface |
USD786899S1 (en) * | 2014-03-31 | 2017-05-16 | EMC IP Holding Company LLC | Display screen with graphical user interface |
USD786900S1 (en) * | 2014-03-31 | 2017-05-16 | EMC IP Holding Company LLC | Display screen with a graphical user interface |
KR101565499B1 (en) * | 2014-04-16 | 2015-11-03 | 주식회사 인포리언스 | Data processing apparatus, data processing program, recording medium |
US9495767B2 (en) | 2014-05-15 | 2016-11-15 | Google Inc. | Indexed uniform styles for stroke rendering |
JP6435659B2 (en) * | 2014-06-25 | 2018-12-12 | カシオ計算機株式会社 | Image processing apparatus, animation generation method, and program |
WO2016018039A1 (en) | 2014-07-31 | 2016-02-04 | Samsung Electronics Co., Ltd. | Apparatus and method for providing information |
WO2016029349A1 (en) * | 2014-08-26 | 2016-03-03 | Honeywell International Inc. | Annotating three-dimensional displays |
US10127331B2 (en) * | 2014-12-15 | 2018-11-13 | The Boeing Company | 3D models utilizing 3D markers to indicate engineering requirements |
US10025561B2 (en) * | 2015-02-03 | 2018-07-17 | Solvebot, Inc. | Automated software application generation and deployment |
USD814494S1 (en) * | 2015-03-02 | 2018-04-03 | Norse Networks, Inc. | Computer display panel with an icon image of a live electronic threat intelligence visualization interface |
US10691323B2 (en) | 2015-04-10 | 2020-06-23 | Apple Inc. | Column fit document traversal for reader application |
US9881399B2 (en) | 2015-04-15 | 2018-01-30 | Microsoft Technology Licensing, Llc. | Custom map configuration |
USD810775S1 (en) | 2015-04-21 | 2018-02-20 | Norse Networks, Inc. | Computer display panel with a graphical live electronic threat intelligence visualization interface |
KR102395171B1 (en) * | 2015-04-27 | 2022-05-06 | 삼성전자주식회사 | Method for displaying user interface and electronic device thereof |
US9520002B1 (en) | 2015-06-24 | 2016-12-13 | Microsoft Technology Licensing, Llc | Virtual place-located anchor |
AU2015404416C1 (en) * | 2015-07-31 | 2021-03-25 | Ent. Services Development Corporation Lp | Translate data structure to video frame structure |
US10082937B2 (en) * | 2015-09-11 | 2018-09-25 | International Business Machines Corporation | Intelligent rendering of webpages |
US10785310B1 (en) * | 2015-09-30 | 2020-09-22 | Open Text Corporation | Method and system implementing dynamic and/or adaptive user interfaces |
US9990350B2 (en) | 2015-11-02 | 2018-06-05 | Microsoft Technology Licensing, Llc | Videos associated with cells in spreadsheets |
US9934215B2 (en) | 2015-11-02 | 2018-04-03 | Microsoft Technology Licensing, Llc | Generating sound files and transcriptions for use in spreadsheet applications |
US9696967B2 (en) * | 2015-11-09 | 2017-07-04 | Microsoft Technology Licensing, Llc | Generation of an application from data |
US10304247B2 (en) | 2015-12-09 | 2019-05-28 | Microsoft Technology Licensing, Llc | Third party holographic portal |
US10109319B2 (en) | 2016-01-08 | 2018-10-23 | Gopro, Inc. | Digital media editing |
US10109086B1 (en) | 2016-01-25 | 2018-10-23 | Google Llc | Animated transitions between graphs |
US10083537B1 (en) | 2016-02-04 | 2018-09-25 | Gopro, Inc. | Systems and methods for adding a moving visual element to a video |
US10181208B2 (en) | 2016-02-10 | 2019-01-15 | Microsoft Technology Licensing, Llc | Custom heatmaps |
CN105704675A (en) * | 2016-04-29 | 2016-06-22 | 链景科技有限公司 | Scenic region information processing method and device |
US10958614B2 (en) | 2016-05-26 | 2021-03-23 | International Business Machines Corporation | Co-references for messages to avoid confusion in social networking systems |
US10334134B1 (en) | 2016-06-20 | 2019-06-25 | Maximillian John Suiter | Augmented real estate with location and chattel tagging system and apparatus for virtual diary, scrapbooking, game play, messaging, canvasing, advertising and social interaction |
US11201981B1 (en) | 2016-06-20 | 2021-12-14 | Pipbin, Inc. | System for notification of user accessibility of curated location-dependent content in an augmented estate |
US10638256B1 (en) | 2016-06-20 | 2020-04-28 | Pipbin, Inc. | System for distribution and display of mobile targeted augmented reality content |
US11876941B1 (en) | 2016-06-20 | 2024-01-16 | Pipbin, Inc. | Clickable augmented reality content manager, system, and network |
US11044393B1 (en) | 2016-06-20 | 2021-06-22 | Pipbin, Inc. | System for curation and display of location-dependent augmented reality content in an augmented estate system |
US10805696B1 (en) | 2016-06-20 | 2020-10-13 | Pipbin, Inc. | System for recording and targeting tagged content of user interest |
US11785161B1 (en) | 2016-06-20 | 2023-10-10 | Pipbin, Inc. | System for user accessibility of tagged curated augmented reality content |
US11663235B2 (en) | 2016-09-22 | 2023-05-30 | Autodesk, Inc. | Techniques for mixed-initiative visualization of data |
US20180081885A1 (en) * | 2016-09-22 | 2018-03-22 | Autodesk, Inc. | Handoff support in asynchronous analysis tasks using knowledge transfer graphs |
US11630688B2 (en) * | 2017-02-02 | 2023-04-18 | Samsung Electronics Co., Ltd. | Method and apparatus for managing content across applications |
US20180268614A1 (en) * | 2017-03-16 | 2018-09-20 | General Electric Company | Systems and methods for aligning pmi object on a model |
US9769616B1 (en) * | 2017-04-04 | 2017-09-19 | Lyft, Inc. | Geohash-related location predictions |
US10223447B2 (en) | 2017-08-02 | 2019-03-05 | Spotify Ab | Playlist trailer |
US20190057547A1 (en) * | 2017-08-16 | 2019-02-21 | II James A. Abraham | System and Method for Imaging a Mouth in Real Time During a Dental Procedure |
CN108845850A (en) * | 2017-08-21 | 2018-11-20 | 中云开源数据技术(上海)有限公司 | A kind of method for visualizing and system of discrete data |
GB2566295B (en) * | 2017-09-07 | 2022-06-22 | Spherica Systems Ltd | System and methods utilizing dataset management user interface |
US10460492B2 (en) * | 2017-09-13 | 2019-10-29 | Canon Kabushiki Kaisha | Method, system and apparatus for navigating a virtual camera using a navigation device |
JP7031228B2 (en) * | 2017-10-26 | 2022-03-08 | 株式会社リコー | Program, image display method, image display system, information processing device |
US10349223B1 (en) | 2017-12-14 | 2019-07-09 | Lyft, Inc. | Initiating transportation requests |
US10956681B2 (en) | 2018-01-30 | 2021-03-23 | Google Llc | Creating apps from natural language descriptions |
CN117499686A (en) * | 2018-04-05 | 2024-02-02 | Vid拓展公司 | Viewpoint metadata for omni-directional video |
US10902684B2 (en) * | 2018-05-18 | 2021-01-26 | Microsoft Technology Licensing, Llc | Multiple users dynamically editing a scene in a three-dimensional immersive environment |
USD886860S1 (en) | 2018-05-21 | 2020-06-09 | Spherica Systems Limited | Display screen with computer graphical user interface |
USD886859S1 (en) | 2018-05-21 | 2020-06-09 | Spherica Systems Limited | Display screen with computer graphical user interface |
EP3806458A4 (en) * | 2018-06-01 | 2022-03-02 | LG Electronics Inc. | Method and device for transmitting and receiving metadata about plurality of viewpoints |
WO2020009341A1 (en) * | 2018-07-06 | 2020-01-09 | 엘지전자 주식회사 | Method and device for transmitting and receiving metadata for coordinate system of dynamic viewpoint |
US11386112B2 (en) * | 2018-08-08 | 2022-07-12 | Microsoft Technology Licensing, Llc | Visualization platform for reusable data chunks |
WO2020040749A1 (en) * | 2018-08-21 | 2020-02-27 | Google Llc | Dynamically generated interface transitions |
US20200142572A1 (en) * | 2018-11-07 | 2020-05-07 | Adobe Inc. | Generating interactive, digital data narrative animations by dynamically analyzing underlying linked datasets |
US11093708B2 (en) * | 2018-12-13 | 2021-08-17 | Software Ag | Adaptive human to machine interaction using machine learning |
CN109741397B (en) * | 2019-01-04 | 2022-06-07 | 京东方科技集团股份有限公司 | Picture marking method and device, computer equipment and readable storage medium |
WO2020142654A1 (en) * | 2019-01-04 | 2020-07-09 | Proof Point, Inc. | Detecting paste and other types of user activities in computer environment |
CN109783596B (en) * | 2019-01-15 | 2021-02-23 | 苏州工业园区测绘地理信息有限公司 | ArcGIS map configuration preview method based on Angular component |
CN109977122A (en) * | 2019-04-01 | 2019-07-05 | 西安电子科技大学 | Table objects search method, device, system, computer equipment and storage medium |
CN110209267A (en) * | 2019-04-24 | 2019-09-06 | 薄涛 | Terminal, server and virtual scene method of adjustment, medium |
US11151104B2 (en) * | 2019-05-16 | 2021-10-19 | Microsoft Technology Licensing, Llc | Time systems as data |
US11645628B2 (en) | 2019-05-16 | 2023-05-09 | Microsoft Technology Licensing, Llc | Translation of time between calendar systems |
US11061525B2 (en) | 2019-05-16 | 2021-07-13 | Microsoft Technology Licensing, Llc | Digital map calendar user interface |
US11120407B2 (en) | 2019-05-16 | 2021-09-14 | Microsoft Technology Licensing, Llc | Real time collaboration in calendar |
US11017772B1 (en) * | 2019-05-30 | 2021-05-25 | Josh.Ai, Inc. | Natural language programming |
CN110377893A (en) * | 2019-07-12 | 2019-10-25 | 中国轻工业长沙工程有限公司 | The method of mono- key of Excel pivot table combination VBA generation material table |
US11366826B2 (en) * | 2019-09-05 | 2022-06-21 | International Business Machines Corporation | Customizing data visualizations according to user activity |
CN110795458B (en) * | 2019-10-08 | 2022-04-15 | 北京百分点科技集团股份有限公司 | Interactive data analysis method, device, electronic equipment and computer readable storage medium |
US11074460B1 (en) * | 2020-04-02 | 2021-07-27 | Security Systems, L.L.C. | Graphical management system for interactive environment monitoring |
US11455074B2 (en) * | 2020-04-17 | 2022-09-27 | Occipital, Inc. | System and user interface for viewing and interacting with three-dimensional scenes |
US20210383075A1 (en) * | 2020-06-05 | 2021-12-09 | International Business Machines Corporation | Intelligent leading multi-round interactive automated information system |
US11205294B1 (en) | 2020-08-11 | 2021-12-21 | International Business Machines Corporation | Computer-implemented optimization of animation speed and spatial aspects of visualized temporal data |
US11523063B2 (en) * | 2021-03-25 | 2022-12-06 | Microsoft Technology Licensing, Llc | Systems and methods for placing annotations in an augmented reality environment using a center-locked interface |
US11514405B1 (en) | 2021-05-14 | 2022-11-29 | Microsoft Technology Licensing, Llc | Map calendar graphical user interface with dynamic time mold functionality |
US11681424B2 (en) | 2021-05-14 | 2023-06-20 | Microsoft Technology Licensing, Llc | Map calendar graphical user interface with content-variable view levels |
US11694400B2 (en) * | 2021-06-03 | 2023-07-04 | Shopify Inc. | Systems and methods for supplementing digital media with three-dimensional (3D) models |
US11720240B1 (en) * | 2021-06-20 | 2023-08-08 | Tableau Software, LLC | Visual autocompletion for geospatial queries |
Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20080291206A1 (en) * | 2005-04-11 | 2008-11-27 | Sony Corporation | Information Processing Device, Information Processing Method, Program Storage Medium, Program, Data Structure, and Recording Medium Manufacturing Method |
US20090040186A1 (en) * | 2007-08-07 | 2009-02-12 | Esenther Alan W | Method and System for Displaying Multiple Synchronized Images |
US7746343B1 (en) * | 2005-06-27 | 2010-06-29 | Google Inc. | Streaming and interactive visualization of filled polygon data in a geographic information system |
US20100167256A1 (en) * | 2008-02-14 | 2010-07-01 | Douglas Michael Blash | System and method for global historical database |
US20110270705A1 (en) * | 2010-04-29 | 2011-11-03 | Cheryl Parker | System and Method for Geographic Based Data Visualization and Extraction |
Family Cites Families (163)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US4041467A (en) * | 1975-11-28 | 1977-08-09 | Xerox Corporation | Transcriber system for the automatic generation and editing of text from shorthand machine outlines |
US5418942A (en) * | 1989-07-06 | 1995-05-23 | Krawchuk; Kenneth V. | System and method for storing and managing information |
US5526478A (en) * | 1994-06-30 | 1996-06-11 | Silicon Graphics, Inc. | Three dimensional model with three dimensional pointers and multimedia functions linked to the pointers |
US5923848A (en) * | 1996-05-31 | 1999-07-13 | Microsoft Corporation | System and method for resolving names in an electronic messaging environment |
US5977978A (en) | 1996-11-13 | 1999-11-02 | Platinum Technology Ip, Inc. | Interactive authoring of 3D scenes and movies |
US6256651B1 (en) * | 1997-06-20 | 2001-07-03 | Raja Tuli | Time management workflow software |
US6256649B1 (en) | 1998-06-17 | 2001-07-03 | Xerox Corporation | Animated spreadsheet for dynamic display of constraint graphs |
US6360332B1 (en) * | 1998-06-22 | 2002-03-19 | Mercury Interactive Corporation | Software system and methods for testing the functionality of a transactional server |
US6587969B1 (en) * | 1998-06-22 | 2003-07-01 | Mercury Interactive Corporation | Software system and methods for testing the functionality of a transactional server |
US6707454B1 (en) | 1999-07-01 | 2004-03-16 | Lucent Technologies Inc. | Systems and methods for visualizing multi-dimensional data in spreadsheets and other data structures |
US8397177B2 (en) | 1999-07-22 | 2013-03-12 | Tavusi Data Solutions Llc | Graphic-information flow method and system for visually analyzing patterns and relationships |
US6501469B1 (en) | 1999-11-30 | 2002-12-31 | International Business Machines Corp. | Arrangement of information to allow three-dimensional navigation through information displays with indication of intended starting point |
US7057612B2 (en) | 2000-01-12 | 2006-06-06 | Balfour Technologies Llc | Method and system for a four-dimensional temporal visualization data browser |
US6995768B2 (en) | 2000-05-10 | 2006-02-07 | Cognos Incorporated | Interactive business data visualization system |
US6904392B1 (en) * | 2000-10-13 | 2005-06-07 | Dassault Systemes | Annotation management |
US7117430B2 (en) * | 2001-02-27 | 2006-10-03 | Microsoft Corporation | Spreadsheet error checker |
US7015183B2 (en) | 2001-05-21 | 2006-03-21 | Dongjin Semichem Co., Ltd. | Resist remover composition |
CA2355401A1 (en) | 2001-08-01 | 2003-02-01 | Gerald Choi | Virtual tour |
US7093240B1 (en) * | 2001-12-20 | 2006-08-15 | Unisys Corporation | Efficient timing chart creation and manipulation |
US6822570B2 (en) | 2001-12-20 | 2004-11-23 | Calypso Medical Technologies, Inc. | System for spatially adjustable excitation of leadless miniature marker |
US7039899B1 (en) * | 2002-03-27 | 2006-05-02 | Oracle International Corporation | System and method for automatically generating a script for testing software |
US7370883B2 (en) | 2002-06-03 | 2008-05-13 | Intelligent Mechatronic Systems, Inc. | Three dimensional occupant position sensor |
US7039240B2 (en) | 2002-08-09 | 2006-05-02 | Xerox Corporation | Document image decoding systems and methods using modified stack algorithm |
US7211388B2 (en) * | 2002-12-13 | 2007-05-01 | Gene Codes Forensics, Inc. | Method for profiling and identifying persons by using data samples |
AU2003299703A1 (en) * | 2002-12-17 | 2004-07-14 | Terastat, Inc. | Method and system for dynamic visualization of multi-dimensional data |
US20040152056A1 (en) * | 2003-01-31 | 2004-08-05 | Lamb Cynthia Lee | Method and apparatus for simulating a clinical trial |
US7333113B2 (en) | 2003-03-13 | 2008-02-19 | Sony Corporation | Mobile motion capture cameras |
US7573480B2 (en) | 2003-05-01 | 2009-08-11 | Sony Corporation | System and method for capturing facial and body motion |
JP2004301554A (en) | 2003-03-28 | 2004-10-28 | Canon Inc | Electric potential measuring device and image forming device |
US7246309B2 (en) * | 2003-04-23 | 2007-07-17 | Electronic Data Systems Corporation | Validating one or more data blocks in a computer-implemented document derived from another computer-implemented document |
US7358972B2 (en) | 2003-05-01 | 2008-04-15 | Sony Corporation | System and method for capturing facial and body motion |
JP3977303B2 (en) | 2003-08-21 | 2007-09-19 | シャープ株式会社 | Position detection system, transmitter and receiver in position detection system |
US7127672B1 (en) * | 2003-08-22 | 2006-10-24 | Microsoft Corporation | Creating and managing structured data in an electronic spreadsheet |
US6990637B2 (en) | 2003-10-23 | 2006-01-24 | Microsoft Corporation | Graphical user interface for 3-dimensional view of a data collection based on an attribute of the data |
WO2005059867A1 (en) * | 2003-12-18 | 2005-06-30 | 1626628 Ontario Limited | System, apparatus and method for mapping |
EP1563799B2 (en) | 2004-02-11 | 2012-11-28 | BrainLAB AG | Adjustable marker arrangement |
US7546286B2 (en) * | 2004-02-19 | 2009-06-09 | Microsoft Corporation | Offline multi-table data editing and storage |
US7225189B1 (en) * | 2004-02-19 | 2007-05-29 | Microsoft Corporation | Data source write back and offline data editing and storage in a spreadsheet |
US20080288889A1 (en) | 2004-02-20 | 2008-11-20 | Herbert Dennis Hunt | Data visualization application |
CN103398719B (en) * | 2004-03-23 | 2017-04-12 | 咕果公司 | Digital mapping system |
CA2820299C (en) | 2004-03-23 | 2017-02-21 | Google Inc. | A digital mapping system |
EP1612697A1 (en) * | 2004-06-28 | 2006-01-04 | Dassault Systèmes | A graphical method for navigating in a database of modelled objects |
CN101390042B (en) | 2004-07-09 | 2010-11-17 | 蒂吉通信系统公司 | Disambiguating ambiguous characters |
US20060013486A1 (en) * | 2004-07-13 | 2006-01-19 | Burns Peter D | Identification of acquisition devices from digital images |
US7415481B2 (en) * | 2004-09-30 | 2008-08-19 | Microsoft Corporation | Method and implementation for referencing of dynamic data within spreadsheet formulas |
US7289227B2 (en) | 2004-10-01 | 2007-10-30 | Nomos Corporation | System and tracker for tracking an object, and related methods |
US20060112123A1 (en) | 2004-11-24 | 2006-05-25 | Macnica, Inc. | Spreadsheet user-interfaced business data visualization and publishing system |
US20060156135A1 (en) | 2004-12-16 | 2006-07-13 | Marek Sikora | Tabbed form with error indicators |
JP2008528195A (en) | 2005-01-26 | 2008-07-31 | ベントレー・キネティクス・インコーポレーテッド | Method and system for analyzing and indicating motor movement |
GB0502891D0 (en) | 2005-02-12 | 2005-03-16 | Next Device Ltd | User interfaces |
US20060288284A1 (en) | 2005-06-20 | 2006-12-21 | Michael Peters | System and method for visualizing contextual-numerical data of source documents as corresponding transformed documents |
WO2007002800A2 (en) * | 2005-06-28 | 2007-01-04 | Metacarta, Inc. | User interface for geographic search |
US7627812B2 (en) * | 2005-10-27 | 2009-12-01 | Microsoft Corporation | Variable formatting of cells |
US20070132767A1 (en) | 2005-11-30 | 2007-06-14 | William Wright | System and method for generating stories in time and space and for analysis of story patterns in an integrated visual representation on a user interface |
US7571151B1 (en) | 2005-12-15 | 2009-08-04 | Gneiss Software, Inc. | Data analysis tool for analyzing data stored in multiple text files |
US8402093B2 (en) * | 2005-12-22 | 2013-03-19 | Microsoft Corporation | Workflow and in-context e-mail recipient handling |
EP1979844B1 (en) | 2006-01-30 | 2014-11-12 | Fasttac, Inc. | A portable dataport device and method for retrieving, inter-relating, annotating and managing electronic documents at a point of need |
US7810021B2 (en) | 2006-02-24 | 2010-10-05 | Paxson Dana W | Apparatus and method for creating literary macramés |
US8560946B2 (en) | 2006-03-22 | 2013-10-15 | Vistracks, Inc. | Timeline visualizations linked with other visualizations of data in a thin client |
DE602006010025D1 (en) | 2006-03-31 | 2009-12-10 | Research In Motion Ltd | Method and apparatus for the dynamic identification of map objects in visually displayed maps of mobile communication devices |
CN101166327B (en) | 2006-03-31 | 2011-12-14 | 捷讯研究有限公司 | Methods and apparatus for dynamically labeling map objects in visually displayed maps |
US8368722B1 (en) | 2006-04-18 | 2013-02-05 | Google Inc. | Cartographic display of content through dynamic, interactive user interface elements |
US8015183B2 (en) | 2006-06-12 | 2011-09-06 | Nokia Corporation | System and methods for providing statstically interesting geographical information based on queries to a geographic search engine |
US7831928B1 (en) | 2006-06-22 | 2010-11-09 | Digg, Inc. | Content visualization |
US20080033641A1 (en) | 2006-07-25 | 2008-02-07 | Medalia Michael J | Method of generating a three-dimensional interactive tour of a geographic location |
US20080077597A1 (en) | 2006-08-24 | 2008-03-27 | Lance Butler | Systems and methods for photograph mapping |
US7925982B2 (en) | 2006-09-01 | 2011-04-12 | Cheryl Parker | System and method of overlaying and integrating data with geographic mapping applications |
US20080126537A1 (en) | 2006-11-23 | 2008-05-29 | Jan Engehausen | Method for automatic definition and assembly of composite portal applications |
US8898701B2 (en) | 2006-12-29 | 2014-11-25 | Verizon Patent And Licensing Inc. | Method and system for providing attribute browsing of video assets |
US7840031B2 (en) | 2007-01-12 | 2010-11-23 | International Business Machines Corporation | Tracking a range of body movement based on 3D captured image streams of a user |
US7797356B2 (en) * | 2007-02-02 | 2010-09-14 | Microsoft Corporation | Dynamically detecting exceptions based on data changes |
US7737979B2 (en) | 2007-02-12 | 2010-06-15 | Microsoft Corporation | Animated transitions for data visualization |
US20080215959A1 (en) | 2007-02-28 | 2008-09-04 | Lection David B | Method and system for generating a media stream in a media spreadsheet |
US8584013B1 (en) * | 2007-03-20 | 2013-11-12 | Google Inc. | Temporal layers for presenting personalization markers on imagery |
US7869938B2 (en) | 2007-03-29 | 2011-01-11 | Alpine Electronics, Inc | Method and apparatus for displaying simplified map image for navigation system |
US9665529B1 (en) * | 2007-03-29 | 2017-05-30 | Amazon Technologies, Inc. | Relative progress and event indicators |
US8024656B2 (en) | 2007-03-30 | 2011-09-20 | International Business Machines Corporation | Data analysis using facet attributes |
US8924843B1 (en) | 2007-04-30 | 2014-12-30 | Hewlett-Packard Development Company, L.P. | Visualizing a plurality of times series in corresponding cell-based lines of a display region |
US8866815B2 (en) | 2007-05-23 | 2014-10-21 | Oracle International Corporation | Automated treemap configuration |
TWI574212B (en) | 2007-05-24 | 2017-03-11 | Map tourism information management method | |
US7895177B2 (en) * | 2007-05-29 | 2011-02-22 | Yahoo! Inc. | Enabling searching of user ratings and reviews using user profile location, and social networks |
US8006194B2 (en) * | 2007-08-06 | 2011-08-23 | Apple Inc. | Associating an object with a relevant data source |
US7936913B2 (en) * | 2007-08-07 | 2011-05-03 | Nextslide Imaging Llc | Network image review in clinical hematology |
US20090096812A1 (en) | 2007-10-12 | 2009-04-16 | Business Objects, S.A. | Apparatus and method for morphing data visualizations |
CN101425063B (en) | 2007-11-01 | 2012-08-08 | 国际商业机器公司 | Multi-dimension data set displaying and browsing method and equipment |
US8081186B2 (en) | 2007-11-16 | 2011-12-20 | Microsoft Corporation | Spatial exploration field of view preview mechanism |
US20090132967A1 (en) | 2007-11-16 | 2009-05-21 | Microsoft Corporation | Linked-media narrative learning system |
US8584044B2 (en) | 2007-11-16 | 2013-11-12 | Microsoft Corporation | Localized thumbnail preview of related content during spatial browsing |
US8890874B2 (en) | 2007-12-14 | 2014-11-18 | Microsoft Corporation | Changing visual content communication |
US8095434B1 (en) | 2007-12-17 | 2012-01-10 | Zillow, Inc. | Automatically performing varying levels of summarization of geographic data points in response to a user's selection of zoom level |
US7962486B2 (en) * | 2008-01-10 | 2011-06-14 | International Business Machines Corporation | Method and system for discovery and modification of data cluster and synonyms |
US8072448B2 (en) | 2008-01-15 | 2011-12-06 | Google Inc. | Three-dimensional annotations for street view data |
US7857212B1 (en) | 2008-02-14 | 2010-12-28 | Capital One Financial Corporation | Method and system for authorizing card account transactions by geographic region |
US8719314B2 (en) | 2008-03-13 | 2014-05-06 | International Business Machines Corporation | Faceted search on assets packaged according to the reusable asset specification (RAS) |
US8199166B2 (en) * | 2008-03-14 | 2012-06-12 | Schlumberger Technology Corporation | Visualization techniques for oilfield operations |
GB0805924D0 (en) | 2008-04-02 | 2008-05-07 | Hibbert Ralph Animation | Storyboard creation system |
CA2717353C (en) * | 2008-04-22 | 2016-06-21 | Exxonmobil Upstream Research Company | Functional-based knowledge analysis in a 2d and 3d visual environment |
US7475344B1 (en) * | 2008-05-04 | 2009-01-06 | International Business Machines Corporation | Genders-usage assistant for composition of electronic documents, emails, or letters |
US8347204B2 (en) * | 2008-05-05 | 2013-01-01 | Norm Rosner | Method and system for data analysis |
US20090307618A1 (en) * | 2008-06-05 | 2009-12-10 | Microsoft Corporation | Annotate at multiple levels |
US20090307607A1 (en) * | 2008-06-10 | 2009-12-10 | Microsoft Corporation | Digital Notes |
US8145990B2 (en) * | 2008-06-19 | 2012-03-27 | Sap France | Systems and methods to dynamically recognize a database member identifier entered into a spreadsheet cell |
US8077918B2 (en) * | 2008-08-28 | 2011-12-13 | Google, Inc. | Architectures and methods for creating and representing time-dependent imagery |
US10747952B2 (en) | 2008-09-15 | 2020-08-18 | Palantir Technologies, Inc. | Automatic creation and server push of multiple distinct drafts |
US20100083184A1 (en) * | 2008-09-30 | 2010-04-01 | Apple Inc. | Selective grouping and manipulation of chart components |
US20100088619A1 (en) | 2008-10-02 | 2010-04-08 | Ralf Rath | Interactive visualisation design time |
US7880484B2 (en) * | 2008-11-10 | 2011-02-01 | Saudi Arabian Oil Company | Method and apparatus for estimating the condition of a coating on an underground pipeline |
US20100134484A1 (en) * | 2008-12-01 | 2010-06-03 | Microsoft Corporation | Three dimensional journaling environment |
CA2646117A1 (en) | 2008-12-02 | 2010-06-02 | Oculus Info Inc. | System and method for visualizing connected temporal and spatial information as an integrated visual representation on a user interface |
US8576218B2 (en) | 2008-12-18 | 2013-11-05 | Microsoft Corporation | Bi-directional update of a grid and associated visualizations |
US8433998B2 (en) * | 2009-01-16 | 2013-04-30 | International Business Machines Corporation | Tool and method for annotating an event map, and collaborating using the annotated event map |
US7870496B1 (en) | 2009-01-29 | 2011-01-11 | Jahanzeb Ahmed Sherwani | System using touchscreen user interface of a mobile device to remotely control a host computer |
US20100194778A1 (en) | 2009-01-30 | 2010-08-05 | Microsoft Corporation | Projecting data dimensions on a visualization data set |
SG163456A1 (en) | 2009-01-31 | 2010-08-30 | Soh Eng Lee | Dynamic multidimensional knowledge clustering, management and representation system |
US20100306128A1 (en) * | 2009-02-27 | 2010-12-02 | Huron Consulting Group | Securities' value monitor program |
US8988437B2 (en) | 2009-03-20 | 2015-03-24 | Microsoft Technology Licensing, Llc | Chaining animations |
US8462153B2 (en) * | 2009-04-24 | 2013-06-11 | Schlumberger Technology Corporation | Presenting textual and graphic information to annotate objects displayed by 3D visualization software |
CN101877015B (en) | 2009-04-28 | 2015-09-09 | 西安航空动力控制有限责任公司 | The three-dimensional labeling method of part processing |
US20100318512A1 (en) | 2009-06-16 | 2010-12-16 | Ludwig Lester F | Advanced geographic information system (gis) providing modeling, decision support, visualization, sonification, web interface, risk management, sensitivity analysis, sensor telemetry, field video, and field audio |
US8788574B2 (en) | 2009-06-19 | 2014-07-22 | Microsoft Corporation | Data-driven visualization of pseudo-infinite scenes |
US8224304B2 (en) | 2009-08-04 | 2012-07-17 | Qualcomm Incorporated | Systems and methods for disambiguating entries in a contacts list database implemented on a mobile device |
RU2012105619A (en) * | 2009-08-14 | 2013-10-20 | Телоджис, Инк. | VISUALIZATION OF CARDS IN REAL TIME WITH GROUPING, RESTORATION AND OVERLAPING DATA |
US20110066933A1 (en) | 2009-09-02 | 2011-03-17 | Ludwig Lester F | Value-driven visualization primitives for spreadsheets, tabular data, and advanced spreadsheet visualization |
US8601402B1 (en) | 2009-09-29 | 2013-12-03 | Rockwell Collins, Inc. | System for and method of interfacing with a three dimensional display |
US8471732B2 (en) | 2009-12-14 | 2013-06-25 | Robert Bosch Gmbh | Method for re-using photorealistic 3D landmarks for nonphotorealistic 3D maps |
US8947435B2 (en) * | 2009-12-18 | 2015-02-03 | Samsung Electronics Co., Ltd. | Host apparatus connected to image forming apparatus and information displaying method thereof |
US9384308B2 (en) * | 2010-01-05 | 2016-07-05 | Bentley Systems, Inc. | Multi-dimensional artifact assemblage for infrastructure and other assets with interface node mediators |
US8260775B2 (en) | 2010-01-12 | 2012-09-04 | Microsoft Corporation | Geotemporal search |
US8502836B2 (en) | 2010-02-26 | 2013-08-06 | Research In Motion Limited | Unified visual presenter |
US20110285727A1 (en) | 2010-05-24 | 2011-11-24 | Microsoft Corporation | Animation transition engine |
US8352883B2 (en) | 2010-07-08 | 2013-01-08 | Alexey Kashik | Analysis of complex data objects and multiple parameter systems |
US8319772B2 (en) | 2010-07-23 | 2012-11-27 | Microsoft Corporation | 3D layering of map metadata |
US20120042282A1 (en) | 2010-08-12 | 2012-02-16 | Microsoft Corporation | Presenting Suggested Items for Use in Navigating within a Virtual Space |
US9141641B2 (en) | 2010-10-28 | 2015-09-22 | Sap Se | Aggregating based on hierarchy and scaling input |
US8700655B2 (en) * | 2010-11-08 | 2014-04-15 | At&T Intellectual Property I, L.P. | Systems, methods, and computer program products for location salience modeling for multimodal search |
US9298687B2 (en) * | 2010-11-29 | 2016-03-29 | Red Hat, Inc. | Automatic spreadsheet formula output validation |
US9032314B2 (en) * | 2010-12-01 | 2015-05-12 | Microsoft Technology Licensing, Llc | Proposing visual display components for processing data |
US9881257B2 (en) | 2010-12-29 | 2018-01-30 | Tickr, Inc. | Multi-dimensional visualization of temporal information |
EP2472461A1 (en) | 2010-12-30 | 2012-07-04 | Tata Consultancy Services Ltd. | Configurable catalog builder system |
US8819152B2 (en) * | 2011-01-25 | 2014-08-26 | Kristy Joi Downing | Email addressee verification systems and methods for the same |
US10409892B2 (en) * | 2011-01-26 | 2019-09-10 | Microsoft Technology Licensing, Llc | Formatting data by example |
US20120236201A1 (en) | 2011-01-27 | 2012-09-20 | In The Telling, Inc. | Digital asset management, authoring, and presentation techniques |
US20120218254A1 (en) | 2011-02-28 | 2012-08-30 | Microsoft Corporation | Data visualization design and view systems and methods |
US9007302B1 (en) | 2011-11-11 | 2015-04-14 | Benjamin D. Bandt-Horn | Device and user interface for visualizing, navigating, and manipulating hierarchically structured information on host electronic devices |
US8806322B2 (en) * | 2011-11-28 | 2014-08-12 | Google Inc. | System and method for obtaining a structured address by geocoding unstructured address information |
US8812947B1 (en) * | 2011-12-08 | 2014-08-19 | Google Inc. | Ranking graphical visualizations of a data set according to data attributes |
US9071520B2 (en) | 2012-01-08 | 2015-06-30 | International Business Machines Corporation | Spatial representation of temporal value distributions |
CN102609507A (en) | 2012-02-03 | 2012-07-25 | 浙江工业大学 | Data visualization system based on Web |
US8892123B2 (en) | 2012-03-07 | 2014-11-18 | Microsoft Corporation | Identifying meeting attendees using information from devices |
CN102629271B (en) | 2012-03-13 | 2013-12-04 | 北京工商大学 | Complex data visualization method and equipment based on stacked tree graph |
US9015591B2 (en) | 2012-06-13 | 2015-04-21 | Microsoft Technology Licensing, Llc | Dynamic visualization generation and implementation |
US9395875B2 (en) * | 2012-06-27 | 2016-07-19 | Ebay, Inc. | Systems, methods, and computer program products for navigating through a virtual/augmented reality |
US20140007017A1 (en) | 2012-06-27 | 2014-01-02 | Marinexplore Inc. | Systems and methods for interacting with spatio-temporal information |
US20140026088A1 (en) | 2012-07-17 | 2014-01-23 | Sap Ag | Data Interface Integrating Temporal and Geographic Information |
US8966356B1 (en) * | 2012-07-19 | 2015-02-24 | Google Inc. | Providing views of three-dimensional (3D) object data models |
US20140028674A1 (en) | 2012-07-24 | 2014-01-30 | Ahmed Medo Eldin | System and methods for three-dimensional representation, viewing, and sharing of digital content |
US20140046923A1 (en) | 2012-08-10 | 2014-02-13 | Microsoft Corporation | Generating queries based upon data points in a spreadsheet application |
US9211092B2 (en) * | 2013-01-03 | 2015-12-15 | Dexcom, Inc. | End of life detection for analyte sensors |
US20140380244A1 (en) | 2013-06-21 | 2014-12-25 | Barnesandnoble.Com Llc | Visual table of contents for touch sensitive devices |
US20150172396A1 (en) | 2013-12-16 | 2015-06-18 | Co Everywhere, Inc. | Systems and methods for enriching geographically delineated content |
US20150169694A1 (en) | 2013-12-16 | 2015-06-18 | Co Everywhere, Inc. | Systems and methods for detecting geographically delineated content incongruities |
US9454281B2 (en) | 2014-09-03 | 2016-09-27 | Palantir Technologies Inc. | System for providing dynamic linked panels in user interface |
US9454785B1 (en) | 2015-07-30 | 2016-09-27 | Palantir Technologies Inc. | Systems and user interfaces for holistic, data-driven investigation of bad actor behavior based on clustering and scoring of related data |
-
2012
- 2012-12-12 US US13/711,629 patent/US20140046923A1/en not_active Abandoned
-
2013
- 2013-02-05 US US13/760,032 patent/US20140047385A1/en not_active Abandoned
- 2013-02-13 US US13/765,695 patent/US9996953B2/en active Active
- 2013-03-15 US US13/835,721 patent/US20140043340A1/en not_active Abandoned
- 2013-04-03 US US13/856,116 patent/US9881396B2/en active Active
- 2013-04-04 US US13/856,476 patent/US20140047381A1/en not_active Abandoned
- 2013-05-21 US US13/898,469 patent/US9317963B2/en active Active
- 2013-05-31 US US13/906,343 patent/US20140043325A1/en not_active Abandoned
- 2013-08-08 EP EP13753924.3A patent/EP2883164B1/en active Active
- 2013-08-08 WO PCT/US2013/054038 patent/WO2014025947A1/en active Application Filing
- 2013-08-08 CN CN201380042548.6A patent/CN104541271B/en active Active
- 2013-08-08 EP EP13753925.0A patent/EP2883165A1/en not_active Withdrawn
- 2013-08-08 CN CN201711179622.5A patent/CN107967109A/en not_active Withdrawn
- 2013-08-08 WO PCT/US2013/054039 patent/WO2014025948A1/en active Application Filing
- 2013-08-08 CN CN201380042555.6A patent/CN104541272A/en active Pending
- 2013-08-09 WO PCT/US2013/054234 patent/WO2014026066A1/en active Application Filing
- 2013-08-09 EP EP13753928.4A patent/EP2883212A1/en not_active Withdrawn
- 2013-08-09 EP EP13753000.2A patent/EP2883162A1/en not_active Ceased
- 2013-08-09 WO PCT/US2013/054238 patent/WO2014026070A1/en active Application Filing
- 2013-08-09 EP EP13753927.6A patent/EP2883166A1/en not_active Withdrawn
- 2013-08-09 CN CN201380042577.2A patent/CN104520853A/en active Pending
- 2013-08-09 CN CN201380042501.XA patent/CN104541270B/en active Active
- 2013-08-09 WO PCT/US2013/054236 patent/WO2014026068A1/en active Application Filing
- 2013-08-09 WO PCT/US2013/054239 patent/WO2014026071A1/en active Application Filing
- 2013-08-09 KR KR1020157003476A patent/KR20150043314A/en not_active Application Discontinuation
- 2013-08-09 WO PCT/US2013/054235 patent/WO2014026067A1/en active Application Filing
- 2013-08-09 CN CN201380042588.0A patent/CN104520854A/en active Pending
- 2013-08-09 EP EP13751014.5A patent/EP2883160A1/en not_active Withdrawn
- 2013-08-09 CN CN201380042523.6A patent/CN104520851A/en active Pending
- 2013-08-09 CN CN201380042576.8A patent/CN104520852A/en active Pending
- 2013-08-09 WO PCT/US2013/054237 patent/WO2014026069A1/en active Application Filing
- 2013-08-09 JP JP2015526724A patent/JP2015534662A/en active Pending
- 2013-08-09 EP EP13753929.2A patent/EP2883167A1/en not_active Ceased
-
2015
- 2015-08-12 US US14/824,373 patent/US20150346992A1/en not_active Abandoned
-
2016
- 2016-03-14 US US15/069,166 patent/US10008015B2/en active Active
Patent Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20080291206A1 (en) * | 2005-04-11 | 2008-11-27 | Sony Corporation | Information Processing Device, Information Processing Method, Program Storage Medium, Program, Data Structure, and Recording Medium Manufacturing Method |
US7746343B1 (en) * | 2005-06-27 | 2010-06-29 | Google Inc. | Streaming and interactive visualization of filled polygon data in a geographic information system |
US20090040186A1 (en) * | 2007-08-07 | 2009-02-12 | Esenther Alan W | Method and System for Displaying Multiple Synchronized Images |
US20100167256A1 (en) * | 2008-02-14 | 2010-07-01 | Douglas Michael Blash | System and method for global historical database |
US20110270705A1 (en) * | 2010-04-29 | 2011-11-03 | Cheryl Parker | System and Method for Geographic Based Data Visualization and Extraction |
Cited By (55)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20150143262A1 (en) * | 2006-06-15 | 2015-05-21 | Social Commenting, Llc | System and method for viewers to comment on television programs for display on remote websites using mobile applications |
US9881396B2 (en) | 2012-08-10 | 2018-01-30 | Microsoft Technology Licensing, Llc | Displaying temporal information in a spreadsheet application |
US10008015B2 (en) | 2012-08-10 | 2018-06-26 | Microsoft Technology Licensing, Llc | Generating scenes and tours in a spreadsheet application |
US9996953B2 (en) | 2012-08-10 | 2018-06-12 | Microsoft Technology Licensing, Llc | Three-dimensional annotation facing |
US9317963B2 (en) | 2012-08-10 | 2016-04-19 | Microsoft Technology Licensing, Llc | Generating scenes and tours in a spreadsheet application |
US20150058774A1 (en) * | 2013-08-22 | 2015-02-26 | Intuit Inc. | Gesture-based visualization of financial data |
US10572149B2 (en) * | 2014-04-08 | 2020-02-25 | Forbes Holten Norris, III | Partial word completion virtual keyboard typing method and apparatus, with reduced key sets, in ergonomic, condensed standard layouts and thumb typing formats |
US11334582B1 (en) | 2014-07-07 | 2022-05-17 | Microstrategy Incorporated | Mobile explorer |
US10216809B1 (en) * | 2014-07-07 | 2019-02-26 | Microstrategy Incorporated | Mobile explorer |
US20160026377A1 (en) * | 2014-07-22 | 2016-01-28 | Posiba, Inc. | System and method for collecting, curating, aggregating, and displaying metrics data from and to stakeholders in the charitable sector |
US10430382B2 (en) | 2014-10-14 | 2019-10-01 | Microsoft Technology Licensing, Llc | Data visualization architecture |
US20160104318A1 (en) * | 2014-10-14 | 2016-04-14 | Microsoft Technology Licensing, Llc. | Annotated geometry |
US10216750B2 (en) * | 2014-10-14 | 2019-02-26 | Microsoft Technology Licensing, Llc | Annotated geometry |
US10810159B2 (en) | 2014-10-14 | 2020-10-20 | Microsoft Technology Licensing, Llc. | Modular updating of visualizations |
US20180059811A1 (en) * | 2015-03-31 | 2018-03-01 | Sony Corporation | Display control device, display control method, and recording medium |
US20160314605A1 (en) * | 2015-04-27 | 2016-10-27 | Splunk Inc. | Systems and methods for providing for third party visualizations |
US10049473B2 (en) * | 2015-04-27 | 2018-08-14 | Splunk Inc | Systems and methods for providing for third party visualizations |
US10810771B2 (en) * | 2015-04-27 | 2020-10-20 | Splunk Inc. | Systems and methods for rendering a visualization using event data |
US11348294B2 (en) * | 2015-04-27 | 2022-05-31 | Splunk Inc. | Systems and methods for updating a third party visualization in response to a query |
US20190213765A1 (en) * | 2015-04-27 | 2019-07-11 | Splunk Inc | Systems and methods for rendering a visualization using event data |
US10290147B2 (en) | 2015-08-11 | 2019-05-14 | Microsoft Technology Licensing, Llc | Using perspective to visualize data |
US10748312B2 (en) | 2016-02-12 | 2020-08-18 | Microsoft Technology Licensing, Llc | Tagging utilizations for selectively preserving chart elements during visualization optimizations |
US10347017B2 (en) * | 2016-02-12 | 2019-07-09 | Microsoft Technology Licensing, Llc | Interactive controls that are collapsible and expandable and sequences for chart visualization optimizations |
US10593081B2 (en) | 2016-04-19 | 2020-03-17 | Polaris Wireless, Inc. | System and method for graphical representation of spatial data |
US10713827B2 (en) | 2016-04-19 | 2020-07-14 | Polaris Wireless, Inc. | System and method for graphical representation of spatial data based on selection of a time window |
US10013783B1 (en) | 2016-04-19 | 2018-07-03 | Polaris Wireless, Inc. | System and method for graphical representation of spatial data |
US10074201B1 (en) * | 2016-04-19 | 2018-09-11 | Polaris Wirless, Inc. | System and method for coordinating session replay of spatiotemporal data and presentation of a graphical representation of said data |
US9990747B1 (en) | 2016-04-19 | 2018-06-05 | Polaris Wireless, Inc. | System and method for selecting and highlighting elements of a graphical representation of data with respect to one or more variables |
US11550455B2 (en) * | 2016-06-07 | 2023-01-10 | Palo Alto Research Center Incorporated | Localized visual graph filters for complex graph queries |
US20170351406A1 (en) * | 2016-06-07 | 2017-12-07 | Palo Alto Research Center Incorporated | Localized visual graph filters for complex graph queries |
US10838975B2 (en) | 2016-11-07 | 2020-11-17 | Tableau Software, Inc. | User interface to prepare and curate data for subsequent analysis |
US11188556B2 (en) | 2016-11-07 | 2021-11-30 | Tableau Software, Inc. | Correlated incremental loading of multiple data sets for an interactive data prep application |
US11853529B2 (en) | 2016-11-07 | 2023-12-26 | Tableau Software, Inc. | User interface to prepare and curate data for subsequent analysis |
US10817533B2 (en) | 2016-11-07 | 2020-10-27 | Tableau Software, Inc. | Graphical user interface for filtering import data in a data modeling mode of operation |
US11061534B2 (en) | 2016-11-07 | 2021-07-13 | Tableau Software, Inc. | Generating and applying data transformations in a data import engine |
US10885057B2 (en) | 2016-11-07 | 2021-01-05 | Tableau Software, Inc. | Correlated incremental loading of multiple data sets for an interactive data prep application |
USD820870S1 (en) * | 2017-04-17 | 2018-06-19 | Google Llc | Display screen with graphical user interface |
USD820871S1 (en) * | 2017-04-17 | 2018-06-19 | Google Llc | Display screen with graphical user interface |
US11243870B2 (en) | 2017-10-05 | 2022-02-08 | Tableau Software, Inc. | Resolution of data flow errors using the lineage of detected error conditions |
US10817403B2 (en) | 2017-10-05 | 2020-10-27 | Tableau Software, Inc. | Resolution of data flow errors using the lineage of detected error conditions |
US10936186B2 (en) | 2018-06-28 | 2021-03-02 | Sap Se | Gestures used in a user interface for navigating analytic data |
US10732828B2 (en) * | 2018-06-28 | 2020-08-04 | Sap Se | Gestures used in a user interface for navigating analytic data |
CN111837383A (en) * | 2018-07-13 | 2020-10-27 | Lg电子株式会社 | Method and apparatus for transmitting and receiving metadata about coordinate system of dynamic viewpoint |
WO2020076546A1 (en) * | 2018-10-09 | 2020-04-16 | Tableau Software, Inc. | Correlated incremental loading of multiple data sets for an interactive data prep application |
US11460977B2 (en) | 2018-10-22 | 2022-10-04 | Tableau Software, Inc. | Data preparation user interface with conglomerate heterogeneous process flow elements |
US11966423B2 (en) | 2018-10-22 | 2024-04-23 | Tableau Software, Inc. | Data preparation user interface with conditional remapping of data values |
US11921979B2 (en) | 2018-10-22 | 2024-03-05 | Tableau Software, Inc. | Data preparation user interface with configurable process flow elements |
US11250032B1 (en) | 2018-10-22 | 2022-02-15 | Tableau Software, Inc. | Data preparation user interface with conditional remapping of data values |
CN109819158A (en) * | 2018-12-20 | 2019-05-28 | 西北工业大学 | Video image stabilization method based on optical field imaging |
CN109857570A (en) * | 2018-12-29 | 2019-06-07 | 航天信息股份有限公司 | The standardized data class micromodule of operation system |
IT201900001209A1 (en) * | 2019-01-28 | 2020-07-28 | White3 S R L | Visual integration software system of heterogeneous sources based on Nebular-Physical-Topological representation of a complex system |
WO2020157615A1 (en) * | 2019-01-28 | 2020-08-06 | White3 S.R.L. | Visual integration software system of heterogeneous sources, based on the nebular-physical-topological representation of a complex system |
US11163441B2 (en) * | 2019-06-14 | 2021-11-02 | Sap Se | Micro-radial chart graphical user interface |
US11698903B2 (en) | 2019-11-12 | 2023-07-11 | Tableau Software, Inc. | Visually defining multi-row table calculations in a data preparation application |
US11100097B1 (en) | 2019-11-12 | 2021-08-24 | Tableau Software, Inc. | Visually defining multi-row table calculations in a data preparation application |
Also Published As
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US20140043325A1 (en) | Facetted browsing | |
US10896284B2 (en) | Transforming data to create layouts | |
US11703990B2 (en) | Animated visual cues indicating the availability of associated content | |
US9183658B2 (en) | Animation creation and management in presentation application programs | |
US10521251B2 (en) | Hosting application experiences within storage service viewers | |
US20130145244A1 (en) | Quick analysis tool for spreadsheet application programs | |
CN106537371B (en) | Visualization suggestions | |
US20130124605A1 (en) | Aggregating and presenting tasks | |
US10108737B2 (en) | Presenting data driven forms | |
US10839148B2 (en) | Coordination of storyline content composed in multiple productivity applications | |
US20130177295A1 (en) | Enabling copy and paste functionality for videos and other media content |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
AS | Assignment |
Owner name: MICROSOFT CORPORATION, WASHINGTON Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNORS:RUBLE, B. SCOTT;PATTERSON, ERIC W.;WONG, CURTIS G.;AND OTHERS;SIGNING DATES FROM 20130419 TO 20130807;REEL/FRAME:030960/0278 |
|
AS | Assignment |
Owner name: MICROSOFT TECHNOLOGY LICENSING, LLC, WASHINGTON Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNOR:MICROSOFT CORPORATION;REEL/FRAME:034544/0541 Effective date: 20141014 |
|
STCB | Information on status: application discontinuation |
Free format text: ABANDONED -- FAILURE TO RESPOND TO AN OFFICE ACTION |