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
SharePoint
Score 7.7 out of 10
N/A
Microsoft's SharePoint is an Intranet solution that enables users to share and manage content, knowledge, and applications to empower teamwork, quickly find information, and collaborate across the organization.
$5
Per User Per Month
Sisense for Cloud Data Teams
Score 4.1 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.
SQL server allows for a member of the database administrators team to assist the end users with queries designed to pull information out of the back end databases. With Microsoft BI the end users can be given connections that allow them to create their own queries, pull the …
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)
Microsoft SharePoint
Sisense for Cloud Data Teams
BI Standard Reporting
Comparison of BI Standard Reporting features of Product A and Product B
Microsoft BI (MSBI)
9.0
53 Ratings
9% above category average
Microsoft SharePoint
-
Ratings
Sisense for Cloud Data Teams
7.0
19 Ratings
14% below category average
Pixel Perfect reports
8.646 Ratings
00 Ratings
6.010 Ratings
Customizable dashboards
9.653 Ratings
00 Ratings
7.019 Ratings
Report Formatting Templates
9.051 Ratings
00 Ratings
8.017 Ratings
Ad-hoc Reporting
Comparison of Ad-hoc Reporting features of Product A and Product B
Microsoft BI (MSBI)
8.6
53 Ratings
7% above category average
Microsoft SharePoint
-
Ratings
Sisense for Cloud Data Teams
4.8
19 Ratings
48% below category average
Drill-down analysis
8.648 Ratings
00 Ratings
6.015 Ratings
Formatting capabilities
8.353 Ratings
00 Ratings
7.018 Ratings
Integration with R or other statistical packages
8.442 Ratings
00 Ratings
3.010 Ratings
Report sharing and collaboration
9.053 Ratings
00 Ratings
3.019 Ratings
Report Output and Scheduling
Comparison of Report Output and Scheduling features of Product A and Product B
Microsoft BI (MSBI)
8.7
52 Ratings
6% above category average
Microsoft SharePoint
-
Ratings
Sisense for Cloud Data Teams
7.6
18 Ratings
7% below category average
Publish to Web
9.448 Ratings
00 Ratings
5.012 Ratings
Publish to PDF
9.248 Ratings
00 Ratings
10.012 Ratings
Report Versioning
7.544 Ratings
00 Ratings
8.012 Ratings
Report Delivery Scheduling
8.647 Ratings
00 Ratings
5.015 Ratings
Delivery to Remote Servers
8.626 Ratings
00 Ratings
10.06 Ratings
Data Discovery and Visualization
Comparison of Data Discovery and Visualization features of Product A and Product B
Microsoft BI has a lot of features and is a very powerful tool, especially if you have folks on your team that know how to utilize all of its capabilities. To truly unlock all that it can do, it does require people to have a deep understanding of its capabilities. That's where the software really shines. If you are looking for a simpler, more basic reporting tool, there are other programs available that do not require such a steep learning curve.
SharePoint Document Management excels as a central repository for storing, organising, and retrieving documents. It supports version control, metadata tagging, secure access, and integration with tools like Power Automate. At our organisation, it's used for managing contracts, policies, and supplier documents. SharePoint Workflow Automation integrates with Power Automate to streamline approvals, gather feedback, and automate recurring tasks. This reduces reliance on email chains and manual trackers.
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.
Windows Explorer users have some difficulty having to constantly UPLOAD / DOWNLOAD files. Specifically on the DOWNLOAD when they are used to Drag & Drop in & out of LOCAL folders via Window's explorer.
Microsoft SharePoint supports multiple "library" types. When implementing our "image" library the search function is done via "tags" and boolean logic. This is challenging to most end users. I'd like our users to be able to search our Microsoft SharePoint image library without having to enter KEYWORD or other BOOLEAN logic.
Microsoft SharePoint can also be an internal website for each department or company wide communication tool but I believe these features are geared for much larger organizations. Since we are a SMB we really aren't using these features. So maybe something more useful to SMBs would be nice.
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.
It's integral to our business. It's already included with most of the Office 365 licensing we buy, so the cost is effectively zero. It stores our files, it is the foundation for custom applications, and Microsoft only continues to enhance its functionality and its connections to other Microsoft tools. SharePoint just keeps getting better and better.
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.
No usability issues reported. Individual teams also have allocated areas which replace legacy shared drives on local LANs. Access to Sharepoint resources is fully integrated with corporate Active Directory with additional two-factor authentication required for administrative users. Users have access to Microsoft Services Hub which allows you to create, manage, and track support requests while staying current on Microsoft technologies with access to select self-paced learning paths
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.
MSBI natively has a site that allows you to vote on user enhancements and bug fixes. This allows the largest nagging issues to float to the top and the development team can prioritize accordingly. As mentioned earlier, the large community base of MSBI developers assist technical resources in handling technical questions.
The face to face training I received was on SharePoint Administration. It was rushed as there was a lot of information to cover and the application of the labs weren't that great either. I like to be able to relate what I am learning to what I am currently doing.
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.
I like to learn at my own pace and online training allows for that. Additionally, you can skip through pieces of content that you already know or are already comfortable with. Microsoft actually offers great videos on their website for basic fundamental SharePoint Training. I have used these training videos in some of my own training sessions with end users.
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.
The reasons for selecting MS SharePoint are: SharePoint provides ease of use and web design assistance and support SharePoint helps you schedule your content for publishing. enables users to share documents with external parties and offers a better internal structure of the content and better indexing and searching capabilities.
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.