SQL Server PIVOT and UNPIVOT – with Sample Code

SQL Server PIVOT and UNPIVOT – with Sample Code

Ben Daland Business Analytics Specialist John Daniel Associates, Inc. Ben’s Profile This article will go over how to transform distinct column values into columns and transform columns into distinct column values using the PIVOT and UNPIVOT function. There are 2 different ways to use these functions – static and dynamic. The static approach is used when the distinct columns or column values are known. If […]

Read Me

How to Perform Data Validation in QlikView

How to Perform Data Validation in QlikView

Susie Bann Business Analytics Specialist John Daniel Associates, Inc. Susie’s Profile As with any BI tool, developer validity testing needs to be performed prior to any and all releases of an application to the end users. BI tools, like QlikView, allow for the rapid development of an application giving results very quickly. This rapid development is wonderful to help see results and make decisions…. but […]

Read Me