It's Excel for Big Data. So easy, so cheap, so fast, and powerful enough most everything.
Overall Satisfaction with Microsoft BI
Microsoft BI is a many-times-relabelled tool for visualization and lite analytics. It's like super duper Pivot Tables and Pivot Charts that let you work with big data. As an analytics tool per se, it's as good as Excel since it is Excel. I wouldn't do any analytics heavy lifting with it personally, but you can easily do algebra stuff and make derived variables. The real business benefit is visualization. It's just very easy and powerful.
- EASY visualization of business data. Excel is the killer app so anybody remotely good at basic office tools knows how to make PivotTables and PivotCharts. If you don't, it's really easy to learn; give it a try... People think big data visualization is hard but it's not for most business use cases.
- FAST visualization of business data. There are BI/Analytics tools out there, some of them beginning with the letter S, that are slooow. I do my taxes waiting for them to run basic queries/filters/charts. Microsoft BI (and Tableau, etc.) create compact data models to allow for pretty fast data loading and slicery.
- FREE or at least REALLY CHEAP visualization of business data. Who has MS Office on their business computer? Oh, everybody. If you don't have Office Pro, pony up for that or get the monthly license. The bigness of data you can run on your own machine is fairly big; don't use cloud if you don't need it. By comparison, who enjoys throwing thousands of dollars away on bloated legacy BI software? Well, too many companies, apparently.
- More than two dimensions. Yes, I know that 2D is the core of Excel's DNA. However, we're starting to deal with higher-dimensional arrays here in analytics land so better visualization support would be cool.
- UI weirdness. By default, you are flipping back between regular Excel tabs and super-top-secret BI tabs. You create charts in one place, but look at them in the other. That kind of stuff. I know there are a couple of other ways to interact with Microsoft BI, but please figure out the main way.
- Better hookups to other analytics tools including Microsoft's. Microsoft BI has a good variety of data connections, and I don't expect it to bloom into a full-fledged analytics tool, but it may be a good idea to keep hammering at connectivity with "hardcore" analytics. In my case, Python stuff.
- Programming packages. Free and powerful, they let you make any diagram, at the cost of difficulty of use.
- Specialist software like Tableau and Microsoft BI. This is the best choice in most cases due to ease of use and quality of output.
- More generic software offered by the big IT companies, often part of a BI suite. There's really a lot of variety here. Use this when it fits the workflow and you are already using the relevant software. But, personally, I'd still use the specialist software.
Visualization of business data: it's good, fast, and cheap. What more can you ask? With more specialized visualization needs, use Tableau or write code. For complex scientific visualizations, write code.
It's also so much easier communicating about the tool and its visuals to other people who don't spend their lives analyzing complex data. "It's Excel for Big Data!" is really quite simple.
Microsoft BI Feature Ratings
Using Microsoft BI
Using Microsoft BI
Like to use
Easy to use
Technical support not required
Quick to learn
Feel confident using
- Familiarity. It's Excel. It's a spreadsheet. Come on.
- Thinking in matrices (PivotTables) takes a little getting used to, but it's not hard. For people without a good high school math background, it may seem unintuitive.
- Charts and PivotCharts are fairly easy, but Microsoft has a ways to go to make them less ugly.
- Data source connections. It's sometimes difficult to replace and update connections.
- Dropping certain types of fields into the Pivot Table (example: default aggregation type for values).
- The weird interface. Microsoft tried to have it both ways by using the standard Excel interface for some tasks, and the "Power" interface for others. It's just awkward, cumbersome, and confusing.