---
title: Data Preparation | Minitab Solution Center Trial
description: Learn how to import, inspect, clean, and reuse a shipping dataset in Minitab Data Center so every downstream analysis starts from trusted data.
---

[![Minitab logo White 1](https://info.minitab.com/hubfs/Minitab%20logo%20White%201.svg)](https://www.minitab.com)

[Solutions](https://www.minitab.com/en-us/solutions/)

#### Analytics

[Statistics & Predictive Analytics](https://www.minitab.com/en-us/solutions/analytics/statistical-analysis-predictive-analytics/) [Data Science & Machine Learning](https://www.minitab.com/en-us/solutions/analytics/data-science-machine-learning/) [Business Analytics & Intelligence](https://www.minitab.com/en-us/solutions/analytics/business-analytics-intelligence/) [Statistical Process Control](https://www.minitab.com/en-us/solutions/analytics/statistical-process-control/) [Quality Analytics](https://www.minitab.com/en-us/solutions/analytics/quality-analytics/) [Live Analytics](https://www.minitab.com/en-us/solutions/analytics/live-analytics/) [Reliability & Life Data Analysis](https://www.minitab.com/en-us/solutions/analytics/reliability/) [Discrete Event Simulation](https://www.minitab.com/en-us/solutions/analytics/discrete-events-simulation/) [Process Mining](https://www.minitab.com/en-us/solutions/analytics/process-mining/)

#### Key Capabilities

[Automated Data Collection](https://www.minitab.com/en-us/solutions/key-capabilities/automated-data-collection/) [Advanced Design of Experiments](https://www.minitab.com/en-us/solutions/key-capabilities/advanced-design-of-experiments-omars/) [Continuous Improvement](https://www.minitab.com/en-us/solutions/key-capabilities/continuous-improvement/) [Data Integration & Data Prep](https://www.minitab.com/en-us/solutions/key-capabilities/data-integration-data-prep/) [Diagramming & Mind Mapping](https://www.minitab.com/en-us/solutions/key-capabilities/diagramming-mind-mapping/) [Digital Twins](https://www.minitab.com/en-us/solutions/key-capabilities/digital-twins/) [Innovation & Project Management](https://www.minitab.com/en-us/solutions/key-capabilities/innovation-project-management/) [Model Deployment & ML Ops](https://www.minitab.com/en-us/solutions/key-capabilities/model-deployment-ml-ops/) [Process Excellence: Detect, Correct & Prevent](https://www.minitab.com/en-us/solutions/key-capabilities/process-excellence/)

#### Featured Industries

[Academic](https://www.minitab.com/en-us/solutions/industry/academic/) [Energy & Natural Resources](https://www.minitab.com/en-us/solutions/industry/energy-resources/) [Government & Public Sector](https://www.minitab.com/en-us/solutions/industry/government/) [Healthcare](https://www.minitab.com/en-us/solutions/industry/healthcare/) [Insurance](https://www.minitab.com/en-us/solutions/industry/insurance/) [Manufacturing & Industrial](https://www.minitab.com/en-us/solutions/industry/manufacturing-industrial/) [Services](https://www.minitab.com/en-us/solutions/industry/service-industries/) [Software & Technology](https://www.minitab.com/en-us/solutions/industry/software-technology/) [Construction](https://www.minitab.com/en-us/solutions/industry/construction/)

#### Featured Roles

[Engineering](https://www.minitab.com/en-us/solutions/role/engineering/) [Business Analysts](https://www.minitab.com/en-us/solutions/role/business-analysts/) [Information Technology](https://www.minitab.com/en-us/solutions/role/information-technology/) [Supply Chain](https://www.minitab.com/en-us/solutions/role/supply-chain/) [Customer Service & Contact Center](https://www.minitab.com/en-us/solutions/role/customer-service-contact-center/) [Human Resources](https://www.minitab.com/en-us/solutions/role/human-resources/) [Marketing](https://www.minitab.com/en-us/solutions/role/marketing/) [Research and Development](https://www.minitab.com/en-us/solutions/role/research-and-development/)

[Products](https://www.minitab.com/en-us/products/)

[Minitab Solution Center](https://www.minitab.com/en-us/products/minitab-solution-center/) [Minitab Statistical Software](https://www.minitab.com/en-us/products/minitab/) [Minitab Connect](https://www.minitab.com/en-us/products/connect/) [Minitab Model Ops](https://www.minitab.com/en-us/products/model-ops/) [Minitab Education Hub](https://www.minitab.com/en-us/products/education-hub/) [Minitab Engage](https://www.minitab.com/en-us/products/engage/) [Minitab Workspace](https://www.minitab.com/en-us/products/workspace/) [Real-Time SPC](https://www.minitab.com/en-us/products/real-time-spc/) [Prolink Data Collection & SPC](https://www.minitab.com/en-us/products/prolink/) [Scytec Data Collection and OEE](https://www.minitab.com/en-us/products/scytec-data-collection-and-oee/) [Simul8 Discrete Event Simulation](https://www.minitab.com/en-us/products/simul8/) [SPM](https://www.minitab.com/en-us/products/spm/)

[Industries](https://www.minitab.com/en-us/solutions/industry/)

[Capabilities](https://www.minitab.com/en-us/solutions/key-capabilities/)

[Resources & Services](https://www.minitab.com/en-us/resources-services/)

#### Resources

[Case Studies](https://www.minitab.com/en-us/resources-services/resources/case-studies/) [Blog](https://www.minitab.com/en-us/resources-services/resources/blog/) [eBooks and White Papers](https://www.minitab.com/en-us/resources-services/resources/ebooks-and-white-papers/) [Data Sets](https://www.minitab.com/en-us/resources-services/resources/data-set/) [Webinars & Events](https://www.minitab.com/en-us/resources-services/resources/events/) [Education Hub](https://www.minitab.com/en-us/resources-services/resources/education-hub/)

#### Services

[Training](https://www.minitab.com/en-us/resources-services/services/training/) [Deployment](https://www.minitab.com/en-us/resources-services/services/deployment/) [Consulting](https://www.minitab.com/en-us/resources-services/services/consulting/) [Self-Paced Learning](https://www.minitab.com/en-us/resources-services/services/self-paced-learning/) [Continuing Education](https://www.minitab.com/en-us/resources-services/services/continuing-education/)

[Support](https://www.minitab.com/en-us/support/)

[Technical Support](https://www.minitab.com/en-us/support/) [Subscriptions & Activation](https://www.minitab.com/en-us/support/subscriptions-and-activation/) [Minitab Quick Start](https://www.minitab.com/en-us/support/quick-start/) [Training](https://www.minitab.com/en-us/support/training/) [Installation Support](https://www.minitab.com/en-us/support/installation/) [Support Videos](https://www.minitab.com/en-us/support/videos/) [Support Documentation](https://www.minitab.com/en-us/support/documents/) [Software Updates](https://www.minitab.com/en-us/support/software-updates/) [Product Downloads](https://www.minitab.com/en-us/support/downloads/) [Support Policy](https://www.minitab.com/en-us/support/policy/)

[Company](https://www.minitab.com/en-us/company/)

[Company](https://www.minitab.com/en-us/company/) [About Us](https://www.minitab.com/en-us/company/our-company/) [Leadership Team](https://www.minitab.com/en-us/company/leadership-team/) [Partners](https://www.minitab.com/en-us/company/partners/) [Careers](https://www.minitab.com/en-us/company/careers/) [Contact](https://www.minitab.com/en-us/company/contact-us/) [News](https://www.minitab.com/en-us/company/press-releases/) [Minitab Merchandise](https://www.minitab.com/en-us/company/minitab-merchandise/)

# Build a reusable data preparation workflow.

Every useful analysis starts with data preparation. This lesson shows you how to connect a file, remove inconsistencies, calculate a key metric, and refresh your output when the source changes all within Minitab Data Center.Once you know this workflow, you can spend less time rebuilding the same spreadsheet cleanup and more time using clean data in dashboards and statistical analysis.

**In 15 minutes, you'll:**

• Open a production-style shipping file in Minitab Data Center

• Check column types, names, and the rows that need attention

• Create a reusable data connection for your next analysis

[Log into your Minitab trial](https://licensing.minitab.com/Login?ReturnUrl=%2F)

[Unlock all of Minitab](https://www.minitab.com/en-us/try-buy/)

![MSC Trial - Data Preparation](https://info.minitab.com/hs-fs/hubfs/MSC%20Trial%20-%20Data%20Preparation.png?width=2000&height=1125&name=MSC%20Trial%20-%20Data%20Preparation.png "MSC Trial - Data Preparation")

### USE CASE

Connect to different data sources and save your cleaning steps.

### DOWNLOAD DATASET

[Download the shipping dataset used in this lesson **here**.](https://support.minitab.com/en-us/datasets/media/generated-content/datasets/Central.xlsx)

### DURATION

 15 minutes

### WHAT YOU'LL NEED

A logged-in Minitab Solution Center trial. 

## Prepare your data for analysis

 Follow six guided steps in Minitab to clean, organize, and save a reusable data connection.

 1

![Add data to your cloud drive](https://info.minitab.com/hs-fs/hubfs/Step%201%20-%20Add%20data%20to%20your%20cloud%20drive.png?width=1080&height=1080&name=Step%201%20-%20Add%20data%20to%20your%20cloud%20drive.png)

### Add data to your cloud drive.

First, download and save the shipping data [Central.xlsx](https://support.minitab.com/en-us/datasets/media/generated-content/datasets/Central.xlsx) to your organization’s cloud storage, whether that’s **Google Drive**, **OneDrive** or **Sharepoint**. 

 

 Note

Your prep steps work from the connected data source. They do not overwrite the original file. 

 2

![Open the shipping data in Data Center](https://info.minitab.com/hs-fs/hubfs/Step%202%20-%20Open%20the%20shipping%20data%20in%20Data%20Center.png?width=1080&height=1080&name=Step%202%20-%20Open%20the%20shipping%20data%20in%20Data%20Center.png)

### Open the shipping data in Data Center

From the Solution Center home page, select Data Prep, choose Add Data, and open Central.xlsx from your online drive. Review the preview before you continue. 

 3

![Check out the file structure](https://info.minitab.com/hs-fs/hubfs/Step%203%20-%20Check%20out%20the%20file%20structure.png?width=1080&height=1080&name=Step%203%20-%20Check%20out%20the%20file%20structure.png)

### Check out the file structure

In the top part of your window, you’ll see 3 nodes: **Central.xslx**, **Cleanup** and **Output**. Click the source file node for Central.xlsx. Confirm the correct sheet is selected, the header row is **1**, and the first data row is **2**.

For this dataset, you can leave the standard cleanup options on, including trim whitespace, remove nonprintable characters, and format dates based on regional settings.

 

 TIP

Use the source file node for file structure. Use the Cleanup node for cleaning the actual rows and values. 

 4

![Remove rows with empty values](https://info.minitab.com/hs-fs/hubfs/Step%204%20-%20Remove%20rows%20with%20empty%20values.png?width=1080&height=1080&name=Step%204%20-%20Remove%20rows%20with%20empty%20values.png)

### Remove rows with empty values

Select the Cleanup node, then click the column you want to check first. Start with **Arrival**, because rows without an arrival date cannot be used to calculate shipping time.

Open Data Prep Options () in the Arrival column header, choose Filter Rows, and set the rule to: **Arrival** is not missing**.** Repeat the same filter for all the other columns, including **Order,** **Status,** or **Distance**.

 

 TIP

The “missing values in every column” checkbox removes only fully blank rows. To remove rows with one missing field, filter each required column to “is not missing.” 

 5

![Step 5 - Add a calculated column](https://info.minitab.com/hs-fs/hubfs/Step%205%20-%20Add%20a%20calculated%20column.png?width=1080&height=1080&name=Step%205%20-%20Add%20a%20calculated%20column.png)

### Add a calculated column

Now, we’ll calculate the time between order and arrival rounded to the nearest whole day and save it as a brand-new column.

 

#### ![ai-icon-1](https://info.minitab.com/hs-fs/hubfs/ai-icon-1.png?width=43&height=38&name=ai-icon-1.png)Minitab AI

You can use Minitab AI to perform many data preparation tasks. Try it out by opening Minitab AI from the left-hand navigation and insert the following prompt to create a calculated column:

 

**Create a calculated column named Delivery Time (Days) that shows the number of whole days between the Order and Arrival columns. Use DATE('Arrival') - DATE('Order').**

 

Or, you can create a calculated column manually:

Click **Add Column \> Calculated Column**, and it will bring up the **Calculated Column** window.

Replace the contents of New Column Name with `Delivery Time (Days)`.

For the equation, paste the following formula into the Equation input box:  `DATE('Arrival')-DATE('Order')`and make sure that `=` is still present at the start of the equation.

Select `Date` in the list under "Insert Function" and click OK. 

You should now see a fifth column called "Delivery Time (Days)" appear in the Data Center.

 

 IMPORTANT

The DATE function is needed in order to return a result in whole days. If you simply calculate `'Arrival'-'Order'`, you’ll get a long trailing decimal after your answer.

 6

![ONE PROJECT OR MANY](https://info.minitab.com/hs-fs/hubfs/Step%205%20-%20Add%20a%20calculated%20column%20(2).png?width=1080&height=1080&name=Step%205%20-%20Add%20a%20calculated%20column%20(2).png)

### Save the repeatable steps

Now that we’ve created our cleaning steps, review the data pipeline from Source File to Cleanup. If the steps look correct, save the Data Center project.

When the source file changes, refresh the connection to apply the same preparation steps to the latest data. You can also send the prepared data directly to Minitab Statistical Software or Minitab Dashboards.

 

 BUILD A CONNECTED DATA WORKFLOW

 Use prepared data directly in a single project, or reuse it across multiple analyses and dashboards as part of one connected workflow. 

## Recap what you learned

You’ve turned a one-time spreadsheet cleanup into a reusable data connection you can trust. Use the same workflow with other recurring datasets to remove what you don’t need, create consistent measures, and refresh the results when the source changes. That means less time rebuilding cleanup steps and more time using reliable data in dashboards and statistical analysis.

## Continue building your Minitab expertise

### [![ic-2](https://info.minitab.com/hs-fs/hubfs/ic-2.jpg?width=418&height=378&name=ic-2.jpg) Dashboards 15 minutes Make your insights visible across your organization. Learn more →](https://info.minitab.com/minitab-trial/dashboards?hsLang=en)

### [![ic-3](https://info.minitab.com/hs-fs/hubfs/ic-3.jpg?width=418&height=378&name=ic-3.jpg) Statistical Analysis 20 minutes Identify root causes and remove bottlenecks. Learn more →](https://info.minitab.com/minitab-trial/statistical-analysis?hsLang=en)

### [![ic-4](https://info.minitab.com/hs-fs/hubfs/ic-4.jpg?width=418&height=378&name=ic-4.jpg) Design of Experiments 20 minutes Get products to market faster with the same confidence. Learn more →](https://info.minitab.com/minitab-trial/design-of-experiments?hsLang=en)

### [![ic-5](https://info.minitab.com/hs-fs/hubfs/ic-5.jpg?width=418&height=378&name=ic-5.jpg) Predictive Analytics 20 minutes Learn how to predict what will happen next based on current data. Learn more →](https://info.minitab.com/minitab-trial/predictive-analytics?hsLang=en)

---

- [Careers](https://www.minitab.com/company/careers/)
- [Trust Center](https://www.minitab.com/trust-center/)
- [Suppliers](https://www.minitab.com/suppliers/)
- [Site Map](https://www.minitab.com/site-map/)

<https://www.linkedin.com/company/minitab/> [Follow us on Twitter](https://www.facebook.com/Minitab/) [Follow us on Instagram](https://www.youtube.com/user/MinitabInc) [Follow us on Facebook](https://www.instagram.com/minitab/)

---

 © 2026 Minitab, LLC. All Rights Reserved.

- [Terms of Use](https://www.minitab.com/legal/terms-of-use/)
- [Privacy Policy](https://www.minitab.com/legal/privacy-policy/)
- [Legal](https://www.minitab.com/legal/)

- Your Privacy Rights