nl.OUG Tech Experience 16 June 2017

Today the second day of the nl.OUG Tech Experience took place in ‘De Rijtuigenloods’. After a really interesting first day it was a real challenge to be at least as good as the day before on day 2. Also for this day the Dutch Oracle User Group has prepared an interesting and varied program. It is nice to see that there was a mix of people which represented the Oracle Community. There where ACE’s and non-ACE’s, men and also women, veteran speakers and relatively newbies (including myself), young and old, Dutchies and foreigners. All in all a great mixture of people with all the same goal; exchanging knowledge, meeting (new) people and having a lot of fun.

Duncan Mills (Oracle) kicked off the day explaining how he loves instead of fears the (Oracle) Cloud.

 

One of the things Duncan has learned in his long impressive career is to be pragmatic. You should make your life as easy as possible. The Cloud offers various tools to support this. In the end the Cloud is a ‘Force Multiplier’ for developers

After the keynote the Experience continued with the different parallel sessions. Also today, one of the SIG-Leads of the nl.OUG, I had the privilege to be part of the BIWA-track (Business Analytics & Data Integration). Today we had four different parallel tracks.

“Migration steps from OWB to ODI” – Gurcan Orhan

Oracle Data Integrator (ODI) is Oracle’s flagship product when it comes to Data Integration (ETL / E-LT). Officials Oracle Warehouse Builder (OWB) does not exist anymore. Still lot’s of company’s are using OWB. Migrating from OWB to ODI is not that easy by default. Gurcan explained which migration steps could make this process a bit easier.

“Introduction in Big Data Cloud Service and Use case” – Marco Klaassens & Daan Bakboord

When you talk about Big Data and the Cloud, Oracle might not be the first supplier people think about. Still Oracle is making serious progression when it comes to the various Cloud products. With an introduction into the Oracle Big Data Cloud Services, all the products could be placed into the context of the Oracle Information Management Reference Architecture. These architectures always make more sense when explained by a real use case.

“Oracle BI is just Lego for adults”

“A Day in the Life of an Oracle Analytics Query” – Christian Berg

When Christian Berg takes the stand you always know his message is supported by sarcasm, fun and beer. It does not matter which product you use in the Oracle Analytics stack, they are all based on the same core. With Oracle Analytics you don’t write a query (just use Oracle SQL Developer for that. Easier and cheaper). Oracle Analytics generates a query based on the metadata you provide. Therefore it is essential to understand how a query is constructed.

Of course Christian had one of the best one-liners of the day; “Oracle BI is just Lego for adults”. Different components fit together to make e.g. the perfect query. If one component does not fit, you don’t get a saw to make the component fit, you try another one which is made to fit in that place.

“Collaboration on analystics in the Oracle Business Intelligence and Data Visualization Cloud Service” – Hasso Schaap

There are several reasons to collaborate on Analytics. Sharing Insights and Story telling are just two examples. Oracle Analytics offers various options to collaborate. Hasso made some reusables. Get into contact with him and start collaborating.

At the end of two really great days, Lucas Jellema wrapped up the experience. With a few salutes, to the board of the nl.OUG for being so brave to host this event, to the audience for joining the conference and to the speakers who were well prepared and willing to share their experiences.

Special thanks to the sponsors.

 

It was a really great event. I enjoyed it a lot. It’s great meeting ‘old’ friends and meeting new ones. The bar is set high for next years experience. Already looking forward!

Download presentations from #OGhTech17 from https://www.nloug.nl/handouts.aspx – only a few slidedecks available, more to follow soon.

See you all next year.

Originally written for LinkedIn

nl.OUG Tech Experience 15 June 2017

Today the first day of the nl-OUG Tech Experience took place in ‘De Rijtuigenloods’. De Dutch Oracle User Group has prepared an interesting and varied program with different speakers from various countries covering almost the complete Oracle RedStack.

 

But first Chairman Robin Buitenhuis kicked of the #OGhTech17 and announced the name change of the OGh. From now on it will be nl.OUG!

Sesame Street SQL

After Robin’s introduction, Maria Colgan from Oracle took the stand. She covered the struggle between developers & dba’s while developing applications. With the (new) Oracle 12c database there is less reason to argue. Here presentation covered subjects like JSON, REST and Docker. In the end Maria could conclude that the Oracle 12c database is the ‘Universal Peace Maker’. Check some more here, to get an impression about some of things Maria showed.

Maria must have had the best term of the day by using; ‘Sesame Street SQL’ which refers to some easy lines of SQL code.

