#ia

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

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

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

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

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

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

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

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

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

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