…brew your own Business Intelligence

Posts Tagged ‘Data Warehouse’

Jar-O-Skittles: Benefits of Table Partitioning

Quick note to the regular reader: don’t worry, still planning on finishing the series on Building a Scale-Out OLAP Farm in the Cloud with Azure VMs. But I’m afraid there’s not much time to work on that until we ship some important code (which I’ve been working around the clock […]

Read more

Types of Fact Tables

In a presentation I’ve been delivering lately, Bus Matrix – the Foundation of your Dimensional Data Model, I briefly cover the hierarchy of an enterprise and how it can be conceptually broken down and mapped into a dimensional model. A single enterprise typically contains many business areas (e.g. Sales, Manufacturing, Finance) […]

Read more

The Best Book On Dimensional Modeling

The Data Warehouse Toolkit by Ralph Kimball has been read cover to cover by most Data Warehousing and Business Intelligence industry professionals. It is perhaps the most popular text on dimensional modeling known to mankind. However, it is not the best book on dimensional modeling. These may seem like pretty bold […]

Read more

Bus Matrix Presentation Follow Up Q&A

On 1/14/2014, I presented Bus Matrix…the foundation of your Dimensional Data Model via the Free Training on the T’s offered by PragmaticWorks. If you weren’t able to attend the live session, you can watch the recording here. This presentation touched on a lot of complex concepts (dimensional modeling, conformed dimensions, […]

Read more

Dimensional Modeling: Junk vs Degenerate

Two commonly misunderstood dimensional modeling techniques are Junk Dimensions and Degenerate Dimensions.  This post is aimed at clearing up the confusion and providing some context and use-cases for each. Junk Dimensions There are certain scenarios where you will find that the source for a fact table contains a bunch of […]

Read more

Steering the Car Back on the Road

In my last post (Go Work for a Consulting Firm), I discussed a difficult situation faced earlier in my career…back when I lacked the knowledge and expertise to solve the problems facing the team and ultimately steer the car back on the road.  Towards the end of that post I […]

Read more

Rapid DW Development with WhereScape RED

Earlier this month, I spent an entire week evaluating WhereScape RED with a new client. If you’ve never heard of it, RED is a platform for rapid data warehouse development. Admittedly, I’ve always been skeptical of these types of tools…”build your entire data warehouse and ETL in a few hours“…but […]

Read more

AdventureWorks, User Adoption, and Self-Service BI Projects

User adoption is critical to the overall success of any IT project…but that goes double for self-service BI projects because at the end of the project the users will be expected to actually use the tools to generate their own BI (reports, dashboards, scorecards, analysis) and facilitate fact-based decision making […]

Read more

SQL Server 2012 Certification Path Update

Yesterday morning, I passed the 70-463: Implementing Data Warehouses with Microsoft SQL Server 2012! This completes the second step on my SQL Server 2012 certification path. What follows is a quick outline of the materials I used while preparing for this exam along with some comments and afterthoughts. Data Warehouse […]

Read more

70-463: Determine whether you need a star or snowflake schema…

If you’re a Kimball purist like myself, the title of this post should give you pause.  I came across this phrase when reviewing the SkillsMeasured section for the 70-463 exam.  At the time, the only scenarios I could come up with that would justify using a snowflake schema were the […]

Read more