it_user6912

Owner with 51-200 employees
Has 10+ Years Of Experience

Badges

75 Points12 YearsTop 20

User Activity

Almost 11 years ago

Commented on Unfortunately, they couldn't deliver as promised. Initially, we were very intrigued by the ability to get four to six complicated reporting tools into one aggregated dashboard.

We connect to Google Analytics, EverHour, Asana, Authority Labs, and Google Docs. EverHour does not even have an API and we managed to automate ETL from it. All this in one month. Our client is, needless to say, very satisfied.

About 12 years ago

Contributed a review of Jira: Pros: Flexible, Open-ended, Useful default values and fields. Cons: Deep and complex, it takes a while to familiarize

About 12 years ago

Commented on It does a lot of what we need but off-the-shelf solutions often can’t do exactly what you need

I see what you mean now One of the ways you can use this is by specifying a user-defined function in the Modified Javascript Value step. Pentaho uses Javascript as the scripting language. You can define this once within a tab that is marked as Start only (executed only once…

About 12 years ago

Commented on It does a lot of what we need but off-the-shelf solutions often can’t do exactly what you need

Do you mean something like an ORM layer that would allow your code to be database agnostic Pentaho ETL could run custom Java code (implemented as a user-defined Step) that has access to an ORM layer. We've done something similar when we need to access OpenERP (before the…

About 12 years ago

Commented on It does a lot of what we need but off-the-shelf solutions often can’t do exactly what you need

We frequently call Python scripts from within Kettle. So we have the best of both worlds Kettle's ETL scripts are no harder to maintain than source code. They are just text files that can easily be maintained within a version control system. The benefit is the visual…

Over 12 years ago

Commented on Very capable suite of BI, reporting, and data mining tools with sophisticated functionality

Excuse me? Good for Windows but not for other operating system? I built 3 Data Warehouses so far using Pentaho on servers running Ubuntu and Debian Linux OS and one on Windows. There is nothing that can be said about Pentaho is better for either Operating Systems.

Over 12 years ago

Contributed a review of Pentaho Business Analytics: Pentaho BI Suite Review: Pentaho Reporting – Part 3 of 6

Almost 13 years ago

Contributed a review of Pentaho Business Analytics: Pentaho BI Suite Review: Pentaho BI Server – Part 2 of 6

Projects

Over 12 years ago

Application Development Project

A new service: Automated report and dashboards for businesses that is not yet ready for a full-blown Data Warehouse

Experience

Reviews

About 12 years ago

Jira

Pros: Flexible, Open-ended, Useful default values and fields. Cons: Deep and complex, it takes a while to familiarize

Over 12 years ago

Pentaho Business Analytics

Pentaho BI Suite Review: Pentaho Reporting – Part 3 of 6

Almost 13 years ago

Pentaho Business Analytics

Pentaho BI Suite Review: Pentaho BI Server – Part 2 of 6

Comments

Almost 11 years ago

Data Integration

Unfortunately, they couldn't deliver as promised. Initially, we were very intrigued by the ability to get four to six complicated reporting tools into one aggregated dashboard.

About 12 years ago

BI (Business Intelligence) Tools

It does a lot of what we need but off-the-shelf solutions often can’t do exactly what you need

About 12 years ago

BI (Business Intelligence) Tools

It does a lot of what we need but off-the-shelf solutions often can’t do exactly what you need

About 12 years ago

BI (Business Intelligence) Tools

It does a lot of what we need but off-the-shelf solutions often can’t do exactly what you need

Over 12 years ago

BI (Business Intelligence) Tools

Very capable suite of BI, reporting, and data mining tools with sophisticated functionality

About me

I solve data management problems for companies in various sectors of industry: Airline Travels, Energy Bill Management, Manufacturing, Commercial Printing/Publishing, Transportation and Logistics, Health Care, and Software Development.

Specializing in building Data Warehouses, designing and implementing BI tools and processes, Change Management, OLAP database schemas, and ETL transformations, I also provide ERP solutions to businesses and organizations.

Specialties: Data Warehouse design and implementation, Business Data Management, BI System Optimization and Training, SDLC, Change Management, Team Building, ETL, Pentaho, OpenERP

Interesting Projects and Accomplishments

Over 12 years ago

Application Development Project