Extracting Data from Multiple Excel sheet using Multiple Tags

Follow the steps given here to know exactly how to extract data from various Excel sheets using multiple tags.

Step 1 Create few samples with Excel with DimCustomer or DimEmployee from Adventures Works Database. Continue reading »

Tags: Microsoft BI

Installing Master Data Services

Find the step by step procedures on installing the master data services given here.

Step 1: Click on the Master Data Services folder present in All Program — > Microsoft SQL Server 2012

Continue reading »

Tags: Microsoft BI