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

Advertisement

Weekly Wrap Up – Zicam, User Stories, Intersect

Five Things I Accomplished Next week I am conducting an Agile user story workshop for a large group of newish product owners. I’ve only done this type of training for developers/project leads so reworking it to fit folks who aren’t used writing up requirements was an interesting exercise on its own. This year my team … 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

Weekly Review – Recharging FTW

One Thing I’ve Learned The being a data geek/project manager does have its life benefits; recently I’ve had a health challenge that while not serious has forced me to focus on being healthier. To that end I’ve done my analysis, weighed some risks, crunched the numbers and have come up with a good workable twenty … Continue reading