News and Views: Drive Smart Decisions with Cloud Analytics, Machine Learning and More

Did you say reporting? Financial reporting includes multiple kinds, and identifying the right one is key.

Did you say reporting? Financial reporting includes multiple kinds, and identifying the right one is key.

Are you looking to migrate Oracle Essbase from Oracle Analytics Cloud or even Oracle Essbase 11g on premise? To keep up with the speed of the future, the time to act is now.

Are you looking to migrate Oracle Essbase from Oracle Analytics Cloud or even Oracle Essbase 11g on premise? To keep up with the speed of the future, the time to act is now.

Like a chef prepares ingredients before cooking, data scientists must prepare data before analysis. What does this involve?

Like a chef prepares ingredients before cooking, data scientists must prepare data before analysis. What does this involve?

To fully realize their data’s benefits, it’s no longer enough to simply gather and analyze data to solve problems. Here’s how you can go deeper.

To fully realize their data’s benefits, it’s no longer enough to simply gather and analyze data to solve problems. Here’s how you can go deeper.

What can you do with the massive amounts of data coming every day? Find the story beneath the numbers to derive hidden insights.

What can you do with the massive amounts of data coming every day? Find the story beneath the numbers to derive hidden insights.

Step Three and Four are all about proving your concept works and building to scale.

Step Three and Four are all about proving your concept works and building to scale.

Step two includes defining a data and analytics strategy while keeping the company's business outcomes in mind.

Step two includes defining a data and analytics strategy while keeping the company's business outcomes in mind.

Crafting machine learning algorithms is essential, retrieving information from those models is critical.

Crafting machine learning algorithms is essential, retrieving information from those models is critical.

Access to blended data provides leaders with pertinent insights during these times of uncertainty.

Access to blended data provides leaders with pertinent insights during these times of uncertainty.

Learn to utilize the full potential of Regular Expressions (also known as Regex).

Learn to utilize the full potential of Regular Expressions (also known as Regex).

Here are three tips and four suggestions to articulate your strategy and gain agreement within your organization.

Here are three tips and four suggestions to articulate your strategy and gain agreement within your organization.

Connect to any data source, perform data analysis, and easily apply augmented data preparation.

Connect to any data source, perform data analysis, and easily apply augmented data preparation.

When it comes to tapping data's potential, many organizations need to begin if they want to win.

When it comes to tapping data's potential, many organizations need to begin if they want to win.

Oracle Autonomous Data Warehouse combined with Oracle Analytics can improve your supply chain performance even during times of global adversity.

Oracle Autonomous Data Warehouse combined with Oracle Analytics can improve your supply chain performance even during times of global adversity.

Make changes to live Oracle Analytics instance deployments with zero downtime.

Make changes to live Oracle Analytics instance deployments with zero downtime.

Business agility comes from data-driven insights.

Business agility comes from data-driven insights.

By looking up the logs, physical SQLs, and numbers of rows returned, you can rapidly fine-tune your data flow designs to optimize them.

By looking up the logs, physical SQLs, and numbers of rows returned, you can rapidly fine-tune your data flow designs to optimize them.

This latest version builds on self-service analytics capabilities for data preparation, discovery, and visualization.

This latest version builds on self-service analytics capabilities for data preparation, discovery, and visualization.

HR managers can delve into complex analyses, deep historical trends, predictions, and cross-departmental support without depending on IT.

HR managers can delve into complex analyses, deep historical trends, predictions, and cross-departmental support without depending on IT.

Oracle Analytics allows you to easily assign a behavior for a given column to visualize it directly on a map by default.

Oracle Analytics allows you to easily assign a behavior for a given column to visualize it directly on a map by default.

By participating in Gartner Peer Insights, Oracle Analytics customers can shape the future of augmented analytics.

By participating in Gartner Peer Insights, Oracle Analytics customers can shape the future of augmented analytics.

Oracle gives you a balance between self-service and governance.

