Oracle Data Visualization -Hands on Lab

“Use Oracle Data
Visualization (DV) to quickly discover analytic insights through
visualizations that you build against a variety of data sources that
you seamlessly blend together.”


Triggered by both Mike Durran and the Amis Oracle OpenWorld & CodeOne review I went through the OOW18 Session Catalog. The Oracle Data Visualization Hands on Lab is an easy way to get in touch with this product. I decided to give it a quick try.

Next to this I am also trying out the Oracle Cloud. I already provisioned an Autonomous Data Warehouse Cloud database (ADWC). It could be nice to combine part of the Hands on Lab with the Oracle Cloud trial.

Impact of Social Media Campaigns on
Product Sales

According to Mike, the Hands on Lab material can be downloaded here.

The Hands on Lab material consists of a pdf with the different steps to be taken. Next to that there are two .xlsx-files with the data.

I decided to try and use Oracle SQL Developer to load the .xlsx-files into my Autonomous Data Warehouse Cloud database. This proces is relatively straightforward.

Make sure you have a SQL Developer connection to ADWC. How you should achieve that is described in the Oracle Help Center.

Via an Right-Mouse-Click, you can Import Data.

Import Data

As from here it is just following the wizard and load the .xlsx-files into ADWC.

Data Preview
Import Method
Choose Columns
Column Definition

Make sure all column names are valid. In the above example ‘DATE’ is a reserveren word. Special characters, like ‘#’, also need special attention.

Column re-Definition
Finish

If everything goes well, the data is loaded into a table, specified in the ‘Import Method’. In this case it is the table: KOOLKART_SALES_DATA.

Table imported

Repeat similar steps for the other .xlsx-file.

If you want to proceed with the Hands on Lab you need to connect Oracle Data Visualization Desktop (DVD) to ADWC. The Oracle A-Team has dedicated a blogpost to this process. When DVD and ADWC are connected, a Data Set can be created.

Create Data Set

From this point onwards, it’s easy to follow the Hands on Lab.

It’s nice to see how easy various components within the Oracle stack can communicate together. This blog only covers the first 58 or so pages. I guess the other steps can be followed just as easy. If there is anything worth mentioning or when I will take a sidestep again I will post again.

Good Luck.

Amis Oracle OpenWorld and CodeOne review

Monday the 5th of November I attended the Amis Oracle OpenWorld & CodeOne review. A summary of two multiple day events in 3 hours and 450 slides. An in-depth analysis of what is here now and what is coming.

Last October 22nd until 25th San Francisco  was the place to be for Oracle OpenWorld 2018 and Oracle Code One 2018. Oracle OpenWorld is the yearly event where Oracle-experts share their knowledge and expertise. Oracle Code One (The successor of JavaOne) is focussing on modern (application and integration) architectures and software development.

For those less fortunate and unable to attend (like myself) there are several sources to stay up to date.

Watch the Keynotes and some of the sessions On Demand.

Check the Session Catalogs from both Oracle OpenWorld and CodeOne for downloads of the presentations and sessions.

Amis Oracle OpenWorld & CodeOne review 

As always Amis has send a delegation to the Oracle conferences. Thanks to Amis and Lucas Jellema and Robert van Mölken in particular I had the chance to get up-to-date. Like every year the organised a Oracle OpenWorld & CodeOne review. In this review Lucas and Robert coverd the following topics (among others):

  • Oracle Cloud Infrastructure (OCI), the Generation 2 Cloud
  • Containers and Kubernetes in the Oracle Cloud
  • Blockchain
  • Machine Learning
  • Autonomous everything
  • IoT
  • Moderne architectures like MicroServices, ServerLess, CQRS & Event Sourcing

Check out the different slides on SlideShare:

Announcements, Analysis and Overviews on Data, Analytics and Machine Learning – https://www.slideshare.net/lucasjellema/amis-oracle-openworld-codeone-review-pillar-1-data-5-november-2018 …

Takeaways & Interpretations on Oracle Cloud Infrastructure – https://www.slideshare.net/lucasjellema/amis-oracle-openworld-codeone-review-pillar-1-cloud-infrastructure-5-november-2018 …

Blockchain, Integration Cloud, ServerLess and MicroServices – https://www.slideshare.net/RobertvanMlken/blockchain-integration-serverless-microservices-oow-2018-review

Custom Application Development – https://www.slideshare.net/lucasjellema/amis-oracle-openworld-codeone-review-pillar-2-custom-application-development-5-november-2018 …

SaaS & Business Applications – https://www.slideshare.net/lucasjellema/amis-oracle-openworld-codeone-review-pillar-2-saas-and-standard-applications-5-november-2018 …

Thanks Lucas and Robert, I have enough homework to keep me busy until next year.

Originally published on LinkedIn.

Looking back at Alteryx Inspire Europe 2018

Last week I stepped out of my comfort zone and attended Alteryx Inspire Europe 2018. For an Oracle addict like me, it was a nice way to experience what else is going on the Data & Analytics world.