The Experience continued with the different parallel sessions. As one of the SIG-Leads of the OGh I had the privilege to be part of the BIWA-track (Business Analytics & Data Integration). Today there were five different parallel tracks.

“Is Oracle the best Language for Statistics.” – Brendan Tierney

Oracle comes with over 300+ statistical functions. These statistical functions are available in all version of the Database. When people are performing statistical analytics it’s always about Excel and R. When doing statistical analysis in the database, there is no need to extract any data onto client machines. It would also eliminate the possible data security issues with using Excel, R or any other tools.

“OBIEE DevOps with Containers: How and Why?” – Gianni Ceresa

Business Analytics development processes should be flexible and agile. Oracle BI is not that flexible and agile by default. A DevOps strategy can be implemented with the help of Docker containers, version control software (e.g. Git) and continuous integration (GitLab) tooling.

“Running R in your Oracle Database using Oracle R Entreprise” – Brendan Tierney

After Brendan’s first presentation one could think there is no need using R. One can do it all with Oracle Database statistical functions. In this presentation we got an introduction into Oracle R Enterprise. Combining the power of R with the in-database Data Mining / Advanced Analytics capabilities.

“Data Modeling, BI Modeling and-or Data Blending & Wrangling. What should I do?” – Hasso Schaap

In Analytics it’s all about data. There are various ways to use this data. If you choose to use it directly you can just blend and wrangle the data in your self-service tool. In some cases it might be better to prepare, govern and secure the data. There will be a need to model the data, either upfront (Conceptual, Logical and Physical) or in the Business Analytics Tool.

“EDQ, OGG and ODI over Exadata in the Cloud for Perfection” – Gurcan Orhan

The BIWA track concluded this day with a taste of pizza as a metaphor of the various Oracle Data Integration tools (EDQ – Enterprise Data Quality, OGG – Oracle Golden Gate and ODI – Oracle Data Integrator) assembled on the Oracle Exadata Machine. Hardware and Software integrated together both On-Premise as well as in the Cloud.

All in all a very interesting day and (hopefully) a start of a new tradition in Oracle Redstack knowledge exchange in the Netherlands.

Originally written for LinkedIn.

BIWA sessions OGh Tech Experience 2017

Thursday 15 juni

10:20 – 11:05
Brendan Tierney
Is Oracle the best Language for Statistics.

11:30 – 12:15
Gianni Ceresa
OBIEE DevOps with Containers: How and Why?

13:30 – 14:15
Brendan Tierney
Running R in your Oracle Database using Oracle R Entreprise

14:30 – 15:15
Hasso Schaap 
Data Modeling, BI Modeling and-or Data Blending & Wrangling. What should I do?

16:00 – 16:45
Gurcan Orhan
EDQ, OGG and ODI over Exadata in the Cloud for Perfection

Friday 16 juni

10:15 – 11:00
Gurcan Orhan
Migration steps from OWB to ODI

11:15 – 12:00
Marco Klaassens & Daan Bakboord
Introduction in Big Data Cloud Service and Use case

13:30 – 14:15
Christian Berg
A Day in the Life of an Oracle Analytics Query

14:30 – 15:15
Hasso Schaap
Collaboration on analystics in the Oracle Business Intelligence and Data Visualization Cloud Service

Tech Experience 2017 – An inspiring source of Oracle knowledge

On June 15th & 16th the Dutch Oracle Usergroup will organise its first “Tech Experience”, a full stack Oracle Technology Conference, covering everything from EngSys and DBA to Development and BI.

English version below

OGh_logo_op_witOp 15 en 16 juni organiseert de OGh haar eerste “Tech Experience”, een tweedaags event dat de complete Oracle Technology Stack zal bedienen: van EngSys en DBA tot Development en BI. Heeft u uw toegangspas al bemachtigd?

Keynote sprekers zijn Maria Colgan (Oracle), Duncan Mills (Oracle) en Lucas Jellema (AMIS). Met meer dan 50 sprekers, waaronder Tim Hall, Christian Berg, Chris Saxon, Toon Koppelaars, Geertjan Wielenga, Grant Ronald, Ralf Muller, Frank Nimphius en Steven Davelaar verdeeld over 9 parallel sessies, kijken we uit naar een veelbelovend en leerzaam programma!

De verschillende tracks waar u aan deel kunt nemen zijn:

  • DBA
  • PL/SQL & SQL
  • BIWA
  • Web & Mobile
  • Integration & Process
  • Cloud Application Foundation (CAF)
  • EngSys
  • WebCenter

Voor het complete overzicht van alle presentaties kijkt u in het programma.

Het congres vindt plaats in de “Rijtuigenloods”, een industriële locatie vanwege haar voormalige functie waar treinwagons hersteld en geschilderd werden. De Rijtuigenloods is gevestigd in Amersfoort, direct naast het centraal station. U kunt ook gewoon met de auto komen want de Rijtuigenloods biedt meer dan genoeg gratis parkeerplekken.

De toegangspas geeft u twee dagen toegang tot het congres, bovendien hebben we op donderdag een onderhoudend avondprogramma voor u samengesteld waar u op de foodmarket van gerechten uit verschillende windstreken kunt genieten.

Inschrijven

Hotel boeken?

Tech Experience 2017 wordt mede mogelijk gemaakt door: AMIS, diamond sponsor / Conspect ICT, gold sponsor / Qualogy Consultancy, gold sponsor / SynTouch, gold sponsor / Simtech Consulting, gold sponsor / Transfer Solutions, silver sponsor / Quistor Enterprises B.V., silver sponsor / Darwin-it Professionals, bronze sponsor


On June 15th & 16th the Dutch Oracle Usergroup will organise its first “Tech Experience”, a full stack Oracle Technology Conference, covering everything from EngSys and DBA to Development and BI. Do you already have your ticket?

Keynote speakers are Maria Colgan (Oracle), Duncan Mills (Oracle) and Lucas Jellema (AMIS). With more than 50 speakers, among whom Tim Hall, Christian Berg, Chris Saxon, Toon Koppelaars, Geertjan Wielenga, Grant Ronald, Ralf Muller, Frank Nimphius and Steven Davelaar covering 9 parallel tracks we are looking forward to a very promising and educational program.

The different tracks you can participate in are in example:

  • DBA
  • PL/SQL & SQL
  • BIWA
  • Web & Mobile
  • Integration & Process
  • Cloud Application Foundation (CAF)
  • EngSys
  • WebCenter

Please consult the program for an overview of all presentations.

The conference will take place in the “Rijtuigenloods”, an industrial looking place because of its former use for railcars to be restored and painted. The Rijtuigenloods is located in Amersfoort, next to the central station, however it offers enough free parking places as well.

The entrance ticket will give you access to the two-day conference and the evening program on Thursday where you can enjoy a food market with meals from different places in the world.

Register

Looking for a hotel?

Tech Experience 2017 is sponsored by:

AMIS, diamond sponsor / Conspect ICT, gold sponsor / Qualogy Consultancy, gold sponsor / SynTouch, gold sponsor / Simtech Consulting, gold sponsor / Transfer Solutions, silver sponsor / Quistor Enterprises B.V., silver sponsor / Darwin-it Professionals, bronze sponsor

What is a figure without any context?

We are currently living in the information age. Several devices, (mobile) applications and computer programs are generating and collecting lots of data. A lot of decisions are made based on a “gut feeling“. In a lot of cases, this will not be any problem. If you cannot trust your gut, who or what can you trust? Still, I think that your gut is based on several years of experience. Why not use data to validate your gut? It will improve your decision-making process. You do not only have your gut, which might be difficult to understand for others, but you have the figures to prove it. Sounds easy, right? Just report some figures and you are done. The real added value to the decision-making process comes when you are able to really understand the data.

Lately, we have seen several examples of not being able to put data into the right context. The public was absolutely sure that Brexit was not going to happen. Who would have thought that Trump would be the next US President? A lot of data about these matters has been collected. Still, it was not possible to predict the outcome. Some important questions can be asked. How was the complete data set constructed? Was the data set representative for the total population involved?

“A picture says more than a thousand words“. This sounds like a true statement. Our brains are better suited to process images than they are able to make sense of a table of figures. But what does a certain visual tell you? What does it exactly mean if we see a decrease in sales for the year 2016? It is not enough to make decisions solely based on the output of a chart. It is the story behind the chart that counts. If we had known the weather was bad in June 2016, we might have been able to explain the drop in ice cream sales in that same month. Being able to visualize the data is one thing. Applying context to the visual is key to make the right decisions.

“Drive change by converting Data into Insight”

If we want to stay ahead of our competition, we need to do things differently. This means the organisation has to change, as in doing things differently and better. Better than last time and better than the competition. Change can be driven by converting data into insight. This whole process consists of a few different steps. First, you have to capture the data. Think about data sources already present within the organisation. Sometimes, it can be valuable to add additional data sources. It might be good to add data about the weather to predict or clarify ice cream sales for a certain period. After the data is captured it needs to be processed. Different data sources need to be combined and some attributes and / or measures might need some additional formatting. If the data sets are ready to be presented, it’s time to think about the best way to visualize data. Not all visualizations are equally suitable to present figures. It makes no sense to present time series in a pie chart. Also the choice of colors can have a huge impact on the interpretation of a visual.

Traditional BI is really focused on answering known questions. How were sales in 2016? Who achieved the highest revenue in 2016? These questions can be modeled upfront in a BI system. The answers to these questions can lead to new questions: why were sales so low in the month of June in 2016? These questions may require new data sources. These data sources can be combined with existing (modeled) data sources. A combination of data sources might yield different insights. This is the process of data discovery. Adding data about the weather or adding information about visitors to a city or a store can give valuable additional information. This additional information adds more value and makes the insights more complete. It gives the possibility to identify interesting patterns, opportunities and previously unknown trends.

Eventually the insights can be shared among other people like your colleagues. A story can be told based on the different insights as a result of the data discovery.

 

“See the Signals”

The Oracle Business Analytics philosophy is to support both traditional BI as well as data discovery. Traditional BI is a process, which is supported by IT. In a traditional BI environment, the IT department guarantees the validity and availability of the data. This data can be traced all the way back from the presentation to the source. Although one can really trust on this data, these environments are not as flexible as the business would like them to be. Sometimes, the business wants to play around with some other data. They want to explore data, which is not yet modeled and governed by the IT department. This data discovery needs to be a self-service process. Waiting for an IT department is not an option. The business wants to be able to visualize their data when they need it.

Oracle’s answer to self-service BI is Oracle Data Visualization (DV). Oracle DV offers the opportunity to add different data sources. With some lightweight ETL capabilities, Oracle DV is able to support the combination of different data sources and the manipulations of the different columns within these data sources. Like the name of the tool tells us, Oracle Data Visualization is a tool to visualize various sources of data in an easy way. This means that complex data sets can be turned into easy to digest and supporting insights. These insights can be shared in separate visual, which allows you to both visualize the data as well as telling the story behind the data.

Oracle Data Visualization is available both on-premise as well as in the Cloud. Moreover, Oracle DV is available as part of a platform (OBIEE and / or BICS) and stand-alone (Oracle DVCS). If you have acquired a license for Oracle DVD, you are allowed to use the Oracle Data Visualization Desktop (DVD) tool. Oracle DVD cannot be licensed separately. It comes with an Oracle DV license. Using Oracle DV allows you to “See the Signals” on any device. Desktop, tablet or browser, it does not matter.

Oracle DV uses the same platform whether you use it in the Cloud or on-premise. This means that you can start very small. If you start with an Oracle Data Visualization Cloud Service, you can start with a subscription of 5 users for as little as $75 per user per month. If Oracle DVCS proves its value, you can easily choose to move to e.g. the Oracle BI Cloud Service (BICS) without the need to start all over.

The Quistor Business Analytics and Big Data practice is specialized in the Oracle Business Analytics offer. If we need to put the offer into more context, we are happy to help you out. Although Oracle Data Visualization is designed to be easily executed by the business, you might need some help to get started. Again, we are happy to put you on the right track.

Please get in contact with me, so we can start telling the story behind your figures.

This article was originally written for the 4th edition of the Quistor QPulse.

The Quistor Business Analytics & Big Data Practice is expanding

Working at Quistor

 

We are expanding our Quistor Business Analytics & Big Data Practice. Therefore we are looking for new colleagues. Please find the vacancies for a Senior Oracle Business Analytics Consultant and a Senior Oracle Data Integrator Consultant below.

Please get into contact with me or send a mail to jobs@quistor.com. If you are not interested yourself, but know someone who might be, I would really appreciate it if you would let me know.

Thanks in advance.

Daan Bakboord

Managing Consultant Quistor Business Analytics & Big Data. Managing and developing the Oracle Business Analytics Practice in the Netherlands. Because of the DNA of Quistor I have a strong focus on Oracle Business Analytics (OBIEE, BICS &OBIA) and Oracle JDEdwards. Next to that I have strong interest in (the Architecture of) Business Analytics and Data Warehousing in general (TOGAF, ArchiMate and CBIP) and Oracle Business Analytics Architectures in specific.