Clear Analytics vs. Microsoft BI (MSBI) vs. Workplace from Meta (discontinued)

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

Well suited: - leadership communication. When our CEO posts a video to all company - it always gets the highest engagement - recognition/achievements posts - live streams for education, knowledge sharing - we are a company of 12000 associates and there is no other corporate channel for us to gather more than 500 people in one place. Less appropriate: - sharing some very targetted messages - it's impossible to do at Workplace without creating a group. So we use email channel for such targetted communications - instant communication like in a chat (probably it's less appropriate in our specific case because we use MS Teams for such quick communication instead of WP chats)

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

• Bring groups of people together to share info, stories, updates, etc.
• The chat app is pretty decent.
• Workplace Live is a good large-group meeting broadcast platform.
• It's pretty intuitive to use for anyone who's used Facebook.
• It provides different levels of "security" for groups, allowing you to have open, closed, and "secret" groups.
• It's easy to paste images into your posts and comments, without having to necessarily go through the process of saving an image as a file, etc.
• It has search capabilities for finding old information.
• It's available for both desktop/laptop and mobile devices.
• It's secured to allow only those within the company to see company-related info (but it also has a few inter-company groups, which can be useful, too).
• Workplace Chat has the ability to set it to Do Not Disturb.
• You can set notifications, including email notifications, if you want to be alerted to new activity in your groups, etc.
• You can use Markdown to format your text

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

• It would be helpful if a review confirmation checkbox was able to be placed by files that needed to be read or reviewed. Along the same line, approve, review again, etc. would be helpful checkboxes to add by files, proposals.
• The layout is clean but suffers a bit from the center column width with two sidebars and a lot of empty space. It almost looks like a going out of business sale retail store where you notice the empty shelves. Workplace feels a bit bare at times. I think some good design modifications can help. Now on mobile, it is a great layout. I am addressing specifically the desktop browser login.
• An admin control dashboard would be really effective and even more so with more users on the platform.

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.

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

Having to download multiple apps just to use the tool is very cumbersome. Facebook would have make this better by wrapping it in as a main feature within their app, but having to use multiple apps to see discussions and walls is so frustrating.

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

Workplace by Facebook is an excellent fit in respect of support and documentation. It has excellent tutorials and documentation, as well. The UI and UX are already great as it is developed and maintained by Facebook, so most of the times, there is no need for any support or documentation.

Incentivized

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.

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

Workplace by Facebook is so much more than just a project management tool like Basecamp or Slack. The ability to disseminate information to employees is easier and better with Workplace by Facebook. It can also be used for informal messaging and sharing of information. It combines the best features of both with the same look and feel as Facebook.

Incentivized

• 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

• We can meet the project times, that with the communication in real time.
• We provide solutions to our suppliers in a reliable and efficient manner.
• When a business can save time and at the same time respond to the demands of customers, this translates into greater market capture of action for the company.

Incentivized