Presidents of USA and their Birth Signs – Sankey Visualization

In this analysis, we will visualize the relation between the Age at Presidency, State of Birth and birth sign. Read more at:

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 … Read more

Q&A: How to find current Inventory Quantity?

Question: How to find the current quantity in Oracle Inventory. What is the table and column details? The short answer is, you can get the current inventory balance by querying the mtl_onhand_quantities view. To get the current balance you would have to write a query like select sum(transaction_quantity) from mtl_onhand_quantities where inventory_item_id=1234 and organization_id=201 Why do we need to do a … Read more

How to find a column in database

Once, at a client site I was asked to do a drill through report from Purchasing to Fixed Assets. I don’t remember the exact details but it had something to do with Purchase orders. I knew little bit about Oracle Purchasing but had not worked enough on Fixed Assets. So I thought maybe I should … Read more