Upload Dataset

Last modified: May 27, 2022

You must be an admin to upload datasets. You can upload data via Designer with the Auto Insights Uploader tool or directly in Auto Insights. There are two ways to upload data in Auto Insights: direct database connection or CSV file upload. 

To upload a dataset...

  1. In Auto Insights go to Datasets > Create dataset in Admin Portal.
    Create dataset in Admin Portal button
  2. Select Datasets > + Add a new dataset. The View Requirements page displays.
  3. Verify that your dataset meets the requirements and select Get Started
  4. Enter a name for your dataset. Then review and check the box next to the PII statement. Note, 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).
  5. Select Continue
  6. Select a data source–either Database Connection or Upload CSV. Learn more about connecting to a database.
    Select a data source screen
  7. 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.
  8. Auto Insights provides a preview of your data, so you can confirm that what you uploaded is correct. At this point, we recommend you check that your Date format is YYYY. Auto Insights does not support YY format.
  9. Select Analyse. Auto Insights begins analyzing your data. 
  10.  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 which Auto Insights use as default in Discover 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 Amount, Expense Amount). For the Measure fields, specify if this is a good thing when it increases (for example, it's good when sales increases, and not good when costs increase), and can this be aggregated over time? Most of the time it is yes unless you have something like a bank balance, where you cannot sum the balance over time.
      Column toggles
  11. Rename if necessary. We recommend trying to make names as natural language as possible. For example:
    • "Claim_Number" change to "Claims"
    • "Sale_Amount_inc_GST" change to "Sales"
    • "Dept_Desc" change to "Department"
    • "Vendor_Supply_Name" change to "Supplier"
  12. Once you have completed your review, select Upload to Alteryx Now. Auto Insights generates insights, meaning there's no need to start from scratch building dashboards, views, or visualizations.

If something goes wrong, we have a troubleshooting guide to help.

Explore Your Data and Set Your Dataset Settings

Explore Dataset

Explore Your Dataset

You're ready to explore your dataset, check out our quick-start guide. In rare cases where Discover doesn't give you any insights, you can find out why by using this Discover troubleshooting guide.

Set Key Measures

The final step before the data is ready for business users is to provide context on what Auto Insights is calling out for your business. Learn how you can tailor the insights that Auto Insights highlights to be relevant to your business here.

Add Goals

With Goals, Auto Insights can help you track your performance against your KPIs with precision. Once Goals are imported, they display in Missions so you can work together with your team to achieve better outcomes. Learn about this beta feature

Give Users Access

Now you're happy with your dataset you can read the Administrator Guide to learn how to assign users to your dataset.

Was This Page Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support. Can't submit this form? Email us.