DataTools Pro provides a bulk import feature that translates any Excel or CSV file into the correct DataTools Pro format. Our goal was to remove manual data preparation steps if possible into a simple step by step wizard. This tutorial will step you through the process.
DataTools Pro Metrics Field Dictionary
When importing metrics into DataTools Pro you can use the following dictionary to ensure you map your metrics data to the right fields.
| Metric Field | Field Definition |
|---|---|
| Metric Name | Short Metric Name |
| Definition | Text definition for your metric. |
| Line of Business | Line of business for which the metric belongs. Multiple lines of business can be separated in text with a “,” |
| Topic | Topic for which the metric belongs. Multiple lines of business can be separated in text with a “,” |
| Alias | Alias is alternative names for your metric that could be used. For example an abbreviation or inversely a longer formal name for a metric |
| Owner | The business owner for your metric. |
Import Process
1. Acquire your Dictionary as a Comma Separated (CSV) or Excel
2. Navigate to the Metrics tab and click “Start Import”
3. Drag your file or click “Browse Files” button to navigate to your computer and select an Excel or CSV file.
4. Select a Header Row that identifies each column of data. The header row does not need to match DataTools Pro
5. Match the columns to the metrics columns.
6. Click “Continue” in the upper right hand corner. In the event you do not match column headers or you have extra columns you will get the following warning. You can Skip this warning acknolwging you are not going to import data for the columns that remain un-mapped.
7. The last step is to review your data before final import. In this step DataTools will review the data for any invalid information or characters. For example Metric names as shown, supports a finite number of special characters.
You can edit any value within the table to correct or manually fill any remaining data that you would like to import as a metric.
8. Click “Submit”
Do you have other formats or systems you want to import metrics from?
If you find yourself needing a better / faster way to import your metrics, we want to hear about it! Feel free to contact us with us or send us a note and we can share some other techniques to get your metrics dictionary into a CSV or Excel.