tag:blogger.com,1999:blog-37866793133319377892024-03-27T16:52:48.959-07:00Oracle Underground BI & Datavizoraclebitechdemohttp://www.blogger.com/profile/10233918098859506651noreply@blogger.comBlogger121125tag:blogger.com,1999:blog-3786679313331937789.post-12988953097164734082021-03-31T07:19:00.007-07:002021-03-31T07:19:35.892-07:00Database privileges required for Text Tokenization in Database AnalyticsOracle Analytics leverages several advanced analytics
capabilities of Oracle Database and makes them available across various
components within the product. Database Analytics step is one such option within the
Dataflows that exposes several database functions like dynamic predictions, sampling,
unpivoting, frequent itemset detection, text tokenization and so on. All these operations are directlyoraclebitechdemohttp://www.blogger.com/profile/10233918098859506651noreply@blogger.com4tag:blogger.com,1999:blog-3786679313331937789.post-87452886706039888512021-03-31T07:04:00.005-07:002021-03-31T07:04:53.434-07:00Logistic Regression : Understanding model hyper-parametersIntroductionOracle Analytics enables data analysts to train Machine Learning (ML) Models and score their datasets. It offers several algorithms that help to build different types of ML models, and with each algorithm comes a list of hyper-parameters to control the model training process. All these parameters can be manually tuned to the improve overall model design and accuracy. oraclebitechdemohttp://www.blogger.com/profile/10233918098859506651noreply@blogger.com10tag:blogger.com,1999:blog-3786679313331937789.post-4304145951377736332021-02-27T07:55:00.001-08:002021-02-27T07:55:41.852-08:00Multiple Top N Filters – Part 1 of 2Top N analysis is a useful technique and helps in focusing on a small ordered set of data items from a large dataset. They help in answering queries like 'What are the Top 5 products that have had maximum Sales' or ' Who are the top 3 agents who sold maximum policies' and so on. Oracle Analytics offers Top
Bottom N filters that allows you to easily perform Top N or Bottom N analysis.
oraclebitechdemohttp://www.blogger.com/profile/10233918098859506651noreply@blogger.com0tag:blogger.com,1999:blog-3786679313331937789.post-29913840621136793432021-02-25T06:28:00.000-08:002021-02-25T06:28:07.911-08:00Creating a vanity for Oracle Analytics CloudOracle
Analytics vanity URLs allow you to customize your access point to Oracle
Analytics giving your own deployment a custom, easy to access end point.
This blog will
accelerate your vanity URL deployment, total time to set it up should be less than 10 minutes. Should you seek additional details and use cases beyond this blog overview, you can also refer to the official oraclebitechdemohttp://www.blogger.com/profile/10233918098859506651noreply@blogger.com1tag:blogger.com,1999:blog-3786679313331937789.post-61035673536495005042021-02-25T01:47:00.003-08:002021-02-25T01:47:37.359-08:00How to Calculate Top N Versus Rest of Population in Oracle AnalyticsOracle Analytics enables users to easily filter visualizations or whole canvases by using Top N or Bottom N filters. These filters have several nice options such as starting from a Metric, or starting from an Attribute, or even setting the 'implicit grain' that will control what level of aggregation the Top N calculation will start from. These filters come extremely handy in most situations.But oraclebitechdemohttp://www.blogger.com/profile/10233918098859506651noreply@blogger.com0tag:blogger.com,1999:blog-3786679313331937789.post-24614036362554977712021-02-24T08:47:00.000-08:002021-02-24T08:47:07.721-08:00OAC Integrating WMS MapsWhat is a web map service? Web Map Service (WMS) is a standard protocol for serving geo-referenced map images and data generated by a Geographic Information System (GIS). The Open Geospatial Consortium developed the specification and first published it in 1999. So, simply put, WMS is a way of interacting with a web server which hosts map backgrounds. Oracle Analytics now includes the oraclebitechdemohttp://www.blogger.com/profile/10233918098859506651noreply@blogger.com0tag:blogger.com,1999:blog-3786679313331937789.post-36359381533474743112021-02-24T07:24:00.002-08:002021-02-24T07:24:27.680-08:00OAC integration with XYZ Tiled Web MapsTiled web maps or XYZ tile layers are maps that are displayed in a web browser by joining dozens of individually requested image or vector tiles from a web server. Along with WMS, XYZ tiled web maps are one of the most popular techniques used to display maps and to enable user interactions such as panning and zooming. The above picture shows a tiled web map of OpenSteetMap style focusing on oraclebitechdemohttp://www.blogger.com/profile/10233918098859506651noreply@blogger.com0tag:blogger.com,1999:blog-3786679313331937789.post-30536791657579660052020-12-18T02:54:00.008-08:002020-12-18T03:05:51.945-08:00Calculating Correlation Coefficients with Oracle Analytics CORN functionOracle Analytics platform provides multiple functions to analyze and better understand your data. This blog explains a prebuilt function that makes it very simple to calculate Pearson's Correlation Coefficient (PCC) between two columns. This function is called CORN in Oracle Analytics. Before going any further let us remember what correlation coefficient is and what it is used for.What is oraclebitechdemohttp://www.blogger.com/profile/10233918098859506651noreply@blogger.com2tag:blogger.com,1999:blog-3786679313331937789.post-72129078982121489432020-12-18T02:22:00.002-08:002020-12-18T02:22:34.919-08:00Consuming Analysis from Spatial Studio directly from OACSpatial Analysis is a process in which you model problems geographically and compute results using various spatial calculation. This is something that is used widely in many scenarios which include analyzing the results of an election, finding areas that are likely to affected by a hurricane when it makes a landfall, etc... Spatial technology helps in understanding where things occur, measuring oraclebitechdemohttp://www.blogger.com/profile/10233918098859506651noreply@blogger.com0tag:blogger.com,1999:blog-3786679313331937789.post-6261810741244723002020-12-14T08:52:00.000-08:002020-12-14T08:52:07.683-08:00Oracle Essbase 21.1 is AvailableIf you’ve been using Essbase
standalone (11g) for years, and yearning for the day that you could take
advantage of the latest Essbase features, but remain on your independent,
standalone Linux platform, THAT DAY IS HERE!
We’re excited to announce the
availability of Essbase 21c. This new release has many enhancements of the
Essbase features you’ve come to know and value. It also gives you all oraclebitechdemohttp://www.blogger.com/profile/10233918098859506651noreply@blogger.com1tag:blogger.com,1999:blog-3786679313331937789.post-55445203312126034142020-12-10T06:32:00.003-08:002020-12-10T06:32:33.713-08:00OAC querying JSON Data with AJD (Autonomous JSON Database)JSON or JavaScript Object Notation is an open data format
and the preferred data interchange format for web applications. JSON format is highly used in developing web applications where fast, compact and convenient
serialization of data is required.
While Oracle Analytics Cloud (OAC) does not inherently support
JSON format data sources, overcoming this limitation is simply done by
integrating oraclebitechdemohttp://www.blogger.com/profile/10233918098859506651noreply@blogger.com0tag:blogger.com,1999:blog-3786679313331937789.post-46327346601786550892020-12-07T06:53:00.003-08:002020-12-07T06:53:49.954-08:00Easily Get a Unique ID Column in Your OA DatasetIt often happens to me that, while analyzing data, I end-up needing a unique identifier for every row in my dataset, but... it's just not present in there.... Doesn't that happen to you too sometimes ? Whether the underlying data is self uploaded , or is an enterprise semantic layer, sometimes simply we don't have the choice to go back to the physical data and add a unique row id for each record oraclebitechdemohttp://www.blogger.com/profile/10233918098859506651noreply@blogger.com1tag:blogger.com,1999:blog-3786679313331937789.post-86764867273157662542020-12-07T05:55:00.018-08:002020-12-07T06:13:22.242-08:00The New Network Graph Custom Viz Plugin for Oracle AnalyticsThe Network Plugin Custom Viz Plugin enables to visualize Networks dataset with Oracle Analytics. While it provides a simple way of visualizing networks, the plugin offers a comprehensive representation of all connections
between various nodes in a network, various properties to adjust the visualization. The parameters that can be tuned help users understand the relationship
among the nodes like oraclebitechdemohttp://www.blogger.com/profile/10233918098859506651noreply@blogger.com3tag:blogger.com,1999:blog-3786679313331937789.post-75251938858668682132020-09-08T05:22:00.003-07:002020-11-10T07:53:08.623-08:00Leveraging Custom Data Actions Plugins in Oracle AnalyticsData action plug-ins leverage the data actions framework to provide
custom, data-driven actions that are integrated into Oracle Analytics.
You develop your custom data action using Oracle Analytics Desktop and
then deploy your data action to Oracle Analytics. This video will help understand the usage and the value of custom Data-action plugins and will walk you through the structure of the oraclebitechdemohttp://www.blogger.com/profile/10233918098859506651noreply@blogger.com0tag:blogger.com,1999:blog-3786679313331937789.post-34380677310773207212020-08-26T02:49:00.001-07:002020-08-26T02:49:38.181-07:00Embedding Oracle Analytics Dynamically - Part IIThis blog is a part of the 2 part blog series on embedding Oracle Analytics content into an External portal. In the first part, we explored how to embed visualizations from a project into an external web portal, with the ability to pass filter values from the web portal down to the embedded Oracle Analytics visual. In this second part, let's see how to set-up an interaction directly oraclebitechdemohttp://www.blogger.com/profile/10233918098859506651noreply@blogger.com0tag:blogger.com,1999:blog-3786679313331937789.post-74490673082731554332020-08-20T08:46:00.002-07:002020-08-20T08:46:42.154-07:00Mask or anonymize sensitive data in Oracle Analytics
IntroductionIn the world of data driven decision making, analysts and managers should ensure appropriate privacy controls by restricting access to certain sensitive information in their data. Many times analysts work with sensitive information data like SSN (Social Security Numbers), CCN (Credit Card Numbers), Patient Names and so on. This data details should be masked before becoming availableoraclebitechdemohttp://www.blogger.com/profile/10233918098859506651noreply@blogger.com4tag:blogger.com,1999:blog-3786679313331937789.post-56061355904198820692020-08-10T06:29:00.007-07:002020-08-26T06:11:23.125-07:00Embedding Oracle Analytics Dynamically - Part IOracle Analytics visualizations can easily be embedded into external websites, custom portal, applicative pages.... We will start exploring this capability in this blog entry. We will be creating our own custom website and we include Oracle Analytics content as a part of it. We will also explore the various steps involved to do this embedding of Analytics content. Let us start with a bare oraclebitechdemohttp://www.blogger.com/profile/10233918098859506651noreply@blogger.com0tag:blogger.com,1999:blog-3786679313331937789.post-88200678494365763642020-07-20T05:40:00.013-07:002020-07-21T04:49:43.943-07:00Custom Scripts in Oracle Analytics Desktop - GeocodingOracle Analytics is a comprehensive unified platform offering services including self-service visualizations, powerful data-prep tool, advanced analytics and augmented analytics.In this blog, we are going to explain the use of leveraging custom-scripts using Oracle Analytics Desktop (OAD) and few tips and tricks to install additional custom Python packages that do not come by default with the oraclebitechdemohttp://www.blogger.com/profile/10233918098859506651noreply@blogger.com1tag:blogger.com,1999:blog-3786679313331937789.post-38912462624827242422020-07-20T02:21:00.002-07:002020-07-20T02:22:38.309-07:00Parameters of Random-Forest Algorithm for ClassificationsOracle Analytics includes several Machine Learning algorithms that
enable data analysts to identify patterns in their data and make predictions on it.
These various algorithms support different type of models : classifications, clustering or numeric predictions. Each algorithm offers several hyper-parameters to control the model training process and that can be manually tuned to improve overall oraclebitechdemohttp://www.blogger.com/profile/10233918098859506651noreply@blogger.com1tag:blogger.com,1999:blog-3786679313331937789.post-87101569794292651462020-07-16T00:00:00.001-07:002020-07-16T00:00:31.654-07:00Maps - Custom Image backgrounds Part IIThe Voyageurs Wolf Project was an initiative taken by University of Minnesota in collaboration with the Voyageurs National Park to study the ecology of wolves and their prey(moose, dear, beavers etc) during the summer in Great Voyageurs ecosystem. Specifically this research was aimed at studying the movement pattern of the wolves and its reproductive ecology.To track the movements of wolves and oraclebitechdemohttp://www.blogger.com/profile/10233918098859506651noreply@blogger.com0tag:blogger.com,1999:blog-3786679313331937789.post-10901347657075193432020-07-06T02:56:00.001-07:002020-07-06T02:56:32.520-07:00Building a filter-selective calculation with Oracle Analytics - Part IIIn our previous post here, we discussed a technique to build custom metrics in Oracle Analytics Self Service (DV, no RPD modeling) that would not obey to filter selections. Our use case was a a global revenue canvas where, if a user selects a specific country from a canvas filter, the metric % of Total Global Revenue would remain showing ratio of this country's revenue vs the whole oraclebitechdemohttp://www.blogger.com/profile/10233918098859506651noreply@blogger.com0tag:blogger.com,1999:blog-3786679313331937789.post-29177532743821940542020-07-03T05:04:00.003-07:002020-07-06T02:58:19.844-07:00Building a filter-proof calculation with Oracle Analytics - Part IIn some Analytics dashboards, we sometime need to represent values of filtered data, as a ratio to total data in the dataset. Meaning, filtering the numerator wihtout filtering the denominator of the fraction...For example, I could filter my Global Revenue dashboard for only France, for 2019, and yet still want to see the % France represents out of the total Global revenue in 2019. That's a oraclebitechdemohttp://www.blogger.com/profile/10233918098859506651noreply@blogger.com0tag:blogger.com,1999:blog-3786679313331937789.post-38315890807971619062020-06-08T01:23:00.002-07:002020-06-08T01:23:34.888-07:00Maps - Custom Image backgrounds
Images are everywhere - and are not just worth a thousand words, thousand tweets, or text or anything not visual.Whether it's a meme, artsy photo, selfie or an article click-bait, a good portion of the websites are increasingly filled with more images and less text. Images are more impact-full than text, more engaging, more insightful and definitely more quick to interpret by human brains.
oraclebitechdemohttp://www.blogger.com/profile/10233918098859506651noreply@blogger.com0tag:blogger.com,1999:blog-3786679313331937789.post-55940629834908672082020-06-08T00:54:00.001-07:002020-06-08T00:54:09.702-07:00How Regex can enhance Data Preparation?
Is simple find-and-replace not sufficient for your need in Oracle Analytics Data Preparation ? Regular Expression Replace functionality is bringing great new powerful abilities with pattern matching in Oracle Analytics Data Prepare. We will see what it has got to offer, in this blog.
First, take a quick look at the video which explains briefly about this feature.
Oracle Analytics now allows oraclebitechdemohttp://www.blogger.com/profile/10233918098859506651noreply@blogger.com0tag:blogger.com,1999:blog-3786679313331937789.post-55055772164116244082020-05-25T08:30:00.001-07:002020-05-25T23:53:38.279-07:00How to retrieve valuable information related to your ML models in Oracle Database - Part II
In part I of the blog on this topic (http://oracledataviz.blogspot.com/2020/04/how-to-retrieve-valuable-information.html), we talked about the
various data mining views that store information about every ML model that gets
created in the Oracle database. These views have information about ML models size, models settings, attributes used in the models etc. This information is
available for oraclebitechdemohttp://www.blogger.com/profile/10233918098859506651noreply@blogger.com0