Abstract: Described herein are various technologies pertaining to construction and application of a data cleaning template. A data cleaning tool, when applying the data cleaning template to a data set, is configured to identify a column in the data set that has data entries of a data type specified in the data cleaning template. In response to identifying the column in the data set, the data cleaning tool, when applying the data cleaning template to the data set, alters a format of the data entries in the column from a first format to a second format, the second format specified in the data cleaning template.

Abstract: A user interface having components that each provide a view on underlying data, and controls for preparing the data. This allows the user to have a wide variety of views on the data set, and corresponding controls appropriate for that view. The level of control over data preparation is even further enhanced by a selection control and navigation control. The selection control allows a portion of the view to be selected, which would in turn affect the view(s) displayed in one or more other user interface components. The navigation control causes the user interface components to display views on the data set as that data set existed at various prior stages in data preparation. The selection control remains active even when viewing prior stages of the data set.

Abstract: A user interface that includes components that each provide a view on the underlying data set, and also provide controls for editing or preparing the data set. The user interface components include a detail user interface component that displays a detail view on the data set, and summary user interface component(s) that each display a corresponding summary view on the data set. A promotion control promotes a summary view on the data set to a detailed view on the data set, and corresponding changes the controls usable in the promoted detail view. This allows the user to have a wide variety of views on the data set, and corresponding controls appropriate for that view. Thus, the user can take the most efficient and intuitive approach to editing or preparing the data, thereby allowing data preparation to be more efficient, intuitive and likely correct.

Abstract: Described herein are various technologies pertaining to construction and application of a data cleaning template. A data cleaning tool, when applying the data cleaning template to a data set, is configured to identify a column in the data set that has data entries of a data type specified in the data cleaning template. In response to identifying the column in the data set, the data cleaning tool, when applying the data cleaning template to the data set, alters a format of the data entries in the column from a first format to a second format, the second format specified in the data cleaning template.

Abstract: Described herein are various technologies pertaining to construction and application of a data cleaning template. A data cleaning tool, when applying the data cleaning template to a data set, is configured to identify a column in the data set that has data entries of a data type specified in the data cleaning template. In response to identifying the column in the data set, the data cleaning tool, when applying the data cleaning template to the data set, alters a format of the data entries in the column from a first format to a second format, the second format specified in the data cleaning template.

Abstract: Disclosed herein is a system and method for allowing a user to zoom in and out on a large data set and maintain resolution and understanding on the data. The system monitors how the user uses the data and also detects the user's actions with respect to zooming on the data. Based on the user's interactions and the type of data the system determines for each zoom level what data to display to the user on the display and if the display needs to be modified to maintain usability of the data. In some scenarios a display management component may change the format of the data such that the user may better understand the data.

Abstract: A filter builder is data characteristic guided. A data characteristic can be determined that describes data or the distribution thereof. A visualization of the data characteristic can be generated and displayed. A selection signal from an input device can be received selecting one or more elements of visualizations. Based on one or more selected elements, a filter condition can be generated automatically and presented in the same context with the visualizations.

Abstract: A user interface that includes components that each provide a view on the underlying data set, and also provide controls for editing or preparing the data set. The user interface components include a detail user interface component that displays a detail view on the data set, and summary user interface component(s) that each display a corresponding summary view on the data set. A promotion control promotes a summary view on the data set to a detailed view on the data set, and corresponding changes the controls usable in the promoted detail view. This allows the user to have a wide variety of views on the data set, and corresponding controls appropriate for that view. Thus, the user can take the most efficient and intuitive approach to editing or preparing the data, thereby allowing data preparation to be more efficient, intuitive and likely correct.

Abstract: A user interface having components that each provide a view on underlying data, and controls for preparing the data. This allows the user to have a wide variety of views on the data set, and corresponding controls appropriate for that view. The level of control over data preparation is even further enhanced by a selection control and navigation control. The selection control allows a portion of the view to be selected, which would in turn affect the view(s) displayed in one or more other user interface components. The navigation control causes the user interface components to display views on the data set as that data set existed at various prior stages in data preparation. The selection control remains active even when viewing prior stages of the data set.

Abstract: Described herein are various technologies pertaining to construction and application of a data cleaning template. A data cleaning tool, when applying the data cleaning template to a data set, is configured to identify a column in the data set that has data entries of a data type specified in the data cleaning template. In response to identifying the column in the data set, the data cleaning tool, when applying the data cleaning template to the data set, alters a format of the data entries in the column from a first format to a second format, the second format specified in the data cleaning template.

Abstract: Disclosed herein is a system and method for allowing a user to zoom in and out on a large data set and maintain resolution and understanding on the data. The system monitors how the user uses the data and also detects the user's actions with respect to zooming on the data. Based on the user's interactions and the type of data the system determines for each zoom level what data to display to the user on the display and if the display needs to be modified to maintain usability of the data. In some scenarios a display management component may change the format of the data such that the user may better understand the data.

Abstract: Jobs can be authored in conjunction with a visual workspace. Upon selection of representation of a data source in the workspace, a preview of the data source can be generated within context of the visual workspace. Further, representations of one or more data transformation operations can be provided with the preview. Selection of a transformation operation results in an updated preview reflecting application of the operation as well as generation of backend code to perform the operation. Furthermore, a job comprising one or more transformation operations can be added to the workspace automatically.

Abstract: Jobs can be created within a visual authoring environment. A new job of a selected type can be added to a diagrammatic workspace. Subsequently, a mechanism configured to enable selection of a saved job that implements all or a portion of the job can be presented. After selection, a saved job can be acquired and the workspace updated based thereon. Furthermore, data sources associated with the saved job can be can be added to a data source designated portion of the environment.