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
Salesforce CRM Analytics
Score 8.5 out of 10
N/A
Salesforce CRM Analytics (formerly Tableau CRM) is a cloud-based business intelligence solutions and analytics software. It provides users with automated data discovery, CRM-connected analytics, top-down views of data, augmented analytics, predictive insights, and customizable data visualization tools.
$125
per month
Sigma
Score 8.2 out of 10
N/A
Sigma Computing headquartered in San Francisco provides a suite of data services such as code free data modeling, data search and explorating, and related BI and data visualization services.
The biggest player against Microsoft BI (MSBI) was Tableau, which was acquired by Salesforce. Recently there have been other standalone software/applications that provide similar functionality to Microsoft BI (MSBI). Because my company is a Microsoft shop, we have not explored …
Salesforce needs fully baked data for its architecture and design to give you the best results you deserve. Teams not having used Salesforce previously take some time getting used to EA. But its ability to give the data points for KPIs to the sales team in real time and to the …
Salesforce analytics cloud was selected for its client management capabilities that were already setup internally. As an analysis tool, Tableau was the most valuable tool, but it didn’t have the CRM capabilities of the Salesforce ecosystem.
I'd rate Sigma to be extremely similar to Sisense except it looks not as nice. I would say that as a tool, Sigma is more user-friendly than Tableau, Power BI, Trevor, and Metabase.
I do feel that Looker is far more powerful and looks great, but I also recognize that Looker does …
Sigma Computing is easier for users, has less latency, and was a better experience working with the seller. It is a great solution that I am super impressed with. The alternatives we evaluated were more difficult and slower. Sigma is fast and easy and that is worth so much in …
Sigma Computing is significantly faster and more versatile than Data Studio integrations for marketing data. While it is less powerful than Tableau for data visualization, it is much easier to use due to its spread sheet like user interface. Microsoft BI is a middle ground but …
Sigma has a good balance of affordability, self-service ability for technical teams, and ease of use. We chose it over the others basically based on ROI.
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.
For us it really comes down to that book management and next best contact for our advisors. When we're thinking about a book of business that may range, depending on the advisor, from 400 clients to a thousand clients, how do they really optimize their time? Who do they call next? Who do they work with to make sure not only they're keeping those clients engaged, they're not leaving the firm going to other advisors who they haven't talked to in a while who might need their attention. That's really where that CRM analytics is really proven pretty powerful for us.
We were able to set up client-facing embedded reports with ease and security. The interface is not difficult to learn, although we may not be aware of or lack the necessary expertise to utilize more advanced features that would likely benefit us.
Implementation takes time and resources. It is a heavy lift to implement and at first, it can take a little bit of time to understand what you are looking at. But once it's implemented it's easy to get started.
Without any BI expertise or resources available to your organization, the implementation of this is difficult. If you aren't used to BI tools and don't have an expert in house, the terminology can be difficult to understand at first.
Their support is not on hand to help you if you encounter any issues, at least not on all the plans or the basic plans. Real-time support service is an add-on, so you'll need to be patient if you require help or pay extra money.
More functionality for the tool is needed to compete with other heavyweights in the arena like Tableau, Qlik, and Microstrategy. Still lacks the robustness, functionality, and flexibility other competing products possess.
Sigma Computing does not allow custom ordering of pivot fields in pivot tables easily
Sigma Computing lacks functionality for creating tables or sections that dynamically adjust to the browser window's height while maintaining a fixed height textbox at the bottom
Sigma Computing does not provide straightforward options for formatting totals in tables, such as renaming 'Total' to 'Average', 'Team Total', etc
Sigma Computing does not support searching by individual tab names within a workbook
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.
Sigma has helped us a lot and has become an integral part of our daily workflow. It would be difficult to switch to another platform and have to rebuild the numerous metrics and performance reports that we have already established
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.
For someone who don't have coding background, this could be a useful tool and fairly easy to learn and use given the good support. However, if you know other open source tools, it would be much easier to use the other tools and the knowledge is more transferable in the future.
It has a clean and modern interface. However, it is not completely intuitive. I think it would be better and easier to navigate with more Windows style drop down menus and/or tabls. There is a significant learning curve, but that may be due in part to the technical nature of this type of software tool.
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.
I was not able to be in interaction much with Salesforce support team since every feature works the way it should be working. So far I have not experienced any bug or major glitches that would delay the result of my work and performance. There is also a hotline in our company for Salesforce issue but so far I have not used it.
They are very friendly and informative. They are quick in resolving our queries and help us understand very minute things as well. They are quick in creating feature tickets based on our custom requirements, and they would also create a bug ticket if there is any discrepancy and get that checked on time.
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.
An implementation partner would certainly result in greater output in a more efficient amount of time. However, I have found implementation partners to be extremely expensive for the output received (at least working for a non-profit company they are frequently unaffordable). Internal implementation does help with usable output though since internal knowledge would better know the data architecture and business processes
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.
Tableau is the absolute top of the class when it comes to business intelligence, but it doesn't make sense for every business case. In our case, we needed a simple data visualization platform for our CRM platform and sales pipeline. Salesforce Analytics, while nowhere near as robust, did the job we needed it to do perfectly in a significantly more cost-effective manner.
With Looker, to be effective, a substantial amount of coding & modeling needs to happen in LookML. Being another language to learn, users have to context switch again from at a minimum either SQL or Python into LookML. The concept of being able to source control, code review, and deploy your models is a plus though.
Tableau is the gold standard for data visualization, no question. Power users will be able to create dazzling content that Sigma won't necessarily be able to easily match. However, since development usually happens via an extract, helping other users troubleshoot is an arduous process. Trying to re-do or un-do all the transformations and calculations that cause a certain number is very difficult.
With Sigma, all the queries happen directly against Snowflake and you can see the query logs. The data modeling happens right in a tabular, spreadsheet-like manner, so within only a few minutes, substantial transformations can happen, with visualizations just a few more clicks away.
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.
I would say it's been positive just because as a company, anyone that has access to it can go in there and pull any company information and we're very up to date then on all of our client base. So I would say it's been a very positive impact.
Monitoring health of cloud platform has allowed the company to anticipate issues before they affect customers – Sigma prompted us building a canary monitoring process that provides customer container health.
Customer success has used an activity report to discover customers running runaway processes that they were unaware of, creating an alert to contact the customer and prevent an embarrassing situation.
Customer success uses the activity report to prompt conversations regarding increases or declines in behavior that led to increasing contract limits or addressing churn concerns.
