This is the first of a series of posts, which I will use to describe the implementation of a SQL Server 2005 BI solution designed to extract and analyze data captured in a semi-structured data source I discussed in my previous post.
In the course of this exercise, we will:
- Define a top-down SQL Server Analysis Services (SSAS) Unified Dimensional Model (UDM), which will capture the dimensional structure of the source information.
- Generate a relational star schema based on the UDM.
- Develop a SQL Server 2005 Integration Services (SSIS) solution, which will extract the data from the semi-structured spreadsheet and use it to populate the UDM.
- Revisit the SSIS solution and augment it with maintenance procedures such as updating the UDM with new data feeds.
Continue reading ‘“Employment Analysis” BI Solution - Part I (Building the UDM)’