top of page
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...
100
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...
220
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...
90
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...
30
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...
110
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...
270
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...
30
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...
110
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....
2720
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...
160
bottom of page