In this article, an overview of dimensions and measures was
provided. Some general concepts were introduced. The concepts introduced here
are illustrated with a sample picture from Excel (very simplified view). The
idea is that you have the capability to filter by region or by sales person and
have the sales amount changed. We also showed the two way of creating
dimensions schema: Star and Snow Flake. In the next article we will begin the
practical implementation of an Analysis Services project, stay tuned and happy
BI.