i recently joined a company that uses microstrategy as its BI platform… previously i had spent the last 10 years working with Tableau.

i can’t seem to find any good training materials or even a general community. Tableau had an amazing online community and countless blogs, tutorials, etc - if i could find something that is even 10% of that for microstrategy i would be so happy.

any tips or suggestions?

The best part about MicroStrategy is that cute little HackaTron mascot, don't yall agree?

With the additions of Migrations and the pretty continuous updates to mstrio in general has anyone attempted to do a project duplication using mstrio / is this even possible yet?

I haven't fully wrapped my head around migrations yet and how they are constructed with the Migration object and the package etc.

I can see methods to export the project settings and also creating a new project looks simple enough, however the tricky bit I think is the copying of the objects from one project to another

Would a package of type Project be able to hold such a large around of objects? I suspect not but would be curious to hear of people's experiences

Context:

I have a customer who has a lot of Service Hierarchy layers. We have built a scoring model based on their lower level of thier service which is Business Service and the currrent dashboard looks something like below.

I'm using the "Enable Outline" feaure to show the Hierarchy.

Service A

• Service 1

• Service i

• Service

• Score

Now, the score is calculated at the lowest layer. And then I use the "Show Totals" option to show totals at each of these layers.

Problem:

Some of the services after layer 2 are misssing. In that case, our model shows UNSPECIFIED - Now clicking on the UNSPECIFIED bring me the scores of all the all the UNSPECIFIED ones(in a diff grid) which is not something that I want.

How should I approach this?

Hopefully this sub isn't all about crypto. I have a dossier that has 3 datasets in it. Some scheduling data. Some productivity data and some quality scores. The only common element is a user. However the users are all in different formats - firstname last name lastname, first... There is no userid or common way to join the 3 tables natively. I have created a crosswalk table with 3 different ways of making names and 1 "gold standard" . I'd like to use that gold standard as a filter item that filters all visualizations in a chapter. However when I "link to other dataset" the 3 fields to the tables, things start going away. I know the joins work, the data are correct. Is what I am trying to do feasible? I tried linking 1 field to each of the tables and that does work. I don't lose data. But if I link the second and or third, things change.

I have created two versions of my metric, lets call them Sales 1 and Sales 2, I have two attributes product group and Brand. I would like to have product group and brand as separate bars which are also filterable independently of one another. So I could compare brand A's performance vs brand B's performance (by filtering between them) as a portion of the total of a selected product group. Ie what is the contribution canned beans brand A is of the total product category of canned beans. I have created a graph with two instances of the metric sales. I have added in my dashboard two filters, one for brand and one for product group but when I apply the target of those filters to the graph, they apply to both metric/ the whole report rather than the metric independently. I found a how to which suggested targeting the filters scope by selecting 'Filter settings or properties' but neither of those are an option when I open the three dot menu. Is there any way to do this, or am I missing something? Thanks.

Hello,

I'm working as an analyst and my role requires me to visualize and present data. From what I understand, PowerBI and Tableau are the gold standard tools for this.

With that in mind, I set my eyes on learning Tableau as the demand for data visualization skills is on the rise and Tableau seems to be one of the most commonly used tools for the job.

I requested Tableau from my company's IT but was told that the company has moved to using MicroStrategy for their BI and enterprise strategy solutions.

I did some research on MicroStrategy and noted a few things that were concerning to me:

• MicroStrategy is said to be developer-focused. To fully understand this tool I need to drastically up my technical experience. While there is a steep learning curve for tools like PowerBI and Tableau, they seem to be more user-friendly and someone without an expansive technical background can pick it up quicker.
• MicroStrategy is criticized as an increasingly-irrelevant product, at least in some corners of reddit. I read that MicroStrategy is a tool that's been out for several decades and focus is shifting to other BI tools. That said, some other people say the contrary.
• MicroStrategy is shifting its focus from its BI product to cryptocurrency investment. I'm not sure what this means for the product itself, but as support shifts away from it, it will continue to be less used in the future.
• Relevance of tool to skillset; my use case for a tool like Tableau and MicroStrategy is largely for visualizing and presenting data. While I'm willing to build out my skillset further, my only use for the service for a considerable time would be for almost exclusively visualizing and presenting.

Further context:

• My team does not use a BI tool at the moment for visualization and analytics. We use the Office suite and I'm starting to feel quite limited with it.
• I'd be learning whichever BI tool individually. I'm one of three people in my BU that need to extensively visualize and present data. This means if I want to use something like Tableau Desktop, I'd either have to have a very strong case to make space in my department's budget for just me, or pay out of pocket (which I refuse to do). Getting approved for MicroStrategy is just a matter of submitting a ticket.
• I want to build skills that will carry on for several years into my career. While I am willing to get in the mud to up my technical experience and learn MicroStrategy, if things point to its obsolescence in the near future, I don't want to invest my time in it. If that's the case, I'd rather just find some way to get my hands on a different tool.

Thanks everyone. Would love to hear everyone's takes and experiences on either side of the fence.

Hello,

I have two rows/attributes that are replicated in multiple tables within the same page. However, once they are used in one table, they won't repeat in the other. Is there a quick fix for this?

Thank you!

Hello everyone,

I am working with Microstrategy Workstation where I have added a simple data model with calender table, products table and a facts table.