Last week I stepped out of my comfort zone and attended Alteryx Inspire Europe 2018. When I joined Pong. earlier this year, I found out that we have an Alteryx license. Working in Oracle environments for so long, I had not run into Alteryx before. I was very curious about the possibilities of the project. Lucky for me Werner Maurits made it possible for me to attend the event.

I had a few questions upfront.

“What is Alteryx and why would I use it?” 

The event was made up of a few different tracks. I decided to attend several different trainings to make sure I would make my hands dirty. These Platform Trainings gave me a lot of hands-on insight of the product, next to things like…..

  • ……the Keynotes (e.g. Dean Stoecker, Founder + CEO, Ashley Kramer – SVP of Product Management and a lot more)
  • …..Sponsor Expo (great to see the integration with third party solutions like Snowflake DB), 
  • …..Breakout Sessions
  • …..ALTER.NATION ( Community, User Groups, AFG, User Experience Lab, Social Lounge, Product Showcase). 
  • …..The Solutions Centre, which was a bit off limits for me. If you would have an challenge to conquer, the (and I quote) brilliant minds of Alteryx development, product management, professional services, and Customer Success Group associates are there to help you. 
  • …..CODE.CHELLA, the Inspire gala event was fun too.

For another impression of the event, check out the #alteryxeu18 hashtag (while it lasts).

Back to the question; “What is Alteryx?”. Alteryx is an end-to-end analytics platform which tries to bring Business Users and Data Engineers / Scientists together. One single platform where different types of user can “discover, transform, model, and analyze data using a single governed, collaborative, and scalable enterprise analytic solution”.

  • Discover and Collaborate – Alteryx Connect helps users to search & find the right analytic assets at the right time, combining data cataloging and metadata.
  • Prepare, Analyze and Model – Alteryx Designer provides a self-service capability to cleanse, prepare and blend data from all relevant datasources.
  • Share, Scale and Govern – Alteryx Server allows to create, publish, and share analytic applications and data connections. It helps to schedule and automate workflow jobs, next to controlling data access.
  • Deploy and Manage – Alteryx Promote makes it easy to deploy, manage, and monitor production based analytic models.

Although the event is a great opportunity to get together with Alteryx enthusiasts, I spend most of my time exploring Alteryx Designer. Another great way to get to know about Alteryx (including Designer) is the Alteryx Community.

During the event lots of Use Cases have been presented, also by the various attending and presenting customers. That gave me an impression for my second question; “Why would I use Alteryx?”. The opportunities seem to be endless. Alteryx Community is another place where I could find some possible use cases, per department, industry and product.

All in all I have been experiencing three very inspiring days. Far too much for me to absorb everything, but a very nice opportunity to get to know more about the Alteryx product.

The coming weeks / months I will spend some more time in the Alteryx Academy and the Tips & Tricks. This way I will be better equipped to get more out of Alteryx for Pong. It is a happy couple anyway.

 

ODC Appreciation Day: ‘Blank Canvas’ Syndrome

It’s ODC Appreciation Day again. In the 2018 edition, I would like to thank Oracle for integrating Machine Learning into their Data Visualization product that explains attributes in context of the other attributes and metrics in the dataset.

It’s that time of the year again. After 2016 and 2017 the ODC Appreciation Day of 2018 is there. As Tim Hall mentioned in his Summary-post in oktober 2016, ODC Appreciation  Day is; “to mobilise the Oracle community to say #ThanksODC for everything the  Oracle Developer Community (ODC) has done for the Oracle community over the years.” 

Machine Learning Alleviates ‘Blank Canvas’ Syndrome

For my contribution, I would like to refer to a blogpost by Oracle’s Barry Mosterd. Oracle has integrated Machine Learning into their Data Visualization product that explains attributes in context of the other attributes and metrics in the dataset. This way; “Machine Learning is now in the hands of business users, empowering them to filter noise, quickly see the signals and share their findings.”

Thanks again to Tim for organising this event. Looking forward to all the different contributions. Curious what other people have to share on ODC Appreciation Day, check here.

Cheers.

The Forrester Wave™: Big Data Fabric, Q2 2018

The @Forrester Wave™: Big Data Fabric, Q2 2018. @Oracle continues to broaden its Big Data Fabric solution and leads the pack.

I have written about analyst reports in the past. Last week I read about the The Forrester Wave™: Big Data Fabric, Q2 2018. A few months ago I wrote a 5 part series about Big Data Platforms. Apparently platforms like Cloudera an Hortonworks do not run the show according to this analysis report.

“Talend, Denodo Technologies, Oracle, IBM, And Paxata Lead The Pack”

According to Forrester, a Big Data Fabric is an emerging platform which accelerates business insights; “by automating ingestion, curation, discovery, preparation and integration from data silos”. It can support many types of use cases. The top big data fabric use cases Forrester has seen are:

  • A 360-degree view of the customer
  • Internet-of-things (IoT) analytics
  • Real-time & Advanced analytics

