Weekly Wrap Up – Coursera and Customer Service

One Thing I Learned File this under a ‘Duh!’ moment – Every January we spend the month archiving a year’s worth of data from all cubes, cleaning up unused tables and procs, and doing of review of data to ensure that we’re still using the most accurate measure and that our dimensions are sound. This … Continue reading

October 2014 – Goals

Projects This month we’re wrapping up a two new data warehouses, since both are with new user groups we’ll be doing a ton of training and are expecting quite a bit of enhancements as they start digging through their data. We’re also ramping down our Lotus Notes to SharePoint conversion; more than 800 separate databases … Continue reading

BI Yearly Maintenance

I look at data warehouses and data marts like cabinets where you store specific items.  And like any cabinet, at least in my house, over time they get a little overstuffed, you may find things that don’t really belong, or things that you no longer want or need, maybe even a few things that have … Continue reading

Weekly Wrap Up – Kodyaz, Agile Exams and Do Nothing

One Thing I’ve Learned Over the years I’ve collected a bunch of methods to pivot data in queries and result sets, some easy, some way too complicated, none really the best method. This week I finally sat down and focused on learning how to use the Pivot function in SQL Server (It’s not as easy … Continue reading

September 2013 Goals

Leadership 2014 Leadership Training Two years into this little side project and I’m very happy to say we’re going to go for a third. This year we took a new group of 20 through Everyone Communicates/Few Connect and the group of 18 from last year through Leading Change. We (now a team of 3 passionate … Continue reading