Monday, 30 November 2015

Two Year - A Big Thanks to all my readers



Wow…it’s been near 2 year since I have authoring biwithui.blogspot.in .I would love to thank each and every one who have read/like/dislike/comments on  my blogs.

Contributing of open source community has been an area of interest since 2012 when I have started my carrier in this field. I really love to share my knowledge and experience through this blog whatever I have learned so far... I love BI creative works and design. I would never feel complete, with one of them missing. Pentaho comes my first choice and interesting tool to explore. One of the main reasons to work on Pentaho it’s easy to implement with third party application. Over a year, I have been actively involved in solving problems /issues question to all Pentaho developer .I will continue to post some more new exciting stuff in coming days.

But in order to contribute more I would love to get suggestion from you guys...Please share yours ideas, thoughts and particular area which you want to explore.

If you have any particular suggestions feel free to drop me mail:

you also share your ideas on my blog as well as. 

Cheers !!!

Thursday, 24 September 2015

Splitting Single Row into Multiple Rows Using ETL



Hi Guys ,

Here I have seen this is common scenario where we need to split the single rows into multiple rows as per their need.
So,I want to explain how to split the single row into multiple rows as mention below scenario:

For example:

Input:
ID
Col1
Col2
Col3
Col4
1001
Abc
Cde
12
34

Out Put:
ID
Col1
Col2
1001
Abc
12
1001
Cde
34

The above scenario you can achieved with the help of Row Normaliser step in ETL.

It’s very easy to use.

Etl design:
 Row Normaliser:


 OutPut:





If you have any question you can ask me or else you can drop me email :
 
Sumit Bansal
BI Developer


Tuesday, 11 August 2015

Pentaho CDE Dashboard using MongoDb (No Sql database)




Hey Guys, 

Here I would like to explain how to use mongodb as data source for creating interactive visualization dashboard using c-tools.

There is no direct way to use Mongo DB in CDE dashboard one and only one and easy approach will use ‘Kettle Query’ option in the Pentaho code to get the required result set for visualization.

Let's assume you have a collection called ‘Test’.

ETL Design:

Below mention screen shot is the ETL design that i’m using to get my required result set.


Creating Dashboard:

Steps :
 
Prepare the layout as per your requirement.

Used the dashboard component as your requirement .Here I’m using pie chart for creating the dashboard.

In Data sources section take “KETTLE Queries”. (Upload the ktr file to your dashboard folder using the Pentaho User Console).

In “Kettle Tran formation file” property locates the uploaded ktr file. (for eg: sample. ktr).

Give the step name which is giving the required result (for example: Sample).

Provide the required data source name under pie chart .

Save the dashboard and Preview it you will see the required output.

OutPut:


Cheers !!! Have Fun


If you have any question you can ask me or else you can drop me email :
 
Sumit Bansal
BI Developer