Microsoft BI is a business intelligence product used for data analysis and generating reports on server-based data. It features unlimited data analysis capacity with its reporting engine, SQL Server Reporting Services alongside ETL, master data management, and data cleansing.
It is well suited for projects that are more discovery related. If this is a one-time project that we create a visual for, this would definitely make sense to use. If this is an ongoing analysis (monthly for example), we might look to another software that we would be able to automate a little further in how the visualization comes together
Microsoft BI is well suited for Stream analytics, easy data integration, report creation and UI/UX designs (limited but what all available are great ones) Microsoft BI may be less appropriate for handling huge number of datasets and difficult queries. It may also be difficult for a company with heavy data.
In comparison to other tools such as GraphWiz or Circos, Gephi comes with an intuitive, easy-to-use interface that makes it easy to load your data, and quickly start building all sorts of different graphs. There's absolutely no code that needs to be written for either loading or modeling. And without downloading additional plug-ins, Gephi ships with quite a few standard graph models, as well as some "fun" extras such as the Sierpinski triangle, and a variety of force atlas types.
Most of the layout types (maybe all) are highly configurable, which can make for extremely customized and unique displays of your data. Again, none of this requires the user to write any code. That said, it is possible to script custom functionality for your models, or even update the Java source code yourself, if you feel like getting technical. Gephi builds are available on GitHub, and the developers encourage people to contribute ideas, improvements, and plug-ins.
There's a plug-in for Gephi that allows for streaming data to update your model. This essentially allows you to create near realtime graphs of your data in motion. This plug-in was by far the biggest reaston we invested time in the product; to create animated data visualizations without exhaustive hours in development.
I (and many others) have had to expand Gephi's memory manually by experimenting with the configuration file. I'm glad it's possible, but it should be easier.
Gephi sometimes crashes inexplicably and loses your work, so I have developed a habit of explicitly exporting versions of my graphs as csv's, but I think this should be handled automatically in Gephi.
Because it is prone to crash, ideally, Gephi would help the user manage his/her use, by estimating processing and memory for very large tasks and prompting the user to confirm their requests before executing. Instead, I just tend to avoid certain functions.
The race to perfect gathering of Non-Traditional datasets is on-going; with Microsoft arguably not the leader of the pack in this category.
Licensing options for PowerBI visualizations may be a factor. I.e. if you need to implement B2C PowerBI visualizations, the cost is considerably high especially for startups.
Some clients are still resistant putting their data on the cloud, which restricts lots of functionality to Power BI.
While Gephi isn't perfect, it's a powerful tool for mathematical graph modelling that's hard to find in other products, particularly by way of its interface. It grants non-software developers access to a point-and-click way of creating accurate, beautiful visualizations that would normally take hours in other applications. The fact that it allows for live streaming data is also something that's hard to come by, at least for visualization software
Microsoft BI is fundamental to our suite of BI applications. That being said, Northcraft Analytics is focused on delighting our customers, so if the underlying factors of our decision change, we would choose to re-write our BI applications on a different stack. Luckily, mathematics are the fundamental IP of our technology... and is portable across all BI platforms for the foreseeable future.
Gephi is very intuitive and the fact that it shows its process helps the user understand what's going on. However, the animation features can really slow it down and there isn't a way to shut them off. Furthermore, the failures on saving mean you frequently have to start over. These problems disrupt the workflow and can be frustrating.
The Microsoft BI tools have great usability for both developers and end users alike. For developers familiar with Visual Studio, there is little learning curve. For those not, the single Visual Studio IDE means not having to learn separate tools for each component. For end-users, the web interface for SSRS is simple to navigate with intuitive controls. For ad-hoc analysis, Excel can connect directly to SSAS and provide a pivot table like experience which is familiar to many users. For database development, there is beginning to be some confusion, as there are now three tool choices (VS, SSMS, Azure Data Studio) for developers. I would like to see Azure Data Studio become the superset of SSMS and eventually supplant it.
SQL Server Reporting Services (SSRS) can drag at times. We created two report servers and placed them under an F5 load balancer. This configuration has worked well. We have seen sluggish performance at times due to the Windows Firewall.
While support from Microsoft isn't necessarily always best of breed, you're also not paying the price for premium support that you would on other platforms. The strength of the stack is in the ecosystem that surrounds it. In contrast to other products, there are hundreds, even thousands of bloggers that post daily as well as vibrant user communities that surround the tool. I've had much better luck finding help with SQL Server related issues than I have with any other product, but that help doesn't always come directly from Microsoft.
I have used on-line training from Microsoft and from Pragmatic Works. I would recommend Pragmatic Works as the best way to get up to speed quickly, and then use the Microsoft on-line training to deep dive into specific features that you need to get depth with.
We are a consulting firm and as such our best resources are always billing on client projects. Our internal implementation has weaknesses, but that's true for any company like ours. My rating is based on the product's ease of implementation.
The interactivity in Gephi and the quality of the output figures are impressive. However, the selling point was the fact that we were able to link Gephi into our pipeline using Java's interface. Other products were less customizable and lacking of the sophistication Gephi provided without too much pain during the liking process.
We have used the built in ConnectWise Manager reports and custom reports. The reports provide static data. PowerBI shows us live data we can drill down into and easily adjust parameters. It's much more useful than a static PDF report.
I have only used the product for education purposes. I will not be the best person to provide details about ROI and business efficiency and customer service. I was personally very excited about the tool and am continuing my work on the tool.
As a SaaS provider we see being able to provide self-service BI to our client users as a competitive advantage. In fact the MSSQL enabled BI is a contributing factor to many winning RFPs we have done for prospective client organisations.
However MSSQL BI requires extensive knowledge and skills to design and develop data warehouses & data models as a foundation to support business analysts and users to interrogate data effectively and efficiently. Often times we find having strong in-house MSSQL expertise is a bless.
