Thursday, January 28, 2010

Post Microstrategy World 2010

As I'm sitting in the airport thinking about everything I learned over the past two days, I gotta say this:
I am blown away at the potential Microstrategy Office has for reporting and what it can do through Sharepoint.
I'm rethinking the direction I want to take The Big Project.
The amount of time this will save in a number of processes is phenominal!


- Posted using BlogPress from my iPhone

Thursday, January 21, 2010

The biggest, most complicated project of my entire career started 3 months ago.

It was what they actually promoted me to do at work.  And I mostly have the skills to do it.  Unless you count project management as a skill.  And then I don't.


What I'm doing is automating a giant set of processes that are a hugely manual, redundant, labor intensive mess.  Ok, mess is probably an unkind word.  But it's certainly time for an overhaul.

I am starting it out taking what's in Excel, optimizing formulas, eliminating links to outside workbooks, cleaning it and sending the components back to the group that uses it.  The next step is to use our SharePoint site to get the team that uses these workbooks into the habit of going in & out of that instead of emailing things around for approval.  Once I can get them into that mode of workflow, I'm planning on building the necessary tables in Access, publishing it into the SharePoint location, and then designing the components in Infopath.

Oh, and I'm not a programmer.  Every day I'm grateful for Google!