Introductionguide > Data Wizard > Introduction
- Import Data
- Edit Data
- Merge Data
- Export Data
- Match Regional ID
- Express Publish
Statistics Data Wizard (DW) is your statistical application for simplifying the data import management process for Statistics eXplorer including data import (Excel, PC-AXIS, SDMX, Unicode), edit data and metadata, merge indicators from different data sources, quick preview and creation of preloaded Unicode data files. DW lets the user import Excel files with different commonly statistical structures for temporal multivariate data or the user can easily create customized templates to fit own data structure. The importers for the default standards PC-AXIS and SDMX simplifies loading your data. Your imported data can then be previewed to verify data in the interactive Bar Chart component or the time graph. The user also has the ability to add important metadata, such as longer indicator description, measurement unit, data precision etc. Extending an existing data set with a new time step is another useful feature. Combining your data with a geographical region can be difficult. DW also supports a matching names technology that help identify a country or local region name and associate the name with a correct ISO code (national) or local number (municipalities). When your data are imported and metadata attached and verified, the result is exported to our eXplorer Unicode file format and can then be imported in Statistics eXplorer or used to pre-load the data set. Finally, DW lets you create a Story for immediate web publishing by Statistics Publisher and thus bypass Statistics eXplorer.
Data Wizard Demonstrator
Data Wizard Demonstrator
DW Lets the user load some common file formats like Excel, eXplorer Unicode, PC-AXIS and SDMX. When using the 'World' version of DW the user also can load indicators directly from the World Bank database. The import data support for DW is basicaly the same as Statistics eXplorer (read more about Statistics eXplorer Data Managment), but DW has an improved support for the common Excel format. DW supports a high number of Excel data structures and have six preloaded templates matching six common excel data structures for quick usage, read more about these formats in the Default Templates section. If none of the default templates matches your data sctructue in Excel, you can fast and easy create your very own default template and save it on your computer. Read more about this in the Creation of Custom Templates section.
When DW has imported data from any source the user will face the 'Edit Data Set' phase of DW. This is phase meant to let the user get a quick preview of the data with common visualizations. In this stage all data is editable and the user may delete, edit and add data and metadata, read more about this process in the Edit Data Sets section.
One of the big strengths of DW is the possibility it gives users to merge data from different sources and different formats. This could involve merging new indicators to a previously created eXplorer Unicode file, or adding a new timestep to data without having to redo and restart any process. This process is descibed further in the Merge Data Sets section.
Save your data as an eXplorer compitable Unicode file for analysis. Read more about this in the Export Data Sets section.
To fit your data to a map component you need ID for all of your records. These ID:s will will work as indentifiers for the map component. The ID commonly used for World eXplorer is the ISO 3166-1 alpha-3 (ISO 3) codes, and for Sweden eXplorer the four digit municipality codes. Unfortunately these codes are not always present in the data, that is why DW has functionality to try and match the regional names to the correct regional ID. Read mor about this in the Match ID section.
Save the data as an Publisher compatible Story file for quick publishing of data. Read more about this in the Publish Data Sets section.