Microsoft BI & Data Warehousing

• Data warehousing Architecture - We analyze and understand the business requirement of our client and develop optimized data warehouse architecture by creating departmental data marts, e.g. Sales, Finance, Web Traffic etc. Most of the models follows standard start schema model.
• ETL using SSIS - We develop ETL packages using Integration service to load data from heterogeneous data sources. These packages polish data by slicing and dicing and load to departmental data marts. We then schedule the packages to run automatically and monitor the execution.
• Info cube creation using SSAS - Once the data is refreshed in data warehouse we analyze & aggregate them and build business cube. Cubes are mainly used for business data analysis, e.g. Job Search Analysis, Resume Search Analysis, Sales Analysis, Finance data Analysis etc. These analyses help in business decision making and prediction.
• BI Reporting using SSRS - We maintain a huge MS report server of our client consist of thousands of reports. These reports are being consumed by the leadership and business users regularly. Few key reports developed by us would be Sales and Business stats, Consumer Status, Partner Stats, Business Fast Fact reports, Account Performance reports, Traffic reports, Industry Comparison report, Year Over Year performance report, various scorecards and KPIs etc. Many of the reports have drill down capabilities.
• Dashboard reporting using SSRS and Excel 2007
• Deployment using Sharepoint WSS