Transaction Conditions in MicroStrategy

This week we will continue to explore the transactional part a little bit more. We’ve already learned the basics and how it works, but today we’re going to take a look at other features of MicroStrategy’s transaction Services, so let’s get started!

Read More »

MAIN CATEGORIES

MicroStrategy

Power BI

General

MicroStrategy Pass Through Functions

MicroStrategy Pass Through Functions

This week I bring a very useful functionality in MicroStrategy: Pass-through functionalities, which allow us to add by hand a query (or, rather, part of the query) to give a little more flexibility to the query we want to create or use.

Read More »
OneDrive personal y PowerBI

OneDrive personal as data source in PowerBI

We will show you through a few small changes, how you can use OneDrive personal (free) to upload and update the Service data from CSV or Excel files on those occasions that we do not have a OneDrive for Business, Sharepoint account or we can not use the On-premise Data Gateway.

Read More »
MicroStrategy Backup

MicroStrategy Backup

This week I bring an article that is always good to have on hand. Let’s be honest, who has never accidentally deleted or overwritten an object? How many Christs remembered and curses to heaven when having to remake an object again for not making an emergency copy? Haha relax, we’ve all been there at some point, and on the way to not repeat it, today I’ll tell you a little bit about the backup and restore methodology. Join me!

Read More »
Slowly Changing Dimensions

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 »
AI Unsupervised Learning

AI: Unsupervised Learning

Within the Machine Learning area, we can find several types of learning, including unsupervised learning. This area has a lot of potentials, as it saves us the tedious task of having a set of labeled data.

Read More »

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 »
Business Data Master Logo

No te pierdas el

WEBINAR
Gratuito

Explicaremos en detalle los contenidos y objetivos del Business Data Master

29/11/2021

18:30 (GTM+1)

Online

BUSINESS DATA MASTER

* Tu información será utilizada exclusivamente para contactarte en relación al Business Data Master. No hacemos spam ni compartimos datos con terceros.