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.
$14
per month per user
Sisense for Cloud Data Teams
Score 4.5 out of 10
N/A
Sisense for Cloud Data Teams (formerly Periscope Data) is a data visualization tool that allows users to connect to their SQL databases to create sharable, interactive dashboards. In addition to SQL, its analytics integrate with R and Python, allowing users to prep datasets, perform analysis, and create their own visualizations. Sisense acquired Periscope Data in mid-2019.
Periscope's lightweight footprint and customizable SQL-based reports make it a better choice for us than Tableau or Microsoft BI. We deal with millions of rows of transactional data in a SQL Server data warehouse, so having seamless front-end integration makes reporting seamless.
Features
Microsoft BI (MSBI)
Sisense for Cloud Data Teams
BI Standard Reporting
Comparison of BI Standard Reporting features of Product A and Product B
Microsoft BI (MSBI)
9.8
49 Ratings
18% above category average
Sisense for Cloud Data Teams
7.0
19 Ratings
15% below category average
Pixel Perfect reports
9.842 Ratings
6.010 Ratings
Customizable dashboards
9.749 Ratings
7.019 Ratings
Report Formatting Templates
9.847 Ratings
8.017 Ratings
Ad-hoc Reporting
Comparison of Ad-hoc Reporting features of Product A and Product B
Microsoft BI (MSBI)
9.8
49 Ratings
20% above category average
Sisense for Cloud Data Teams
4.8
19 Ratings
48% below category average
Drill-down analysis
9.844 Ratings
6.015 Ratings
Formatting capabilities
9.749 Ratings
7.018 Ratings
Integration with R or other statistical packages
9.839 Ratings
3.010 Ratings
Report sharing and collaboration
9.849 Ratings
3.019 Ratings
Report Output and Scheduling
Comparison of Report Output and Scheduling features of Product A and Product B
Microsoft BI (MSBI)
9.8
48 Ratings
18% above category average
Sisense for Cloud Data Teams
7.6
18 Ratings
8% below category average
Publish to Web
9.844 Ratings
5.012 Ratings
Publish to PDF
9.844 Ratings
10.012 Ratings
Report Versioning
9.840 Ratings
8.012 Ratings
Report Delivery Scheduling
9.843 Ratings
5.015 Ratings
Delivery to Remote Servers
9.824 Ratings
10.06 Ratings
Data Discovery and Visualization
Comparison of Data Discovery and Visualization features of Product A and Product B
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.
Sisense for Cloud Data Teams is suited so well for our project that works with lots of data and needs some ways to share data internally or externally with our clients. It's very easy to pull out the data from the sense in best and in a suitable format and moreover a huge number of options are available there to represent the data. All features of this Sisense for cloud data teams software can be taken advantage of if you have a team who are well versed in data analytics, data management, and programming.
Rapid deployment of polished T-SQL-based data visualization charts and dashboards. Periscope supports a variety of database technologies, and allows users to write custom queries to display data.
Included caching to reduce server load.
Outstanding customer service/support, with expert advice as needed.
Constant updates and new features.
Built-in SQL formatters take the pain out of manipulating date/time objects.
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.
Include more appropriate updates in their monthly newsletter as opposed to the general overview that doesn't always have the most pertinent information at the forefront.
There are bugs at times when certain dashboards are down, though not in an overwhelming way.
If you do not tag something it shows up in multiple views and may be accessible to people that it should not be, though that is a user error it may make sense to prompt for a tag and security setting.
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.
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.
If you know SQL or are somewhat data-savvy, you'll feel right at home with Sisense for Cloud Data Teams. However, like most other BI tools, it is a little challenging to use for users that are non-technical. The graphs and charts are very visually appealing, and there's lots of customization and export options.
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.
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.
Google Analytics works well but it does not have all of the bells and whistles that Periscope Data offers. Google Analytics is best used in a Google environment but if you are using other tools and programs outside of the Google universe, then Periscope Data is a much better option.
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.