Oracle gives you a balance between self-service and governance.

Using Oracle Analytics data visualization feature and machine learning we can gain some valuable insight into our marketing strategy

Using Oracle Analytics data visualization feature and machine learning we can gain some valuable insight into our marketing strategy

Sharing and Access granted (or denied). As the designer, you're in control.

Sharing and Access granted (or denied). As the designer, you're in control.

Take advantage of Pareto's principle with this free plugin.

Take advantage of Pareto's principle with this free plugin.

There are important differences between Project Level and Dataset Level Calculations.

There are important differences between Project Level and Dataset Level Calculations.

Oracle Analytics along with Oracle Autonomous Database can help data-driven companies achieve these goals.

Oracle Analytics along with Oracle Autonomous Database can help data-driven companies achieve these goals.

Is it Barcelona in Spain or Barcelona in Venezuela? Oracle Analytics map data visualization feature can help.

Is it Barcelona in Spain or Barcelona in Venezuela? Oracle Analytics map data visualization feature can help.

Lessons from Harvard Business School professor Clayton Christensen.

Lessons from Harvard Business School professor Clayton Christensen.

Data scientists will be in progressively higher demand in 2020 (and even 2025) but will become more efficient due to AI-driven data gathering and analytics techniques.

Data scientists will be in progressively higher demand in 2020 (and even 2025) but will become more efficient due to AI-driven data gathering and analytics techniques.

Oracle Analytics features a friendly way to prep data before building visualizations and deriving insights.

Oracle Analytics features a friendly way to prep data before building visualizations and deriving insights.

With Oracle Analytics for Applications for Fusion ERP, executives can leverage AI and augmented analytics to do what they need to do.

With Oracle Analytics for Applications for Fusion ERP, executives can leverage AI and augmented analytics to do what they need to do.

A more data-driven approach includes using Oracle Analytics to consider all of your options.

A more data-driven approach includes using Oracle Analytics to consider all of your options.

The possibilities between humans and machines are endless, but success requires new skills.

The possibilities between humans and machines are endless, but success requires new skills.

Artificial Intelligence and Machine Learning are key to better understanding our worldwide data trends.

Artificial Intelligence and Machine Learning are key to better understanding our worldwide data trends.

It's never been more straightforward to modernize your analytic environment.

It's never been more straightforward to modernize your analytic environment.

85% of big data projects fail by imploding under their own complexity. Oracle Cloud Infrastructure Data Flow represents a more efficient, more secure, and simply easier way to take projects to completion.

85% of big data projects fail by imploding under their own complexity. Oracle Cloud Infrastructure Data Flow represents a more efficient, more secure, and simply easier way to take projects...

Oracle announces Oracle Cloud Infrastructure Data Catalog, a brand new tool to manage and govern your big data. Organize, enrich, search, and consolidate data in a way that expedites and optimizes your data lake.

Oracle announces Oracle Cloud Infrastructure Data Catalog, a brand new tool to manage and govern your big data. Organize, enrich, search, and consolidate data in a way that expedites and...

Oracle Cloud Infrastructure Data Science is an enterprise grade data science service where teams of data scientists can collaborate to build, train, and deploy machine learning models.

Oracle Cloud Infrastructure Data Science is an enterprise grade data science service where teams of data scientists can collaborate to build, train, and deploy machine learning models.

Instead, set your business free and allow users to do what they do in a flexible but controlled multiuser environment.

Instead, set your business free and allow users to do what they do in a flexible but controlled multiuser environment.

Along with our customers and partners, we've diligently worked to make Oracle Analytics Cloud the best analytics solution it can be.

Along with our customers and partners, we've diligently worked to make Oracle Analytics Cloud the best analytics solution it can be.

The best source of tomorrow's citizen data scientists will come from the Business Analyst community.

The best source of tomorrow's citizen data scientists will come from the Business Analyst community.

