SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Terry's Business Intelligence

Terry is a BI Developer in London, focusing on DataWarehouse design and Reporting using SQL Server SSIS/SSAS/SSRS.

Archives: August 2013

Building a simple forecast solution on SQL Server

Pricing Forecast is a marketing function that requires a lot of data crunching. Normally there are some factors that the Marketing team wants to adjust to find out just the optimum pricing for their products. Accordingly, the forecast solution needs to be fairly flexible but still be powerful enough to…

Read more

7 comments, 1,047 reads

Posted in Terry's Business Intelligence on 30 August 2013


The purpose of normalisation is to remove redundancy and prevent conflict. 1st Normal Form (1NF) – Every field can have only one value. No repeating value and no repeating groups. From wikipedia: A relation is in first normal form if the domain of each attribute contains only atomic values, and…

Read more

0 comments, 428 reads

Posted in Terry's Business Intelligence on 7 August 2013