Skip to main content

Posts

Showing posts with the label OAS

Talking to Oracle Analytics

Being able to talk to computers using natural language, especially with the recent advancements in general AI models like ChatGPT, has become very popular in the last few months. Everyone is doing it. It's simple, easy to use, and frankly, it can be very useful. What has been around for a while—think Siri, Alexa, or TV remote controllers—has now been taken to a new level and is already widely used in business. In Oracle Analytics, Natural Language Recognition has been available for several years. I remember the early days when the Oracle Day by Day mobile application was introduced. One of the coolest features in Day by Day was the ability to ask questions using natural language. For example, What is revenue by region and channel for seniors? would provide an answer in the form of charts, tables, and more. This feature is still available today, and you can ask such questions in the Search field located on the Oracle Analytics home page. Oracle Analytics then provides the f...

Migrating to Oracle Analytics

Oracle Analytics has been publicly available for more than three years now. Since the beginning Oracle has been improving the product and many innovations have been into the product stack, expanding into areas like data visualization, data discovery, data management, augmented analytics, machine learning and others quite heavily.  The gap between Oracle Analytics and its predecessor Oracle Business Intelligence has been widened and many Oracle Business Intelligence users have decided to upgrade to Oracle Analytics. On the other handside, we can still see a lot of Oracle Business Intelligence users continuing to use Oracle Business Intelligence.  I think that today, Oracle Analytics has matured enough and is providing so many new features that the time has come for all existing users of Oracle Business Intelligence to seriously consider a move to Oracle Analytics, either that being migrated and implemented within Oracle Cloud Infrastructure as Oracle Analytics Cloud, or on-prem...

Working with Graph in Oracle Analytics - Intro

You can find the following definition about Graphs and Graph theory on Wiki :  In mathematics, graph theory is the study of graphs, which are mathematical structures used to model pairwise relations between objects. A graph in this context is made up of vertices (also called nodes or points) which are connected by edges (also called links or lines). A distinction is made between undirected graphs, where edges link two vertices symmetrically, and directed graphs, where edges link two vertices asymmetrically. Graphs are one of the principal objects of study in discrete mathematics. In essence, graphs are used to model various types of relationships. In case of business analytics, graphs can used in sales and marketing departments to perform recommendations of the products to particular group of customers that are somehow related to some other group of customers, in manufacturing they can be exploited to manage inventory more effectively due to better planning of materials and semi-pr...

Oracle Analytics 6.0: Hierarchical Columns

  Oracle Analytics 6.0 has arrived! Our Oracle Analytics instance was just patched a few hour ago. Everyone who is using Interactive Dashboards and Analytics (even from OBIEE times) is familiar with hierarchical columns. They are very popular with users and in some cases, like working with OLAP cubes (ie. Essbase), necessary. Oracle Data Visualisations (in the past) aka Oracle Analytics (today) lacked this functionality until now. In version 6.0 this has finally been included and here we are testing it. Data Visualisations with Hierarchical Columns Hiearchical Columns are the most applicable in tables or pivot tables, however they can be used in some other visualizations like trellis. We will create a project first. Hierarchical columns can be defined in Oracle Analytics Data Models aka Subject Areas, Oracle Planning applications or Essbase cubes. By selecting one of subject areas you can now see hierarchical columns in the data model in the Data panel: Working with hierarchical co...