Oracle Fusion Analytics Warehouse (FAW) is a family of prebuilt, cloud-native analytics applications designed for Oracle Cloud Applications. Recently rebranded as the Oracle Fusion Data Intelligence (FDI) Platform, it provides business users with out-of-the-box insights to improve decision-making.
FAW is built on a powerful architecture combining Oracle Analytics Cloud (OAC), Oracle Autonomous Data Warehouse (ADW), and automated data pipelines. This provides business users with a complete analytics solution without the need for extensive data preparation or development.
Core components and architecture
FAW is a managed service that runs on Oracle Cloud Infrastructure (OCI). Its main components work together to provide a seamless flow of data from source applications to actionable dashboards.
- Oracle Fusion Cloud Applications (SaaS): The data begins its journey here, originating from key business areas such as Enterprise Resource Planning (ERP), Human Capital Management (HCM), Supply Chain Management (SCM), and Customer Experience (CX).
- Automated Data Pipelines: A pre-built data pipeline automatically extracts and loads data from the Oracle Fusion Cloud Applications into the data warehouse. These automated processes minimize the need for manual Extract, Transform, Load (ETL) tasks.
- Oracle Autonomous Data Warehouse (ADW): The extracted data is stored in this cloud-native, self-driving database. The ADW is optimized for analytics and handles large volumes of data with high performance and scalability.
- Semantic Model: A pre-built, business-friendly semantic layer sits on top of the data warehouse. This model standardizes data definitions, provides meaningful column names, and defines the relationships between data tables, making it easy for non-technical users to build reports.
- Oracle Analytics Cloud (OAC): This component is the front-end for FAW. It provides the tools for data preparation, visualization, reporting, and dashboard creation. Business users interact with OAC to access the prebuilt content or create their own reports from the data in ADW.
- Pre-built Content: FAW comes with an extensive library of ready-to-use Key Performance Indicators (KPIs), dashboards, and reports for different business functions, enabling rapid time-to-value for customers.
Key features and capabilities
- Pre-packaged analytics: FAW provides a collection of pre-built analytics applications for different business functions, such as ERP Analytics, HCM Analytics, and SCM Analytics. This eliminates the need for organizations to build their analytics solutions from scratch.
- AI-powered self-service analytics: Empowering business users, FAW provides advanced features like data preparation, rich data visualization, augmented analysis (AI-powered insights), and Natural Language Processing (NLP).
- Unified view of business performance: By consolidating data from various business functions into a single analytics platform, FAW eliminates data silos. This enables cross-functional analysis to see how one department's performance impacts another.
- Extensibility: Users can extend the standard FAW solution to meet specific business needs. This includes:
- Data Augmentation: Combining external data from non-Oracle sources (like Salesforce) or on-premises systems with the Fusion data in ADW.
- Semantic Model Extension: Customizing the semantic model to add new dimensions, facts, or hierarchies.
- Content Customization: Creating new KPIs, dashboards, and reports.
- Security and compliance: FAW inherits the security features of Oracle Cloud Infrastructure (OCI), ensuring data protection through features like access management and data encryption. This provides consistency in security across platforms.
Use cases and benefits
Organizations use FAW to gain a comprehensive, data-driven understanding of their business.
- Finance: Analyze profitability drivers, track costs, manage expenses, and model financial scenarios with ERP Analytics.
- Human Resources: Gain insights into workforce composition, attrition, retention, and diversity with HCM Analytics.
- Supply Chain: Improve inventory management, track supplier performance, and manage supply risk using SCM Analytics.
- Customer Experience: Evaluate profitability, campaign effectiveness, and customer churn rates by combining sales, marketing, and service data.
The key benefits of FAW are its rapid deployment, quick time-to-value, and reduced cost and complexity compared to building a custom data analytics solution. It enables business leaders to monitor key metrics in real time and make informed, proactive decisions that drive operational effectiveness and strategic growth.