Magic Formulas of The Data Wizard

Check out these helpful tutorials and reference formulas. If they help you along your journey to mastering data, leave a comment!

Peeling Data out of the Center of a String

Wednesday, November 3rd, 2010

This morning I was presented with a challenge. My friend had 3,500 lines of data that looked something like this: P-ADAMSRES-0253_P-ADAMSRES-0253-001_Base_Fixed P-AESC-1421_P-AESC-1421-001_Base_IF NGPL, Tex_1 P-AMGC-0028_P-AMGC-0028-001_Base_Fixed P-ATMOS-0010_P-ATMOS-0010-001_Base_Nymex Last_1 P-BARBANK-0075_P-BARBANK-0075-001_Base_Fixed She needed the second occurrence of the “P-” from each line, along with the “-001″ or whatever it might be. So from the first line she wanted […]

Comparing Data Sets

Thursday, October 21st, 2010

Last Thursday I had the privilege of teaching a group of division order analysts about the VLOOKUP function. I consider VLOOKUP to be an essential tool for data manipulation, so I knew it would be the primary function I focused on during our short 55-minute class. But I also knew that data is often not […]

Spend your morning sleeping in, not gathering data.

Friday, November 13th, 2009

Ever wonder why some folks get into the office at the crack of dawn? Sometimes it’s because they have something  important that has to be sent to their customers each and every morning, and it takes them a bit of time to prepare whatever that “something” is. Back in 2003 I helped a Gas Scheduler […]

Testimonials

Tuesday, November 3rd, 2009

I am in awe!  That was amazing to watch the automation of a process that takes me forever, be done in under a minute.  Thank you! Melanie F. Your tools are fast, effective and widely used.  Dennis D. Thanks for designing the great tool that you did–if you only knew what a life saver it […]

The Wizard’s Mission

Monday, November 2nd, 2009

At The Data Wizard, our goal is to provide end users with “outside-the-box” solutions for extracting and using data. Our techniques challenge the traditional methods for accomplishing a task. Whether it is an ad-hoc report for management, a weekly calculation of taxes due to the state, or a monthly filing with the government, most users […]

Keep it Data

Saturday, August 1st, 2009

Everyone’s heard of the KISS principle. Introducing the KID principle. How many times have you heard someone say “I need a Report”? If you’re like me the answer is way too often. Over time users have been conditioned to believe that if they just had one more report they could get what they needed. Maybe […]

We’re All Data Manipulators…

Saturday, August 1st, 2009

“When we think about it we’re all just manipulating data. We need to learn how to do it more effectively and more efficiently”   VP Accounting This was part of an introductory speech our accounting vice president gave a room full of accounting professionals one morning just before I put on a four-hour training session.  […]