Matt Milella

Parse File Names Using Regular Expressions

Recently I needed to parse a full path to a bunch of files to get just the name of the file. To do this I had to use a regular expression and some string manipulation. In doing this I found the use of regular expressions in Oracle Analytics to be very powerful and I thoughtContinue reading “Parse File Names Using Regular Expressions”

Remove Duplicates in a Data Set

Have you ever needed to remove duplicate rows in a data set? Well me neither, but an unnamed PM asked me to do it one night long ago and I am finally getting to publishing how. The Setup I have some survey data (totally fake) and in the data there are duplicate rows with oneContinue reading “Remove Duplicates in a Data Set”

Use Emojis in Analytics 😍

Did you know that emoji can be used in Oracle Analytics projects? Well now you do and there are some cool 😎 use cases for this as long as you are willing to be creative. Point to Stuff ☝️Showing users exactly what to click or tap on is often important in delivering analytics. Pointing handsContinue reading “Use Emojis in Analytics 😍”

Tips and Tricks and When to Use Oracle Analytics Desktop

Oracle Analytics allows customers to get insights on data with a couple key deployment options; cloud (OAC) and on-premises (OAS). This should cover most needs, but there are a couple of specific reasons for a desktop version. First, if you just want to try things out you can download the desktop version. One great wayContinue reading “Tips and Tricks and When to Use Oracle Analytics Desktop”

Show the Latest Data

Sometimes you need to just show the latest data. This is often the case for metrics like inventory or some percentages where adding things up just does not make sense. Most analytic tools like Oracle Analytics allows authors to pick from various aggregation methods as a solution, but when building a project you don’t alwaysContinue reading “Show the Latest Data”

Be ‘Responsive’ to a Point

By default Oracle Analytics data visualization projects are responsive by default and this is great so authors generally don’t have to worry about device, device size, or screen resolution. Right? Above is an example of some to the beautiful screenshot I see on social media showing off an authors work, but this sort of layoutContinue reading “Be ‘Responsive’ to a Point”

Ready for Launch

With little to do in my spare time I am now able to finally do this blog consolidation that has been at the bottom of my todo list for many months. The plumbing part is all complete and here is what you need to know. More content is on the way! This clean up neededContinue reading “Ready for Launch”

A Fresh Start

For a few years I have been trying to find time to launch a new and organized place to me to share some of my knowledge on data. I have been at this game for more than 20 years and my blogging and ‘underground’ days started decades back when I was writing about and postingContinue reading “A Fresh Start”

Setting the PORTALPATH for OAC 5.5 and Above

For years our Oracle Business Intelligence customers have been using an RPD session variable to redirect end users to a specific dashboard when they hit the URL for their analytic platform. https://hostname/analytics This has served us well but fast forward to Oracle Analytics and this approach needed to change. Starting with OAC 5.5 this isContinue reading “Setting the PORTALPATH for OAC 5.5 and Above”

Oracle Analytics on Chrome 80 (now 84)

Google had put the brakes on this update back in March but now it is back, and rolling out as we do this update. All the same details below still apply just a few months later. https://www.chromium.org/updates/same-site In February Google will roll out an update to Chrome (80) that will implement a secure-by-default model forContinue reading “Oracle Analytics on Chrome 80 (now 84)”