Monday, November 21, 2011

Top 10 BI Predictions for 2012

Top 10 BI predictions for 2010 by Forrester Research.

Top 10 BI Predictions for 2012

Tuesday, November 15, 2011

Introduction to Hbase Video from Cloudera!

I listened to this video link posted in Cloudera - Big Data distribution company. It gives fairly vague idea about Hbase.

Since HDFS has the drawback of sequential access, Hbase is built to overcome this drawback and to make use of random access along with HDFS. Hbase is a combination of HDFS and Random access technology together.

Please find the link for the video here:
Introduction to HBase - Todd Lipcon (Cloudera)

Monday, November 7, 2011

Source system Analysis - SAP

This is the first data warehouse, I am working which has SAP as its source system. I don't have much knowledge on SAP process flow, tables etc. Have seen couple of screens where users query for some details. Last week for one of the data issues, I was searching online for the "Billing Document" flow. Initially assumed that all Billing documents are Invoices, later the below comments in the SAP discussion clarified the point.

1) What is the difference between billing document and invoice?

Billing document is a general term that includes - sales invoice, debit memo, credit memo and cancellation documents. In layman's term, invoice usually refers to the sales invoice, or what you send to your customer as your company's bill or charges. So, all billing documents are not invoices..But all invoices are billing documents . Usually, Invoice is document indicating to delivery goods and Billing is a receipt of payment

Tables are VBRK & VBRP. For flow, go to transaction VF03, enter document number and hit 'Display Document Flow' button on toolbar VBRK and VBRP holds billing/invoice details.


Also I found that SHKZG field is called return/cancellation flag. When this flag is set, It means that invoiced item is returned to its manufacturer. There are 2 ways of Invoice cancellation, 1) by issuing a Invoice cancellation billing document 2) by setting this return flag set along with Credit memo Billing document.

If I found more, Will post in my next blog.

Happy Learning!

Sunday, November 6, 2011

The Data Quality Chronicle – Big Data … Little Data Quality

The Data Quality Chronicle – Big Data … Little Data Quality

Fooled by "Ungroup by" Clause

Recently I have become active again in spending time online to improve my career and of course to write more blog posts and comments about the things I read online.

I came across this blog and was reading with interest till the end with full concentration. :D

Strated thinking during the halfway of reading this post, how this new "ungroup by" clause is possible. How the query mentioned by the author breaks the results by Year, since it was not specified.

At the end of the post, I came to know that it is April fool post.

"Like for Ungroup by"

Tuesday, October 18, 2011

MSTR Personal BI

Now in this competitive BI market, BI Vendors are rapidly adapting/supporting latest BI technology trends such BI in Cloud, Social BI and Mobile BI etc. For last few months, I am watching the BI market space just out of curiousity for new product releases, M&As, MoU etc from BI vendors. Quick response and transformation of MSTR to support these latest technologies catches my eye and providing MSTR service as part of Informatica cloud is good strartegic move.

Recently I heard about this free personal BI service from MSTR from one of my colleagues. You can get more details from the below link.

“MicroStrategy Announces Cloud Personal, a Free SaaS-based Business Intelligence Service”

Out of curiosity, I have created this peronal dashboard report, analyzing my personal spending for last 3 months. [;)]



Also I have submitted my dashboard for the dashboard competition conducted by MSTR, wish me luck.. [:)]

Meet you all in my next blog. Happy Learning!

Here is the tweet from Microstrategy.
"It's easy to gain insight in 60 seconds with MicroStrategy Cloud Personal. Watch our new video and send us your own: link"

Monday, January 19, 2009

AR - Net Payment Terms with the Customer - Know How

Hi,
I have lately exploring some of the business meanings of the report we are creating for our customers. While loading and reporting i have noticed the column called Payment Terms which will contain values such as NET15, NET30, and NET60 etc. I know this is some kind of terms which an organization have with the Customer. But i dont know it is related to the Account Receivables. Please find the explanation on the articles i come across.
"An example of a common payment term is Net 30, meaning payment is due in the amount of the invoice 30 days from the date of invoice. Other common payment terms include Net 45 and Net 60 but could in reality be for any time period agreed upon by the vendor and the customer."
I have Payment Term with my Customer as well as my vendors. Payment term with the Vendor will be applicable for the Account Payables whereas the Payment Term with the Customer is to Account Receivables.
Cheers!
Soma