5 Minute Overview of Pentaho Business Analytics
Mondrian - Interactive Statistical Data Visualization in JAVA
Try out the newest version of IBM Many Eyes! New site design and layout
Data Warehouse Overview
Entity–attribute–value model ( EAV ) is a data model to describe entities where the number of attributes (properties, parameters) that can be used to describe them is potentially vast, but the number that will actually apply to a given entity is relatively modest. In mathematics, this model is known as a sparse matrix . EAV is also known as object–attribute–value model , vertical database model and open schema . Entity–attribute–value model
JasperReports JasperReports is an open source Java reporting tool that can write to a variety of targets, such as: screen, a printer, into PDF , HTML , Microsoft Excel , RTF , ODT , Comma-separated values or XML files. It can be used in Java-enabled applications, including Java EE or web applications , to generate dynamic content. It reads its instructions from an XML or .jasper file.
Who enjoys the fastest internet?
DSPL stands for Dataset Publishing Language. DSPL Tutorial - DSPL: Dataset Publishing Language - Google Code
Recombinant Data Corp. - Healthcare Data Warehousing
03. Hello World Example - Pentaho Wiki Although this will be a simple example, it will introduce you to some of the fundamentals of PDI:
Loop over fields in a MySQL table to generate csv files
When doing ETL work every now and then the exact SQL query you want to execute depends on some input parameters determined at runtime. This requirement comes up most frequently when SELECTing data. Dynamic SQL Queries in PDI a.k.a. Kettle | Adventures with Open Source BI
Slowly changing dimension Dimension is a term in data management and data warehousing . It's the logical groupings of data such as geographical location, customer or product information. With Slowly Changing Dimensions (SCDs) data changes slowly, rather than changing on a time-based, regular schedule. [ 1 ]
Power Your Decisions With SAP Crystal Solutions
OpenMRS: ETL/Data Warehouse/Reporting
ETL Process The ETL (Extract, Transform, Load) process is comprised of several steps and its architecture depends on the specific data warehouse system. In this post, an outline of the process will be given along with choices that are/could be used for OpenMRS.
Why would we want to build a data warehouse system? Another approach for reporting: A Data Warehouse System
DW Data Model This post is going to describe the data model for the OpenMRS data warehouse. It will be edited frequently to add documentation for the model and to modify it. Star Schemas
You can create three different types of reports: a Period Indicator Report, a Row-Per-Patient Report, or a Custom Report (Advanced). Building Reports (Step By Step Guide) - Documentation - OpenMRS Wiki
openmrs-reporting-etl-olap - A data warehouse system for OpenMRS, based on other open source projects.
Pentaho and OpenMRS Integration We have a great opportunity to explore how Pentaho can provide ETL, analytics, and reporting benefits to OpenMRS , an open source medical records platform and community interested in global health care.
Pentaho ETL and Designs for Dimensional Modeling (Design Page, R&D) - Projects - OpenMRS Wiki Abstract OpenMRS has few tools in place allowing for easier analysis of concept, patient, location, encounter or visit data in an aggregated, dimensional manner.
Cohort Queries as a Pentaho Reporting Data Source - Projects - OpenMRS Wiki
Concept Dictionary Creation and Maintenance Under Resource Constraints: Lessons from the AMPATH Medical Record System
Welcome to Apelon DTS
Advanced Concept Management at OpenMRS
Concept Dictionary - Documentation - OpenMRS Wiki
OpenMRS Database Schema
Main Page - MaternalConceptLab