The surest way to foster this alignment is with an Analytics Center of Excellence (ACE).

The surest way to foster this alignment is with an Analytics Center of Excellence (ACE).

Our example uses a custom picture of a stadium with stats about NFL fan attendance.

Our example uses a custom picture of a stadium with stats about NFL fan attendance.

Discover how automation and autonomy can make it faster and easier for you to deliver sound business decisions.

Discover how automation and autonomy can make it faster and easier for you to deliver sound business decisions.

Oracle Analytics and Integration Cloud enable Skanska to quickly meet compliance requirements and mitigate overall business risk.

Oracle Analytics and Integration Cloud enable Skanska to quickly meet compliance requirements and mitigate overall business risk.

Are you getting the most out of every customer segment? Oracle Analytics has the solution.

Are you getting the most out of every customer segment? Oracle Analytics has the solution.

Leveraging predictive analytics and machine learning, can address the needs of the business with speed and agility

Leveraging predictive analytics and machine learning, can address the needs of the business with speed and agility

The business rule of thumb has always been... Show me data in a way that's easy to understand.

The business rule of thumb has always been... Show me data in a way that's easy to understand.

Oracle Analytics is best positioned to predict outcomes with adaptive intelligence and machine learning.

Oracle Analytics is best positioned to predict outcomes with adaptive intelligence and machine learning.

Embedding isn't a special use case for analytics—it's a first-class component in every analytics strategy.

Embedding isn't a special use case for analytics—it's a first-class component in every analytics strategy.

AI is not just one or two things. It's augmented capabilities that streamline collaboration across multiple personas.

AI is not just one or two things. It's augmented capabilities that streamline collaboration across multiple personas.

Maximize the value of your data with out-of-the box dashboards, reports, KPIs, and data models.

Maximize the value of your data with out-of-the box dashboards, reports, KPIs, and data models.

Four key observations that have stood the test of time, regardless of analytics products or technologies you use

Four key observations that have stood the test of time, regardless of analytics products or technologies you use

A company must take a holistic view of both the data it captures, but also how that data is consumed and turned from raw material to finished product.

A company must take a holistic view of both the data it captures, but also how that data is consumed and turned from raw material to finished product.

Boris Evelson, Vice President and Principal Analyst at Forrester Research discusses AI and BI in the cloud.

Boris Evelson, Vice President and Principal Analyst at Forrester Research discusses AI and BI in the cloud.

Finance can move into the future with predictive modeling, detailed analysis, and insights from AI and Machine Learning.

Finance can move into the future with predictive modeling, detailed analysis, and insights from AI and Machine Learning.

There are five essential steps, but it all starts with the data.

There are five essential steps, but it all starts with the data.

Wherever you are on your cloud journey, Oracle Cloud Day can help you take the next step toward building a more competitive business.

Wherever you are on your cloud journey, Oracle Cloud Day can help you take the next step toward building a more competitive business.

Western Digital discusses how its operational reporting is now in real time with advanced analytical reporting thanks to Oracle.

Western Digital discusses how its operational reporting is now in real time with advanced analytical reporting thanks to Oracle.

Any data architecture you choose must be open to data from any source, whether refined or raw.

Any data architecture you choose must be open to data from any source, whether refined or raw.

While the overall organization (team) can analyze data, individual divisions and even managers (players) should use the same data to make impactful choices in real time.

While the overall organization (team) can analyze data, individual divisions and even managers (players) should use the same data to make impactful choices in real time.

A discussion about the Oracle Analytics Extension library, Oracle ACE program, and Essbase.

A discussion about the Oracle Analytics Extension library, Oracle ACE program, and Essbase.

Augmented analytics may be the key to expanding adoption beyond 35 percent.

Augmented analytics may be the key to expanding adoption beyond 35 percent.

Calculate any period-to-period measurement with an Oracle Data Visualization data source without the need for a data repository.

