Raw Data Viewer
Overview
The Raw Data Viewer in my8data allows you to view, check, and analyze measurement data in its unprocessed form. Before transferring measurement values to a statistical analysis (MFU, SPC, process capability), you can review the raw data here, check for plausibility, and have basic statistical metrics calculated.
Scope of Functions
| Function | Description |
|---|---|
| Data Display | Tabular display of all imported measurement values |
| Sorting | Sort data by any column (ascending/descending) |
| Filtering | Restrict display to specific value ranges or criteria |
| Statistical Metrics | Automatic calculation of mean, standard deviation, min, max, median |
| Outlier Detection | Identification of unusual measurement values |
| Data Export | Export (filtered) data in various formats |
When Do You Use the Raw Data Viewer?
- Before Analysis: Check your data for completeness and plausibility before starting an MFU, SPC, or process capability analysis
- Data Cleaning: Identify and mark erroneous measurement values or outliers
- Data Understanding: Get an initial impression of the distribution and characteristics of your data
- Traceability: Document the raw data for traceability and audits
Info: The Raw Data Viewer does not change your original data. All filter and sort operations affect only the display. The underlying data remains unchanged.
Displayed Statistical Metrics
For each numerical column, the viewer automatically calculates the following metrics:
| Metric | Formula Symbol | Description |
|---|---|---|
| Count | n | Total number of measurement values |
| Mean | x̄ | Arithmetic mean of all values |
| Standard Deviation | s | Measure of the dispersion of values around the mean |
| Minimum | Min | Smallest measurement value |
| Maximum | Max | Largest measurement value |
| Range | R | Difference between maximum and minimum (R = Max - Min) |
| Median | x̃ | Central value; 50% of values lie above it, 50% below |
Tip: Compare the mean and median. If these values are close to each other, this indicates a symmetric distribution. A large deviation indicates a skewed distribution or outliers.
Data Import
Supported Formats
my8data supports importing raw data from various file formats:
| Format | File Extension | Description | Special Features |
|---|---|---|---|
| CSV | .csv | Comma- or semicolon-separated text file | Delimiter is automatically detected; UTF-8 and ANSI are supported |
| Excel | .xlsx, .xls | Microsoft Excel workbook | Multiple worksheets are supported; selection of desired sheet possible |
| Text File | .txt | Tab-separated or formatted text file | Various delimiters configurable |
Import Procedure
Step 1: Select File
Click Select File or drag the file into the upload area using Drag & Drop. Supported file sizes depend on your plan and server configuration.
Step 2: Check Import Settings
After uploading, my8data displays a preview of the detected data. Review the following settings:
| Setting | Description | Default Value |
|---|---|---|
| Delimiter | Character that separates columns | Automatic detection |
| Decimal Separator | Comma or period | Automatic detection |
| Header Row | Does the first row contain column headings? | Yes |
| Columns to Import | Selection of relevant data columns | All columns |
| Data Type | Numeric, text, date | Automatic detection |
Warning: Pay special attention to the decimal separator. German-language files often use the comma as a decimal separator (e.g., 10,05), while English-language files use the period (e.g., 10.05). An incorrect setting will result in erroneous measurement values.
Step 3: Import Data
After reviewing the preview, click Import. The data is loaded into the Raw Data Viewer and statistical metrics are automatically calculated.
Import from Clipboard
As an alternative to file import, you can also paste measurement values directly from the clipboard:
- Select and copy the measurement values in your source program (e.g., Excel, measurement software)
- In the Raw Data Viewer, click Paste from Clipboard
- The data is automatically detected and inserted into the table
Tip: If you regularly import data from the same source, create a template with the correct column structure. This allows you to reuse import settings and saves time on recurring imports.
Import Troubleshooting
| Problem | Possible Cause | Solution |
|---|---|---|
| All values in one column | Wrong delimiter detected | Set delimiter manually |
| Values recognized as text | Decimal separator incorrect | Adjust decimal separator |
| Empty rows or columns | Source file formatting | Clean up source file or select ranges manually |
| Special characters in column names | Encoding issue (e.g., umlauts) | Save file as UTF-8 |
| Import aborts | File too large or corrupted | Split file into smaller parts |
Info: my8data logs the import process. If problems occur, you will find detailed error messages in the import log, which will help you diagnose the issue.