Sunday, September 22, 2019

OAC Sandbox - Your Name in Lights

It is always fun to see your name in lights!

See your name here -> Oracle DV canvas



Word Cloud Viz


I was able to find a data set that would allow me to do just that, see your name among the USA census data for first names at birth all the way back to 1910!

This is the data set that was used

Beyond the top 1000 names - https://www.ssa.gov/oact/babynames/limits.html


I found it interesting that there were so babies named 'baby*' and over 90% of them over an approx. 20 year span from 1986 to 2006



It was also interesting to take a look at the trend using the custom Butterfly Viz as I was particularly trying to see if there really was a baby boom. This is what I found. Id does appear that there was a baby boom in the 1960s




Well, the fun part was getting to see where my name was in the data and determine if there were any trends, etc.


Filter: Gary



And to use the Grid Heat map to look into my name over time by state.


Gary looks like a popular name in the 1950s particularly in CA and NY.
Interesting that the name wasn't 'nation-wide' until 1941 and started to taper off in the 1980s.


Again, here is the link to start exploring the OAC Sandbox




Using the OAC Sandbox environment is Free.
No catches, no 30-day trial, just free. free as Free as in FREE.


And in case you needed more reason to there is another canvas that is available in the Sandbox -> 'Real Time Sandbox Usage'
that captures the usage statistics of each canvas in a Project.


Check out the usage of the USA census names canvas over the last 30 days!








Wednesday, May 15, 2019

Available to download - Oracle Data Visualization Custom PLUGIN Butterfly

Excited to announce that a 3rd custom PLUGIN I have been working on is available to download and start using now - available on


The Oracle Analytics Library: https://www.oracle.com/solutions/business-analytics/data-visualization/extensions.html


Within the Extensions tab


or download here


Name of Viz: Butterfly Chart

Authors: G.Adashek & D.Flores


Description:

The Butterfly chart, also sometimes known as a tornado bar chart allows to compare 2 data sets side-by-side.
This provides a quick analysis of variances and is a simple comparison chart.
Use the tooltip in this custom viz to easily show the variances.


Saturday, April 20, 2019

New Version Oracle Data Visualization Desktop 12c (12.2.5.2.0)

There is a NEW Oracle Data Visualization Desktop version 12.2.5.2.0 now available!


Download the latest version of Oracle Data Visualization desktop - here


https://www.oracle.com/middleware/technologies/oracle-data-visualization-desktop.html#



#keratoconus




Saturday, March 23, 2019

Available to download - Oracle Data Visualization Custom PLUGIN Vertical Waterfall

Excited to announce that a 2nd custom PLUGIN I have been working on is available to download and start using now - available on

The Oracle Analytics Library: https://www.oracle.com/solutions/business-analytics/data-visualization/extensions.html


Within the Extensions tab

or download here


Name: Vertical Waterfall

Authors: G. Adashek & D.Flores

Description:

The Vertical Waterfall is the ‘tipped’ (top-to-bottom) version of what many know as the traditional horizontal (left-to-right) Waterfall chart. 

By rotating the visualization 90 degrees clockwise, this allows for easy to read text along the y-axis spine of the visualization.



Sunday, January 6, 2019

Oracle Data Visualization - #Makeover Monday 2019 Week 01 NHL Attendance


Happy New Year!


And a start to #MakeoverMonday (MM) in 2019


Here is the set of data to take a look at.

The Data: http://www.makeovermonday.co.uk/data/

Year: 2019
Week: 01
Date: Dec 31
Data: data.world
Source Article Visualization:
NHL Attendance
Data Source: ESPN


Original Visualization:

NHL attendance continues to grow




Article: NHL to Seattle


This is what I did to start to make this better.


I did notice that the overall Total Attendance starting from the 2000-01 season has gone up.


That can be seen from this simple Line chart that I created.





Total NHL Attendance did go up from 40.8M to 44.3M

The original data set did not include the 2004-05 season.
So I added that to the data in order to show a full and proper picture of the seasons over time.

You can see the line chart drop to 0 that season.

There is another drop below 30M in the 2012-13 season since there were only 48-games played in that shortened season. 25.5M that season was the Total Attendance and with a simple ratio formula would have kept the Total Attendance rising to just below 43.6M, an Attendance mark that wouldn't be reached and surpassed until the 2017-18 season! 😳

Stacked Bar with Color by Team gave me a view that there was an extra team, welcome to the league Vegas, in the NHL that last season with a Total Attendance of 1.472M



If you simply take that off of the Total the attendance would actually be lower than the previous year of 43.050M versus the adjusted amount of 42.875M.

You can see that with the Parallel Coordinates chart by adding a few filters.
Filter for showing only the 2 seasons in question as well as removing Vegas.




So I was able to answer the MM question for myself that with just the simple attendance totals, yes, attendnace did go up but that is not entirely fair to simply state since there was another team added to the league last year that skews the data.


But I wanted to take a deeper look into the data for my favorite team, the Chicago Blackhawks. Maybe there was something interesting I could find.

I picked a few Attributes as well as Measures to start.
To select more than 1 at a time, hold down the control/command key while you make multiple selections.

Once I had what I wanted, I then wanted to find out what DV thought would be the best. While the multiple selections are made, Right-Click and select "Create Best Visualization", just that simple.



Unfortunately, the result was not pretty 👀



Looks like a mess in my opinion.

Time to start making changes but leaving alone the Viz Type as Scatter (kind of). I changed the Viz type to "Scatter (Cat.)". This allowed me to group the measures together on the Y-axis and display the Seasons over time on the X-axis. This was the result.


There are a few things that I noticed. It does look like the attendance all around (Total, Home & Road) was going up. But there was something else, if you look at the Red (Road) and Grey (Home) attendance there is a "flip" after the 2007-08 season, meaning that the Home attendance is more than Road from that year onward.

Wanting to highlight this as a part of my final Viz, this was going to help be the baseline.

With that, I right-clicked on the Canvas name and selected "Duplicate Canvas".




I then changed the Viz Type to "Combo" and removed the Total Attendance.
You can see with Lines that the trend does go up and there is a season as mentioned before that Home exceeds Road attendance.



To make the data easier for the reader to distinguish this fact about the data, I made a change to the HOME #Values.

The change was to make this a Bar instead of a Line.
Do do this I right-clicked on the HOME ATTENDANCE #Value in the Y-axis assignments section and selected "Bar".




This is the pre-final Visualization of a Combo with both Line and Bar



In order to create the narrative of the data, I removed the Legend and added the color context to the Title, added text to let the reader know about the league labor disputes, and also added the svg image for additional #1-SVG image context to highlight when the Chicago Blackhawks 🏒 won the Stanley Cup! 3-times 🏆🏆🏆


The Final Visualization was a Combo with both a Line and Bar to be able to clearly highlight the HOME attendance Bars rising above the ROAD Line




Link to Tweet - https://twitter.com/GADASHEK/status/1081655382169276416