nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

OAC DV - Add linear Regression functionality

Thomas HYRIEN

Added linear regressions in the Analysis section, then forecast for certain visualizations such as curves (see the example on the right). In addition to the forecasts already present such as ARIMA, SARIMA, ETS, etc.

Find more posts tagged with

Needs Votes

Status: Needs Votes

Comments

Brendan Tierney

Yes this would be useful and some additional regression lines in other visualizations would also be helpful, along with an AB line

Philippe Lions-Oracle

Thanks @Thomas HYRIEN and @Brendan T

currently using right-click trendline, you can add a linear(regression)/poly/expo trendline on the viz directly, see below, that should already help with the initial question. As for slope and intercept (was that your question ?) these will are provided when the trendline is built on a scatter plot. But when the trendline is using date, X is then normalized to a sequential number and A&B become conventions (funtionally meaningless). Let me know if this does not answer your question

Thanks

Brendan Tierney

https://community.oracle.com/products/oracleanalytics/discussion/comment/71312#Comment_71312

Thanks Philippe

Thomas HYRIEN

Hi,

Thanks,

We would like some additional forecast models in the list in addition to ARIMA, SARIMA, ETS, etc.

Brendan Tierney

While additional algorithms are being requested there is a fuller list of what could be added (some already there)

Autoregression (AR): Predicts future values based on past values of the same series.

Moving Average (MA): Uses the average of previous data points to smooth out fluctuations and identify trends.

ARIMA (Autoregressive Integrated Moving Average): A popular forecasting model that combines AR and MA concepts, often used for non-stationary time series after differencing to make them stationary.

SARIMA (Seasonal ARIMA): An extension of ARIMA designed to handle data with clear seasonal components.

Exponential Smoothing: A family of methods that give more weight to recent observations, including methods like Holt-Winters that capture trend and seasonality.

Vector Autoregression (VAR): An extension of AR for modeling multiple related time series.

LSTM (Long Short-Term Memory) Neural Networks: A type of recurrent neural network well-suited for capturing complex temporal dependencies in time series data.

Prophet: Developed by Facebook, this is a robust forecasting tool designed to handle data with strong seasonal effects and missing values, and is also effective with holiday events.

XGBoost: An efficient and powerful gradient boosting algorithm that can be adapted for time series forecasting on tabular data.

Top Leaders

JeffK 61

Top Ideas

Oracle Analytics Server (OAS) Roadmap for LLM-Based AI and Conversational Assistant Features
Does Oracle have any plans to introduce LLM-based AI features in a future release of Oracle Analytics Server (OAS) on-Premises? In particular, is there a roadmap for bringing capabilities such as the Oracle Analytics AI Assistant or an LLM-powered conversational chatbot, currently available in Oracle Analytics Cloud, to…
Support Attribute-Driven X-Axis and Custom Formula-Based Endpoints in Native OAC Waterfall Charts
Summary of the Enhancement We request two key enhancements to the native Waterfall visualization in OAC Workbooks to support standard financial bridge reporting: Attribute-Driven Category Axis: Allow standard categorical attributes (with custom sorting) directly on the X-axis, removing the current dependency on Date/Time…
Enable API based/programmatic application role creation and configuration in OAC
Currently in OAC, although we can create application roles in the OCI application (e.g Service Administrator), there is no way to programmatically create and configure custom application roles in OAC itself. This has to be done via the console system settings manually in OAC. We are running a large scale OAS > OAC…
Enhancement request for OAC dataset storage management under the 250GB limit
Currently, in Oracle Analytics Cloud (OAC), there is a 250GB storage limit for datasets, but there are no practical management features to operate within this limit. This makes day‑to‑day operations very inconvenient.I would like to request the following enhancements for dataset storage management: Configurable storage…
SQL Passthrough (?) option for manual query datasets
I'm not very technical so if this is a non-starter or there's a solid workaround that already exists, please advise. We have users that query SQL data sources directly in other tools, but then would like to bring that query as a dataset to OAS. Ideally they could create the view in the database and reference that object…