Faced with growing competition, rising costs, and shrinking margins, many partners and executives are asking tough questions about their firm's performance. They not only need a powerful analysis tools to understand what is happening within their businesses, but they also need to make business intelligence information easily accessible throughout their firms so it can be used to make informed decisions and drive performance.

Expert Analytics Foundation is a powerful business intelligence solution that improves law firm performance. Consisting of a data warehouse, OLAP cube, and data Microsoft SharePoint-based data visualization tool, it provides firms with a robust infrastructure for reporting, analysis, and performance management.

Expert Analytics Foundation helps firms analyze their operations in detail, helping them understand where they are performing according to plan and where they need improvement. It presents critical data and metrics to partners, fee earners, and executives in an easily understood graphical format, increasing information access and improving decision making.

• Improves visibility and accountability
• Increases the understanding of key business drivers
• Improves the quality and timeliness of decision-making
• Improves firm performance and profitability
• Drives performance management initiatives
• Enables in-depth and ad-hoc analysis

• Powerful analysis and information access capabilities
• High performance data warehouse and OLAP cube
• 200+ pre-defined performance metrics
• In-depth analysis through Microsoft Excel, Microsoft Report Builder, or any OLAP viewer
• Pre-built charts, queries, and KPIs delivered through Microsoft SharePoint
• Detailed financial and operational data for firm, office, practice group, or professional
• Full multi-currency support
• Powerful, easy-to-use customization layer
• Built on Microsoft business intelligence technologies

Expert Analytics Foundation provides firms with a robust infrastructure for their analysis and performance management needs. The core of the application consists of a completely redesigned data warehouse, ETLs (Extract Transform, and Load), and a single OLAP cube. Data loading and cube processing have been optimized to ensure that information is as current and accurate as possible.

Expert Analytics Foundation tracks more than 200 pre-defined performance and management metrics across the firm, partners, teams, timekeepers, and more. A configurable hierarchy structure allows users to intuitively navigate data and easily view or analyze information across multiple dimensions.

Used in conjunction with Microsoft Excel, Microsoft Report Builder, or any OLAP view, Expert Analytics Foundation provides a firm's financial analysts and power users with powerful data analysis and ad hoc reporting and inquiry capabilities. By analyzing their operations in detail, firm decision makers can better understand the business drivers impacting their performance and make more informed decisions.

Expert Analytics Foundation does far more than just support in-depth analysis. It also helps firms improve their performance.

Expert Analytics Foundation uses a special data visualization component, ClearView Analytics, to unlock the value of a firm's business information. Rather than forcing firm's to distribute voluminous reports, the application provides partners, timekeepers, and other key personnel with customizable, graphical views of relevant performance information and metrics via Microsoft SharePoint for a web browser. The pre-built queries and charts give firms immediate insight into key areas, such as:

• Time
• Disbursements
• Debt
• Exposure
• Financials

Users can drill down to details, rotate data views; and, change filters to uncover hidden details that lead to improved performance. The pre-built queries and charts can be easily customized and combined to deliver tailored information to different users throughout the firm. For example, Practice Group Leaders can see at a glance what is happening with their team and book of business while Executive Directors can see firm performance trends, such as WIP, debtor, and lockup days; aged debt; realization; profitability; and, more.

Expert Analytics Foundation supports multiple currencies. Firms simply link transaction to a desired exchange rate and the application automatically converts and displays transactions in currencies other than the default currency. This allows firms to view analytical information in the currency most appropriate for each office.

Expert Analytics Foundation has been designed from day one with customization in mind. A powerful customization layer enables firms to easily modify and extend the application's data warehouse and OLAP cube and preserves those changes during upgrades.

Expert Analytics Foundation uses Domain Specific Language (DSL) to manage customizations. A user-friendly interface enables non-development staff to create and maintain customization.

Firms can easily rename objects, such as dimensions, dimension attributes, and cube folders; hide dimensions and measure; change measure calculations; add new dimensions or attributes; and, more. Typical firm customizations might include language, terminology, and altering 'slice and dice' dimensions to make business units.

ADERANT understands the sensitivity of firm data, which is why Expert Analytics Foundation comes with a powerful security model that restricts the information users can view. Security information is sourced from ADERANT Expert and applied based on pre-defined scenarios, including:

• Fee Earner
• Matter Responsible Person
• Billing Responsible Person
• Client Responsible Person
• Organizational Unit Hierarchy
• Executive

The model allows users to fit into a number of scenarios. For example, a Matter Responsible Person is also likely to be a Fee Earner.

Expert Analytics Foundation is built on Microsoft SQL Server 2005. It fully leverages Microsoft's advanced business intelligence technologies and capabilities, including SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS). Additional, Expert Analytics Foundation uses SQL Server Integration Services (SSIS) to load data from ADERANT Expert and other data sources into the data warehouse.