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

Clear Analytics has almost all the features which are mostly required by the organizations for their data analytics and transformation activities. Clear Analytics is built on the support of a parallel query engine which makes it handle large volume requests and also provides optimized results. However, every solution has some limitations, Clear Analytics lacks advanced features such as Predictive Analytics which is a very demanding feature in the market as most organizations are adopting AI/ML automation for their businesses. Also, it needs to add a lot of advanced visualizations so that the user has the choice of selection. Overall a good solution to be recommended.

Incentivized

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

• Quick management of the data through Excel thanks to the tools Clear Analytics provides such as filtering different information for an easier view.
• Ability to add new KPIs to measure different areas of our business.
• Drag and drop tool which makes an easier usage of Excel.
• Cost-effective. I find Clear Analytics to be affordable considering the number of features added and the unlimited sharing and editing it provides.

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

• 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

• For Charts and Graphs , getting the Power Point Deck would be helpful. As of now we use the data from Excel Reports

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.

I have really enjoyed working with Clear Analytics. This platform has contributed to increased production and reliable data control processes. It has flexible user interface that can be operated by any organization member. Reports are shared on simple and transparent way in the dashboard for easy access. Data analytics from all departments have created manageable working environment that have increased production.

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.

I have had multiple scenarios where I had to reach out to the support team of Clear Analytics, be it access-related, general queries, during initial implementation, etc. My overall experience has always been good. I got the needed support every time without any delay. I can definitely recommend Clear Analytics simply on the basis of its excellent support team.

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.

There are other great tools that are out there but Clear Analytics is reasonable for our business and provides a lot of features that we specifically needed

Incentivized

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.

• Super useful to get started immediately
• Didn't have to rely on migrating data
• Easy to add members
• Easy to learn and build charts

Incentivized

• 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