SQL Server Business Intelligence

Business Intelligence in Collaborative Planning, Forecasting and Replenishment

Executive Summary Collaborative Planning, Forecasting and Replenishment (CPFR) is a business process or practice that combines the intelligence of multiple businesses or trading partners in the planning and fulfillment of consumer demand. CPFR can be applied to any industry that has a supply chain and brings about significant benefits like reducing inventory, transportation and logistics […]

How to Import Data from Microsoft Office Excel 2007 to SQL Server 2005

SSIS Developers often come across a scenario where they need to import data from a Microsoft Office Excel 2007 Spreadsheet. This article provides a step by step guide on how to import data from a Microsoft Office Excel 2007 Spreadsheet to a SQL Server 2005 database. The first step is to go to Start and select Run and […]

How to Export Data to Microsoft Office Excel 2007 Using SQL Server 2005

SSIS Developers often come across a scenario where they need to export data to a Microsoft Office Excel 2007 spreadsheet. This article provides a step by step guide on how to export data to Microsoft Office Excel 2007. The first step is to go to Start | Run | CMD and type DTSWIZARD. The welcome to SQL Server Import and […]

Slowly Changing Dimension in SQL Server 2005 – Part 2

Introduction Having discussed type1 slowly changing dimensions (SCD) in Part 1 of this article, this article will talk about further on SCDs and how we can implement them in SQL Server 2005. What is Type2 SCD A Type 2 SCD writes a record with the new attribute information and preserves a record of the old dimensional […]

Slowly Changing Dimensions in SQL Server 2005

Introduction Slowly changing dimensions (SCD) are very useful in data warehouses. Even though they are useful, it is very difficult to implement slowly changing dimensions with most of ETL tools. In case of SQL Server 2000 it was difficult to implement SCD’s as there was no direct way of implimenting them.  As you are aware there […]

Same Report but Different Methods in SQL Server Reporting Services

Introduction SQL Server Reporting Services (SSRS) in SQL Server 2005 has given users many options to on how to create a report. This article describes several methods that can be used to develop the same report. In addition, we will analyse the performance of each method so that we know the pros and cons of each option. […]

Building Cubes with SQL Server 2005 Analysis Services

I admit that when it comes to SQL Server Analysis Services (SSAS), I found plenty of reasons to not get started. I have enough to do on a daily basis and I was just not very interested in learning about how to build cubes. Also, there is not much of a demand for cubes where […]

Script Component as Data Source

Introduction If you were asked what are the data sources that you can use as a data source for SQL Server Integration Services (SSIS), you may say list the out of the box data sources such as, SQL Server Oracle, DB2 etc and flat files such as Text files and CSV files or Excel. If […]

Check List for Performance Optimisation in SQL Server Analysis Service 2005

Introduction No matter what your platform or the tools that you are using, performance is almost always the number one feature that customers require.  In the case of SQL Server Analysis Service (SSAS), there are four areas where we can improve the performance. They are database design, processing, querying and configuring SSAS.  Key Attribute For […]

Analysis Services in High Data Volume Business scenarios

Executive Summary The realization of the importance of data warehouses coupled with ever decreasing price of hardware and advanced computing options has resulted in datawarehouses of thousands of gigabytes over the last few years. This in turn has paved way for OLAP solutions that store detail and aggregate data for optimally answering complex business queries […]