Pentaho Analytics for MongoDB cookbook : over 50 recipes to learn how to use Pentaho Analytics and MongoDB to create powerful analysis and reporting solutions /
Annotation
Clasificación: | Libro Electrónico |
---|---|
Autores principales: | , |
Formato: | Electrónico eBook |
Idioma: | Inglés |
Publicado: |
Birmingham :
Packt Publishing,
2015.
|
Colección: | Quick answers to common problems.
|
Temas: | |
Acceso en línea: | Texto completo |
Tabla de Contenidos:
- 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.