Importing Dow Jones Data to a New or Existing Model

To import data from Dow Jones to a new or existing model, you specify the source data and how incoming data should be mapped to model dimensions.

Procedure

  1. Select the appropriate option:
    • If you're creating a new model:
      1. Select Start of the navigation path (Main Menu) Next navigation step  Create Next navigation step  ModelEnd of the navigation path.
      2. Select Start of the navigation pathGet data from a data source Next navigation step Dow JonesEnd of the navigation path.
        Note
        From the acquire data panel, select the filter icon to narrow down the number of data sources in the list. You can filter by data source type or by category.
    • If you're importing into an existing model:
      1. Select Start of the navigation path (Main Menu) Next navigation step  Browse Next navigation step  FilesEnd of the navigation path.
      2. Open the model you want to update.
      3. Switch to the Data Management screen.

      4. Select Start of the navigation path Next navigation step Data sourceEnd of the navigation path.
      5. Select Dow Jones.
        Note
        You can select the filter icon to narrow down the number of data sources in the list. You can filter by data source type or by category.
  2. Select your connection or select Create New Connection.
    For more information, see Import Data Connection to Dow Jones.
  3. Copy a query from an existing model (which you can edit before saving), or create a new query.
  4. If you're using an existing query, select it from the list.
    1. If you want to make changes to the query, select Modify existing query.
    2. Make your changes, and then select OK.
  5. To create a new query, follow these steps:
    1. Select Next.
    2. Build your query by moving data elements into the Selected Data and Filters areas. For more information see, Building a Query.
    3. Select Create.
    4. Type a name for your query and select Create.
      You can continue to work on other tasks while the dataset is being uploaded in the background.
  6. When the draft data is finished uploading, open it from the Draft Data list (for a new model), or the Draft Sources list (for an existing model).

    The data appears in the data integration view.

Next Steps

After the initial import of raw data, continue with the data preparation task before completing your model: Preparing Data.