BI SQL Data Science & Data Mining tool to do forensic / other analytics

Question

BI SQL Data Science & Data Mining tool to do forensic / other analytics

IC IC 236

Good day,

I have a need to improve the analytics within the company, from olap reporting & powerbi
theres a strong need for users to analytically interpret any set of data

Looking into data science tool to plug into data warehouse

Similar Auditing forensic tool where user can setup rules to identify patterns & anomalies & errors
Data science
Machine learning

Preferably BI SQL toolset

Please guide me , is it something i canesign off my sql 2014 > 2019 environment using the data science or is there a tool i can purchase that auditors use for forensics where its very flexible for users to design own rules and BI Tool/highlights shows anomolies

please this will be a great step forward
Thank you

Leon Laude 86,026 Reputation points

2020-10-10T07:53:24.52+00:00

Hi @IC IC ,

PowerBI is currently not supported in the Q&A forums, the supported products are listed over here https://learn.microsoft.com/en-us/answers/products (more to be added later on).

You can ask the experts in the dedicated PowerBI forum over here:
https://community.powerbi.com/t5/Forums/ct-p/PBI_Comm_Forums

----------

(If the reply was helpful please don't forget to upvote or accept as answer, thank you)

Best regards,
Leon
IC IC 236 Reputation points

2020-10-10T09:20:00.277+00:00

Thank You,

However im not specifically looking for powerbi, im looking for a BI forensic tool where rules are setup by users that plugs onto a sql data warehouse where users can do there own data science or something

Any help please

1 answer

Your answer

Leon Laude 86,026 Reputation points

2020-10-10T07:53:24.52+00:00

Hi @IC IC ,

PowerBI is currently not supported in the Q&A forums, the supported products are listed over here https://learn.microsoft.com/en-us/answers/products (more to be added later on).

You can ask the experts in the dedicated PowerBI forum over here:
https://community.powerbi.com/t5/Forums/ct-p/PBI_Comm_Forums

----------

(If the reply was helpful please don't forget to upvote or accept as answer, thank you)

Best regards,
Leon
IC IC 236 Reputation points

2020-10-10T09:20:00.277+00:00

Thank You,

However im not specifically looking for powerbi, im looking for a BI forensic tool where rules are setup by users that plugs onto a sql data warehouse where users can do there own data science or something

Any help please

Answer 1

HarithaMaddi-MSFT 10,146

Hi @IC IC ,

Welcome to Microsoft Q&A Platform. Thanks for posting the query.

Unfortunately, as per my knowledge, there is no single tool that helps us doing all the data science related activities in an automated way. All the tools in place requires certain amount of coding and finetuning as per changing requirements from users.

Azure Data Studio is one great tool which can be used to write sophisticated queries with an user interface that can help in analytic queries, additional reference to this
Auto ML helps in automating the time consuming, iterative tasks of machine learning model development

Please let us know if this helps or for any specific requirements and we will be glad to assist further.

HarithaMaddi-MSFT 10,146 Reputation points

2020-10-13T18:20:35.31+00:00

Hi @IC IC ,

We have not received a response from you. Please let us know if above answer is helpful. Otherwise, let us know and we will continue to engage with you on the query.

Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members
IC IC 236 Reputation points

2020-10-13T19:29:29.913+00:00

Hi,

Thank you so much,
how does licensing work & can i do a trial period
can i do this using sime-private sql database and not cloud?
corporate company does not want to move over
is there more detail rearding the tools

is there freeware to test

regards
HarithaMaddi-MSFT 10,146 Reputation points

2020-10-14T07:48:33.433+00:00
Hi @IC IC ,

Thanks for sharing the queries.

Azure data studio is an open-source tool and yes, it can connect to on-prem SQL database as well. This document has details on the same.

Using Auto ML feature, customers incur the costs associated with the Azure resources consumed (for example, compute and storage costs). There are no additional fees associated with Azure Machine Learning. Please refer this document for pricing details on the same.

Please let us know for further queries and we will be glad to assist.
IC IC 236 Reputation points

2020-10-14T18:51:10.263+00:00

Great stuff!

Do i need to use Auto ML, i dont want to setup azure account yet as corporate dont want cloud storage

?
Thanks
HarithaMaddi-MSFT 10,146 Reputation points

2020-10-15T07:07:40.693+00:00

Hi @IC IC ,

Azure data studio can be used for machine learning model building as well but requires coding. Auto ML is an UI tool where we can input data and it will generate models using various algorithms along with their performance details on the model.

Hope this clarifies the query!
HarithaMaddi-MSFT 10,146 Reputation points

2020-10-16T08:12:36.417+00:00

Hi @IC IC ,

We have not received a response from you. Following up to check if above details helped clarify the question. Otherwise, we will continue to engage with you on the issue.

Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members
Ismail Cassiem 226 Reputation points

2020-10-18T16:20:44.24+00:00

Thank You very much
HarithaMaddi-MSFT 10,146 Reputation points

2020-10-19T08:22:49.207+00:00
Thanks @Ismail Cassiem .

-----------------------------------------------------------------------------------------------------------

Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.

Want a reminder to come back and check responses? Here is how to subscribe to a notification.
Ismail Cassiem 226 Reputation points

2020-10-19T08:27:51.963+00:00

Hi,

I dont see an accept answer button
HarithaMaddi-MSFT 10,146 Reputation points

2020-10-19T08:33:55.847+00:00

Thanks @Ismail Cassiem for reaching out. Please use original account used for posting the question to accept the answer. Kindly let us know if still unable to accept and we will be glad to assist further.
HarithaMaddi-MSFT 10,146 Reputation points

2020-10-20T06:26:38.617+00:00
Hi @IC IC and @Ismail Cassiem ,

We have not received a response from you. Please let us know for any challenges in accepting the answer.

------------------------------------------------------------------------------------------------

Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.

Want a reminder to come back and check responses? Here is how to subscribe to a notification.
HarithaMaddi-MSFT 10,146 Reputation points

2020-10-21T08:22:09.697+00:00

Hi @IC IC and @Ismail Cassiem ,

We still have not heard back from you. Please let us know for any further queries or challenges in accepting the answer.

Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members

Share via

BI SQL Data Science & Data Mining tool to do forensic / other analytics

1 answer

Your answer