hi, i want to build a slack bot that’s going to be able to communicate with our ms sql data and get back the slack message in an easy to rad way.
since the sql tabase is complex as we store 70+ ecom client’s data… i am not sure how my workflow should look like? how to executy it properly…
our idea is to be able to create mvp that our clients could use directly via slack someday, but for now just to be good for internal use…
so e.g if I ask him for MTD revenue and best performing clients with all the key metrics (like per category, per product type, inventory, returns, forecasts, etc) then it should be able to execute needed queries and perform to get the results with key metrics and proposals for improvements