I want to see the End Onhand Inventory (inventory as on the last day) for a particular category from products table.

I found that we need to specify it as a non-aggregate dimension in Microstrategy to do that.

I have added in Calculation of Metric level : DATE - Metric Aggregation - Ending fact

But it is not working. Can anyone please help me with this as I am stuck. 😅

Thanks in advance.

Hi I’m new to micro strategy and trying to embed visualizations through rest api calls

I have been able to show a pie chart but need help to load data in a line chart and a heatmap

I’m using chart.js can anyone give me any leads Thank you

Hello everyone. I work for a small rural hospital that uses a reporting software built on MicroStrategy. It's called BCA. I will start out that I do not have a degree in data analytics, I am merely proficient with Excel, and have taken all of the Kahn and Code Academy courses on SQL. They are wanting me to get MicroStrategy certification to work with this platform. They will reimburse me after certification. My question is, how difficult is it going to be for me to learn? Are there any free resources that I can review before starting this journey?

Liebe Community,

wird bei euch auf TR, nach dem Aktiensplit, auch eine falsche Performance und Rendite angezeigt?

Mstr was solely BI leader before Power BI came into the market, now client base is on declining path so does their revenue. Microsoft has very aggressively marketed power bi as a self serve BI tool and able to sell to clients across the globe as it can integrate to other Microsoft products easily and executives were sold this story.

MSTR has got all the capabilities and still better enterprise wide tool but I do not see MSTR is trying to do anything atleast to keep their existing clients happy.

I believe MSTR must have to bring some strategies to keep their current clients happy else there have been many silent projects migration internally going on, which mstr isn't even aware of and it will be decommissioned soon from everywhere.

Product support staff quality has gone so bad lately. Mostly they have no clue about the issues.

They have to heavily invest in keeping the quality of support to top notch, give unlimited incentives to existing clients (better than no clients in coming years), invest more on innovation and features which allows seemless and easy integration with other products.

Investing in Bitcoin is great future proof strategy but shouldn't ignore their BI product what they have been doing for 30+ years. Bring your focus back!

Please feel free to provide your inputs.

Hi guys, I have been working mostly with visualization tools such as Power bi and Tableau. Yesterday my manager asked me to explore Microstrategy and try to learn it as we might be soon getting some BI client works with the preferred BI tool being Microstrategy.

Please help me how can I learn properly and quickly the tool and if anyone can point out some good resources it would be very helpful for me 🙂.

Thanks in advance.

I'm a QA person in a software development shop. We've recently started using MicroStrategy for our BI solution and hired an experienced BI developer for it. This new BI developer has informed us that it is not standard practice to do QA cycles on BI solutions and that promoting changes from a dev environment to a QA environment for testing prior to promoting to production is unheard of. Is this truly common practice?

Does Microstrategy have a charitable giving contact? I did not see anything on their site.

Due to the this subreddit being unmoderated, we've moved to r/MSTRbater for the long term health of the community.

/r/mstrbater.

Given the amount of spam here without any Mods, please migrate to this subreddit instead.

Hi there,

Recently our company has upgraded from Update 7 to Update 12. There are a lot of useful new tools and tricks, but I am currently stuck with understanding how to use one, Parameters.

Does anyone know how to use them? I understand how they work (via the demo dashboard) but I don't get how to create one and how to apply to my data at work, even with a simple dataset.

Hi guys,

We were doing some general SQL maintenance of a new client and I checked the metadata, it needs a rebuild. Is this something that can be safely done on the metadata?

Thanks in advance!

If yes, can someone guide me please, I don't seem to find how. Thank you!

I need to count rows for open cases and rows for closed cases using the same date filter. Is there a way to create a filter for both and then custom metrics that ignore one of the date parameters? For example, the Count of Closed Cases would ignore the DateOpen parameter and the Count of Open Cases would ignore the DateClosed parameter. So when I filter for December 2022, I have a metric that shows cases opened in December 2022, and another metric that shows cases closed in December 2022.

My company is switching from Power BI to Microstrategy, and I find myself struggling to recreate simple things I did in previous dashboards. I’m guessing ‘Wrangling’ the data is like query editor? How do I remove null or unwanted rows from columns or merge columns from another table if needed? Thanks!!

Hi,

Im new to MSTR and I’ve imported 6 monthly files into MSTR dossier, all of which have similar column headers. How do I join them into a single dataset vertically (appending)? I am unable to append outside of MSTR as each file is fairly big (100MB in .csv format) and joining it would breach MSTR’s 250MB data import limit. Any advice?

The support page for sankey diagrams say that it supports ‘unbalanced data’ …that’s the type of sankey diagram data where 100% of the instances on the left of the chart are not 100% reflected on the right of the chart (because some of the volume terminates at an intermediate node in between left-node and right-node). However, I have no idea how what way to structure the underlying dataset so that data can be visualised in this way. Does anyone know how to do this or where I might find more resources online about this feature?

I have a dataset where I have weekly data till Friday August 4, 2023. Is there a way I can make MSTR display rows of null data with week number and week ending date (Friday of every week) till December 31, 2023 without having to manually add rows of data to the data source?

I want best resources for microstrategy where I can learn in depth. Like what is stackoverflow for microstrategy