First Steps with Oracle Analytics Cloud

Preface

Not a long ago Oracle added a new offer to their Cloud - an OBIEE in a Cloud with full access. Francesco Tisiot made an overview of it and now it's time to go a bit deeper and see how you can poke it with a sharp stick by yourself. In this blog, I'll show how to get your own OAC instance as fast and easy as possible.

Before you start

The very first (more...)

Benefits and Use of Analytics for Insurance

The world in which we live is a volatile world, a fact that doesn’t bode well for the insurance industry whose greatest ally is “certainty”. Analytics, however, can somehow fill the gap. In this regard, BI reporting tools such as data visualization software are extremely useful.

Advanced analytics for insurance allows all stakeholders in the industry to identify new growth opportunities and risk factors as soon as they take shape. Insurance companies such as yours (more...)

ACE Alumni

Today, I asked Oracle to move me from Oracle ACE Director status to Oracle ACE Alumni status.  There are a number of reasons why I decided to change status.  When I started answering questions on internet forums years ago, I did it to share what I had learned in order to help others.  The same goes for this blog which I originally started so that I could give better and more complete answers to questions (more...)

Slides from the Ireland OUG Meetup May 2017

Here are some of the slides from our meetup on 11th May 2017.

The remaining slides will be added when they are available.

The Dark Cloud of the H1-B Fallout for Indian Companies: Layoffs or Reduced Valuations

India's second-largest IT company, Infosys, put out a press release on the 2nd of May, 2017 (link), that it would be hiring "10,000 American Workers Over the Next Two Years and establish four new Technology and Innovation Hubs across the country focusing on cutting-edge technology areas, including artificial intelligence, machine learning, user experience, emerging digital technologies, cloud, and big data."

OBIEE upgrades and Windows vulnerabilities

OBIEE upgrades and Windows vulnerabilities

OBIEE upgrades and Windows vulnerabilities

These two topics may seem unrelated; however, the ransomware attacks over the last few days provide us with a reminder of what people can do with known vulnerabilities in an operating system.

Organisations consider upgrades a necessary evil; they cost money, take up time and often have little tangible benefit or return on investment (ROI). In the case of upgrades between major version of software, for example, moving from OBIEE 10g to 12c there are (more...)

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. … Continue reading "BIWA sessions OGh Tech Experience 2017"

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.

List of Visualizations and Chart Engines

The internet is quickly filling up with wonderful visualizations and this is because of greater awareness that "Visuals are better than spreadsheets" for conveying the story.

This couldn't be possible without the innumerable Charting engines made available by the dedication of open source developers.

Checkout the wonderful and interesting list of charts and engines that were submitted to Hacker News

Read more at http://www.infocaptor.com/dashboard/big-list-of-visualizations-and-chart-engines

List of “Dashboard” Startups and Products

The idea of building a dashboard application has become synonymous to the idea of a developer thinking let us build a "To-do" application.

This is evident by the sheer amount of dashboard related applications that developers/founders have submitted to Hacker News over the past several years.

The dashboards range from wide spectrum, on one side to personal dashboards, project management dashboards, network dashboards to full blown social media dashboards.

If you are looking to build (more...)

Reporting and Dashboard Automation for Marketing

Marketing Reporting and Dashboard Automation

For anyone who works in the marketing sector, customer satisfaction and company progress are of utmost importance.

In the past, entrepreneurs lived by the adage “The customer is always right.” Even then, the satisfaction of customers was the gauge of company owners as to what products or services they would cater. But with technology automating almost every task today, these satisfaction indicators are further expounded and interpreted through analytics (more...)

A focus on Higher Education, HEDW 2017

First, before I get into a great week of Higher Education Data Warehousing and analytics discussions, I want to thank the HEDW board and their membership. They embraced us with open arms in our first year of conference sponsorship. Our longtime friend and HEDW board member, Phyllis Wykoff, from Miami University of Ohio even spent some time with us behind the booth!

HEDW was in the lovely desert scape of Tucson, AZ at the University (more...)

How to create Teradata Server Dashboard

Teradata delivers better business outcomes through technology-enabled solutions in the areas that matter most ? from operational excellence and asset optimization, to customer experience and product innovation, to finance transformation and risk mitigation. It works with leading businesses in over 75 countries worldwide including many of the top performers and best-known brands in telecom, transportation, consumer packaged goods, financial services and manufacturing.

Are you using Teradata Server for your data marts or data-warehouse? If so, build (more...)

How to make dashboard using PostgreSQL database

PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, macOS, Solaris, Tru64), and Windows.

Are you using PostgreSQL for your data marts or data-warehouse? If so, build your Free PostgreSQL performance dashboard software.

Read (more...)

How to create dashboard for MySQL database

MySQL is the most popular Open Source SQL database management system. Due to its reliability and easy-to-use structure, MySQL is widely used within almost any industry. It is used by both small and big businesses. Among MySQL users you can find such huge companies like Facebook, Youtube, Twitter,etc.

Using MySQL with InfoCaptor does not require any JDBC driver as it uses native PHP drivers. In case you need to use JDBC drivers, please check this (more...)

The Case for ETL in the Cloud – CAPEX vs OPEX

Recently Oracle announced a new cloud service for Oracle Data Integrator. Because I was helping our sales team by doing some estimates and statements of work, I was already thinking of costs, ROI, use cases, and the questions behind making a decision to move to the cloud. I want to explore what is the business case for using or switching to ODICS?

Oracle Data Integration Cloud Services

First, let me briefly talk about what is (more...)

OUG Ireland Meetup 11th May

The next OUG Ireland Meetup is happening on 11th May, in the Bank of Ireland Grand Canal Dock. This is a free event and is open to every one. You don't have to be a member to attend.

Following on from a very successful 2 day OUG Ireland Conference with over 250 attendees, we have organised our next meetup. This was mentioned during the opening session of the conference.

NewImage

We typically have 2 presentations (more...)

Setting up Oracle Database on Docker

A couple of days ago it was announced that several Oracle images were available on the Docker Store.

This is by far the easiest Oracle Database install I have every done !

You simply have no excuse now for not installing and using an Oracle Database. Just go and do it now!

The following steps outlines what I did you get an Oracle 12.1c Database.

1. Download and Install Docker

There isn't much to say (more...)

Breaking News! Dodeca Spreadsheet Management System Certified on Oracle Analytics Cloud!

Now that the Oracle Analytics Cloud, or "OAC", has been released, we had to get serious about our work with one of the Oracle Analytics Cloud components, the Essbase Cloud Service, or "EssCS" for short.  You would think that we should have been working hard on EssCS for quite some time, but we had been assured by Oracle product management that the Essbase Java API would be available in EssCS.  Of course, Dodeca was built (more...)

SQL-on-Hadoop: Impala vs Drill

SQL-on-Hadoop: Impala vs Drill

I recently wrote a blog post about Oracle's Analytic Views and how those can be used in order to provide a simple SQL interface to end users with data stored in a relational database. In today's post I'm expanding a little bit on my horizons by looking at how to effectively query data in Hadoop using SQL. The SQL-on-Hadoop interface is key for many organizations - it allows querying the Big Data world using existing (more...)