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...
top of page
Carlos Altamirano
- Sep 8
- 3 min
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,...
70
Carlos Altamirano
- Aug 16
- 3 min
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...
20
Carlos Altamirano
- Jul 1
- 2 min
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...
60
Carlos Altamirano
- Jun 27
- 3 min
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...
210
Carlos Altamirano
- Jun 20
- 2 min
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...
90
Carlos Altamirano
- Jun 13
- 2 min
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...
30
Carlos Altamirano
- Jun 6
- 2 min
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...
100
Carlos Altamirano
- May 22
- 2 min
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...
270
Carlos Altamirano
- Apr 19
- 4 min
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...
30
Carlos Altamirano
- Apr 13
- 1 min
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...
100
Carlos Altamirano
- Apr 4
- 3 min
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....
2710
Carlos Altamirano
- Apr 3
- 3 min
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...
160
bottom of page