Author Archives: Henry

Innovate Internal and Customer Support with an LLM-Powered Slack Bot for B2B

I’ve been looking for AI use cases in B2B SaaS and lately found out one from Pipedream which is really interesting and I think it’s worth to introduce to more B2B companies.

Pi, a Slack bot powered by Pipedream and GPT-4

Pipedream is an automation platform for developers and they created this Slack bot for their Slack community. Even since I joined their Slack channel, I’ve seen people chat with Pi every day across all kinds of questions regarding Pipedream. Pi is built on top of Pipedream official documents and thus its answer is specific to their business context compared to generic answers from ChatGPT. It definitely helps a lot for both Pipedream team and the community. With this a great success, Pipedream team even shares a detailed article about how to create your own chat bot.

However, before we start creating a similar bot, it’s more useful to know where we come from and where we’re heading to.

LLM I/O

LLM Input/Output
Continue reading

Exploring LLM Use Cases in B2B SaaS Through AI.JSX’s Sidekick

The explosive growth of ChatGPT has seamlessly blended into my daily workflow, fueling strategic discussions and code-writing endeavors. Its significant impact has piqued my curiosity regarding the potential advantages it can unveil for B2B SaaS companies.

On a quest for inspiring use cases, I discovered AI.JSX, a compelling AI application framework for JavaScript. It facilitates the creation of Sidekicks (conversational assistants) using personalized data, presenting a trio of core pillars: DocsQA, Tools, and GenUI.

AI.JSX Sidekick Example
Continue reading

3 Reasons Why Marketing Operation Manager Should Learn Node.js

If you are working in a role in Marketing/Sales/Revenue Operations and your daily work includes automation, integration, and dashboard and reporting, you may wonder, why would I learn a programming language for my daily work when most of the time I can do it without having to write code? Truth is, you would agree that at some point or for some specific tasks, you do wish you could be able to write simple scripts to get things done. Good news is it’s actually not that hard to learn some basics of a programming language and you can apply it to your work right away!

That’s how I started learning Node.js!

Continue reading

How to customize bar colors in a waterfall chart in Google Sheets

Waterfall chart is a good way to show changes overtime. One good example is showing how business revenue is growing in different components over a certain period so that you can have an overview of growth drivers.

Here is a use case where I want to illustrate how ARR is growing in the past year and the formula is very straightforward:

Continue reading

Another Quadratic Programming Example with R

Following Quadratic Programming with R, this is another example of how to solve quadratic programming problem with R package “quadprog“.

Why Another Example?

Quadratic programming matrix math notation
quadratic programming matrix notation

quadprog” package requires us to rewrite the quadratic equation in the proper matrix equation as above. You may have the following questions:

  • What if our equation is to maximize the objective function instead of minimize it?
  • What if the inequality constraints are “less than (<=)” instead of “more than (>=)”?
  • What if there is no equality constraints?

To give you an idea how to answer these questions, this post will give you another example.

Continue reading