Astrato Analytics vs. Microsoft BI (MSBI) vs. Cyfe, by Traject

Astrato Analytics provides a feature-rich application that it easy to use for the non-technical user yet robust enough to create a sophisticated SaaS application. Astrato Analytics provides native integration to all the major large cloud data platforms and the implementation is very straight forward. The value provided through their feature-rich platform and competitive pricing is unmatched.

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.

Incentivized

Cyfe might be for you if you are looking for a cost-effective way to display all of your marketing metrics in one place. If you are looking for a detailed, fine-tuned, niche, or extremely specific metrics, this might not be the best solution. Cyfe is good for a general health check-up of marketing, but not a finely tuned examination.

Incentivized

• Writeback to the database is simple and straightforward and allows us to build apps in the tool with a level of interation that is not possible with other BI tools
• Version control that is built into the workbooks allows us to quickly deploy changes without the fear of losing the older version and maintianing both a historcal updates and the ability to rollback
• Easy connectivity to a wide range of data platforms including Snowflake, Databricks, and Google Workspace within the same tenant allows us to leverage data from each of these platforms for specific use cases

• 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

• Has preset metric groups that pull similar stats together in one "bucket" saving you the time of setting up each stat-line one by one
• Allows you to easily adjust the timeframe for what stats you want to see, so you can find YOY stats or just last month's stats rather quickly
• Colored visualizations of stats make it easy to notice when campaigns are taking off

Incentivized

• The product is still young, as a consequence, some features aren't as mature as competitors. Astrato has worked to catch up quickly, by rolling out new features regularly
• Better ability to control icons and themes from a central point, instead of having to add/change them on each report

Incentivized

• MSBI designs can work on increasing data processing capabilities enough to handle the huge datasets etc.
• It would be a lot better if it is a little low on cost.
• it needs to create opportunities little more than they do regarding customization of some very unique visualization effects

• I'd love to see additional functionality to customize colors. The light/dark option is very nice, but a little more flexibility in the colors would go a long way, especially if it was possible at the dashboard level rather than just the account level. Along the same lines, being able to customize the charts a little more, for example being able to show an x-axis on single data type graphs, could make them easier to read in some cases.
• Being able to choose to report on converted clicks or conversions in AdWords would be helpful.
• Needs the ability to show the date range on the shared URL dashboards. Would be even better if the date range was adjustable on that view, too.

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 has become a part of our internal tools so unless a competitor comes out with similar functionality as a similar price point it is unlikely that we would not renew. One area that would cause us not to renew would be if a competing service came out with more third-party integrations that match our needs. Price at this point is no longer an issue as it would allow us to automate a somewhat manual process that we have now connecting Cyfe widgets to Google Sheets.

It is a very intuitive system, a pleasure to use, practical and simple, for medium to advanced activities. BI supervisors are delighted with much of the functionality, but highlight some weaknesses that they still have, such as the loading speed in HEIC-type files.

Without a doubt, it is a tool that has become essential in our business routine.

Incentivized

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

I gave it a rating of 7 because it does a good job at what it does, but there are missing that are missing which I would have benefited from. For instance, if I was able to drill down more on the specific metrics I was able to see, that would have been helpful.

Incentivized

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.

Very friendly, with online help, blog and community. The template documentation could be more complete, however.

Incentivized

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.

Incentivized

Because I had a very minor question and I was able to speak directly to the founder through LinkedIn and through email. I know that as they grow this may not always be an option but the fact that he made himself available to answer my questions said a lot about his passion for the product.

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

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.

Cyfe is a 15 minutes implementation, then some time to get your data sources created. This is an easy one person job that will not result in down time or unnecessary wasted man hours.

To scale PowerBi, we would have needed a staff of technical folks and a substantial budget, and we still probably could not have created the robust SaaS application we did with Astrato Analytics. Astrato Analytics allowed for a staff of two to create and rollout a SaaS Application in under 60 days and provided hands on support to us as needed. There really is no comparison.

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

The Salesforce dashboard is comparably flexible and intuitive, but designed more to its internal CRM focus. SumAll shares the social media dashboard capabilities, but lacks all others. Its interesting feature is side-by-side graph analysis for cross-channel performance. Cyfe might borrow from SumAll's default weekly email summary of performance from the dashboard, but implementation could be too complex. Nuvi dashboard is exclusively for social media marketing, but lacks Cyfe's flexibility for third party integration and window customization settings.

• The ability to unify multiple platforms in Astrato provides cost savings.

• 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

• Cyfe allows us to provide real time data to our clients
• Cyfe allows us to provide detailed analytics to our clients showing actual results
• Cyfe reduced our need to provide monthly "reports" to our marketing clients
• Cyfe allows us to have better situational awareness and know what is going on throughout our multiple organizations