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: October 2013

First take on PowerPivot

What is PowerPivot for Excel? PowerPivot brings the power of Data Modelling into your PC. Traditionally, the DataWarehouse is built on a database server (SQL) and a data model is built on top of it (SSAS). Then, a front end is used to present the data to users. Now, data…

Read more

1 comments, 323 reads

Posted in Terry's Business Intelligence on 30 October 2013

Understanding the PIVOT function

The PIVOT function is very useful but not easily understood at first. I thank Itzik Ben-Gan, Dejan Sarka and Ron Talmage and their study guide Exam 70-461: Querying Microsoft SQL Server 2012 for the brilliant explanation. Here’s their example replicated here. Remember there are 3 columns used in PIVOT. The…

Read more

3 comments, 1,807 reads

Posted in Terry's Business Intelligence on 25 October 2013

Get list of dates using recursive Common Table Expression (CTE)

Many times we need a list of consecutive dates or time at runtime mainly for a recursive ETL process. This code provides a list almost instantaneously with only the start and end dates being the only input. The output is in Date format but is easily extended to a DateTime…

Read more

0 comments, 345 reads

Posted in Terry's Business Intelligence on 23 October 2013

Top 10 Tips when synchronising your database and Mailchimp

Okay, sooner or later someone is going to need to synchronise all those people who registered on your company website with an email service provider to do a bit of marketing. In my case, the latest email provider to come my way is MailChimp. MailChimp is a very popular email…

Read more

0 comments, 121 reads

Posted in Terry's Business Intelligence on 17 October 2013

MailChimp Database Synchronisation Process

After giving you the Top 10 Tips when synchronising your database with MailChimp, I thought why not write up the process as well to help you along. Step 1: Download MailChimp Lists Step 2: Create the Master Comparison Table Step 3: Know the email update process Step 4: Run the…

Read more

0 comments, 134 reads

Posted in Terry's Business Intelligence on 17 October 2013

Top 11 Qualities of a DataWarehouse Implementer

Top 11th Quality: Curious to explore different designs There are many ways to achieve the same thing. Before actually getting your hands dirty, think and do some high level designs, then choose the best one. They need not be perfect, and the beauty of it is the more experience you…

Read more

0 comments, 94 reads

Posted in Terry's Business Intelligence on 14 October 2013