Paul Hernandez playing with Data

Business Intelligence, Data Analysis, Advanced Analytics and more …

October 22, 2012

Manage packages stored in the MSDB database with T-SQL

Last week we’ve performed a typical migration from a development server to a production server. Both servers are running SQL Server 2008 R2 databases. I created a set of SSIS ETL packages and I wanted to move them to production environment too. In our development environment we usually store the packages in the msdb database…
February 10, 2012

Dashboard creation with Pentaho and CDE. Step by step screencast tutorial.

Introduction This screencast tutorial shows how to create a dashboard using Pentaho and the Community Tools (CTools), especially the Community Dashboard Editor (CDE). A dashboard with two different bar charts is created step by step, including the layout, data sources and components configuration. It’s very similar to this tutorial: Creating Dashboards with CDE, but it…
January 23, 2012

Reports vs. Dashboards and Balanced Scorecards. Differences in theory and practice.

Introduction: Decision Support Systems and BI Solutions are intended to provide integrated information to decision makers in order to identify and solve problems and make decisions. To present this information to end-users BI developers usually create Reports, Dashboards and Scorecards, but do the users (analysts, managers, CEOs) and developers really understand the differences between them?…
September 24, 2011

Problem using the Navigation Menu Component – Pentaho 3.8 CDE Bundle 1.0 RC3

The CDE Bundle 1.0 RC3 comes with a Navigation Menu Component, which introduces a menu that allow you to browse the complete Pentaho solution repository (non-hidden folders). I tried to use the component but it does not appear in the preview of the dashboard. After some googling I found the following post: http://forums.pentaho.com/showthread.php?80700-CDE-Navigation-Menu-Component-not-usable The problem is…
September 15, 2011

Problem creating New Data Source in Pentaho CE 3.8 (Solved)

After installing Pentaho BI Server CE 3.8 and upgraded my java JDK to 1.7, I wasn’t able to create or edit new data sources. I tried with several connections and very simple queries, I was able to see the results in the preview but when I clicked the “Finish” button I got always the same…
September 11, 2011

Create and maintain dashboards with Pentaho CTools (CDF, CDE, CCC)

Recently I got involved in a project, implementing dashboards for a private company. I am responsible for the Front-End development and I had to decide the technologies to accomplish this task. Then I found Pentaho CE and the CTools. Pentaho CE (Community Edition) is an open source BI Suite made up of several products. One…
June 8, 2011

How to use jQuery .live() to catch events from dynamically generated elements.

Learning Objetives In this screencast you will learn: How to use the .click() event handler for checkboxes. The .live() method to catch events from dynamically generated elements. How to use the :not() Selector. Create and append checkboxes dynamically using jQuery. Get Source Files References: http://stackoverflow.com/questions/1455223/how-to-catch-check-uncheck-event-of-input-type-checkbox-with-jquery http://stackoverflow.com/questions/2055459/dynamically-create-checkbox-with-jquery-from-text-input http://api.jquery.com/live/
April 9, 2011

Welcome

Welcome to my personal blog. Here I want to post several tutorials about different technologies for Web development and discuss them, in order to help people build better applications in a faster and up-to-date way. With the right information you can handle the world!