• Oracle Express Server
• Oracle Sales Analyzer
• Oracle Financial Analyzer
• Oracle Express Objects/ Analyzer

Data Warehousing & Data Marts

• Oracle Warehouse Builder (OWB)
• Oracle Data Mining Suite (Oracle Darwin)

Data Warehousing & Business Intelligence

By having access to the right information at the right time, executives can make better, faster, and more informed decisions. Al Faisaliah Advanced Systems Technology Est. (FAST), part of its offerings to its customers, is Business Intelligence (BI) Turnkey Solutions, which include data warehousing, data marts, and OLAP business analysis solutions. 

Beside FAST's proven track record and wide expertise in the IT turnkey solutions, FAST and through its empowered partners can bring to a BI project not only technical expertise but also specialized industry experience and expertise as per the customer industry (Banking, Telecom, Power Generation, Manufacturing , … etc)

Here, we would like to slightly high light upon our solution and product offerings which are based on Oracle technology. 

On Line Analytical Processing (OLAP)

Online Analytical Processing (OLAP) supports for analyzing corporate data in a way that provides insight look into your enterprise, its customers, suppliers, and markets. Oracle OLAP tools are unique in providing a single, integrated software architecture to support strategic decision making. Oracle OLAP product family includes:

• Oracle Express Server, a powerful and extensible calculation engine for creating derived data values. 
• Sales Analyzer & Financial Analyzer, end-user applications allowing data access, calculation, and information sharing.
• Oracle Express Object & Oracle Express Analyzer, tools supplying a visual, point-and-click environment for building OLAP applications capable of modeling, graphical display, forecasting, statistical analysis, communication, database management, and data acqusition. 
• Oracle Discoverer & Oracle Reports, query and reporting tools that integrate seamlessly with Express technology and enable users across the enterprise to deliver fast answers to hard questions. 
  
  These products support for the full spectrum of enterprise business analysis requirement - from production reporting and ad hoc quering to advanced analysis. This is in addition, to open interfaces that support a wide range of third-party applications. This integrated solution supplies superior ease of use and unmatched performance while reducing development and deployment costs.

Oracle Express Server - and other Oracle Express products - provide all the required functionality to bring the full power of On Line Analytical Processing (OLAP) to your entire enterprise. Generally, OLAP is driven from a multidimensional database model, and performs analysis, calculation, and recalculation to support what-if scenarios and other strategy-setting needs. An unusually powerful and extensible calculation engine, Express Server also includes features that make it a flexible, affordable, and easy-to-use solution.

• Flexible multidimensional storage and access 
• Fully web-enabled & web-browser interface
• Intuitive administrative environment 
• Familiar analysis environment, via Express Server add-in technology, to allow spreadsheet users to perform OLAP analysis 

Oracle Sales Analyzer - provide the user with a very flexible and powerful online analytical processing (OLAP) tool to access, analyze, and distribute corporate sales and marketing data, stored in a data warehouse or data mart, with out any involvement of IT support. Some other features of Oracle Sales Analyzer include:

• Secure, Powerful, and Web Accessible, as Oracle Sales Analyzer Web client provides easy, cost-effective access to dynamic documents via a Web browser.
• Flexible, intuitive, user-driven analysis, Oracle Sales Analyzer's intuitive wizards, report templates, and specialized sales and marketing calculations makes it easy to create, on the spot, analytical metrics, aggregations, new dynamic reports. 
• Fast, effective, sales support, Oracle Sales Analyzer makes information easily accessible. In fact, sales organizations will be able to efficiently gather information that answers questions concerning profitability by customer, region per time series. 

Convenient, profitable marketing analysis, by easily accessing, analyzing, and distributing data warehouse or data mart information. Oracle Sales Analyzer helps analyzing new market opportunities, promotions, and profitable customers and products.

Oracle Financial Analyzer - provide the user with a very flexible and powerful online analytical processing (OLAP) tool to access, analyze, and distribute financial data, stored in a data warehouse or data mart, with out any involvement of IT support. Also, Oracle Financial Analyzer (OFA) provides budgeting and planing. Other Oracle Financial Analyzer features include:

