Microsoft BI (MSBI) vs. Ontraport

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.

Here are some cases where Ontraport is well suited : - When writing emails, you can easily access to preview, manage the changes and go back to what you did before - When using automations, if there's an error, you can go back to a previous version of it. There are also some super tools that allows to see where a clients is on an automation without having to go through the all automation. It is less appropriate when you are several colleague that are addressing an issue on an email/automation as it doesn't allows you to be multiple person on the item.

Incentivized

• 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.

Incentivized

• Dashboards for our daily stats.
• The email follows up and broadcasts are simple and easy.
• Sales and marketing can now see the impact they have working together. Nobody can point finger anymore.
• They have the best customer support. I can't tell you how many times they have walked me through the problems that I created.
• Amazing email inboxing.

Incentivized

• 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.

Incentivized

• Wish they had more options for their forms. Would really like to use multi-step forms.
• A lot of times their forms load slowly on the website. Would like to see them speed up their services.
• Their broadcasting options are legacy. There are better options out there for sending broadcast messages.

Incentivized

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.

My client was already using Ontraport and had a decent investment in the tool. As soon as we turn around the revenue situation with my client's products, we will be ditching OAP immediately, despite the significant re-implementation cost we are going to face moving to a new system. I am part of a high-end, professional marketing group, and the overwhelming sentiment with these other professionals is that one should run away from this as fast as humanly possible. I thought their words were just ungrounded opinion, and I deeply regret that I did not heed them more closely before sinking still more time and effort into OAP.

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.

Incentivized

The software is just easy to use. The UI is fairly intuitive. The help system is pretty good. I find it is pretty quick to get my work completed and if I don't document my things well, I can always figure out how I did something when I need to make changes. When I have a problem the tech support is easy to deal with and when things need to get escalated they are resolved quickly.

The product has been reliable.

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.

Most of the time OP runs fine. But I've had to submit more support tickets this year do to messages, seq.'s or rules not running correctly. Also experienced slow response times moving in and around OP.

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.

The techs are reasonably savvy, highly courteous and want to do right by their customers. Unfortunately, the product they are supporting is so deeply flawed that there's only so much they can do when your legitimate business requirements are simply not supported.

This training was more directed toward what the product was capable of rather than actual programming.

I went to their Ontrapalooza event, and it opened my mind as to how the software can be used.

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.

If you know your business, ONTRAPORT is easy

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.

Incentivized

Task management was the main thing that separated ONTRAPORT for me. Keeping things accountable. As well, I felt the campaign builder was slicker, and that the contact management was more robust. Custom fields are very customizable.

With the new lower priced options, it's now easier for newer businesses to start with a more basic version and upgrade as they need more features.

• 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.

Incentivized

• We are providing better customer service as a direct result of Ontraport. We can track where all of our customers are, what pages/sites/modules they are visiting with ease and tailor our communication accordingly.
• Our marketing funnel has become vastly improved, meaning that our ROI for marketing has gone up. Sales this April are double what they were last year.
• Our team works better together because we all have a better idea of what the other needs and when. The tasks that we can assign in Ontraport mean nothing gets missed, creating a better customer and employee experience.