Aggregated data according to your business needs. It is optimized for business terms. For example, Rolling numbers by quarter.
Zero to Cube in 60 Minutes
Overcome the barriers of traditional training and seminars with this Quick Start to building a cube. This all demo session will get you started and answer many questions you have about building cubes the right way, the first time.
Adam Jorgensen(website), President – Pragmatic Works Consulting – has over a decade of experience leading organizations around the world in developing and implementing enterprise solutions. Adam is also very involved in the community as a featured author on SQLServerCentral, SQLShare, as well as a regular contributor to the SQLPASS Virtual User Groups and other organizations. He regularly speaks at industry group events, Code Camps, and SQLSaturday events on strategic and technical topics.
Fact Tables – Actual facts such as sales, orders, or donations.
Dimension – any that starts with the word “by”. For example, Sales by state or orders by gender.
Power Pivot (Website)