Import Data via Admin Portal

In Auto Insights, select your user avatar to open the user menu and select Admin Portal.

Select Datasets > + Add a new dataset > Admin Portal. The View Requirements page displays.

Verify that your dataset meets the requirements and select Get Started.

Enter a name for your dataset. Then review and check the box next to the PII statement. Note, that a dataset name must start with a letter and can only contain lowercase letters, numbers, or underscores. Our recommendation is to keep it simple and reusable. We don't recommend dataset names with dates and months (Supermarket_data_20200101) or version numbers (Supermarket_data_v2).

Select Continue.

Select a data source–either Database Connection or Upload CSV. Learn more about connecting to a database.

Select Continue.

1. If you select Upload CSV, a window displays to either drag and drop or browse files. Your file must be comma-delimited, in CSV or Zip format, and must not exceed 2GB in size. For larger sizes and scheduled refreshes, use a database connection.

2. If you select Database Connection, a window displays to enter database connection details. Enter Database Type, Database Name, Host IP/DNS, Port, Username, Password, and Table Name or Query Statement.

Auto Insights provides a preview of your data, so you can confirm that what you uploaded is correct. At this point, check that your Date format is YYYY. Auto Insights does not support the YY format.

Select Analyse. Auto Insights begins analyzing your data.

Confirm your column fields are correct. You can update column headings, or turn off columns you don't want to show. There might be some columns that are unavailable. If it's still required for you to analyze them, turn them back on. The main reason for Auto Insights switching the column off is due to a large proportion of missing data in that column.

1. Dates: Indicators of time

   For the Date fields please specify your Financial Year Start Month and if it should be the Default Date. Default Dates are those that Auto Insights uses as default in Missions and Search unless otherwise specified in the Search question.

2. Segments: Dimensions you can break your measures down by (for example, Categorical fields such as Departments, Age Groups, Gender, or Supplier Names).

3. Measures: Fields Auto Insights can sum or aggregate (for example, numeric fields such as Sales Amounts, Quantities, Spend Amounts, and Expense Amounts). For the Measure fields, specify if this is a good thing when it increases (for example, it's good when sales increase, and not good when costs increase), and can be aggregated over time. Most of the time it is yes unless you have, for example, a bank balance, where you cannot sum the balance over time.

   

Once you have completed your review, select Upload to Alteryx Auto Insights. Auto Insights generates insights, meaning there's no need to start from scratch building dashboards, views, or visualizations.