Brent Greenwood's blog

If you're anywhere near Huntington Beach this week, and you're interested in SQL Server, data, analytics or any combination of tho...

4/4 San Diego SQL BI User Group: Here are those references I mentioned in my 4/4 talk on ETL Design Patterns.  Lots of good content in h...

A Pareto Chart can be a powerful visualization to help you apply the 80/20 rule.  This viz focuses attention on the ~20% of the universe (...

Who knew Delorean's topped out at 88 MPH... This is a follow-up post to one I did a little while back on Time dimensions in PowerP...

I've been working with Excel 2013 more and more recently, and have to say I'm impressed with all of the enhancements the product t...

Groupers are your friends Sometimes you  need to perform what I'd call a multi-pass aggregation.  Rolling up data to a higher lev...

I need a time dimension BOYEE!! The other day I needed to build a model that would enable slicing of events by time of day.  My users wa...

Had a requirement the other day to be able to visualize historical sales and forecasts in one continuous line chart.  Actually pretty s...

The SoCal Rock & Roll Code Camp will be going off again in a few weeks (6/24 - 25).  Back at UC San Diego-Extension for the annual weeke...

March 24, 2012.  Mark your calendars. If you live in Southern California or are heading this way, come check out the Orange County SQL Sat...