Just the Headlines

Short on time? Here are the key facts.

  • An AMLAW Top 20 Law Firm needed a technical solution to decrease report load time, centralize information, standardize metrics, and increase data security.
  • Their data was migrated to the cloud and Aptitive developed a data platform to organize operational data and store a standardized set of metrics.
  • Aptitive established single sign on and row level security to quickly identify the user and filter the data to the correct level of access.
  • As a result, the law firm is able to tap into one location for all data and reporting needs. This enables them to better support their partners in answering questions, reduce the number of reports and time spent on report creation, and decrease the time and money spent on IT support.


Aptitive helped a Global Law Firm achieve fast, reliable, and consistent analytics that gave them an edge up in the market by migrating the firm’s financial data to a cloud-based data platform.



Featured Technologies

Oracle Peoplesoft
Microsoft Azure Active Directory
Thomson Reuters ELITE

The Challenge

Our client faced many challenges with their existing technology environment, and they believed they needed to modernize in order to stay competitive.

The most frequently noted issues were:

  • Reports took too long to load, especially in offices across the world.
  • Employees had to go to multiple places and people throughout the firm to find information.
  • Metrics used for making key decisions were often different based on who put them together and where they got their data from.
  • The firm could not see a clear lineage of who had access to what data.

The Solution

While there were many options to purchase financial analysis systems, our client wanted to build a foundation that could expand beyond just the financial information to cover their firm-wide metrics on both the operational and the practice side of the business in the future.

To address this need, Aptitive developed an end-to-end solution that:

  • Pulls data used for reporting out of Elite 3E (the firm’s financial system) using Microsoft Azure resources, which improved the system’s speed for daily use.
  • Stores a standardized set of metrics (that the business users have reviewed and agreed upon) in Snowflake (a cloud-based database) for end users to easily access.
  • Established single sign on (SSO) and row-level security (RLS) to quickly identify the user and then filter the data to the correct level of access.
  • Created a starter pack within Tableau that pulls together the data from Snowflake and adds any commonly used, dynamic calculations for a quick start to reporting.

The Outcome

By making reporting and ad hoc analysis faster and easier with a centralized and cloud-based data platform solution, Aptitive enabled the operational employees to:

  • Better support their partners in answering questions about their clients, matters, timekeepers, and financials.
  • Have drag-and-drop reporting capabilities.
  • Reduce the number of reports created from 800 to 50.
  • Tap into one location for all data and reporting needs – no more emails sent to 5 different employees for the same data set.
  • Reduce time spent on report creation and instead shift this time to data analysis and action item suggestions that led to more revenue.
  • Less time and money spent on IT support of the data and analytics systems, more time spent on making new and more data available to the end users.

The Results

  • Over 300 metrics were standardized and agreed-upon at a firm-level, with drag-and-drop capability for any reporting need.
  • Report creation time was increased by 45%.
  • The onboarding time for new operational employees to create their own trusted reports went from 3 months to 2 weeks.
  • IT support hours of the data platform were reduced by 85%.

Interested in Cloud Modernization for your organization? Get started with a complimentary strategy session.

Get Started