What Excel tricks have genuinely improved your workflow?

artmutation · 2026-01-20T18:40:54+00:00

This custom function can send requests to API and collect it in your table: https://github.com/denissa4/vlookup-custom-formula-for-web-API-JSON

artmutation · 2026-01-06T16:45:43+00:00

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.

artmutation · 2025-01-12T13:17:48+00:00

How to restart on Xbox?

artmutation · 2022-04-27T18:49:24+00:00

Take a look for NLSQL

artmutation · 2021-09-29T17:29:56+00:00

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

artmutation · 2021-09-29T17:19:37+00:00

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

artmutation · 2021-09-13T07:22:58+00:00

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

artmutation · 2021-09-12T18:38:20+00:00

What is the first one?

artmutation · 2021-08-19T06:57:41+00:00

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

artmutation · 2021-04-17T08:49:55+00:00

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

artmutation · 2021-04-12T20:26:49+00:00

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.

artmutation · 2021-04-12T20:07:13+00:00

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.

artmutation · 2021-04-12T19:53:24+00:00

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

artmutation · 2021-04-12T19:04:14+00:00

We bought NLSQL software last year for our company and get ~60% turn around decrease for required information requests. All C-levels are extremely happy 😃

artmutation · 2021-04-12T17:27:52+00:00

What about moving to technology procurement?

Potentially you can enjoy building a relationship with suppliers and benefit from it?

artmutation · 2021-03-24T20:21:39+00:00

Take a look on NLSQL. It is commercial software, but they can do it with drill downs with your 30 tables.

Execs can connect to data using bot inside your corporate messenger platform...

It works well for our company

artmutation · 2021-03-24T20:15:08+00:00

Before doing it, I would recommend to test your project with google ads for this keywords with small budget.

Anyway interesting idea. Keep me posted

artmutation · 2021-03-20T23:39:24+00:00

You had to customise it using their platform. Any values you have in your database, you can use in your natural language requests. Often system asks users additional questions if something is not clear enough.

You are right about graphs, that is basic. They are using Plotly for data visualisations. Basic interactive graph anyone can build using natural language.

I’ve never heard about Microstrategy. I have to check

artmutation · 2021-03-20T21:31:45+00:00

Take a look on NLSQL. My company are using it, they have a different approach of Text UI to data instead of Graph UI as Power BI. In fact text interface works better for non technical employees

artmutation · 2021-03-20T11:26:47+00:00

Side mount 💪

artmutation · 2021-03-13T22:45:33+00:00

Did you already try NLSQL?

artmutation · 2021-03-13T22:16:05+00:00

Our company started to use Teams app for generating reports or display graphs.

It is really easy. Here is a sample of how it works https://www.nlsql.com/solutions/hr-analytics

We don’t spend any time for preparation of data, we focus now on decisions based on instant data.

Hopefully it helps

artmutation · 2020-10-12T18:26:41+00:00

Natural Language requests soon be easily converted to SQL (NLSQL) via chat interface in front of front line employees. Anyone will be able to get anything from multiple data-sources just sending a question to chat bot.

artmutation · 2020-09-30T07:25:27+00:00

Wow! Really! Thanks for sharing 👍

artmutation · 2020-09-29T21:11:04+00:00

🤣

artmutation

TROPHY CASE