[MUSIC PLAYING]
Today we will demonstrate how
to utilize Oracle Analytics
Cloud to extend
analysis of project data
from Oracle Enterprise
Resource Planning, or ERP.
Using the tight integration
between Oracle Analytics Cloud
and Enterprise
Resource Planning,
we will be able to pull
in curated content.
Blend in third party data
staged in our Autonomous Data
Warehouse.
Perform what if
analysis and apply
machine learning to create
intuitive visualizations.
Using these integrated
Oracle services together,
you will gain
additional insights
needed to make swift
and informed decisions.
Our Demo centers around
Pam, a project manager
who is in charge of delivering
a marquee capital building
project.
This project has
already budgeted
for raw materials
as well as tariffs
on items that are imported
from other countries.
Pam uses Oracle Transaction
Business Intelligence, or OTBI,
to review her project
status on a frequent basis.
In her review she attempts
to investigate why
this project is over budget.
However, she can
only view and analyze
data that is available
in this application.
So let's take a
look at how Pam will
pull these analysis from the
Business Intelligence Reporting
tool.
So after logging in she'll
pull her first pre-built report
which will show her her actuals
to date versus her budget
to date.
At a very high level.
And she'll see that
the actuals has
exceeded the budget to date.
She'll want to look into
this a little bit more
and so she'll pull her
next pre-built report
which will provide her
a little more detail.
In this case, the raw materials.
She'll see that the
raw materials are all
under budget at this time with
the exception of one area.
The tariffs that she
pays to import steel
has exceeded that budget.
Without being able to derive
any more additional information
from these analysis she reaches
out to her data analyst, Josh,
to investigate further.
Josh uses Oracle Analytics
Cloud's native applications
connector to connect
to the ERP application
and pulling the curated
data from the analysis
that Pam had already
built. Josh also pulls
in the US hard harmonized data
scheduled data from Oracle
Autonomous Data Warehouse.
By using machine
learning on the data
he notices that there has
been an increase in the data
on steel from China.
He does what if analysis and
data visualization switching
the source of material.
He then compare and
contrast the project cost
and derives that the
total cost of buying steel
is the lowest when
sourced from Mexico.
Once Josh has
completed this work
he can share these
visuals with Pam
in a PowerPoint presentation.
Additionally though, he can do
a couple other things for her.
He can embed these
dashboards into ERP
so that Pam may access
them at any point in time.
If she clicks a tile
in her ERP application
it will take her to
the charts and graphs
that Josh has create for her.
And you can see that she
can see the same information
that she was pulling from her
OTBI reports from earlier.
Additionally, she can
also see that if she
were to source her steel from
Mexico as opposed to China
she would see a cost savings
as opposed to a cost overrun.
Secondly, if Pam wants to be
able to review her project
status on the go, she
can use Oracle's day
by day mobile application and
ask it additional information
with a voice query.
What is the inception
to date budget by task?
As you can see, it's pulled
up the data that we've wanted.
And we can drill down
further if we need to.
Let's take a look
at architecture
and see how it interacts
with one another.
Enterprise Resource
Planning is integrated
with Oracle Analytics Cloud.
Additional data sets are pulled
from Oracle Autonomous Data
Warehouse which
is also integrated
with Oracle Analytics Cloud.
And visualizations and
what if analysis are
built in data visualization.
Finally the forecasted
visualizations
are embedded in ERP
and sent in PowerPoint
to the project manager
via email and day by day.
Using Oracle Analytics Cloud
we can blend third party data,
apply machine learning, and
forecast the best course
of action for our ERP projects.
This is made easy with
Oracle Analytics Clouds
unique integration with
Enterprise Resource Planning
which enables its users to
pull in that curated content
from pre-built analysis.
Oracle Analytics Cloud and
Autonomous Data Warehouse
allows you to gain
faster insights
by leveraging the work you've
already completed in ERP.
These Oracle Cloud
offerings are positioned
to save your company
time and money.
[MUSIC PLAYING]