Calculate any period-to-period measurement with an Oracle Data Visualization data source without the need for a data repository.

Your path to augmented analytics is likely to to follow a typical six-stage progression.

Your path to augmented analytics is likely to to follow a typical six-stage progression.

Many popular requests have been implemented in this release.

Many popular requests have been implemented in this release.

The Mercedes-Benz maker was interested in what factors helped a customer choose an entry-level A-Class vehicle

The Mercedes-Benz maker was interested in what factors helped a customer choose an entry-level A-Class vehicle

How does analytics and data affect sales? An in-depth look at how Riverbed Technologies used Oracle's platform to analyze, update, and improve their sales numbers.

How does analytics and data affect sales? An in-depth look at how Riverbed Technologies used Oracle's platform to analyze, update, and improve their sales numbers.

The four winners and two finalist companies excelled in their use of Oracle Analytics solutions to accelerate innovation

The four winners and two finalist companies excelled in their use of Oracle Analytics solutions to accelerate innovation

A look at how AI and ML can work with Business Intelligence to create Augmented Analytics.

A look at how AI and ML can work with Business Intelligence to create Augmented Analytics.

Some simple advice for institutions working to increase their analytics maturity

Some simple advice for institutions working to increase their analytics maturity

Quality analysis relies on quality data, your expertise, and Oracle tools.

Quality analysis relies on quality data, your expertise, and Oracle tools.

We recommend using the Explain feature in Oracle Analytics to get the inside scoop.

We recommend using the Explain feature in Oracle Analytics to get the inside scoop.

The data analysis reconciled the costs and effectiveness of medications and treatments delivered to the 53 million residents of England.

The data analysis reconciled the costs and effectiveness of medications and treatments delivered to the 53 million residents of England.

Schools like Cal Poly San Luis Obispo are leading the charge toward better data-driven decision making.

Schools like Cal Poly San Luis Obispo are leading the charge toward better data-driven decision making.

Learn how to include forecast, clusters computation, outliers identification, trend lines, and more.

Learn how to include forecast, clusters computation, outliers identification, trend lines, and more.

Cognizant recently implemented the Oracle Analytics Cloud platform for a large American health insurance company.

Cognizant recently implemented the Oracle Analytics Cloud platform for a large American health insurance company.

For us, leadership requires that we get two things right.

For us, leadership requires that we get two things right.

ZS Wellness was able to deploy Oracle Analytics in only four days—and immediately began to see results.

ZS Wellness was able to deploy Oracle Analytics in only four days—and immediately began to see results.

