Pivoting data in SQL

Most pivoting of data is done outside of the relational SQL databases. Relational databases are rigid and the variable number of columns in a pivot table is not something that goes hand in hand with the rigid structures defined in relational database. Pivot tables make some data just that much easier to work with. A…Continue readingPivoting data in SQL

Business Intelligence SQL

Technical Dept: SQL CASE statement in Business Intelligence (BI)

Sometimes making the simplest enhancement can be difficult to implement at a technical level. Simple is relative off course but from a BI perspective somethings I would consider simple to include: Adding a single column to a report Changing a calculation in a report or cube The reason everyday tasks in a BI environment become…Continue readingTechnical Dept: SQL CASE statement in Business Intelligence (BI)