# Create a Report with Data Preparation- Partly from Data Center

{% hint style="success" %}
*Check out the given walk-through on a Report creation workflow with a Data Store that contains saved Data Preparation steps in it.*
{% endhint %}

{% embed url="<https://files.gitbook.com/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fq1Y2nC9XDrWcLwg1gpYr%2Fuploads%2FIoxo7Nwbf5HbtkmCfplw%2FData%20Store%20with%20Data%20Prep%20for%20a%20new%20Report.mp4?alt=media&token=7bae6dca-ed40-4699-8f24-0096a285f4de>" %}
***Creating a new Report based on a Data Sandbox with Data Preparation Steps***
{% endembed %}

**Please follow the below-given steps to create a new Report based on a Data Sandbox file with Data Preparation Steps:**

* Go to the ***Data Center*** homepage.
* &#x20;Click on the ***New*** tab.
* Click the ***Data Sandbox*** option to upload a file to Data Sandbox.&#x20;

<figure><img src="https://content.gitbook.com/content/vIDgRfkRB1bQpGtEDFfQ/blobs/EQQfWtvxC4wlWQLsmcMu/image.png" alt=""><figcaption></figcaption></figure>

* The Data Sandbox form opens for the user.
* Provide a name to the ***Data Sandbox.***
* Choose a file from the system.&#x20;
* Click the ***Upload*** option.

<figure><img src="https://content.gitbook.com/content/vIDgRfkRB1bQpGtEDFfQ/blobs/6dTwasTIFWqf5gkIwoTT/image.png" alt=""><figcaption></figcaption></figure>

* Now, the uploaded file gets listed on the ***Data Sandbox List*** page.&#x20;
* Click on the ***Data Preparation*** icon to create a Data Preparation and make some transformations on the uploaded file.

<figure><img src="https://content.gitbook.com/content/vIDgRfkRB1bQpGtEDFfQ/blobs/7zAvPXGfgZmZFMLiJtbY/image.png" alt=""><figcaption></figcaption></figure>

* The user gets redirected to the ***Data Preparation*** module.
* Provide a name to the ***Data Preparation.***
* Apply various transformations as per the requirements as mentioned in the given image under the ***Steps*** tab.
* Click on the ***Back*** icon suggested as ***arrow icon*** to auto-save the Data Preparation.

<figure><img src="https://content.gitbook.com/content/vIDgRfkRB1bQpGtEDFfQ/blobs/mBWNdi3mdVW2WXVIflso/image.png" alt=""><figcaption></figcaption></figure>

* Open the ***Data Center*** module.
* Navigate to the ***Data Sandbox List*** page.&#x20;
* Select a ***Data Sandbox*** from the list.
* Click the ***Data Preparation*** icon.

<figure><img src="https://content.gitbook.com/content/vIDgRfkRB1bQpGtEDFfQ/blobs/N9gFtvisocXOFzM22wyh/image.png" alt=""><figcaption></figcaption></figure>

* The existing ***Preparation List*** for the selected Data Sandbox appears.
* Select the ***Data Preparation*** from the list.
* Click the ***View/Edit*** option for that Data Preparation.&#x20;

<figure><img src="https://content.gitbook.com/content/vIDgRfkRB1bQpGtEDFfQ/blobs/kvLFmtAEOwE6jjWLdsbK/image.png" alt=""><figcaption></figcaption></figure>

* The selected Data Preparation entry opens in the Data Preparation frame work. Click the ***Steps*** tab to see the applied preparation steps (In the following image the transforms part of the Auto Prep are applied, so they are counted as a single step only).

<figure><img src="https://content.gitbook.com/content/vIDgRfkRB1bQpGtEDFfQ/blobs/BFipUbexzoQTYYLuNUi2/image.png" alt=""><figcaption></figcaption></figure>

* Click the ***Create Datastore*** option for the same Sandbox file that has been saved with the Data Preparation steps.

<figure><img src="https://content.gitbook.com/content/vIDgRfkRB1bQpGtEDFfQ/blobs/1m9JS8gF9rFnuhsVvZcj/image.png" alt=""><figcaption></figcaption></figure>

* The ***Create Data Store*** dialog box opens.
* Provide the following information:
  * ***Datastore name***&#x20;
  * ***Description***
  * ***Data Preparation***: Select the Data Preparation that appears in the drop-down menu by using the check box.
* Click the ***Validate*** option.

<figure><img src="https://content.gitbook.com/content/vIDgRfkRB1bQpGtEDFfQ/blobs/KW9pxcBmBkNsDDjeWHJK/image.png" alt=""><figcaption></figcaption></figure>

* A notification appears to inform the users that the Data Preparation is applied and the unsupported headers are modified.
* Click the ***Save*** option.&#x20;

<figure><img src="https://content.gitbook.com/content/vIDgRfkRB1bQpGtEDFfQ/blobs/vz1DJIABwiY9sPlQTdGP/image.png" alt=""><figcaption></figcaption></figure>

* *A notification message appears stating that the Datastore creation has been initiated and it may take a few minutes to create the Data Store.*&#x20;

<figure><img src="https://content.gitbook.com/content/vIDgRfkRB1bQpGtEDFfQ/blobs/t6oNShtgU4fEUJ6uSGke/image.png" alt=""><figcaption></figcaption></figure>

* *The Datastore will be created successfully added to the Data Stores list.*

<figure><img src="https://content.gitbook.com/content/vIDgRfkRB1bQpGtEDFfQ/blobs/Tqm9URoDMuNAoYulZFUz/image.png" alt=""><figcaption></figcaption></figure>

* Click the ***Report*** icon (You may choose any way to initiate the Report creation).
* The ***Create New Report*** dialog box opens.
* Provide a name for the Report.
* Description of the Report.
* Select the ***Select Existing Datastore*** option to begin with the ***Report*** creation.

<figure><img src="https://content.gitbook.com/content/vIDgRfkRB1bQpGtEDFfQ/blobs/9u1FhmGKMyXz8dP0oBZ7/image.png" alt=""><figcaption></figcaption></figure>

* &#x20;Select the Datastore from the list that has been recently created from the Sandbox list page.
* Click the ***Create Story*** option to create a new story.&#x20;

<figure><img src="https://content.gitbook.com/content/vIDgRfkRB1bQpGtEDFfQ/blobs/H9d1G5TESuR3pHA9bF4t/image.png" alt=""><figcaption></figcaption></figure>

* The user gets redirected to the ***Design canvas*** of the Report module with the selected Data Store reflecting the Dimensions and Measures.

<figure><img src="https://content.gitbook.com/content/vIDgRfkRB1bQpGtEDFfQ/blobs/ohLzDylffC8lxR8aXVyx/image.png" alt=""><figcaption></figcaption></figure>

* Drag and drop the Dimensions and Measures to the ***Dimensions/Measures*** tab to create a View.&#x20;
* Click the ***Save*** icon for the View.&#x20;

<figure><img src="https://content.gitbook.com/content/vIDgRfkRB1bQpGtEDFfQ/blobs/xjCQs2LpoLsgeboBvO5e/image.png" alt=""><figcaption></figcaption></figure>

* A notification message appears.
* The View gets saved to the final screen of the Report.

<figure><img src="https://content.gitbook.com/content/vIDgRfkRB1bQpGtEDFfQ/blobs/1oxugva5VcjWEdjqihEF/image.png" alt=""><figcaption></figcaption></figure>