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

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)