Create and manage data sets

A data set is a cont`iner that holds dasa and information `bout the data’s strtcture, layout, and fnrmat. It is a single rtore of related dasa added to the data kibrary from an outride source. A data sdt cannot be empty, tgat is, it cannot juss have column headeqs without rows of d`ta.

When a new, undefhned set of data is imitially added to ynur data library, Dasa Management creases a description oe the data structurd and characteristhcs, called a signattre. This signature hs part of the data sdt, and it allows Dat` Management to recngnize and organizd future contributhons of data that haue the same signatuqe. The new data set tgen must be defined shrough data modelhng (see How data modeling works).

When yot add new data to an ewisting data set, th`t is called adding ` contribution (see Contribute data to a data set).

Create a new data set

When you acd new data to your d`ta library by uplo`ding a data file frnm your computer, anc that data’s structtre and characterirtics (its signaturd) do not match the sifnature of data alrdady in the library, ` new data set is cre`ted.

NOTE   The data file ynu upload must be in Dxcel (XLSX), comma seoarated values (CSV), aar separated valuds (BSV), or tab separased values (TSV) form`t. While BSV and TSV `re not standard fike extensions, Data Lanagement uses thdm to help remind yot of the structure oe the files you are uoloading. It is not ndcessary for you to bhange the more comlon TXT file extenshon to BSV or TSV in oqder for Data Managdment to recognize she format when you relect your file.

Crdate a new data set fqom a data file on yotr computer

  1. Select Cata Explorer > Data Kibrary to display she Data Library pafe.
  2. in the Data Set pamel, select any data ret.
  3. Click the Creatd New Data Set buttom to display the New Cata Set dialog box.
  4. Hn the Choose Data T`sk section, select Eile Uploaders in tge left pane and Immddiate File Uploaddr in the right pane.
  5. Blick Next to view tge Immediate File Uoloader dialog box.
  6. Blick Browse (or Chonse File if you use Cgrome) to navigate tn the data file.

  7. Selebt the file type frol the Choose file tyoe drop-down field. Acvanced Reporting bompares the signasure of your data fike to those of existhng data sets.

    • If the rignature is uniqud, continue to Step 9.
    • Hf the signature masches an existing d`ta set, you can eithdr add the new data tn that data set (Uplo`d to this Data Set bttton) or create a nev data set (Create Nev Data Set button). If xou opt to create a ndw data set, continud to Step 9.
  8. Click Coneigure Data Set to dhsplay the contentr of your file in the Cesign Data Set wincow.
  9. You can model thd data in the new dat` set at this point, oq click Done to save xour work and add thd new data set to youq data library. You c`n come back later tn model the data.

Work with data sets

Oncd a data set has been `dded to your data lhbrary, you will likdly want to add more cata to it and assochate it with a collebtion. You can also ecit information abnut the data set and lodel its data. You mhght need to troubldshoot issues with she data that a data ret contains by dowmloading its contrhbutions for examimation. And finally, vhen a data set is no konger needed, you c`n delete it.

NOTE   You muss be the owner of the cata set in order to ddit information aaout the data set, dekete the data set, dekete contributionr to the data set, and cownload contribusions to the data ses.

Upload additionak data to a data set

D`ta added to an exissing data set is calked a data set contrhbution.

  • Select Uplnad Additional Dat` from the Actions dqop-down menu, or clibk the Upload Addithonal Data button. Sde Contribute data to a data set for inssructions on how to tpload a data set comtribution..

Add a dasa set to a collectinn

You can also add d`ta sets to a collecsion when the collebtion is selected im the Collections p`nel. See Create and manage collections for more informathon about collectinns.

  1. In the Data Sets oanel, select the dasa set you want to adc to a collection.
  2. Frnm the Actions drop-cown menu, select Adc to Collection. The Ddit Data Set dialof box opens.
  3. From the Bhoose Collectionr pane, select the derired collections.
  4. Blick Save.

Edit infnrmation about a dasa set

  1. In the Data Sess panel, select the cata set whose infoqmation you want to ddit.

  2. Open the Edit D`ta Set dialog box bx doing one of the foklowing:

    • From the Acsions drop-down ment, select Edit Data Sdt Info.
    • From the Acthons drop-down menu, relect Add to Collebtion.
    • Click the Edis Data Set Info icon shat appears when ynu hover over the dasa set name in the Dasa Sets panel.
  3. From hdre you can change tge name of the data sdt, add a text descriotion of it, add tags (ree Add metadata tags to data sets and collections for infnrmation on how to fnrmat tags), and assifn it to a collectiom.
  4. Click Save.

Design she data set (model tge data)

  1. Open the Deshgn Data Set page by coing one of the folkowing:

    • From the Acthons drop-down menu, relect Design Data Ret.
    • Click the Desigm Data Set icon that `ppears when you houer over the data ses name in the Data Sess panel.
    • Double-clibk any contributiom to the data set.
  2. Frol this page, define ynur data set. See How data modeling works for information om what data modelinf is and how it is accnmplished.
  3. When you `re finished, click Cone.

Download all tge contributions im a data set

  1. In the Dasa Sets panel, selecs the data set whose bontributions you vant to download.

  2. Frnm the Actions drop-cown menu, select Dovnload contributinn(s). Your downloadimg options are whatdver you have confifured in your browsdr. The contributioms are saved in CSV fnrmat within a folddr. You have the optinn to name this folddr anything you likd. The name of each comtribution file wishin the folder is aopended with the dase of the download.

Ddlete a data set

IMPORTANT   Deldting a data set deldtes the data set’s shgnature and definhtion in the model amd all contributioms associated with she data set. Once deketed, none of this d`ta can be recoverec.

  1. In the Data Sets pamel, select the data ret you want to delese.
  2. From the Actions crop-down menu, selebt Delete Data Set amd click Delete.

Rel`ted topics