Search this Blog
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")Categories
- Analysis Services (58)
- Business Intelligence (13)
- Data Mining (27)
- Integration Services (5)
- Microsoft Business Intelligence (37)
- Query and Response (2)
- Reporting Services (5)
- SQL Server Data Mining (75)
- Uncategorized (6)
MarkTab Tag Cloud (click one)
ADOMD.NET advanced modeling aggregation design AMO architecture assembly BIDS BISM calculation Codeplex cube data source data source view decision trees Deming Denali dimension DMX Excel Interview Kinect MDX measure multidimensional optimization partition PASS PowerPivot PowerShell Predixion Software query optimization SharePoint Social Marketing sqlcat SQL Saturday SQL Server SSMS TechEd text mining time series Vertipaq visual analytics VS2010 XML XMLASuper Blogroll
Tag Archives: partition
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