The data warehouse is the key behind a competent Business Intelligence system. This is the place to store and organize your data so business users can access and query it to help the company move in the right direction. This easy access to complicated data enables effective business analysis and business forecasting, which in turn provides great insight on various trends and supports in faster and better decision making.
Source for BI systems
BI systems can you a as a source various systems, depending of the business context, systems or need.
1. Operational Systems
Core Banking
CRM
Transaction Systems
Call Center
ERP
Loan Approval
Collateral Management
RDM
Campaign Management
2. DataQuality Systems
3. Social Media
4. Market Data
FX evolution
Trading
Prices
Market shares
Demographics
Ratings
5. Non banking companies
Group Companies
Telco data – statistics
Energy companies
Statistics institutes
Customer DB
Addresses
Typical BI consumers
The typical customers that consume BI data are most of the times internal teams which require reports and analysis of the real time picture of the business. Next, you will need to have a BI solution for your customers, to retrieve various reports on their dashboards. A hot topic represents the requests that official organizations would require from time to time, depending on regulations, or other special requests – police, auditors, ANAF, BNR (including their systems).
Key Capabilities of the Enterprise Data Warehouse
Data Modeling: Customized, business-specific solutions that create effective data models, designed to understand the data gathered by the systems.
Data Mart Development: data mart design and development help organizations across a variety of industries collate and store discrete data on a single platform, enabling effective analyses and informed business decisions.
Data Integration: Build an information-enabled enterprise by transforming data into a key decision driver, using ETL and ETL data transformation tools.
Information Delivery: Place data in the hands of an organization’s workers in a form-factor (mobile, PDF report, Excel etc.) that ensures action is taken on the information at the right time. Provide a single access point for aggregated information via an easy-to-use Web-based interface.
Maintenance Operations, Support & Upgrades: Large-scale migration and upgrade services using methodologies specific to business intelligence projects, whether upgrading to a newer version of your existing tools and applications, or making a platform, or re-engineering decision for the overall BI architecture.
