Skip to main content


Why Fusion Analytics Warehouse (FAW) is the Platform for the New Norm of Today’s World

In today’s data-driven world, speed and agility can be the deciding factor for survival in the marketplace and we know that data and analytics are the enablers of agility.  No longer can companies afford to maintain data and analytics platforms that can be outdated shortly after they are deployed.  Time cannot be spent on time-consuming and expensive upgrades. The modern data and analytics platform needs to be a living, breathing organism that is continuously improved, does not require traditional upgrades, and can rapidly respond to changes in analytical needs (the COVID-19 situation of our present-day has made that point in a big way).  Oracle has built such a platform in the Cloud-based Fusion Analytics Warehouse (FAW) suite.

For those that are not aware, FAW is a Cloud-based data and analytics platform developed by Oracle, leveraging Oracle Autonomous Data Warehouse (ADW) and Oracle Analytics Cloud (OAC), that is built to work ‘hand-in-glove’ with Oracle’s Cloud SaaS applications like Enterprise Resource Planning (ERP) Cloud, Human Capital Management (HCM) Cloud, Supply Chain Management (SCM) Cloud and Customer Experience (CX) Cloud.

FAW consists of a suite of analytics modules for ERP, HCM, SCM, and CX Cloud.  Each module includes the following:

  1. prebuilt data pipeline to extract data from the Oracle Cloud SaaS application
  2. a prebuilt database data model
  3. prebuilt semantic layer for support of analytics and reporting
  4. prebuilt metrics and KPI’s
  5. prebuilt reports and dashboards.

Please see the link below for information from Oracle’s website:

Important Benefits of Fusion Analytics Warehouse (FAW):

  1. Extensions and Customizations are Expected in FAW – While Oracle is providing about 50 or so ‘out of the box’ metrics, Oracle does not know exactly how each company looks at their business, calculates financial metrics, analyzes their supply chain, etc. Oracle is, therefore, providing easy-to-use tools to extend and customize the out of the box data model, semantic layer, metrics, and reports.
  2. Pre-built Data Pipeline Saves Time and Cost – this is a huge time and cost saver! No need to worry about understanding all the tables and views in Oracle Cloud apps and how to extract data from them.  That has been done for you.
  3. Pre-built Data Model and Semantic Layer Shifts Focus to Analytics – another huge time saver! It allows you to worry about your metrics and the value your analytics can bring. No need to worry about complex modeling of core ERP, SCM, HCM, or CX data.
  4. FAW as Enterprise Data and Analytics Platform – FAW can be extended to include non-Oracle data sources. Those data sources can be loaded into a different schema in the same data warehouse as Oracle provides with FAW to store the data of Oracle Cloud SaaS apps.  Also, those non-Oracle data sources can share the same semantic model as Oracle Cloud SaaS apps for reporting and analysis. For companies where a good bit of their enterprise data is running through Oracle Cloud SaaS applications, this makes a lot of sense.
  5. Never Perform an Upgrade Again! – FAW is Cloud-based so Oracle can roll out updates and enhancements automatically without requiring customers to perform an upgrade process. You might ask “what if I have made customizations”? Oracle is providing wizards to allow your customizations to be made in a way that will survive upgrades!
  6. Machine Learning and Predictive Analytics Built In – FAW already includes machine learning and predictive analytics but because FAW is a Cloud-based platform, Oracle can and will continuously update the analytics modules with additional machine learning and predictive analytics capabilities.

As a Cloud-based data and analytics platform that is purpose-built for integration with Oracle Cloud SaaS apps, FAW allows companies to maximize their Cloud investment while also deploying a data and analytics platform that supports continuous improvement and that can quickly adapt to changes in analytical needs – without an expensive and time-consuming upgrade.

Perficient’s Oracle Analytics team has deep expertise in Oracle Analytics, including FAW, and has helped numerous companies define and deploy Oracle Cloud-based data warehouses and analytic systems.

Thoughts on “Why Fusion Analytics Warehouse (FAW) is the Platform for the New Norm of Today’s World”

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Myles Gilsenan, Director - Oracle Business Analytics

Myles has more than 25 years of global experience in the design and deployment of large scale ERP, Data Warehousing and Business Intelligence solutions. He spent the first 10 years of his career at a Big 4 consulting firm leading international ERP and BI deployments. He then moved into industry where he held senior management positions in Business Intelligence and Global Finance Technology. He has been leveraging Oracle BI technology to transform companies into data-driven organizations for the past 15 years. He is a thought leader in the area of data warehousing and BI with a focus on Oracle Cloud technologies. He frequently speaks at Oracle-related conferences on the topics of BI and analytics. Myles has lived and worked in Tokyo, London and Hong Kong and has a demonstrated track record of delivery in complex environments.

More from this Author

Follow Us