How would you like to know what your software users are thinking and how they might react in the future? Oracle Analytics Cloud supports the accumulation of Usage Tracking (UT) statistics that help in monitoring system usage and performance to understand and predict user behavior. Knowing in advance what choices a user is likely to make helps increase efficiency and reduce errors. These statistics can be used in a variety of ways such as in system or database optimization, aggregation strategies, or internal billing of users/departments based on the resources that they consume. Usage tracking is particularly useful in determining user queries that are creating performance bottlenecks based on query frequency and response time.  Previous versions of Oracle Business Intelligence Server can track usage at a detailed query level. When Usage Tracking is enabled, it collects data records for every query that is executed and writes them all to database tables. Both logical and physical queries are tracked and logged in separate tables, along with various performance measures:  The following video gives a high-level overview of how to set up Usage Tracking on your Oracle Analytics Cloud environment.     Prepare to Enable Usage Tracking We're going to dive into this process, but first you will need to meet the following conditions to enable Usage Tracking in your environment: Usage Tracking requires a full metadata repository database (RPD) to be enabled. It will track usage on any queries, even outside the RPD, but it only requires an RPD for its configuration. For example, UT cannot be enabled when only a Thin Client Modeler (TCM) such as a web-based admin-tool model is active on your Oracle Analytics Cloud. UT requires access to a database to write data back into tables. A user login with create table privileges on the database schema will be needed during the configuration. Configure Usage Tracking UT configuration involves the following two steps:  Database connection in RPD: Using Administrator tool client (the editor for the RPD repository), define a database connection in the physical layer of your RPD. This connection should point to a database where Usage Tracking tables will be created and maintained. This database can be anywhere on the cloud as long as it is accessible for write access by Oracle Analytics Cloud.  System Settings in Oracle Analytics Cloud: Configure Usage Tracking parameters, such as connection pool name, physical query table name, and logical query table name.   Define a Database Connection in RPD Open the RPD which is uploaded in Oracle Analytics Cloud and create a new database in the physical layer. Provide an appropriate name (e.g., UsageTracking) and choose the database type as Oracle 12c. Under this database, create a new Connection Pool with an appropriate name (e.g., UTConnectionPool). Provide the connection details to the database where UT is to be configured and login credentials to the schema.  Note: This database user needs to have table privileges on the schema.    Next, create a physical schema in the RPD with the same name as the database schema to be used by UT (e.g., UT_demo).  Once these definitions are complete, the physical layer should look like this.    Save the RPD and upload it onto Oracle Analytics Cloud using the Replace Data Model option within the Service Console. System Configuration On Oracle Analytics Cloud, open the System settings screen from the Console Tab.  Scroll down and modify the following properties. 1) Toggle on the Enable Usage Tracking button 2) Usage Tracking Connection Pool: Enter the connection pool name in the format: <Database>.<ConnectionPool>  Example: UsageTracking.UTConnectionPool 3) Usage Tracking Physical Query Logging Table: This is the table where details about the physical queries executed by Business Intelligence Server against the underlying database are tracked. Enter the name in the format:  <Database>.<Schema>.<Table> Example: UsageTracking.UT_demo.PhysicalQueries 4) Usage Tracking Logical Query Logging Table: This is the table where details about the logical SQLs executed by Business Intelligence Server are tracked. Enter the name in the format: <Database>.<Schema>.<Table> Example: UsageTracking.UT_demo.LogicalQueries 5) Usage Tracking Max Rows : Specifies the number of rows after which the UT tables will be purged. The default value is 0 which implies there is no purging. You can set it to any desired value and the records will be purged once that threshold is reached. After entering these details, restart Oracle Business Intelligence Server. Once the server is restarted, Usage Tracking is enabled, and the two UT tables are created in the database. UT Tables Explained Open SQL Developer, log in to the UT database, and observe that the two tables have been created.   To generate some usage tracking data, log in to Oracle Analytics Cloud and click around some Data Visualization (DV) projects, both Extended Subject Areas (XSA) as well as subject area based. Also, open the BI classic home and open a few dashboards to generate some queries. Now observe that the tables for logical and physical queries are populated with usage tracking information.     Important Columns in Logical Queries Table END_TS End time of query execution ERROR_TEXT Error message if the query has errored out ID Primary key QUERY_TEXT Actual query text RESP_TIME_SEC Total response time of query in seconds ROW_COUNT Number of rows returned by the query SAW_DASHBOARD Dashboard name where query is getting generated SESSION_ID Session ID from the user firing the query START_TS Start time of the query execution SUBJECT_AREA_NAME   Subject area used for the query USER_NAME User ID who has executed the query     Important Columns in Physical Queries Table ID Primary key LOGICAL_QUERY_ID  Foreign key from the logical queries table QUERY_TEXT Query text TIME_SEC Time taken by query to complete ROW_COUNT Number of rows returned by the query START_TS Start time of the query END_TS End time of the query   The join between the 2 tables can be performed using the join condition:      LogicalQueries.ID  =  PhysicalQueries.Logical_Query_ID.    Note that not all logical queries will generate a corresponding physical query. For example, some logical queries may hit cache and return results from cache. When this happens, logical queries will not generate a physical query. Analyzing UT Data Once UT is enabled, the system usage can be analyzed from DV. In order to do this, create a DV connection to the UT database, create datasets for the Physical Queries and Logical Queries tables and analyze them within a DV project.  Following is a sample analysis built on the UT tables that shows number of sessions, number of queries, most frequently used subject areas, most frequently used dashboards, and so on.  Conclusion Usage Tracking provides a mechanism for administrators to keep track of the usage of the Oracle Analytics Cloud system. These statistics can be leveraged to take decisions to scale up, scale down, restrict access during certain time periods, pause/resume the system, and so on. To learn how you can benefit from the latest features in Oracle Analytics, visit Oracle.com/Analytics, and don't forget to subscribe to the Oracle Analytics Advantage blog and get the latest posts sent to your inbox.

