June 24, 2016 at 7:50 am
Our company just set up a SSAS Tabular instance and so far building the star schema has been absolutely brilliant, one snafu we have ran into though. The Excel data-mining plug in doesn't seem to work with the Tabular instance. Is there other tools out there that can perform time series and other predictive analysis off of the tabular version? While the processing speed of the tabular version is tremendous, it lacks this one key component.
Any suggestions in regards to mining tabular data, such as using the ARTxp or ARIMA algorithms?
Querying Microsoft SQL Server 2012/2014 - Certified
June 24, 2016 at 8:28 am
There are some time-series calculations possible by using DAX in Tabular models, but as far as I know there isn't anything close to ARTxx or ARIMA available in that product.
For pre SQL Server 2016 instances, you can create a data mining model in SSDT which will allow you to perform statistical analysis over a data set. If you're fortunate enough to be on SQL Server 2016, I'd recommend looking at R which is now available from within the SQL Server product suite.
June 24, 2016 at 8:40 am
Thanks for the heads up. I think what we going to end up doing is just moving our multidimensional box to the BI version and using that to perform data mining off the tabular sets. (Sorry a rookie so hope this makes sense).
Querying Microsoft SQL Server 2012/2014 - Certified
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply