Exploring Oracle Business Analytics

In the blogpost about “Gathering new Knowledge” I decided to investigate a few different areas of the Oracle atmosphere. Oracle Business Analytics was one of them. In a series of different blogposts I will cover different parts of the Oracle Business Analytics  product suite. At the end of this post there will be a list of different links to the blogposts I will be sharing.

I will begin with a post I created earlier. This is because of the importance of the subject. One crucial element in Oracle Analytics is the Oracle BI Server. Thanks to Christian Berg, we were able to go to the Core of Oracle Analytics.

Last month Oracle released a new version of Oracle Data Visualization V3.0. In this upgraded version you can expect some new functionality regarding:

  • connections to data sources & data preparation,
  • enhanced data flow
  • intuitive data visualization process setup & formatting
  • comprehensive system management toolset

When the posts are ready, I will post the links below. I hope you will find my findings interesting. Please share your comments.

This post is written as part of my Gathering new Knowledge series.

Thanks for reading.

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.

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.

Separate the Signals from the Noise

Earlier this year I wrote two blogposts about the publication of Gartner’s Magic Quadrant for Business Intelligence and Analytic Platforms.

Without choosing sides between Gartner or Oracle, it is clear that the landscape of analytics (and the tools and techniques to support analytics) is changing.

Today I viewed a webcast where both Rita Sallam (Research Vice President Business Analytics and Data Sciences @ Gartner) and Rich Clayton (Vice President Business Analytics @ Oracle) express their views on:

  • The current and future state of the BI/Analytics market
  • Oracle’s answer to the evolution of this market
  • Some of the types of Analytics use cases
  • How to see the signals in your data and discover the answers

Find the link to the webcast below:

The Industry Experts’ Guide to the Changing Landscape of Analytics

Quistor believes in Oracle’s strategy when it comes to Business Intelligence and Analytics. If necessary or desired, we would be happy to put things in context.

Daan Bakboord

This article is originally written for LinkedIn.

Oracle Business Analytics from a different angle

Gartner’s latest version of the Magic Quadrant for Business Intelligence and Analytics Platforms (#BIAMQ) caused a lot of noise in the Analytics Market. Gartner and Oracle have different views of this market. Gartner sees a difference; “…between a modern BI and Analytics Platform and a traditional, IT-centric Reporting and Analysis Platform”.

It’s clear that Oracle and Gartner have a different view on the Analytics Market. Is it Agile BI and / or Enterprise Reporting? There are probably several pros and cons for either view. In the end I don’t believe it’s a matter of right or wrong. Although Oracle is not included in Gartner’s Magic Quadrant, that does not mean that Oracle does not have a strategy when it comes to Business Analytics. It’s important that you see and understand the context of a certain view. I will try to give some more insights into Oracle’s Business Analytics Strategy.

Oracle Business Analytics Strategy

If an organization wants to stay ahead of the competition, it should focus on innovation. The Oracle Business Analytics Strategy supports this drive towards innovation with the Oracle Business Analytics Portfolio. This Portfolio consists of the following elements:

  • Operational Reporting (Monitoring)
  • Strategic Analytics (Optimization)
  • Visual Discovery (Innovation)

Operational Reporting (Monitoring) 

Although there is more and more focus on innovating an organization’s business, people still need (real-time) operational information to support their daily work. Employees use operational reports to solve problems or to monitor their daily operations.

Operational Reporting represents the current state of the different areas of the organization.

 

Strategic Analytics (Optimization)

Operational Reporting is specific per Line of Business. Business Leaders tend to look across the different Lines of Business. Strategic Analytics focuses on metrics that deliver insight. Questions like; ‘Why did it happen?‘ and ‘What will going to happen?‘ need to be answered.

Strategic Analytics represents the state of an organization as a whole.

Visual Discovery (Innovation)

The first two elements of the Oracle Business Analytics Portfolio are considered traditional forms of BI. Over the last years organizations have developed a need to explore various data sets without IT support. Organizations use visual data discovery tools to identify patterns and opportunities for innovation. These visual data discovery tools focus on ease of use and the ability to visualize different (complex) data sets.

Visual Discovery helps organizations answer questions like; ‚Should we invest in new sales channels?‘ or ‚Has a discount a positive effect on our revenue?‘.

To summarize, the Oracle Analytics Portfolio supports the drive towards innovation across the entire organization for all users and all analytic needs. According to Oracle, organizations need a bi-modal Business Analytics Strategy. This strategy is designed for IT-led (consistancy & scalability) and Business-led (speed & discovery) analytics initiatives.

 

Hybrid Cloud

Traditional BI platforms are characterized by IT-controlled reports and analysis on desktop dashboards. New BI platforms must be able to support the visualization of different (personal) data sets on mobile and wearables in the cloud or in a hybrid environment.

Oracle wants to extend existing investments in on-premise architectures with innovations in the cloud. Therefore the Oracle Analytics Portfolio can be deployed anywhere on-premise as well as in the cloud or in any hybrid form. It does not matter which deployment option is chosen, it’s the same architecture, the same standard and the same product.

Oracle’s Business Analytics Strategy aims at supporting IT-led buying as well as buying driven by the business. Next to that Oracle’s Business Analytics portfolio can be deployed on-premise as well as in the cloud. When it comes to; ‚buying driven by the business‘, Oracle offers Stand alone products as well as products integrated in the platform.The Oracle Business Analytics offering consists of the following products:

  • Data Visualization On-Premise
  • Data Visualization Cloud Service (DVCS)
  • Oracle BI Cloud Service (BICS)
    • Including Data Visualization
  • Oracle BI 12c
    • Data Visualization (add-on)

Oracle Data Visualization

With Oracle Data Visualization users can; ‚See the Signals‘. Oracle offers Visual Analytics in every solution, on every device, embedded in the cloud or integrated in the platform and even in the Big Data stack. Oracle Data Visualization enables users to create rich visuals of any data set in an intuitive way. Users can bring in different types of data sets to blend data together. Visualizations can be shared with others. Oracle Data Visualization supports; ‚Storytelling‘. This way users can help others see the same patterns and opportunities. Last but not least, Oracle Data Visualization is fully portable between any (mobile) device.

Oracle Data Visualization is simple but powerful. It is designed to support (small) departmental initiatives which should be performed without IT support. Oracle Visual Analytics projects can be started small, but can grow if necessary.

An organization can start with a subscription to the Data Visualization Cloud Service (DVCS) at a price of $150 per named user per month with a minimum of 5 users.

Sign up for a trial subscription to the Oracle Data Visualization Cloud Service here.

Oracle BI Cloud Service

The Oracle BI Cloud Service (BICS) is a complete Cloud Solution for Enterprise BI. With BICS it’s possible to combine any data from any data source. Via dozens of visualizations and calculations users can gain unique insights. BICS runs in the Oracle Cloud. The environment is fully managed, patched, backed up and upgraded by Oracle. This means that organizations running BICS can reduce significantly on operations, software, hardware and facilities.

Visual Analytics can be embedded into an Enterprise solution and that’s what makes Oracle unique. BICS makes it possible to integrate (blend) personal and enterprise data. Finally, BI applications are portable between on-premise and the cloud.

Sign up for a trial subscription to the Oracle Business Intelligence Cloud Service here.

Oracle Business Intelligence 12c

OBI 12c is one integrated platform which runs on-premise. Oracle Data Visualization can be embedded as a paid add-on. Oracle Business Intelligence 12c has a modern interface design. The new Alta UI, which is used across all Oracle’s applications, has a clean page design and is focussed on the data. One of the key new features in OBI 12c are the Advanced Analytics capabilities. This way a user can instantly answer predictive and statistical questions via a free distribution of R. Next to that Oracle made improvements to the mobile experience and the in-memory performance. Last but certainly not least, Oracle has made the OBI 12c a lot simpler. This means that Oracle has simplified the installation and configuration. This makes upgrading from 11g to 12c a lot less difficult than the upgrade from 10g to 11g. Also Regression Testing is made easy with the Baseline Validation Tool.

Oracle Business Intelligence 12c is an Enterprise Analytics Platform. It is Business Leader friendly as well as IT-friendly. OBI 12c allows users to upload their personal data and combine the results with IT-curated data for quick analysis and data visualization.

 

Summary

The Oracle Business Analytics Strategy is based on three pillars:

  • See the Signals
    • Visual Analytics in every solution
  • Sprint to Innovation
    • Cloud First strategy
  • Scale the Insights
    • One integrated platform

Quistor believes in Oracle’s strategy when it comes to Business Intelligence and Analytics. If necessary or desired, we would be happy to put things in context.

Daan Bakboord

This article is originally written for Quistor’s QPulse.