Blog
Notes on data warehouses, BI, SQL and analytics.
How to increase trust in the answers of an AI agent?
Connecting an AI agent to ClickHouse over MCP is an evening of work. Making its answers trustworthy is already a project. A breakdown based on a real rollout.
How to speed up a dashboard?
A well-made dashboard is not only about useful charts and tables. A good dashboard should load fast, and certainly should not fail with an error because of
Interview on Zerocoder
The training center Zerocoder published an interview with me about analytics and the use of AI in business tasks. I talked about how I got into BI and
Removing duplicates from Google BigQuery tables
The task of removing duplicates from a BigQuery table can be solved in different ways. Let's look at a few of them.
How to do an UPSERT in Google BigQuery?
There are several ways to implement an UPSERT operation in BigQuery. I will describe one of these approaches in this article.
Visualizing Date Gaps in Google Data Studio
I have a dashboard for monitoring integrations with various services. For example, in it I track the completeness of the data being collected
How to calculate MAU for each day in Google BigQuery?
A short guide on how to create a table in Google BigQuery that outputs MAU (monthly active users) for each day, as well as WAU
Filtering Out the Current Month with Google Data Studio
Recently I had a task to visualize data in Google Data Studio. Lots of charts and tables with data grouped
When there is neither a class nor an id…
Sometimes you come across buttons on pages that you really, really need to add click tracking to via Google Tag Manager, but identifying
Setting Up Dynamic Remarketing in GTM Without a Developer
Often, to attract traffic, an online store uses several remarketing systems at once, such as Google Ads, the Facebook pixel, VK, myTarget