Sneak Peek of Data Warehousing: Part One

Anyone using Everest through the last few versions has likely noticed a variety of visible changes. Enhancements to data panels and charting have provided greater flexibility to manipulate data; the ability to include reports and workflow attachments on notifications have enhanced communication; improvements to exporting options and integration with third-party systems have made the system more versatile.

On another level, technical enhancements are being made to the underlying architecture that expands the versatility of the product and greatly enhance the user experience, such as improvements to scheduled reports and full support for SQL Server Reporting Services. One of the most important improvements we’re making in this area is to our Data Warehousing.

What is Data Warehousing?

A data warehouse is a central repository of data designed to support forecasting and decision-making across an organization through reporting and data analysis.

Because data warehouses can store both current and historical data, and also integrate data from multiple sources, they are excellent for helping present a cohesive picture of a business.

Benefits of a Data Warehouse

Data warehouses by themselves are merely static repositories, typically storing large amounts of raw transactional data. This isn’t terribly exciting or useful because no matter how many systems a DWH integrates or how much historical data it contains, it ultimately just holds pieces of data.

What every business professional needs is a way to convert that data into information for practical consumption through:

  • Strategic planning and business forecasting models
  • Trend analysis of holdings, pricing, ratings, financials, third-party compliance results, performance or other types of comparative time-series analysis
  • Tracking and management of period-end closing process (month-end, quarter-end)
  • Scheduled reports to automatically extract, calculate and disseminate analysis to stakeholders
  • Data panels that facilitate data mining and drill-down analysis to gain greater insight into any situation

The goal in all cases is to deliver forward-looking, actionable information into the right hands by combining the right elements of a data warehouse with the existing slice-and-dice capabilities of Everest panels and reports.

We’re building upon this strength of Everest for the remainder of this year, with some exciting announcements on the horizon for our product direction.

To learn about the specific enhancements we’re making to Data Warehousing in Everest, read Part 2: A Deeper Look or contact your Relationship Manager.

Article written as a joint effort between the Development, Professional Services and Relationship Management teams at Black Mountain Systems