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.
Predictive Pipeline kept track of every change in the sales pipeline and predicts quota attainment boasting 80% accuracy, with Neuralytics, the XANT predictive engine. The product was based on C9 Predictive Sales, owned and supported by XANT (formerly InsideSales.com) since May 2015, and no longer available for sale.
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.
C9 is a good and economical solution for what it does. If evaluating them today, I would want to clearly understand their product roadmap and their ability to execute against it.
It gives you the ability to see where your pipeline was in the past and compare to how it is now. You can set queries that will allow you to show at risk deals, committed deals, etc.
This gives much better visibility for management to coach.
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.
We had uptime issues, weird error messages, sluggish performance, and bad data. I hope that some of this can be attributed to growing pains as the company was relatively new when we signed our initial contract.
It was not dependable enough to trust the data and to count on accessing the app when we needed it.
It actually was unavailable at EOQ one time.
I also did not care for the lack of real-time pipeline information. If someone was doing a pipeline review, there was no instant gratification i.e. to see changes in pipeline occur as an AE made a change to an opportunity.
You couldn’t do any configuration at all. Even if you just wanted to change a field or add a filter, you had to go through their services team. It was a recognized challenge and I saw roadmap addressing it.
The query tool is a little hard to use and we have found that queries are very slow and lock up.
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.
C9 is now part of the sales management culture here at IPC. There is no longer any guesswork about the funnel or the forecast. C9 does something that SFDC does not...it increases significantly the value of the information in SFDC by unlocking the meta data that we all need to run the business
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.
From a sales manager’s perspective it was fairly easy to use the base functionality (just viewing current pipeline) and much harder to look at analytics (pipeline changes over time). C9 made this easier by allowing sales ops to publish views to sales managers. The query tool was harder to use than it had to be. For example, there were no out of the box relationships set up between Salesforce.com tables (e.g. accounts to opportunities), so I had to create those relationships myself.
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.
C9 cares about their customers and responds quickly. However, the ticketing system could be better and there is no easy way to track the status of your requests.
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.
Very simple implementation. They basically set up the imports and then they configure the tool per customer requests.
I wish there had been more consultation during the implementation, but it wasn’t bad given the effort expended. We ended up re-implementing after about a year and a half.
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.
Zoho CRM is less up to speed and much more out of date. The support at InsideSales.com Predictive Pipeline have been very helpful during the initial roll out face. Overall I was very happy!
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.
The product provides a single source for pipeline and forecast data and has scaled well with our organization. We have grown from 10 sales reps to 100 reps and we really needed a tool to to manage data and do roll-ups etc.
It's also important to provide senior management visibility into the pipeline, and the tool works well for this.
