Faster and Easier Analytics - InformationWeek
Software // Information Management
04:53 PM

Faster and Easier Analytics

ProClarity analytics platform gets faster, easier.

•Closely integrated with Microsoft technologies
•Good information organization and visualization capabilities
•User-friendly interface and features
•Lacks support for non-Microsoft platforms
•Alert and notification capabilities underutilized
•Installation and documentation need improvement

From a business perspective, BI is the sum of three fundamental processes: assembling data, analyzing it and presenting it to the user. ProClarity provides for the last two by offering advanced data analytics, visualization and reporting, and a platform for creating custom analytic applications.

Now in version 6, ProClarity has long been known for taking some of the administrative and pricing pain out of data analytics and reporting by piggybacking on Microsoft's SQL Server database management system and the OLAP and report servers packaged with it: Analysis Services and Reporting Services. ProClarity builds on Microsoft's OLAP data management strengths, such as its data mining capabilities and the option to manage multidimensional data in relational OLAP (ROLAP), multidimensional OLAP (MOLAP) or hybrid storage models. It's ready to integrate with the SQL Server 2005 (Yukon) release expected soon.

New in version 6 are some additional visualization capabilities, additional KPI definitions and icons, many new navigation and automation features designed for quicker insight, deeper integration with Excel and Reporting Services, and performance improvements. If you are a Microsoft shop, ProClarity can offer some advantages over competitors in terms of ease of implementation and use. Although some of the enhancements in this version are differentiators, others (such as new KPI definitions) play catch-up with BI heavyweights such as BusinessObjects and Cognos. The best solution for your environment will of course depend on your user base and budget.

I evaluated ProClarity 6 by installing the full suite on a Windows XP laptop (with a 498MHz Intel Pentium III CPU and 576MB of RAM), which served as both client and server. The installation process and documentation leave something to be desired. Even the vanilla setup required a series of semiautomated steps that demanded significant manual intervention. Overall, however, ProClarity is well designed and integrates smoothly with Microsoft technologies.

At the heart of the ProClarity solution is its family of servers: Analytics Server, Business Logic Server and Dashboard Server. The ProClarity Analytics Server (PAS), the centerpiece of this trio, is a midtier server with a thin client called Web Standard, a repository called the Analytics Server database, which resides within Microsoft SQL Server, and an administrative tool. PAS is the go-between for ProClarity clients and Microsoft Analysis Services. It also provides centralized security, on top of the Windows security model, and shared repository services. In particular, PAS gives users a way to publish key performance indicators (KPIs) and other user-defined knowledge, then share it with other users in the form of "Briefing Books."

Briefing Books and their components can be created, shared, distributed through e-mail and exported to Excel or Outlook. They are easy to work with and an effective mechanism for organizing and sharing knowledge, but they should be designed with care by experienced practitioners. To optimize performance, PAS offers connection pooling and the ability to cache pages of Briefing Books,

The Business Logic Server lets users store predefined analytic best practices, including business logic and rules, KPIs and member and set definitions (such as year-to-date growth). Two client-side tools — KPI Designer and Selector — let users add content to the Business Logic Server. Dashboard Server lets them share content at a higher level, such as by creating and sharing subject areas that encapsulate best practices. Sharing content in this form looks like a good way to enhance productivity and consistency.

1 of 2
Comment  | 
Print  | 
More Insights
Newest First  |  Oldest First  |  Threaded View
How Enterprises Are Attacking the IT Security Enterprise
How Enterprises Are Attacking the IT Security Enterprise
To learn more about what organizations are doing to tackle attacks and threats we surveyed a group of 300 IT and infosec professionals to find out what their biggest IT security challenges are and what they're doing to defend against today's threats. Download the report to see what they're saying.
Register for InformationWeek Newsletters
White Papers
Current Issue
2017 State of the Cloud Report
As the use of public cloud becomes a given, IT leaders must navigate the transition and advocate for management tools or architectures that allow them to realize the benefits they seek. Download this report to explore the issues and how to best leverage the cloud moving forward.
Twitter Feed
InformationWeek Radio
Archived InformationWeek Radio
Join us for a roundup of the top stories on for the week of November 6, 2016. We'll be talking with the editors and correspondents who brought you the top stories of the week to get the "story behind the story."
Sponsored Live Streaming Video
Everything You've Been Told About Mobility Is Wrong
Attend this video symposium with Sean Wisdom, Global Director of Mobility Solutions, and learn about how you can harness powerful new products to mobilize your business potential.
Flash Poll