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
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
Taarradhin 