| Description |
1 online resource : illustrations. |
|
text file |
| Series |
Quick answers to common problems
|
|
Quick answers to common problems.
|
| Note |
Includes index. |
| Summary |
Annotation Over 50 recipes to learn how to use Pentaho Analytics and MongoDB to create powerful analysis and reporting solutionsAbout This Book Create reports and stunning dashboards with MongoDB data Accelerate data access and maximize productivity with unique features of Pentaho for MongoDB A step-by-step recipe-based guide for making full use of Pentaho suite tools with MongoDBWho This Book Is ForThis book is intended for data architects and developers with a basic level of knowledge of MongoDB. Familiarity with Pentaho is not expected. What You Will Learn Extract, load, and transform data from MongoDB collections to other datasources Design Pentaho Reports using different types of connections for MongoDB Create a OLAP mondrian schema for MongoDB Explore your MongoDB data using Pentaho Analyzer Utilize the drag and drop web interface to create dashboards Use Kettle Thin JDBC with MongoDB for analysis Integrate advanced dashboards with MondoDB using different types of connections Publish and run a report on Pentaho BI server using a web interfaceIn DetailMongoDB is an open source, schemaless NoSQL database system. Pentaho as a famous open source Analysis tool provides high performance, high availability, and easy scalability for large sets of data. The variant features in Pentaho for MongoDB are designed to empower organizations to be more agile and scalable and also enables applications to have better flexibility, faster performance, and lower costs. Whether you are brand new to online learning or a seasoned expert, this book will provide you with the skills you need to create turnkey analytic solutions that deliver insight and drive value for your organization. The book will begin by taking you through Pentaho Data Integration and how it works with MongoDB. You will then be taken through the Kettle Thin JDBC Driver for enabling a Java application to interact with a database. This will be followed by exploration of a MongoDB collection using Pentaho Instant view and creating reports with MongoDB as a datasource using Pentaho Report Designer. The book will then teach you how to explore and visualize your data in Pentaho BI Server using Pentaho Analyzer. You will then learn how to create advanced dashboards with your data. The book concludes by highlighting contributions of the Pentaho Community. Style and approach A comprehensive, recipe-based guide to take complete advantage of the Pentaho Analytics for MongoDB. |
| Contents |
Cover; Copyright; Credits; About the Authors; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: PDI and MongoDB; Introduction; Learning basic operations with Pentaho Data Integration; Migrating data from the RDBMS to MongoDB; Loading data from MongoDB to MySQL; Migrating data from files to MongoDB; Exporting MongoDB data using the aggregation framework; MongoDB Map/Reduce using the User Defined Java Class step and MongoDB Java Driver; Working with jobs and filtering MongoDB data using parameters and variables; Chapter 2: The Thin Kettle JDBC Driver; Introduction. |
|
Using a transformation as a data serviceRunning the Carte server in a single instance; Running the Pentaho Data Integration server in a single instance; Define a connection using a SQL Client (SQuirreL SQL); Chapter 3: Pentaho Instaview; Introduction; Creating an analysis view; Modifying Instaview transformations; Modifying the Instaview model; Exploring, saving, deleting, and opening analysis reports; Chapter 4: A MongoDB OLAP Schema; Introduction; Creating a date dimension; Creating an Orders cube; Creating the customer and product dimensions; Saving and publishing a Mondrian schema. |
|
Creating a Mondrian 4 physical schemaCreating a Mondrian 4 cube; Publishing a Mondrian 4 schema; Chapter 5: Pentaho Reporting; Introduction; Copying the MongoDB JDBC library; Connecting to MongoDB using Reporting Wizard; Connecting to MongoDB via PDI; Adding a chart to a report; Adding parameters to a report; Adding a formula to a report; Grouping data in reports; Creating subreports; Creating a report with MongoDB via Java; Publishing a report to the Pentaho server; Running a report in the Pentaho Server; Chapter 6: The Pentaho BI Server; Introduction; Importing Foodmart MongoDB sample data. |
|
Creating a new analysis view using Pentaho AnalyzerCreating a dashboard using Pentaho Dashboard Designer; Chapter 7: Pentaho Dashboards; Introduction; Copying the MongoDB JDBC library; Importing a sample repository; Using a transformation data source; Using a BeanShell data source; Using Pentaho Analyzer for MongoDB data source; Using a Thin Kettle data source; Defining dashboard layouts; Creating a Dashboard Table component; Creating a Dashboard line chart component; Chapter 8: Pentaho Community Contributions; Introduction; PDI MongoDB Delete Step; PDI MongoDB GridFS Output Step. |
|
PDI MongoDB Map/Reduce Output stepPDI MongoDB Lookup step; Index. |
| Local Note |
eBooks on EBSCOhost EBSCO eBook Subscription Academic Collection - North America |
| Subject |
MongoDB.
|
|
MongoDB. |
|
MongoDB. |
|
Data mining.
|
|
Data mining. |
|
Data integration (Computer science)
|
|
Data integration (Computer science) |
|
Information visualization.
|
|
Information visualization. |
| Genre/Form |
Electronic books.
|
| Added Author |
Ward, Harris, author.
|
| Other Form: |
Print version: Latino, Joel. Pentaho Analytics for MongoDB Cookbook. Birmingham : Packt Publishing, ©2015 |
| ISBN |
9781783553280 (electronic book) |
|
1783553286 (electronic book) |
|
1783553278 |
|
9781783553273 |
|
9781783553273 |
| Standard No. |
9781783553273 |
|
