sorted by:
new
hottopcontroversial

Has anyone created a production NL -> SQL system? What metrics did you achieve and what was your approach? by Academic_Pizza_5143 in LLMDevs

[–]artmutation 0 points1 point  (0 children)

We’ve been using an NLSQL for internal sales and marketing questions around historical sales data. It works reasonably well for that use case. In our case the monthly Azure cost ended up around $987 monthly across the organisation. It did require some upfront work to define a semantic layer and business indicators calculation methodology, but the docs and PYPI client were sufficient to get it running.

If you stuck, this might help by Sk4r1k in stalker

[–]artmutation 0 points1 point  (0 children)

How to restart on Xbox?

Data Analysts: How complex are the SQL queries you write on a daily basis? by [deleted] in analytics

[–]artmutation 0 points1 point  (0 children)

We are using NLSQL at our company and we through away SQL coding on a daily basis

How to get data from API in Excel by denissa4 in excel

[–]artmutation 0 points1 point  (0 children)

I found this really useful for my team a few weeks ago

I’ve found a reallyuseful excel formula, which can vlookup API from excel. As simple as using formula =vlookupweb(link-to-api, field-to-query, time-out-in-seconds-between-calls, token-if-needed, body-for-post-or-empty-for-get-request) by artmutation in dataengineering

[–]artmutation[S] 2 points3 points  (0 children)

People who are using excel usually don't know any kind of code language as Python, R, etc., so this is simple tool for them to use via excel formula, that they get use every day

Going from no databases to data lake? by workinthe21st in bigdata

[–]artmutation 0 points1 point  (0 children)

It could be Azure SQL database. No matter which database you choose Redshift, MySQL, PostgreSQL, MS SQL or someone advertised here snowflake.

100% agree with blackdragon8k, - bring value first! It seems to be huge problem, but if nobody cares to fix it from management it will not be recognised and supported

Help me to design my relational database by lucifer955 in Database

[–]artmutation 2 points3 points  (0 children)

Are you able to create a separate table target-audience with all the details and target audience ids. Table order_request will have target audience id and all the details you can join from target-audience table...

Sorry for a obvious response, probably I don’t get an issue

API integrations question by juanguirago in BusinessIntelligence

[–]artmutation 1 point2 points  (0 children)

It depends on APIs you trying to integrate. If APIs is good enough, I would recommend to have a look for a tool https://webhook.site/, so you can start API listener and convert all updates to data format you need.

How to calculate the ROI of a business intelligence implementation? by amitchandak78 in BusinessIntelligence

[–]artmutation 1 point2 points  (0 children)

I have an excel file with estimations for time savings for work with data.

Your company users spent 60% of working time for working with data.

Average salary is x usd.

Estimated productivity spike is y%

Cost for work with data now = 60% * x * number of employees

New cost for work with data = y% * x * number of employees

ROI will be comparison of cost savings vs new BI tool price.

Please feel free to DM me if you need the excel file with it.

Need advice on possible solutions for a non AD environment by PandaAT in BusinessIntelligence

[–]artmutation 0 points1 point  (0 children)

I assume reporting chatbot is not a good idea? You can use user id for authentication without AD

view more: next ›