Blog | Xyclos | Ecuador

When to use Excel and when to use Power Query? A practical analysis | Xyclos

Oct 134 min read

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...

Discover the 6 most in-demand roles in Data Analysis | Xyclos

Carlos Altamirano

Oct 46 min read

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...

Power BI: Data Model and Semantic Model | Xyclos

Carlos Altamirano

Sep 233 min read

Power BI: Data Model and Semantic Model | Xyclos

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

Smart Data Analytics: Power BI and ChatGPT in Action | Xyclos

Carlos Altamirano

Sep 173 min read

Smart Data Analytics: Power BI and ChatGPT in Action | Xyclos

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

Interview with PI, an AI that can converse! | Xyclos

Carlos Altamirano

Sep 156 min read

Interview with PI, an AI that can converse! | Xyclos

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...

My first experience programming with ChatGPT and Visual Basic | Xyclos

Carlos Altamirano

Sep 83 min read

My first experience programming with ChatGPT and Visual Basic | Xyclos

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

Pomodoro: The art of learning to pause and rest | Xyclos

Carlos Altamirano

Sep 15 min read

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...

From Excel to Power BI: A Journey of Business Transformation | Xyclos

Carlos Altamirano

Aug 217 min read

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...

Optimizing and improving financial reports in Power BI: A real case

Carlos Altamirano

Aug 163 min read

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

Jul 153 min read

Perplexity: Tips and news | Xyclos

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

Advantages of using DAX Query View in Power BI | Xyclos

Carlos Altamirano

Jul 12 min read

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...

Create custom Data Model pages in Power BI Desktop | Xyclos

Carlos Altamirano

Jun 273 min read

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...

Learn the processes and components of Power BI Desktop | Xyclos

Carlos Altamirano

Jun 202 min read

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...

Are you looking for the best Basic Intermediate Business Excel course? | Xyclos

Carlos Altamirano

Jun 132 min read

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...

Create button to clear all applied slicers in Power BI | Xyclos

Carlos Altamirano

Jun 62 min read

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...

Advanced methods to concatenate cells | Microsoft Excel | Xyclos

Carlos Altamirano

May 222 min read

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...

With Power Query everything is easier | Xyclos

Carlos Altamirano

Apr 194 min read

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...

Concept: Granularity in Power BI and Microsoft Excel | Xyclos

Carlos Altamirano

Apr 131 min read

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...

Convert a date to month as text | Microsoft Excel | Xyclos

Carlos Altamirano

Apr 43 min read

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....

The secret to professional success: UP-Skills, RE-Skills | Xyclos

Carlos Altamirano

Apr 33 min read

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...