Categories
SQL

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

Categories
SQL

SQL Sample data sets

A blog centred around SQL and data warehousing is going to include a significant number of SQL statements as examples to show concepts covered in the blog. Instead of making up fictional use cases in my head as I blogged I decided to look around for open data sets I could base my examples on.…Continue readingSQL Sample data sets

Categories
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)