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

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

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

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

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

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

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

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

Many companies spend a fortune in organizing and storing their data. The amount of data that is generated daily may vary for different companies but it is not uncommon to hear of scores of GB of data for medium sized companies and terabytes of data for large enterprises. It is indeed challenging to store this … Read more