I have published hundreds of articles on my blog on various topics and I wanted to categorize them to have better control over them for...

In all professions or activities there are always different levels of knowledge and applicability of that knowledge, so a way is sought...

In Power BI and other computing systems, two terms are used when creating the conditions to optimize data usability, carried out in this...

The best of both worlds. In Power BI, I created 3 measures to understand the performance of a client's bottle production: Total bottles...

But what better way to learn about someone: by asking them, by interviewing them. Let's see what Pi has to tell us about Pi . Pi is a...

Introduction I had a very special and interesting request from a customer. Marcela, a service salesperson for an international company,...

A while ago I discovered something fascinating: sometimes, in order to move forward, we need to stop. Sounds counterintuitive, right? But...

The Beginning: An Excel Course that Opened Doors It all started when Diego took an intermediate-advanced business Excel course. That's...

Introduction In the financial world, the quality of reports depends not only on the data they contain, but also on how this data is...

I always switch between ChatGPT , Claude , Perplexity , You , Pi , Gemini , Copilot when I find myself researching something with...

In Power BI Desktop we have a very useful tool to visualize the results of DAX instructions before using them in our Model. It is called...

Introduction In the world of data analysis, a well-structured Data Model is the backbone of any Business Intelligence project. In Power...

This is an introduction to the process and components we have in the Power BI Desktop application, for Windows. Power Query It is the...

In April of this year 2024, I trained several people from a company in the Basic Intermediate Business Excel course. I evaluated their...

Have you ever found yourself browsing a Power BI report with multiple slicers applied and wishing you could delete them all with a single...

When we need to concatenate or join cells, we have several functions that can help us with this: Concatenate Concat Textjoin Suppose we...

Case to solve The other day a client called me who had the following problem. On the one hand, it has a book currently made up of 3 tabs...

What is granularity or granularity applied to a Data Model? Granularity is the level of detail that a table contains. In principle it can...

We are going to learn how to display and how to extract the month from a date, along with other examples that include the day and year....

Skills We all have one or more abilities or skills that we have acquired over time by performing certain tasks with safety and...