Borland - Pentaho analytics for MongoDB : combine Pentaho Analytics and MongoDB to create powerful analysis and reporting solutions

Pentaho Analytics for MongoDB Combine Pentaho Analytics and MongoDB to create powerful analysis and reporting solutions Bo Borland BIRMINGHAM - MUMBAI Pentaho Analytics for MongoDB Copyright 2014 Packt Publishing All rights reserved. No part of this book may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, without the prior written permission of the publisher, except in the case of brief quotations embedded in critical articles or reviews. Every effort has been made in the preparation of this book to ensure the accuracy of the information presented. However, the information contained in this book is sold without warranty, either express or implied. Neither the author, nor Packt Publishing, and its dealers and distributors will be held liable for any damages caused or alleged to be caused directly or indirectly by this book. Packt Publishing has endeavored to provide trademark information about all of the companies and products mentioned in this book by the appropriate use of capitals.

However, Packt Publishing cannot guarantee the accuracy of this information. First published: February 2014 Production Reference: 1180214 Published by Packt Publishing Ltd. Livery Place 35 Livery Street Birmingham B3 2PB, UK. ISBN 978-1-78216-835-5 www.packtpub.com Cover Image by Andrey Bayda (http://shutterstock.com) Credits AuthorProofreaders Bo Borland Simran Bhogal Maria Gould Reviewers Ameesha Green Rio Bastian Pooya Esfandiar Indexers Gretchen Moran Priya Subramani Khaled Tannir Hemangini Bari Monica Ajmera Mehta Acquisition Editors Rekha Nair James Jones Meeta Rajani Graphics Abhinash Sahu Content Development Editor Yuvraj Mannari Govindan K Production CoordinatorsTechnical Editors Conidon Miranda Dennis John Kyle Albuquerque Gaurav Thingalaya Cover WorkProject Coordinator Kyle Albuquerque Aboli Ambardekar About the Author Bo Borland is the vice president of field technical sales at Pentaho, a leading Big Data analytics software provider. He has a passion for building teams and helping companies improve performance with data analytics. Prior to joining Pentaho, Bo worked as a management consultant at Deloitte and as a solution architect at Cognos, an IBM company.

He founded a successful analytics consulting company, Management Signals, which merged with Pentaho in 2012. His 14 years' experience in professional analytics includes roles in management, sales, consulting, and sales engineering. Pentaho Corporation is a leading Big Data analytics company headquartered in Orlando, FL, with offices in San Francisco, London, and Portugal. Pentaho tightly couples data integration with full business analytics capabilities into a single, integrated software platform. The company's subscription-based software offers SMEs and global enterprises the ability to reduce the time taken to design, develop, and deploy Big Data analytics solutions. I wish to thank the wonderful team at Pentaho for their support and encouragement of this project, especially Rebecca Shomair and Monie TenBroeck for proactively reaching out to offer a helping hand, and Gretchen Moran for her valuable assistance as a technical reviewer for this book.

I also want to thank my wife, Alison, and daughters, Lin and Greta, for graciously accepting the fact that many nights and weekends were spent writing this book. About the Reviewers Rio Bastian is a happy software developer already working on several IT projects. His interests include business intelligence, data integration, tuning SQL, and tuning Java code. He has also been a Pentaho Business Intelligence trainer for a server company in Indonesia and Malaysia. He is currently focused on the development of an airline customer loyalty program in PT. Aero Systems Indonesia, an IT consultant specializing in airline industries.

In his spare time, he tries to share his experience in developing software through his personal blog altanovela.wordpress.com. You can reach him on Skype via rio.bastian or via e-mail at altanovela@gmail.com. Pooya Esfandiar is a software engineer and data analyst. He received an MS in Computer Science from the University of British Columbia in 2010 while working at the data management and mining labs. His research interests include simulation, data mining, and machine learning in social networks. He has worked with a few companies and organizations in Iran and Canada to solve business problems in information systems, general software engineering, and data analysis.

He once designed an in-house analytics solution using Pentaho and MongoDB and is now working as a software engineer at Amazon.com, Inc. Gretchen Moran is working as an independent Pentaho consultant on a variety of business analytics and Big Data projects. She has 15 years' experience in the business intelligence industry, developing software and providing services for a number of companies, including Hyperion Solutions and Pentaho Corporation. Gretchen continues to contribute to Pentaho Corporation's latest software initiatives while managing the daily adventures of her two children, Isabella and Jack, with her husband Doug. Khaled Tannir has been working with computers since 1980. He began programming with the legendary Sinclair Zx81 and afterwards with all Commodore home computer products (VIC-20, Commodore 64, Commodore 128D, and Amiga 500).

He has a Bachelor's degree in Electronics, a Master's degree in System Information Architectures in which he graduated with a professional thesis, and he completed his education with a Master of Research degree. He is a Microsoft Certified Solution Developer (MCSD) and has more than 20 years' technical experience leading the development and implementation of software solutions and giving technical presentations. He works as an independent IT consultant and has worked as an infrastructure engineer, senior developer, and enterprise/solution architect for many companies in France and Canada. With a significant experience in Microsoft .NET/Servers and Oracle Java technologies, he has extensive skills in online/offline application design, system conversions, and multilanguage applications on both the Internet and desktops. He spends his time researching on new technologies, learning about them, and looking for new adventures in France, North America, and the Middle East. He owns an IT and electronics laboratory with many servers, monitors, open electronics boards (such as Arduino, Netduino, Raspberry Pi, and .NET Gadgeteer), and some smartphone devices based on Windows Phone, Android, and iOS operating systems.

In 2012, he contributed to the EGC 2012 (International Complex Data Mining forum at Bordeaux University, France) and presented his work on how to optimize datadistribution in a cloud computing environment in a workshop session. This work aims to define an approach to optimize the use of data mining algorithms such as k-means and Apriori in a cloud computing environment. He is the author of RavenDB 2.x Beginner's Guide, Packt Publishing and OptimizingHadoop MapReduce, Packt Publishing. He aims to get a PhD degree in Cloud Computing and Big Data and wants to learn more and more about these technologies. He enjoys taking landscape and night photos, travelling, playing video games, creating funny electronics gadgets with Arduino / .NET Gadgeteer and of course, spending time with his wife and family. www.PacktPub.com Support files, eBooks, discount offers and more You might want to visit www.PacktPub.com for support files and downloads related to your book. www.PacktPub.com Support files, eBooks, discount offers and more