What is the most dangerous food at Olive Garden?

Olive Garden is one of the favorite destination for Italian food and today we got hold of the entire Olive Garden menu along with their nutrition data.

A typical meal at Olive Garden starts with a drink, appetizers [free bread sticks], main dish and finally the desert.

So going in the same sequence let see what the data menu for Wine and Beer has to offer.

Amount of Carbs per serving in your favorite Wine (more...)

Toggling the database in OBIEE 11g at runtime

We have a replication and the primary database server. Replicating the data takes some time so the replication server is usually a few mins behind the primary server. The requirement for one of the report was to get the data from the primary server if the replication is lagging by over 1 min. This blog talks about a method to implement this business use case.

In my project, we have a table that tells us (more...)

Oracle VM file sharing with Windows host

This article talks about the process to share files between Oracle VM and windows host.


Open the VM and navigate to System -> Preferences -> Personal File Sharing as shown below.


















Check the Share public files on network check box as shown below.



















Open the Network as shown below.



















Navigate to the following path
(more...)

List of acquisitions by Microsoft a data journey

If we look into the SEC data for Microsoft and other tech companies, Microsoft spends the most in Research and Development from [by dollar]

Image

Read more at: http://www.infocaptor.com/dashboard/list-of-acquisitions-by-microsoft-a-data-journey

Enabling Autotrace in SQL Developer

This is mainly a note to myself to save me from looking up the details very time I need it. I can just go to my own post.

To use Autotrace in SQL you need to grant the schema the PLUSTRACE role.

But in SQL Developer you need the PLUSTRACE role that has a few additional privileges.

Connect to SYS as sysdba and run the following.


grant select on v_$session to plustrace;
grant select on (more...)

Popularity of Tea, Coffee, Beer and Wine Visualization

If number of searches were an indicator for gauging the popularity of a drink between Tea, Coffee, Beer and Wine then who wins the contest?

Which drink is gaining popularity and which is losing?

Read more at: http://www.infocaptor.com/dashboard/popularity-of-tea-coffee-beer-and-wine-visualization

Map Reduce: File compression and Processing cost

| Aug 18, 2015

Recently while working with a customer we ran into an interesting situation concerning file compression and processing time. For a system like Hadoop, file compression has been always a good way to save on space, especially when Hadoop replicates the data multiple times.

All Hadoop compression algorithms exhibit a space/time trade-off: faster compression and decompression speeds usually come at the expense of space savings.  For more details about how compression is used, see https://documentation.altiscale. (more...)

Managing ORE in-database Data Stores using SQL

When working with ORE you will end up creating a number of different data stores in the database. Also as your data science team increases the number of data stores can grow to a very large number.

When you install Oracle R Enterprise you will get a number of views that are made available to ORE users to see what ORE Data stores they have and what objects exist in them. All using SQL.

Perhaps (more...)

Cloudera certifies InfoCaptor for Big Data analytics on Hadoop

Cloudera welcomes InfoCaptor as a certified partner for data analytics and visualization. InfoCaptor delivers self-service BI and analytics to data analysts and business users in enterprise organizations, enabling more users to mine and search for data that uncovers valuable business insights and maximizes value from an enterprise data hub

Rudrasoft, the software company that specializes in data analytics dashboard solutions, announced today that it has released an updated version of its popular InfoCaptor software, which (more...)

Reddit 10 year growth analysis and visualization

In this article we will analyze the 10 year growth history of Reddit using simple visualizations.

Read more http://www.infocaptor.com/dashboard/reddit-10-year-growth-analysis-and-visualization

Marriage and Divorce Rates Analysis Dashboard CDC Data set

Marriage rates by Census region

Read more at: www.infocaptor.com/dashboard/marriage-and-divorce-rates-analysis-dashboard-cdc-data-set

Discoverer and Windows 10

Hi everyone
Has anyone had the courage to upgrade to Windows 10 and see if Discoverer Plus still works?

How about the Discoverer server? Anyone tried that.

If you have drop me a reply

Michael

Check out What Sauron is saying about Oracle

Over past year we have been (hopefully) hearing about Oracle Big Data SQL.

This is a new(-ish) option from Oracle that allows us to run our SQL queries not just on the data in our Oracle Database but also against NoSQL databases and Hadoop. No extra coding is needed, no extra formatting is needed, etc.

All the hard work in connecting to the data in this systems, translating it into executable code on these systems, (more...)

Charting Number of R Packages over time (Part 3)

This is the third and final blog post on analysing the number of new R packages that have been submitted over time.

Check out the previous blog posts:

  • Blog Post 1 : Getting, some basic analysis and graph
  • Blog Post 2 : Aggregating the data and create a number of more useful graphs.

In this blog post I will show you how you can perform Forecasting on our data to make some predictions on the (more...)

NFL Play by play analysis using Cloudera Impala

Who won the most games against which losing team?

 

Read More at: www.infocaptor.com/dashboard/nfl-play-by-play-analysis-using-cloudera-impala

Extracting Data from BICS / Apex via RESTful Webservice

A few days ago, I read the following post; Extracting Data from BICS / Apex via RESTful Webservice on the Oracle A-Team Chronicles website. I tried the example to see how things work. Cocoa Rest Client In the blogpost is referred to cURL to test the REST-endpoints. I have been testing this out on a Mac and…Read more Extracting Data from BICS / Apex via RESTful Webservice

Oracle BI Cloud Service (BICS) – Planned Upgrade for 10-July-2015

As from the 10th of July the Oracle BI Cloud Service environment will be upgraded. Looking forward to the new features and enhancements to the Oracle BI Cloud Service. Find below a list of things we can expect. Fresh new look to Oracle BI Cloud Service Improved design that’s simple to navigate and easy to…Read more Oracle BI Cloud Service (BICS) – Planned Upgrade for 10-July-2015

Flipkart, ecommerce, machine learning, and free advice

I wrote about the obsession of Flipkart (and Myntra) with "mobile-only" without even having an iPad-optimized app! I also talked about the stunning advances being made in voice-search by using machine learning, cognitive learning, natural language processing, even as voice-based search capabilities of e-commerce companies - including Amazon - remain abysmal. Finally, I also included several use-cases that these companies need to work on incorporating into their capabilities.

That piece, Flipkart, Focus and Free Advice (more...)

Next Generation Outline Extractor 2.0.4.887 Released

We recently released an updated version of the Next Generation Outline Extractor. This new version, 2.0.4.887, addresses three issues:


  • Fixed an issue where the username and password passed via the command line were improperly logged
  • Fixed an issue reading MaxL XML data sources when the alias or UDA contained xml encoded characters such as the ampersand (&) character.
  • Updated labels on the Input Source tab of the user interface to clarify their (more...)

Using Internet Explorer to customize OBIEE 11g UI

We recently had a requirement that the button sizes in OBIEE had to be increased. The reasoning was that the users of some of these reports are old and they hate smaller sized buttons. Now we know the properties of buttons such as the size are set in the css files which together form (more...)