Slowly Changing Dimensions

The way to keep in our Data Warehouse a history of all the changes that allow us to explore the specific value of data at a given time is by applying the Slowly Changing Dimensions (SCD) methodologies.

Read More »

MAIN CATEGORIES

MicroStrategy

General

MicroStrategy Definition of Fact Tables in queries

Esta semana volvemos con una nueva historia vivida en carne propia, de estas que te dan respaldo a la experiencia como consultor, de aquellas que se aprende cuando uno las vive.

In my case, it was a situation that I knew how to solve, but it is a situation that is not common to see and I thought it was appropriate to tell you about it. This week I am going to tell you how we can control which tables will dominate the queries when creating reports in MicroStrategy.

Read More »

MicroStrategy Training Metrics

This week I bring a topic that has been in MicroStrategy for many years, but few people know about it and companies spend thousands of dollars to implement it in an outsourced way. Sometimes it may be justified, as this is an out-of-the-box solution, but believe me, if it were better known, it would be used a lot. And yes, we are talking about machine learning techniques integrated with MicroStrategy! So, without further delay, the topic of the week: Training Metrics.

Read More »
AI NLP Natural Language Processing

AI: NLP – Natural Language Processing

NLP or Natural Language Processing (NLP) is a branch of Artificial Intelligence (AI) that helps computers understand, interpret and process human language. Some examples of use are translation, audio transcription, conversation, information recovery…

Read More »
AI Image Classification

AI: Image classification

In recent years, the technology associated with Artificial Intelligence (AI) has undergone great development, which is giving rise to new tools and applications that were previously unthinkable: object detection, image segmentation, analysis of people, diagnosis of diseases…

Read More »
How to Create Presentations with MicroStartegy

How to Create Presentations with MicroStrategy

This week, I bring you a twist on a tool we are used to, for a functionality that is not specifically related to BI: Using Dossiers for presentations.

Yes, yes, you heard right, and I am not talking about the pure and simple data analysis we are used to. Let’s analyse a bit: We use presentations and PowerPoint to defend an idea, to explain something, to make a proposal, to present results, etc?

Read More »
webinar: Gestalt laws

Webinar: Gestalt Laws

After the overwhelming success of the video series and article on the Laws of Gestalt, MicroStrategy and Joaquín Attanasio present the definitive webinar.

Read More »
MicroStrategy Types of Caches

MicroStrategy Types of Caches

Today, we will continue to delve a little deeper into optimisation techniques and take a look at the different types of caches available in MicroStrategy.

As you may have noticed, in the previous article we talked about the report cache specifically, but there are other types of cache that play a part in the optimisation of the tool. Let’s analyse them.

Read More »
MicroStrategy Transformations

MicroStrategy Transformations

This week I am taking you on a journey through time and space. Sounds like a Bradbury story or a Stephen Hopkins theory, doesn’t it? So today we will take our metrics, put them in the DeLorean and make them travel back in time and into other dimensions to see what value they correspond to wherever we go. So fasten your seatbelts, because today we will be looking at: Transformations.

Read More »