Pentaho Analytics for MongoDB cookbook : over 50 recipes to learn how to use Pentaho Analytics and MongoDB to create powerful analysis and reporting solutions /: over 50 recipes to learn how to use Pentaho Analytics and MongoDB to create powerful analysis and reporting solutions. (2015)
- Record Type:
- Book
- Title:
- Pentaho Analytics for MongoDB cookbook : over 50 recipes to learn how to use Pentaho Analytics and MongoDB to create powerful analysis and reporting solutions /: over 50 recipes to learn how to use Pentaho Analytics and MongoDB to create powerful analysis and reporting solutions. (2015)
- Main Title:
- Pentaho Analytics for MongoDB cookbook : over 50 recipes to learn how to use Pentaho Analytics and MongoDB to create powerful analysis and reporting solutions
- Further Information:
- Note: Joel Latino, Harris Ward.
- Authors:
- Latino, Joel
Ward, Harris - 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;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 … (more)
- Publisher Details:
- Birmingham : Packt Publishing
- Publication Date:
- 2015
- Extent:
- 1 online resource, illustrations
- Subjects:
- 006.312
COMPUTERS -- Programming -- Open Source
Data mining
Data integration (Computer science)
Information visualization
COMPUTERS / Databases / Data Mining
Data integration (Computer science)
Data mining
Information visualization
COMPUTERS -- Programming Languages -- C
Electronic books
Electronic books - Languages:
- English
- ISBNs:
- 9781783553280
1783553286
1783553278
9781783553273 - Related ISBNs:
- 9781783553273
- Notes:
- Note: Online resource; title from PDF title page (EBSCO, viewed May 3, 2016)
- Access Rights:
- Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
- Access Usage:
- Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.
- View Content:
- Available online (eLD content is only available in our Reading Rooms) ↗
- Physical Locations:
- British Library HMNTS - ELD.DS.87613
- Ingest File:
- 01_051.xml