Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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

0 comments, 148 reads

Posted in Terry's Business Intelligence on 30 August 2013

Normalisation

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, 114 reads

Posted in Terry's Business Intelligence on 7 August 2013