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
• 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; 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
• 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.