A data source is any tabular structure. You get to see data source values after you load a file or send a query to a service that returns results.
A data source can contain any of the following:
- Match columns - These contain values that are found in the match column of another source, which relates this source to the other, for example, Customer ID or Product ID.
- Attribute columns - These contain text, dates, or numbers that are required individually and aren’t aggregated, for example, Year, Category Country, Type, or Name.
- Measure columns - These contain values that should be aggregated, for example, Revenue or Miles driven.
You can analyze a data source on its own, or you can analyze two or more data sources together, depending on what the data source contains. If you use multiple sources together, then at least one match column must exist in each source. The requirements for matching are:
- The sources contain common values, for example, Customer ID or Product ID.
- The match must be of the same data type, for example, number with number, date with date, or text with text.