Yes, all business intelligence reports can be exported in a variety of popular formats such as Excel, PDF and PowerPoint.
The data warehouse contains all your customer data from multiple sources, allowing you to group related individuals based on your own rules which can be tweaked and refined over time giving you the ultimate flexibility when segmenting your customer base.
Yes one of the key value propositions of business intelligence is that it functions as a one-stop portal for delivering interactive reports by role to everyone in the organization. It can integrate into Active Directory to make user management centralized and convenient. Business intelligence reports can be surfaced in SharePoint as a widget but also you can create custom SharePoint reports that derive their data from the data warehouse.
The two main resource types needed are business and technical people. On the business side, Lodestar trains key staff that will administer the system and create most of the reporting content for the organization. The people in this role will need to understand the banking and reporting requirements of the organization but it is not necessary for them to be technically proficient. On the technical side, your existing server support staff will be more than sufficient to monitor and manage the Lodestar server. Lodestar offers a service to take care of any and all Oracle related tasks which removes the need for your staff to have Oracle expertise.
The Lodestar solution lives on a server in-house to give you maximum flexibility and control of your data and the systems that will feed into the data warehouse.
The Lodestar solution comes with all the cubes that you viewed in the demonstration as well as all the business intelligence content presented (and more!).
Generally a mix of the two approaches is the most effective. The advantage of the centralized model is that a small group of people become in-depth experts on the business intelligence application and the data models in the warehouse. The self-serve option allows a wider group of people access to create their own business intelligence content for themselves or their departments. Of the two approaches, it is more essential to have a strong group of centralized report writers as a best practice.
Yes on a few different levels. On the system level there are built in search fields for finding existing business intelligence reports. On the data side, you can create any business intelligence report to contain free form text fields that allow you to search for matching data on any of the fields in the data warehouse. With this approach you can create general reports on a data model that allows users to search and find the specific records they are looking for.
The consistency is derived from the entire institution utilizing the same data model, and not falling back on the outdated practice of taking core information offline into Excel for manipulation. The depth lies in the ability create reports that are aggregated with the ability to dive down all the way to the transactional or account details with a click of a button.
The data warehouse functions as a storage facility for information from all your production systems and ties that information together to get a consolidated view of the customer. Business intelligence allows you to easily move around in that information and distribute it effectively to all departments. Analyzing transactional past behavior can help you predict future behavior.