How would you like to know what your software users are thinking and how they might react in the future? Oracle Analytics Cloud supports the accumulation of Usage Tracking (UT) statistics that help in...

Companies migrating to the cloud for analytics are looking first and foremost for agile self-service models.

Companies migrating to the cloud for analytics are looking first and foremost for agile self-service models.

One brand... three products... endless possibilities

One brand... three products... endless possibilities

Analytics should be augmented, integrated, and collaborative for all lines of business.

Analytics should be augmented, integrated, and collaborative for all lines of business.

Genpact reduced its analytics modeling response time to seconds instead of hours with the help of Oracle Analytics.

Genpact reduced its analytics modeling response time to seconds instead of hours with the help of Oracle Analytics.

We're building on three key priorities to guide customers on their analytics journey

We're building on three key priorities to guide customers on their analytics journey

With the help of Oracle Analytics Cloud, Ireland's main postal provider moves forward with its digital transformations and cloud-based endeavors.

With the help of Oracle Analytics Cloud, Ireland's main postal provider moves forward with its digital transformations and cloud-based endeavors.

Oracle Analytics Cloud data visualization feature supports different aggregation rules so you can answer complex business questions.

Oracle Analytics Cloud data visualization feature supports different aggregation rules so you can answer complex business questions.

Oracle Analytics helps IT empower business customers with self-service analytics.

Oracle Analytics helps IT empower business customers with self-service analytics.

Learn to make your data flow a bit more functionally representative, such as when converting currency values.

Learn to make your data flow a bit more functionally representative, such as when converting currency values.

Stay a step ahead of Microsoft Power BI.

Stay a step ahead of Microsoft Power BI.

World Cup teams winning the toss would benefit from looking at historical stats and Oracle Analytics to make an informed decision.

World Cup teams winning the toss would benefit from looking at historical stats and Oracle Analytics to make an informed decision.

Oracle Analytics Cloud enables an entire portfolio of data visualization capabilities across the enterprise.

Oracle Analytics Cloud enables an entire portfolio of data visualization capabilities across the enterprise.

The retail landscape is changing, and ecommerce is putting a tremendous amount of pressure on retailers, leading to greater emphasis on analytics as a competitive advantage.

The retail landscape is changing, and ecommerce is putting a tremendous amount of pressure on retailers, leading to greater emphasis on analytics as a competitive advantage.

Everybody wants to be insight-driven, but what do they need to make that a reality?

Everybody wants to be insight-driven, but what do they need to make that a reality?

Oracle Analytics Cloud can be used to gain insight into employee satisfaction and prevent turnover.

Oracle Analytics Cloud can be used to gain insight into employee satisfaction and prevent turnover.

Finding talented employees is only the beginning of the HR puzzle these days.

Finding talented employees is only the beginning of the HR puzzle these days.

Because companies crave a competitive advantage and desire better insight into their data, more and more are adopting analytics and machine learning in the marketplace.

Because companies crave a competitive advantage and desire better insight into their data, more and more are adopting analytics and machine learning in the marketplace.

To be smart, your mobile analytics platform should satisfy these four areas of your professional life.

To be smart, your mobile analytics platform should satisfy these four areas of your professional life.