Data Mining Part 31: DMX functions

• Daniel Calbimonte

  SSCertifiable

  Points: 6292

  More actions

  August 13, 2015 at 12:06 am

  #319829

  Comments posted to this topic are about the item Data Mining Part 31: DMX functions

• xsevensinzx

  One Orange Chip

  Points: 25560

  More actions

  August 13, 2015 at 9:08 pm

  #1819941

  Thanks for the great article.

  Here is a question unrelated to the article, but related to the topic.

  Why would someone use SSAS as opposed to R and Python?

  I ask because I work with a lot of fans of R. Others I know who work in data analysis, especially in startups and so forth are using Python. I know very few who are actually leverage SSAS Data Mining for any analysis unless they are specifically a Microsoft BI professional who consults for the purpose of setting up Microsoft BI stacks and so forth. This does not include those using SSAS for OLAP Cubes, which a lot more people use SSAS for that purpose. I view Data Mining separate.

  I personally have done some cool things in SSAS that you have covered. It's not too hard to start doing forecasting and so forth. It seems to have a lot of popular models. But, I'm not a data scientist either. So, I don't see the pros and cons of why I shouldn't leverage SSAS over R or Python when my data is already living in SQL Server?

  Any insight is much appreciated in your experience.

• Daniel Calbimonte

  SSCertifiable

  Points: 6292

  More actions

  August 14, 2015 at 4:57 pm

  #1820251

  It is hard to say. It is like Facebook. There are other better social media apps, but Facebook is the most popular. It is not a feature problem. It is a marketing matter. It requires more publicity.

  SSAS and Data Mining are great tools, it has thousands of customers, but not millions of customers like other tools.

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  August 18, 2015 at 8:04 am

  #1820747

  Another great chapter in the series.