top of page


The perfect triad: generative AI + human judgment + deterministic tools | Xyclos
It all started with this idea today, which I made to ChatGPT o3: " LLM's are predictive, and you can't expect consistent or equal...

Carlos Altamirano
25 minutes ago3 min read
1
0


What do I like about functions in Excel and Google Sheets? | Xyclos
What do I like about functions? I like them because when used alone or together, they turn me into a programmer... into a data analyst...

Carlos Altamirano
Apr 103 min read
3
0


Automation in Outlook, Excel, and Power BI | Xyclos
In 2025, everyone is talking about automation and AI agents. And I started to think that I've been managing automation for more than 30...

Carlos Altamirano
Mar 244 min read
6
0


Using Tasks 2025: Outlook, Google, iPhone and ChatGPT | Xyclos
What are tasks? A task is a specific activity that needs to be performed, either at work (such as completing a report) or in personal ...

Carlos Altamirano
Jan 193 min read
3
0


When to use Excel and when to use Power Query? A practical analysis | Xyclos
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...

Carlos Altamirano
Oct 13, 20244 min read
7
0


Discover the 6 most in-demand roles in Data Analysis | Xyclos
In all professions or activities there are always different levels of knowledge and applicability of that knowledge, so a way is sought...

Carlos Altamirano
Oct 4, 20246 min read
2
0


Pomodoro: The art of learning to pause and rest | Xyclos
A while ago I discovered something fascinating: sometimes, in order to move forward, we need to stop. Sounds counterintuitive, right? But...

Carlos Altamirano
Sep 1, 20245 min read
3
0


From Excel to Power BI: A Journey of Business Transformation | Xyclos
The Beginning: An Excel Course that Opened Doors It all started when Diego took an intermediate-advanced business Excel course. That's...

Carlos Altamirano
Aug 21, 20247 min read
8
0


Optimizing and improving financial reports in Power BI: A real case
Introduction In the financial world, the quality of reports depends not only on the data they contain, but also on how this data is...

Carlos Altamirano
Aug 16, 20243 min read
4
0


Perplexity: Tips and news | Xyclos
I always switch between ChatGPT , Claude , Perplexity , You , Pi , Gemini , Copilot when I find myself researching something with...

Carlos Altamirano
Jul 15, 20243 min read
6
0


Advantages of using DAX Query View in Power BI | Xyclos
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...

Carlos Altamirano
Jul 1, 20242 min read
10
0


Create custom Data Model pages in Power BI Desktop | Xyclos
Introduction In the world of data analysis, a well-structured Data Model is the backbone of any Business Intelligence project. In Power...

Carlos Altamirano
Jun 27, 20243 min read
29
0


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

Carlos Altamirano
Jun 20, 20242 min read
9
0


Are you looking for the best Basic Intermediate Business Excel course? | Xyclos
In April of this year 2024, I trained several people from a company in the Basic Intermediate Business Excel course. I evaluated their...

Carlos Altamirano
Jun 13, 20242 min read
3
0


Create button to clear all applied slicers in Power BI | Xyclos
Have you ever found yourself browsing a Power BI report with multiple slicers applied and wishing you could delete them all with a single...

Carlos Altamirano
Jun 6, 20242 min read
17
0


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

Carlos Altamirano
May 22, 20242 min read
28
0


With Power Query everything is easier | Xyclos
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...

Carlos Altamirano
Apr 19, 20244 min read
3
0


Concept: Granularity in Power BI and Microsoft Excel | Xyclos
What is granularity or granularity applied to a Data Model? Granularity is the level of detail that a table contains. In principle it can...

Carlos Altamirano
Apr 13, 20241 min read
11
0


Convert a date to month as text | Microsoft Excel | Xyclos
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....

Carlos Altamirano
Apr 4, 20243 min read
273
0


The secret to professional success: UP-Skills, RE-Skills | Xyclos
Skills We all have one or more abilities or skills that we have acquired over time by performing certain tasks with safety and...

Carlos Altamirano
Apr 3, 20243 min read
16
0
bottom of page