Getting started with Community Dashboard Editor in Pentaho|Example

Pentaho provides various tools to create custom dashboards to visualize the big data in the form of PI-charts, Bar chart, line charts, graphs and much more. It provides data integration with different data sources and extracts the analysis report from data sets.Getting started with Community Dashboard Editor in Pentaho, this tutorial explains complete steps to create following dashboard

Getting started with Community Dashboard Editor in Pentaho

Steps to create Pentaho Dashboard

  1. Select Create New option from below PUI screen 
    Getting started with Community Dashboard Editor in Pentaho

  2. Click on Create New -> CDE Dashboard, see in below screenshot 
    Getting started with Community Dashboard Editor in Pentaho

  3. Select a template for your dashboard.
  4. In the given Example, we are using “2 Columns Template” according to our requirement. As give in below structure
    pentaho7
    There is one header, footer and two Panels present in the Dashboard Panel_1 -> for the bar chart and dropdownPanel_2 -> for the Line chart

  5. Click on DataSource option from the panel. Click on SQL Queries -> SQL over sqljdbc, fill property values according to your database connection.
  6. In the given example we created the Data Source

Data Sources –

1. Inspection_data

Query –

SELECT
Center AS SERIES,
COUNT(CASE District_Decision WHEN ‘VAI’ THEN 1 ELSE NULL END) AS VAI,
COUNT(CASE District_Decision WHEN ‘OAI’ THEN 1 ELSE NULL END) AS OAI,
COUNT(CASE District_Decision WHEN ‘NAI’ THEN 1 ELSE NULL END) AS NAI
FROM
fda_inspection_data WHERE EXTRACT(YEAR FROM Inspection_End_date)=${year}
GROUP BY
SERIES, ‘Center’;

Set the Parameters for Inspection_data

pentaho8

2. Data Source – get_all_years

Query-

SELECT DISTINCT EXTRACT(YEAR FROM Inspection_End_date) AS YEAR FROM fda_inspection_data;


3. Data Source- F_and_D_query

Query-

SELECT DISTINCT EXTRACT(YEAR FROM Inspection_End_date) AS SERIES,
COUNT(CASE Country WHEN ‘US’ THEN 1 ELSE NULL END) AS Domestic,
COUNT(CASE Country WHEN ‘US’ THEN NULL ELSE 1 END) AS Foreign_Country
FROM fda_inspection_data WHERE EXTRACT(YEAR FROM Inspection_End_date)<=2016 GROUP BY SERIES;

Creating the Component in the Pentaho

  1. In components Tab, there is multiple types of chart and custom components. Here we are using chart -> CCC bar chart and CCC Line Chart.
  2. And for the Select dropdown, we are using Select ->Select Component.
  3. For creating parameter for select dropdown use generic->Simple Parameter
  4. For parameter properties name – year and value – 2008 (default) 
    Getting started with Community Dashboard Editor in Pentaho

  5. Set properties for select component 
    pentaho10

  6. Set the properties for bar chart 
    Getting started with Community Dashboard Editor in PentahoNote: To make create stacked bar chat, set the property stacked=true.

  7. Set the properties for Line chart 
    Getting started with Community Dashboard Editor in Pentaho-Set plot2DotsVisible – true to see dots on the lines.


  8. The HtmlObject name must be the name set in the Layouts names (column name, HTML name ).
  9. Click on view Icon to see Dashboard.

Please connect via comments or emails for more explanation and queries related to BI, we will happy to help you. www.ease2code.com

Comments

  1. This information is invaluable. When can I find out more?

  2. php script says:

    i’m sure all of you are actually impressive and since for beginners like me….i managed to get to the correct destination for a read about whatever wanted…

  3. Hey There. I found your blog using msn. This is a very well written article.
    I will make sure to bookmark it and come back to read more of your
    useful information. Thanks for the post. I’ll definitely comeback.

  4. John Henery says:

    This is such a great website.

  5. recipe script says:

    I wanted to thank you once again for your amazing web-site you have made here. It is full of useful tips for those who are truly interested in this specific subject, specifically this very post. You really are all really sweet as well as thoughtful of others and also reading your blog posts is a superb delight in my opinion.

  6. Logo Design says:

    Hi there, beautiful weblog with great informational content. This is a really interesting and informative post.

  7. I really liked your article post.Really looking forward to read more. Great.

  8. mantenimineto ordenadores says:

    This is really revealing, you are a very professional blogger. I have joined your RSS and I want to enjoy more things in this great blog. Also, I’ve shared your site on my social networks!

    regards

  9. Racquel Rosenblatt says:

    Thanks for the info

  10. Amparo Sobrowski says:

    Thanks for the sensible critique. Me and my neighbor were just preparing to do some research on this. We got a grab a book from our local library but I think I learned more from this post. I’m very glad to see such excellent info being shared freely out there.

Speak Your Mind

*