Forum Discussion

RogerPou's avatar
RogerPou
Copper Contributor
Dec 24, 2020

Can we use Azure Machine Learning on a Azure Analysis Services?

Hello, it's my first post ever since i was hired as Data Scientist after graduating this month. 

Of course, i have no experience in any cloud microsoft techonologies (yet)  and ask for forgiveness in advance if I mix concepts incorrectly. 

Also, i tried to search similar answers in the forum but sadly found nothing.

 

In our business, we deployed an Azure Analysis Services with our data models ( i think it's called datalake). These models are used most of them for Reporting in Power BI.

 

Right now, we would like to explore more deep types of analysis using machine learning techniques in Azure Machine Learning. 

 

The basic problem is how do i acces to the information in the tabular models in Azure Analysis Services from Azure Machine learning? Is this new platform (Azure ML) able to do that easily, without any trick? 

 

For example, we tried to make some querys (to Azure Analysis Services) from our locals, using python and pyodbc library. This never worked and there's no information (at least i've found) in the internet. The reason to use python to make querys it's for practical reasons. You make the query, and you call still work on the same notebook without downloading anything externaly, then throw X machine learning algorithm to do Classification, Regression... in the data selected in the query to make a Exploratory Data Analysis.

 

So our idea, would be to replace this locals machines for something in the cloud which i hope have a direct implementation to work with that and also better hardware.

 

Am i wrong, right...? Do you have any suggestion of how we should do things?

Please, correct me!

 

Thank you for your answer!

 

 

 

 

 

 

 

 

  • HusseinAwad's avatar
    HusseinAwad
    Copper Contributor
    I think first step you need to do is to get clear about what's your outcome? Of course running the workloads in the cloud is more efficient and easier for you to manage.

    So I'd say understand your data, and put your target then decide which ML algorithms you need to run and how you'll be able to measure the accuracy of your model. Then go ahead and implement this on Azure.

    Hope this helps!

Resources