MSBI Tutor

SSAS  Stand for  SQL Server Analysis Services . It is the On-Line Analytical Processing ( OLAP ) Component of  Microsoft SQL Server . SSAS allows you to build multidimensional structures called Cubes to pre-calculate and store complex aggregations, and also to build mining models to perform data analysis to identify valuable information like trends, patterns, relationships etc. within the data using Data Mining capabilities of SSAS, which otherwise could be really difficult to determine without Data Mining capabilities. The SSAS main idea is to trade off increased storage space now for speed of querying later. OLAP does this by pre-calculating and storing aggregates. This takes a lot of disk space, but it means that when you want to explore the data you can do it so quickly. Online Analytical Processing Server (OLAP): Online Analytical Processing Server (OLAP) is based on multidimensional data model. It allows the managers, analysts to get insight the information...

QUESTION 1 You are an ETL developer for a mortgage company. In your application you have to load data from a Microsoft Excel source and an OLE DB source. The Excel source contains vender data and has approximately 1000 records. The OLE source contains loan data and has approximately 1,000,000 records. Sample vendor data (Excel source) is shown in the following table: VendorID VendorName 1 VendorA 2 VendorB 3 VendorC 4 VendorD 5 VendorE Sample loan data (OLE DB source) is shown in the following table: LoanNumber VendorID LoanAmount I-100 1 120000 I-200 1 130000 I-300 2 150000 I-400 3 150000 I-500 4 160000 I-600 4 170000 I-700 5 180000 The CIO asks you to generate an Excel file with the loan list information for each vendor. You build a SQL Server 2008 Integration Services (SSIS) package that can generate the Excel files dynamically. The Excel files should have the vendor name as the prefix and the date as the suffix (e.g., VendorA_DDMMYYYY.xlsx)...