OBIEE – Creating MySql Datasource

We will be using the sample food mart database for all tutorials. Please look into the introduction blog to obtain the link for this database.In this post we look at creating a datasource to the foodmart database in MySql. The screenshots are from a windows XP machine.Steps to create the data source.1. Goto Start -> … Read more

OBIEE – Introduction

In this series of post we will look at Oracle Business Intelligence Enterprise Edition.The source database for the examples is the foodmart database which can be downloaded from here . Look at this blog from more details on this database.The blogs will cover the following: Creating a repository. Using Answers Creating Dashboards Using BI publisher … Read more

Key Performance Indicators and Balanced Scorecard

Performance management is critical to an organization’s success. The top management spends a lot of time in making sure that the company’s day to day activity is aligned with its long term goals. The facets of performance management are :1 Alignment – The top management needs to align the business processes of a company to … Read more

R and Java – JRI using eclipse.

Update – Check out the new¬†RJava Eclipse Plugin.R is a powerful language for statistical computing and graphics. R has a strong community support and is finding new use in the corporate world. If R can be integrated with Java, it would provide a greap acceptance into new products. A library called rjava exists that helps … Read more

Examples using R – Randomized Block Design

Problem : We wish to determine whether or not four different tips produce different readings on a hardness testing machine. An experiment such as these might be part of a gauge capability study. The machine operates by pressingthe tip into a metal test coupon, and frm the depth of the resulting depression, the hardness of … Read more

Examples using R – Analysis of Variance

Problem: A product development engineer is interested in investigating the tensile strength of a new synthetic fiber that will be used t omake cloth for men’s shirts. The engineer knows from previous experience that the strength is affected by he weight percent of cotton used in the blend of materials for the fiber. Furthermore, she … Read more

Examples – Comparing two conditions using R.

Problem : The tension bond strangth of portland cement mortar is an important characteristic of the product. An engineer in interested in comparing the strength of a modified formulation in which polymer latex emulsions have been added during mixing to the strength of the unmodified mortar. The experimanter has collected 10 observations on strength for … Read more

Design of Experiments – Introduction

Experiments are performed in various fields to understand the behaviour of a system. In this post we will analyse the common terms used during an experiment design. Experiment : An experiment can be defined as a test or a group of test wherein changes are made to the input variables and the effect of that … Read more

Dimensional Modeling

A company that has a huge volume of data builds a data warehouse so that it can generate reports, perform analytics and make informed decisions. The process of building a data warehouse from a transactional or source system is important and the process that a company selects depends on its long term vision and goal … Read more