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: optimization
Using SQL Server Integration Services to Load Data
Microsoft SQL Server 2008 Analysis Services Unleashed Review Chapter 22 This chapter discusses leveraging SQL Server Integration Services to load data into a cube. If you have Analysis Services you also have Integration Services, no additional licensing required. However, you may have … Continue reading
Posted in Analysis Services, Integration Services
Tagged dimension, optimization, partition, SSIS
Leave a comment
Dimension and Partition Processing
Microsoft SQL Server 2008 Analysis Services Unleashed Review Chapter 21 As this chapter claims at the outset, SSAS only stores information in two locations: dimension files and partition files. Chapter 20 had discussed the static description of these files, and this … Continue reading
Multidimensional Models and Relational Database Schemas
Microsoft SQL Server 2008 Analysis Services Unleashed Review Chapter 19 This chapter assumes much of the data for the data source views comes from relational sources. The first part outlines advantages and disadvantages of using star or snowflake schemas as sources. … Continue reading
English