Message from MarkTab
After years of graduate education and even more years of professional experience (with SAS and Microsoft), I still find data mining an awesome and challenging topic. I use this blog to share my best tips and achievements learned sometimes through great struggle. Today, I provide data mining advice to leading companies and industries in the United States and around the world. I share my journey and insights at leading conferences like SAS Global Forum, Microsoft TechEd, and Predictive Analytics World.
As I continue learning, my hope is to inspire you to not just learn more but also apply mathematics through technology. Data mining is a powerful tool for leaders of leaders of leaders. If you like this blog, click the "About" page to find out how to go deeper. -- Mark Tabladillo ("MarkTab")- by
Tag Archives: aggregation design
SQL Server Data Mining and Apollo Columnstore Indexes
Note: This post was revised November 12, 2010 to clarify the brand names Apollo and VertiPaq (thanks Denny Lee of SQLCAT) — and I extended comments on Amir Netz’s C++ versus C# analogy which I believe clarifies the discussion between what … Continue reading
Quick Guide to BIDS Helper 1.4.3.0 for SSAS
BIDS Helper is an amazing free add-in for Business Intelligence Development Studio (BIDS). You can obtain the add-in from the Codeplex website. The purpose of this posting is to provide a quick guide to version 1.4.3.0 Analysis Services (SSAS) functions. … Continue reading
Posted in Microsoft Business Intelligence
Tagged aggregation, aggregation design, calculation, cube, dimension, measure, perspective, roles
Leave a comment
Aggregation Design and Usage-Based Optimization
Microsoft SQL Server 2008 Analysis Services Unleashed Review Chapter 23 This chapter discusses managing and optimizing the aggregations. Again, the “cube” in SSAS is comprised of partitions within which are aggregations. The chapter starts with another discussion of dimensions. A relational reporting-style … Continue reading
English