Tableau vs MicroStrategy

Tableau Desktop is a BI solution for data visualization, dashboarding and location analysis. In online reviews, users said they found its drag-and-drop charting a boon for creating charts and maps. Regarding customization, many users praised the platform for its various labeling and design options.I recently tried the Tableau Desktop 2024.1.3 version. The trial is only for 14 days and is enough for a sneak peek into Tableau’s dashboarding and data storytelling capabilities. For more straightforward use cases, Tableau is incredibly user-friendly and fast. Creating a new sheet gives you a canvas to create a visualization. Once you have the required sheets, combining them into a dashboard view is straightforward — select and add.My dataset included healthcare data, including details of patients, their hospital visits and insurance payer details. One use case was to find the total claim settlement amount. I dragged the Total Claims Cost and Payer fields to the column and row shelves, and Tableau gave me a bar graph. The toolbar had single-click options for sorting data from increasing to decreasing values or the other way around.To view the number of encounters by payer, I dragged the Payer field to the row shelf and used the SUM(ROW_COUNT()) function on the column shelf. The chart popped up with more visualization and layout options.I wanted an interactive filter to view the average claim cost by birthdate. I dragged the Birthdate field to the Filters shelf and right-clicked on it to set the end date as October 22, 1961. Selecting Show Filter added a slider conveniently to the right of my visualization. I could see the data for people born before October 22, 1961, and if required, I could change the end date.Another use case would be viewing the data by the type of hospital visits — how many people were inpatients, outpatients or those who needed emergency care. I dragged and dropped the Total Claims Cost and Payer fields into columns and rows, respectively. Similarly, I dropped Encounterclass into the Filters shelf and clicked on Show Filter to enable a checkbox on the screen. It had all the categories of visits, giving users the option to select the desired views.One-fourth of the users discussing adoption said there was a steep learning curve. Tableau relies on Python and R scripts for statistics in its visualizations. It's where the named licenses can prove to be a blessing, as you can opt to train upcoming Creators and Explorers. We recommend factoring in training if you want to hit the ground running.Some reviewers felt discounted packages for business editions should be available, similar to the free student licenses. At $70 per user, the Creator license can seem costly when compared to Power BI ($9.99 per user) and Qlik Sense ($30 per user).Here's the good news, though. Its built-in user management acts as a permissions layer for your organization - users can only access the relevant content. Plus, an organization will have very few Creators and a greater number of Viewers and Explorers, and the license fee reduces from Creator to Explorer to Viewer.We recommend opting for a wise license combination to get the most out of the product.On the upside, the vendor constantly releases new features, the latest one being Einstein CoPilot in beta.Overall, Tableau is a competitive BI solution, but if the pricing seems inflexible, quite a few other solutions offer live insights and advanced analytics out of the box.

MicroStrategy is a patchwork quilt of products on the web, desktop and mobile. There’s MicroStrategy Library where you can access published content and Auto Express for dashboarding and bot creation. Anyone with basic data skills can feed information to a bot and gain insights in seconds.You don’t need a credit card to sign up for the free trial, but you won’t be able to publish content to the server without a paid upgrade. As for choosing which edition to use, there’s the web and the desktop instance. Which one will suit you? Maybe both?MicroStrategy Workstation is for developers and data analysts and is more robust for manipulating data. It provides administrative control, even when offline, and helps prototype content before it goes live. Combining multiple visualizations on a single page provided me with more context for the same data.On the other hand, the Workstation version lacks the same level of natural language processing as the web version.MicroStrategy Web is for delivering content to your clients. Being online, it’s open to seamless upgrades and customization, and identity management and collaboration are built in. If you have a small organization, the web version might suffice, but you might want to consider going for both if you deal with large data volumes.Metadata mapping was immensely useful to me when designing a bot using MicroStrategy Auto Express. All I needed to do was feed it the data, and it generated a slew of questions I might want to ask.With a semantic layer, Microstrategy is among the BI tools that work best with large data warehouses. If you’ve just started in business or haven’t got large data volumes yet, you might want to consider a simpler tool.An oft-repeated sentiment in user reviews was that this motley crew of products — web, desktop and mobile — didn’t always sync. The vendor positions MicroStrategy One as a unified solution that’ll, hopefully, eliminate these annoyances.On the flip side, quite a few users said it could be clunky for inexperienced users. Also, some reviewers said it slowed on occasion. Most people said the solution was expensive and found its learning curve quite steep.In summary, MicroStrategy is worth considering, especially if you’re a medium or large-sized company looking for a web reporting tool with a user-friendly interface.