> For the complete documentation index, see [llms.txt](https://docs.bdb.ai/self-service-visualization-6/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.bdb.ai/self-service-visualization-6/creating-a-new-report/create-new-report/creating-a-new-report-with-data-preparation/create-a-report-with-data-preparation-inside-the-report-ui.md).

# Create a Report with Data Preparation  - Inside the Report UI

Create a new Report by implementing the Data Preparation steps to an uploaded file using the Report UI.

{% hint style="success" %}
*Check out the given walk-through to create a new report on top of an uploaded file that contains Data Preparation steps.*
{% endhint %}

{% embed url="<https://files.gitbook.com/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FxZF8YGlESz97qqyTOJvz%2Fuploads%2FMOg7l5v5ubtZEWNP3yTs%2FCreating%20a%20Data%20Prep%20Report%20from%20the%20Report%20Interface..mp4?alt=media&token=699aafcb-be45-48be-9002-60c9b4375eb0>" %}
***Creating a new Report based on an uploaded file with Data Preparation steps***
{% endembed %}

Please follow the below-given steps to create a new report based on an uploaded file containing the Data Preparation Steps:

* Click the Report icon or Create a Report option from the Platform homepage.&#x20;
* The Create New Report dialog box opens.
* Provide the name of the Report.
* Describe the Report.
* Click the Upload CSV option to upload a CSV file.

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

* Provide a name for the Datastore.
* Click the ***Choose File*** option to select and upload a file from the local system.

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

{% hint style="info" %}
*<mark style="color:green;">Please Note:</mark>* After selecting the Upload CSV file a field to mention the delimiter appears on the ***Create New Report*** page.
{% endhint %}

* The selected file's name appears next to the ***Choose File*** option.
* A notification flashes to inform you that uploading the selected file may take a few moments.

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

* A notification message appears to ensure that the file is successfully uploaded.

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

* Click the ***Data Prep*** option provided at the bottom of the page.

<figure><img src="https://content.gitbook.com/content/qcRKh6n896BG051TWTp3/blobs/4kPmv740x1GlHrf3lnKN/image.png" alt=""><figcaption></figcaption></figure>

* The data of the selected CSV file opens in the Data Grid format under the Data Preparation framework.

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

* Apply the required Transforms. or Click the Auto Prep option to apply the auto-mated transforms to the selected data (In the below-given image the ***Auto Prep*** option has been chosen).

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

* Open the ***Steps*** tab to see the applied Data Preparation steps (In this case, all the transforms part of the Auto Prep appear as a single step).
* Provide a name for the Data Preparation.&#x20;
* Click the ***SAVE*** option.

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

* A notification message ensures the user that the ***Data Preparation*** has been successfully applied.
* Click the **Apply and Close** icon.

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

* A notification ensures that the selected Data Preparation has been applied.
* Click the ***Create Report*** option.

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

* Another notification message informs the users that the Data Store creation process has been started and a status notification will be sent shortly.

<figure><img src="https://content.gitbook.com/content/qcRKh6n896BG051TWTp3/blobs/2FufyQphu6oMF3QyOYDr/image.png" alt=""><figcaption></figcaption></figure>

* The report gets created under My Documents, and the Design canvas of the report opens by default.
* Create a ***View*** by drag and drop of the required Dimensions and Measures.
* Click the ***Save*** option to save the View.

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

* A notification message appears to ensure that the View has been created successfully.
* The newly created View gets Saved to the final screen of the Report.

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

{% hint style="info" %}
*<mark style="color:green;">Please Note:</mark> The same steps can be applied to an uploaded Excel file to create a Report.*
{% endhint %}