4 ms·
Main use case for BI analyst is generally something along the lines of integrating data from a few data sources (CRM, e-commerce etc) into a single data warehou
by sails 6y ago
Main use case for BI analyst is generally something along the lines of integrating data from a few data sources (CRM, e-commerce etc) into a single data warehouse and then building analytical investigations on that data, most typically to track and distribute KPIs.
Typically in this workflow there is some or other use case that involves some minor predictive element (eg: who are the most likely leads to convert to sales) which then requires some light ML to make a prediction. This often results in very little in the way of actionable outcomes, but doesn't seem to stop people wanting to do it.
I wrote a blog about the stack and workflow [1]. This is quite an established domain.
Probably an easier route for a snowflake customer is to call the ML function using this new Snowflake feature: External Functions[2]
[1] https://groupby1.substack.com/p/data-as-a-utility-tool https://groupby1.substack.com/p/data-as-a-utility-tool
[2] https://docs.snowflake.com/en/sql-reference/external-functions-introduction.html https://docs.snowflake.com/en/sql-reference/external-functio...