Likelihood to Recommend 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.
Read full review We just need to refresh our data once a day for our unique use case, which allows the complete online system to run on extracts. For us, this is critical because our daylight hours are spent focusing on new updates and implementations rather than worrying about excessive database traffic (which would be required with a direct connection to the online system). The process of importing extracts is straightforward and sturdy enough to handle massive amounts of data.
Read full review Pros Comparatively easy to use compared to other data analytics solutions, collaborating with other colleagues on data work is simple. Using Visual Studio for database, ETL, reporting, and analytics development save time and money. Transfer of data from one application to another via Excel and comparison of data attributes between applications Dashboard functionality, as well as Python support, are available, allowing you to add additional charts and graphs. Read full review Tableau Online is completely cloud based and that's why the reports and dashboards are accessible even on the go. One doesn't always need to access the office laptop to access the reports. The visualizations are interactive and one can quickly change the level at which they want to view the information. For example, one person might be more interested in looking at the country level performances rather than client level. This is intuitive and one doesn't need to create multiple reports for the same. The feature to ask questions in plain vanilla English language is great and helpful. For quick adhoc fact checks one can simply type what they are looking for and the Natural Language Programming algorithms under the hood parse the query, interpret it and then fetch the results accordingly in a visual form. Read full review Cons 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. Read full review Can be a steep learning curve for new users Modeling and building algorithms aren't always intuitive and take some testing/retesting to ensure it's working as it should Inability to integrate easily with our HRIS platform. Reports are pulled from HRIS at various intervals and uploaded into Tableau Read full review Likelihood to Renew 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.
Read full review Usability 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.
Read full review From an end user perspective Tableau Online is overall very easy to navigate once you get used to it, my only complaint is that when expanding or contracting a graph, the "plus" and "minus" on the bottom left is sometimes hidden, and should always be visible. From a builder perspective, it can take some getting used to but the sheer depth of customization makes it all worthwhile.
Read full review Reliability and Availability The product has been reliable.
Read full review Performance 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.
Read full review Support Rating 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.
Read full review In times where the system is down, support has always been quick to notify and keep us apprised of the latest developments. It's crucial for our system to always be available, but when emergencies have arisen, I don't recall a time where the Tableau Online Support hasn't been able to address our concerns in a timely manner.
Read full review In-Person Training This training was more directed toward what the product was capable of rather than actual programming.
Read full review Online Training 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.
Read full review Implementation Rating 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.
Read full review Alternatives Considered 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.
Read full review Googles dashboard suite is very user-friendly and anyone can edit and make changes with very little knowledge or practice. But nothing I’ve worked with compares to the customization and multi streams of data in a user-friendly package like tableau does. It’s a really cool piece of software and I would choose that again.
Read full review Return on Investment 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. Read full review When we release new products, we are now able to quickly see data and toggle between current periods and previous to see performance Generating new reports requires less IT time to build Data can be shared across many different device types We now have integration where our customers can extract data from our software more easily-this was a big ask from our customers Read full review ScreenShots