Pentaho for Big Data Analytics: Enhance Your Knowledge of Big Data and Leverage the Power of Pentaho to Extract Its Treasures

Cover 1 Copyright 3 Credits 4 About the Authors 5 About the Reviewers 7 www.PacktPub.com 9 Table of Contents 10 Preface 14 Chapter 1: The Rise of Pentaho Analytics along with Big Data 20 Pentaho BI Suite – components 21 Data 22 Server applications 23 Thin Client Tools 23 Design tools 24 Edge over competitors 25 Summary 25 Chapter 2: Setting Up the Ground 26 Pentaho BI Server and the development platform 26 Prerequisites/system requirements 27 Obtaining Pentaho BI Server (Community Edition) 27 JAVA_HOME and JRE_HOME 28 Running Pentaho BI Server 29 Pentaho User Console (PUC) 30 Pentaho Action Sequence and solution 32 JPivot component example 33 Message template component example 34 Embedded HSQLDB database server 35 Pentaho Marketplace 38 Saiku installation 38 Pentaho Administration Console (PAC) 40 Creating data connections 41 Summary 44 Chapter 3: Churning Big Data with Pentaho 46 An overview of Big Data and Hadoop 46 Big Data 47 Hadoop 48 The Hadoop architecture 48 The Hadoop ecosystem 51 Hortonworks Sandbox 54 Pentaho Data Integration (PDI) 54 Pentaho Big Data plugin configuration 55 Importing data to Hive 57 Putting a data file into HDFS 63 Loading data from HDFS into Hive (job orchestration) 65 Summary 69 Chapter 4: Pentaho Business Analytics Tools 70 The business analytics life cycle 70 Preparing data 72 Preparing BI Server to work with Hive 72 Executing and monitoring a Hive MapReduce job 73 Pentaho Reporting 74 Data visualization and dashboard building 77 Creating a layout using a predefined template 79 Creating a data source 82 Creating a component 84 Summary 85 Chapter 5: Visualization of Big Data 86 Data visualization 86 Data source preparation 88 Repopulating the nyse_stocks Hive table 88 Pentaho's data source integration 89 Consuming PDI as a CDA data source 90 Visualizing data using CTools 91 Visualizing trends using a line chart 91 Interactivity using a parameter 92 Multiple pie charts 94 Waterfall chart 95 CSS styling 97 Summary 100 Appendix A: Big Data Set 102 Freebase 102 U.S. airline on-time performance 103 Amazon public data sets 103 Appendix B: Hadoop Setup 104 Hortonworks Sandbox 104 Setting up the Hortonworks Sandbox 104 Hortonworks Sandbox web administration 106 Transferring a file using secure FTP 108 Preparing Hive data 109 The nyse_stocks sample data 111 Index 112 Enhance your knowledge of Big Data and leverage the power of Pentaho to extract its treasures **Overview** * A guide to using Pentaho Business Analytics for big data analysis * Learn Pentaho’s visualization and reporting tools with practical examples and tips * Precise insights into churning big data into meaningful knowledge with Pentaho **In Detail** 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. 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. 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 Hadoop and Pentaho MapReduce. 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. **What you will learn from this book** * Get to grips with the Pentaho suite * Explore the basics of Big Data and its business context * Set up a Pentaho business analytics server * Consume Big Data on HDFS platform using Pentaho Data Integration * Create visualization with Pentaho's tools * Distinguish signal from noise with Pentaho's Data Analytics capabilities * Design and set up your own Pentaho dashboard * Move from data to analytics in just a few steps with Community Dashboard Framework (CDF) **Approach** The book is a practical guide, full of step-by-step examples that are easy to follow and implement. **Who this book is written for** This book is for developers, system administrators, and business intelligence professionals looking to learn how to get more out of their data through Pentaho. In order to best engage with the examples, some knowledge of Java will be required.

In Detail

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.

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.

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.

Approach

The book is a practical guide, full of step-by-step examples that are easy to follow and implement.

Who this book is for

This book is for developers, system administrators, and business intelligence professionals looking to learn how to get more out of their data through Pentaho. In order to best engage with the examples, some knowledge of Java will be required.