• Familiar analytical environment through familiar user interface to access the general ledger and other data sources. 
• Extensive financial modeling and analysis such as iterative budget process and tailored views. 
• Integration, security, and flexibility as data from general ledger systems, relational databases, and other sources can be easily integrated with centralized and powerful security.

Oracle Express Objects/ Analyzer - Express Objects is the Express Server's object-oriented, visual environment that provides "fill-in-the-blanks" programming for creating custom OLAP applications. In fact, Express Objects supports fully the object-oriented notions, such as inheritance, encapsulation, and polymorphism that enhance code modularity and reusability. Further, Express Analyzer Express Analyzer can run, modify, and extend applications developed in Express Objects, empowering end users to analyze and report data provided by Express Server. 

• Powerful and open environment, because of transparent connectivity to relational data warehouses through Express Server, supports for DDLs and OLE, OCX/ ActiveX/ JavaBeans embeding.
• Fast and Intuitive Web Publishing, astThe Web Publisher module, included with Express Objects/ Analyzer , makes it easy to build interactive, data-driven OLAP Web sites. Further, through integration with Oracle Discoverer, Express Objects supports easy access to dynamic, transaction-level detail. 
• Powerful and Intuitive Analysis, through Express Analyzer, briefings are created using point-and-click tools - and without having to write any code .

Oracle Express Objects/ Analyzer - Oracle Reports, comprising Reports Services for Oracle RDBMS and Reports Developer, part of Oracle iDS, empowers end-user reporting with expansive processing power - without over dependency on IT resources. 

Oracle Discoverer, comprising Discoverer Viewer for Oracle RDBMS, Discoverer Administration Edition (part of Oracle iDS), and Discoverer Plus for single users, enable queries to be easily built and quickly deployed - without sacrificing operational efficiencies. 

For more online information about Oracle OLAP tools : http://www.oracle.com

Data Warehousing & Data Marts

Oracle provides all the software requirements to build an Enterprise Data Warehouse and Data Marts. These products range from the data warehouse engine (Oracle RDBMS), data warehouse design/ development tools (Oracle iDS, Oracle Warehouse Builder), muti-dimentional analysis engine (Oracle Express Server), OLAP tools (OSA, OFA, OEO,OEA, Discoverer, Reports), and Data Mining and web enabling capabilities 

Oracle Warehouse Builder (OWB) - helps you design, deploy, and manage a data warehouse. Through the open-standard Common Warehouse Model (CWM), OWB integrates diverse databases, customer relationship management (CRM) and enterprise resource planing (ERP) applications, business intelligence tools, and online analytical processing technology. Oracle Warehouse Builder (OWB) supports

• Fast, Wizard-Driven Warehouse Design 
  Using OWB's wizard-driven graphical user interface and library of pre-defined transformations, users can speed warehouse design and implementation. 
• Accurate, Automated Data Loading and Transformation, OWB validates objects, mappings, and transformations, then generates error-free code for implementing the warehouse. The system generates scripts and programs depending on deployment requirements, or a wizard-driven interface generates control files for flat file extraction. 
• Broad and Seamless Integration, OWB collects and distributes warehouse meta-data via Common Warehouse Model (CWM) , allowing data to be extracted and exchanged throughout the enterprise without manual intervention. Also, OWB supports gateways for ODBC, RDBMS, DRDA, and using Oracle Pure Extract, data can be extracted from IBM OS/390 mainframe sources such as Information Management System (IMS), IBM DB2, and Virtual Sequential Access Method (VSAM) files, and Sequential files.
•  Intelligent Processes and Higher Performance, Oracle Warehouse Builder delivers key performance advantages in the areas of extraction, loading, security, and maintenance. 

Oracle Data Mining Suite (Oracle Darwin) - is a flexible and powerful enterprise data mining software that is capable to find meaningful relations and patterns hidden within corporate data. These hidden relations and patterns is to provide the insight needed for highly personalized and profitable customer relationships. 

Oracle Data Mining Suite supports for strategies to:

• Profile customers with greater accuracy 
• Identify your most profitable customers 
• Acquire new customers 
• Prevent customer attrition
• Enable cross-selling
• Detect fraud 
  

Oracle Data Mining Suite is differentiated for its Enterprise Scalability, and Comprehensive modeling. 

For more online information about Oracle OLAP tools : http://www.oracle.com