What is OLAP? :
What is OLAP? Specialized data storage (MOLAP)
Dimensional analysis techniques
Specialized user interfaces
A critical component of most business intelligence systems
Dimensional Modeling Elements :
Dimensional Modeling Elements Dimensions
Dimension members
Descriptions
Attributes
Hierarchies
Data Cubes :
Data Cubes Multidimensional arrays of data
Data arrays are indexed by functional elements, (time periods, products, etc.), not integers.
Data cubes are like “data hotels” with a cell created for every combination of dimension members.
The Benefits of OLAP Technology :
The Benefits of OLAP Technology Shows how business results vary as a function of key drivers
Gives the analyst the ability to create and format their own reports
Allows the analyst to choose the level of detail they want to see
By “cruising down the multidimensional superhighway” the analyst can explore and get a feel for the dynamics of the business process.
Analytical Alchemy :
Analytical Alchemy The practice of Business Intelligence is not just software
The practice of Business Intelligence must also include expertise in designing measures and understanding the analytical processes that pertain to the business function.
There are techniques and strategies for designing OLAP measures.
In The Multidimensional Data Modeling Toolkit, I call it analytical alchemy
Analytical Elements :
Analytical Elements The Classic Business Intelligence Application of OLAP
Attribute Breakouts
Dimension Profilers
Counting Measures
Time Series manipulations
Others…
To learn a whole lot more :
To learn a whole lot more www.AnalyticalAlchemy.com Look for OLAP Cartoons on YouTube.com
Slide 17:
Look inside at www.Amazon.com