
Founded:
Headquarters:
Ownership:
1992
Jersey City, NJ
Private
Deployment Model:
Intended Users:
Free Trial:
On-premise
All
Yes
Why Clear Analytics
Clear Analytics supports and expands the capabilities of Excel by allowing users to receive accurate data on-demand, while also providing expansive self-service access to BI insights across the entire company, increasing productivity.
Product Details
Clear Analytics delivers users self-service business intelligence through Excel, creating situations where outside help is not needed for valuable, actionable insights to be drawn from data. Rather, Clear Analytics focuses on transforming the average user into a data expert by buoying the capabilities of easy to use, exisiting platforms that users are already familiar with, like Excel.
Clear Analytics seamlessly melds with Excel because it is a gold-level application development partner with Microsoft. The ease of this combination is evident in their Data Share function, which allows, unlike regular Excel, an unlimited number of users to edit and access a given spreadsheet. It can even be accessed simultaneously by different users. This vastly increases the amount of spreadsheets and amount of data that users can share, protect, and manage.
Clear Analytics data quality tools are another significant feature, helping users produce trending reports and dashboards to help data stewards get smoother and quicker visuals of their daily data flows.
Another significant product capability of Clear Analytics is its “logical data warehouse” feature, which, contrary to traditional BI solutions, does not require an expert to maintain, or advanced hardware to setup. Instead, this “logical” approach includes a semantic meta layer which stores the entire data landscape, so that it knows precisely where to search for a given bit of information. Since data is pulled based on when the end-user wants it, no data warehouse is forced to pre-aggregate the information.
Features
While noteworthy for its seamless adaptability with Microsoft tools like Excel and Sharepoint, Clear Analytics also includes a broad array of other business intelligence features, many of which we have listed here below:
Analysis Features
- Ad Hoc Analysis?
- Issue Indicators?
- Online Analytical Processing (OLAP)?
- Predictive Analysis?
- Profit Analysis?
- Trend Indicators?
- User Friendly Interface?
Reporting Features
- Ad Hoc Reporting?
- Automatic Scheduled Reporting?
- Customizable Dashboard?
- Customizable Features?
- Dashboard?
- Financial Forecast/Budget?
- Graphic Benchmark Tools?
- Multiple Languages?
- Performance Measurements?
Target Market
Clear Analytics works across industries, zeroing in on the banking, real estate, and insurance sectors.
- Bank of America
- AIG
- Stone Harbor Investment Partners, L.P.
- Citibank
- UBS AG
- One William Street Capital Management, L.P.
- Ultimus
- Commission Control
- MFA Financial, Inc.
- GoldenTree Asset Management
Free Report: Selecting The Right BI Vendor

Customer Service & Support
Clear Analytics offers a Product Help documents section on their website that helps users self-solve and address issues they have. They also have an FAQ section that explains how and why the product is distinct, and the specifics of its capabilities, such as number of users, its data consolidation abilities, how it is unique from Excel, and more.
There is also a Video section in Support that visualizes queries, dashboards, datasource connections, and other features.
Shortcomings
Although including a robust offering of BI features, Clear Analytics is probably not ideal for companies that do not use Excel or those companies that do not require additional features through Excel.
As a software that largely relies on Excel, it is not an ideal solution for businesses that do a lot of their work remotely on tablets or mobile phones. Competitors offer more complete mobile options. Clear Analytics does not offer an app for access on mobile devices, although this could change in the future.
The product is only available through on-premise deployment, meaning that collaboration between companies through the cloud is not possible.
In addition, Clear Analytics is only available in English.
Screenshots
About
Clear Analytics was founded by Ana-Data, a technology and software company that offers both consulting services and the construction of various software applications. Founded in 1992, Ana-Data focused in creating custom software applications and user-interface design. Perhaps their most successful offering was Clear Analytics, a self-service, enterprise BI solution. Clear Analytics is now independent of Ana-Data. They are based in Jersey City, New Jersey.
Download Comparison Guide
Give Your Feedback