mrc's Cup of Joe Blog

Join us in exploring the world of modern development, evolving technologies, and the art of future-proof software

Business Analytics

Video: How to Chat With Your Database Using AI Data Analytics

Data Analytics with m-Power AI Studio: a user asks for top 10 states by sales and gets a chart from the database

How many report requests are sitting in your queue right now? Maybe Sales wants last quarter’s numbers broken out by state, with a chart for Thursday’s meeting. Or, maybe Operations needs a list of every order that shipped late last week, and why. Each one might be an hour of work, but the problem is that there are forty more behind them.

Meanwhile, your users have discovered AI. Some are asking why they can’t chat with company data the way they chat with ChatGPT. A few, whether you know it or not, are already exporting data and pasting it in.

Both problems have the same fix: Let people ask the database directly (securely, of course).

That’s one thing that m-Power’s AI data analytics assistant aims to solve. It lets business users chat with your data and get back real numbers, analysis, and charts. The AI never connects to your database directly. IT decides which fields it can see, whether or not the query should be read-only, and you pick the LLM.

We just published a short video that walks you through the process:

7 essential elements of embedded analytics software

EducationSummary: What is embedded analytics and why is it so important? What should you look for in an embedded analytics platform? While the requirements vary by company, I believe that certain elements are essential in a good embedded analytics tool. In this article, we explore 7 essential elements you should look for in any good embedded solution.

6 essential elements of modern enterprise reporting software

EducationSummary: What do you look for in a reporting tool? Obviously, the requirements vary by company, but I believe that certain elements are essential in a good reporting tool. In this article, we explore 6 essential elements you should look for in any good reporting solution.

What is business intelligence?

EducationJust the other day, someone asked me this question: “What is business intelligence?” It got me thinking…I frequently write about business intelligence (BI) and why it’s important, but I’ve never really defined the term. In this post, I’d like to take a step back and give you the what, why, who, where, when, and how of business intelligence. Sound good? Okay, let’s get started…

What is business intelligence?
Most companies collect and store data covering all areas of their business. This data sits in a database and is really pretty useless in this format. What do I mean by that? If you looked at data in a database, it wouldn’t make any sense and would most definitely overwhelm you. This is where business intelligence comes into play. Business intelligence is the process of taking that (overwhelming) data in your database and presenting it in an understandable, accessible, and useful fashion. …