Connecting a CSV Source
To bring data in from a CSV file:
- Create a new source -- Click the add button and select CSV as your source type
- Upload your file -- Select a .csv file from your computer (up to 250 MB)
- Wait for processing -- Galdera reads your file and detects the columns. This usually takes 2-5 minutes.
- Map your columns -- Once processing completes, you'll see a column mapping screen:
- Target columns: Select which numeric columns contain the values you want to forecast (e.g., revenue, costs, headcount). Each becomes a measure.
- Dimension columns: Select which categorical columns you want to slice data by (e.g., region, product, department). Each becomes a dimension.
- Date column: Tell Galdera which column contains your dates (e.g., "month" or "date")
- Save -- Galdera creates your measures and dimensions. You're ready to forecast.
- Column names become measure and dimension names -- use clear, descriptive headers in your CSV
- Galdera auto-detects whether your data is in wide format (multiple numeric columns) or long format (one name column + one value column)
- If an upload fails, you can retry or restore to your last successful configuration