Book Image

Pentaho for Big Data Analytics

By : Manoj R Patil, Feris Thia
Book Image

Pentaho for Big Data Analytics

By: Manoj R Patil, Feris Thia

Overview of this book

<p>Pentaho accelerates the realization of value from big data with the most complete solution for big data analytics and data integration. The real power of big data analytics is the abstraction between data and analytics. Data can be distributed across the cluster in various formats, and the analytics platform should have the capability to talk to different heterogeneous data stores and fetch the filtered data to enrich its value.<br /><br />Pentaho Big Data Analytics is a practical, hands-on guide that provides you with clear, step-by-step exercises for using Pentaho to take advantage of big data systems, where data beats algorithm, and gives you a good grounding in using Pentaho Business Analytics’ capabilities.<br /><br />This book looks at the key ingredients of the Pentaho Business Analytics platform. We will see how to prepare the Pentaho BI environment, and get to grips with the big data ecosystem through. The book provides a clear guide to the essential tools of Pentaho Business Analytics, providing familiarity with both the various design tools for setting up reports, and the visualization tools necessary for complete data analysis.</p>
Table of Contents (14 chapters)
Pentaho for Big Data Analytics
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

Visualizing data using CTools


After we prepare Pentaho Data Integration transformation as a data source, let us move further to develop data visualizations using CTools. See Chapter 4, Pentaho Business Analytics Tools for the introduction of the tool.

Visualizing trends using a line chart

The following steps will help you create a line chart using a PDI data source:

  1. In the PUC Browser Panel window, right-click on NYSE Stock Price – Hive and choose Edit; the CDE editor appears. In the menu bar, click on the Layout menu. Explore the layout of this dashboard. Its structure can be represented by the following diagram:

  2. Using the same procedure to create a line chart component described in Chapter 4, Pentaho Business Analytics Tools, type in the values for the following line chart's properties:

    • Name: ccc_line_chart

    • Title: Average Close Price Trend

    • Datasource: line_trend_data

    • Height: 300

    • HtmlObject: Panel_1

    • seriesInRows: False

  3. In the menu bar, click on Save.

  4. In the Browser Panel window, double-click on the...