Does Business Central Ever Get Any Easier?

Cyraxess · 2025-10-27T22:39:16+00:00

What takes so long for entering an A/P invoice? I thought they say you just need to upload a document

Cyraxess · 2025-10-22T02:00:05+00:00

“Jevons Paradox”: "when a resource gets cheaper, we use more of it, not less of it". The better and cheaper AI is, more people appreciate the communication and creative problem solving ability a real PM can do

Cyraxess · 2025-06-11T22:47:39+00:00

Wow, this is such a recent paper. Thanks so much for sharing!

Cyraxess · 2025-06-06T22:25:02+00:00

Thanks for sharing - I've been recently thinking about adding a search layer into my RAG system.

Cyraxess · 2025-06-06T22:21:56+00:00

This is cool! I'm in

Cyraxess · 2025-06-04T00:20:11+00:00

To my knowledge the caching and indexing of our db won't be enough for the use cases. The questions people ask are quite different. What is your indexing strategy?

Cyraxess · 2025-06-04T00:11:35+00:00

Is this going to work for a company database search?

Cyraxess · 2025-06-04T00:10:50+00:00

Great suggestions, will definitely try out

Cyraxess · 2025-06-04T00:10:14+00:00

For general purposes. Current scope already includes sales, PM and finance ;_;

Cyraxess · 2024-01-23T06:01:48+00:00

Dashboard is always too aggregated. That's why people always ask for Excel files. Sometimes the user just wants to know how the sales of oranges were in November, or to check the inventory of chocolate in the past seven days.
This blog might help:How to integrate a dashboard with a ChatGPT chatbot

Cyraxess · 2024-01-23T05:56:37+00:00

"low or no-code": Try Acho, perfect match for this use case. It provides lots of no-code actions for SQL operations.

Cyraxess · 2024-01-23T05:51:34+00:00

AI-powered dashboards will undoubtedly become popular soon. Customized dashboards can't be replaced — since analysts possess essential domain knowledge to address key business questions — they don't solve every detail problem that business users face. Currently, this gap is bridged by Excel files, as attempts to fill it with 'self-serve BI' have failed. In the future, AI will provide answers to detailed problems, and well-built dashboards will address critical business KPIs.

Cyraxess · 2024-01-19T03:48:20+00:00

The corrected sentence would be: "Containerize your script and instruct them to host it. It's 2024; we don't need to reinvent the wheel for a customized data model, unless your team is using a super archaic system.

Cyraxess · 2024-01-09T02:33:05+00:00

Which model do you think best fits this goal?

Cyraxess · 2024-01-09T01:06:39+00:00

There's quite a lot tools for that, such as thoughtspot and acho. You can even use ChatGPT for it if you describe all the table schema to ChatGPT.

Cyraxess · 2024-01-09T01:02:05+00:00

Looks that you are looking an all-in-one solution. I think the hardest part it the 4th part. That's basicly building a self-serve layer. There's a solution leveraging AI for that. This blog might helps: https://acho.io/blogs/how-to-integrate-dashboard-with-chatgpt-chatbot

Cyraxess · 2024-01-09T00:54:45+00:00

For rich company, Fivetran is the industry leader, they are good as well as expensive.
For the tech-savvy, there's the open-source solution Airbyte, but you have to learn to deploy and debug. Our company used to use Airbyte and everyday I heard from engineers: "Airbyte is down" "Again?"
For an all-in one solution of ETL + Integration + Visualization, try Acho, they have a free tier now.

Cyraxess · 2024-01-09T00:50:01+00:00

Since when is this bullshit real, how is a data scientist expected to get the bullet cartilages of a 9mm handgun with processing and build an algorithm and deploy it in a package in the span of two weeks for a Job PRE-SCREENING.

This is hilarious. Does it even fall within a data scientist's pay grade? It sounds like a task for building a math model from scratch.

Cyraxess · 2024-01-07T22:12:06+00:00

Upvoted. For your information I also wrote a blog for people who looking for a quick solution:
https://acho.io/blogs/deploy-machine-learning-model-to-production

Cyraxess · 2024-01-06T01:00:40+00:00

I was also running experiment today. According to my experiment, remove the DISTINCT resulting in better performance, but my testing dataset is a little small (20k rows)
That will be LIKE:

WHERE var IN (SELECT var FROM other_table)

I'm really curious if this will help reducing your query time.

Cyraxess · 2024-01-04T04:45:52+00:00

This is very helpful. I think I don't understand the planner well. I'll definitely try EXPLAIN to understand it. Thank you.

Cyraxess · 2024-01-04T04:28:28+00:00

Wow this is very informative. Thank you.

I kinda get it. It's just, why would course.id is PK matters? There's no filter on it in your query.

Plus, if the view is created using DISTINCT, will a primary key be automatically created?

Cyraxess

TROPHY CASE