Forrester has included the following companies (Cambridge Semantics, Cloudera, Denodo Technologies, Hitachi Vantara, Hortonworks, IBM, Informatica, Oracle, Paxata, Podium Data, SAP, Syncsort, Talend, TIBCO Software, and Trifacta) into the report, based on a few inclusion criteria. The most important ones are the functionality of the offering and (of course) Cloud. The offering must be able to offer the following functionality:

  • data access
  • data discovery
  • data transformation
  • data integration
  • data preparation
  • data security
  • data governance
  • data orchestration of data sources

Of course the solution;

  • “must be able to ingest, process, and curate large amounts of structured, semistructured, and unstructured data stored in Big Data Platforms
  • “should be able to store metadata/catalogs for data modeling and data access purposes to support a globally distributed data fabric.
  • “must be able to run on cloud or on-premises platforms.”

“Oracle continues to broaden its big data fabric solution”

Oracle’s key strengths lie in its security & governance capabilities, highly scalable data movement, and transformations that can be done in real-time streaming environments. Forrester says, Oracle’s customers use the Big Data Fabric to support the various use cases, like real-time analytics, customer intelligence, IoT applications, and other Big Data applications and insights.

In a presentation I did at the UKOUG and the nlOUG last year, I uncovered some parts of the Oracle Big Data (Cloud) offering.

The following Oracle products are included in the report:

On Premise

Cloud

Find out what some of the other vendors have to say about the report:

Of course this report is only a view from one analyst. You should check what the Gartners of this world have to say to get a completer picture.

Originally published on LinkedIn.

 

Creating Plug-in Visualizations for Oracle Data Visualization

Plug-ins make it possible to extend the visualization capabilities of Oracle Data Visualization.

Last week I had the privilege to present at the nlOUG Tech Experience 2018. I decided to discuss the Challenges and Pitfalls of Data Visualization.

nlOUGTech18_Challenges_and_Pitfalls_of_Data_Visualization_page_32

In one of the slides I showed how we apply some of Stephen Few’s rules to our dashboards. Because we were not completely able to achieve this with out-of-the-box functionality, we decided to use jQuery. In the Oracle (OBIEE) Virtual Box Sample App, we found the inspiration.

One of the attendees asked whether it is a lot of work to add these kind of customizations. After the usual; “It depends”, we discussed a possibility to add custom visualizations to Oracle Data Visualization. If you check the ‘The Oracle Analytics Library’, you see a library of different customised data visualization examples. Besides Oracle, several companies like Peak Indicators and Vlamis.

I have not tried it myself, but here are a few links to get you started.

Challenges and Pitfalls of Data Visualization

“A picture says more than a thousand words”. This sounds like a true statement. While it’s true that it is easier to tell a story with visuals than with words, it makes a huge difference which visual you are using for which story. What is the real story behind a visual. Using the wrong visual to tell a certain story can reduce the benefit of a visual to zero. In this presentation we will go through the Challenges & Pitfalls of Data Visualization.

The last two days I was present at the 2018 nlOUG Tech Experience at the Rijtuigenloods in Amersfoort. The Dutch Oracle User Group organizes this event with 69 speakers from 19 countries, who give more than 70 sessions on ground-breaking topics in the field of Oracle (related) Technology.

‘The Cloud is Next’ Tech Experience! 

The nlOUG has been able to get both Regis Louis (Vice President of Product Management & Strategy, Oracle Cloud Platform, EMEA/APAC) as well as Penny Avril (Vice President of Product Management Oracle Database) on stage. They have brought us up to speed with Oracle’s Cloud Platform strategy and Autonomous Data Management.

In addition, Oracle was present and offered various hands-on labs where visitors have been able to try out the latest Cloud products from Oracle themselves.

There where a lot of inspiring and challenging sessions on applying Oracle technology in practice. These sessions include, Continuous Delivery, Blockchain, Data Guard, Oracle Data Modeler, JSF and ADF, hybrid API strategies, Low-Code, Bots, API Integration Testing, Cloud-based Agile Team Development and many more.

The Analytics track was filled with sessions about Data Visualisation, Kafka, Graph Database, Hybrid Cloud solutions, Chat bots and much more.

The Psychology of Data Visualization

Yours truly had the privilege to take the stand in one of the old train wagons. “A picture says more than a thousand words”. This sounds like a true statement. While it’s true that it is easier to tell a story with visuals than with words, it makes a huge difference which visual you are using for which story. What is the real story behind a visual. Using the wrong visual to tell a certain story can reduce the benefit of a visual to zero. In this presentation we will go through the Challenges & Pitfalls of Data Visualization.

I uploaded my slides on SlideShare.

Of course a big thanks to our sponsors!

 

I had a great time. As always these conferences ar great place to exchange knowledge and meet with like minded people. I have met some ‘old’ and some new friends. Hopefully I will see you (again) next year at the third anniversary of the nlOUG Tech Experience.

Originally published on LinkedIn.