May 7

Oz’s Memories from PASS BAC 2015

0  comments

Before the memories of the PASS Business Analytics Conference 2015 completely fade away, I want to thank the people who made the conference happen. Lots of great folks worked behind the scenes to make the Conference work: Leeza Zelmer, Teresa Cheung, Denise McInerney, Jen Underwood and Jen Stirrup.

2014-07-16_19-22-332

It was a pleasure to meet fellow Chicagoan, Michael Pamphlet, Microsoft Program Manager and Customer Insights Driver. Our paths have crossed before, and I really appreciate his mission to uncover more ways to help people get the most from Excel.

2014-07-16_19-22-332
Scary DBA, Grant Fritchey & SQLRockStar Thomas LaRock were a blast to talk with. Through our conversations, and the general mood of the Conference, I came away with a solid sense that we’re truly on the same team. Whatever our respective BI tools are, we just want clean, useful data.

2014-07-16_19-22-332
And then there were all the great Excel folks whom I was able to meet–many for the first time.

Chandoo wearing Oz's steampunk hat.
It was a pleasure to have Chandoo wear my hat. Maybe some dashboarding magic will rub off on me.

 

szilvia
Szilvia Juhasz: the Excel High Priestess. (Wearing my hat)

 

IMG_20150421_140725
Minie Park and Dipak Bhudia of Clear Analytics.
ExcelTV
Me, Szilvia Juhasz, Rick Grantham and Jordan Goldmeier (Szilvia wearing my other hat)

 

MOST MEMORABLE: “DRAW A PICTURE!”

One thing that sticks with me is Mico Yuk‘s keynote presentation. MicoYAs she closed, she urged us to do more communication with pictures. “It doesn’t have to be pretty. Draw a picture on a napkin, take a picture of it and send it to your client.”

Sometimes when processes fail or a solution isn’t making sense in someone else’s mind, or we even need to get something straight in our own mind, it helps to step and draw or make a diagram. Words and numbers are don’t easily translate a story and the level of drama that does or doesn’t exist.

Mico told us that we know this already. We know how much pictures can articulate. So, let’s do it. Mico has given us permission!

Here’s a drawing I used to envision where and how data gets messed up. It starts somewhere out in whatever we call reality. Data is collected and converted into data which eventually shows up in the form of a report. Before the reports, there are definitions, business rules, and interpretations and other filters. They are all opportunities for data corruption.

 

real world

Again, thanks to everyone who participated in the PASS Business Analytics Conference 2015. I hope our paths continue to cross, and we keep up the battle against crap data.

 

 

Oz Du Soleil
Latest posts by Oz Du Soleil (see all)

Tags

BI Brainz, draw a picture, Grant Fritchey, Michael Pamphlet, Mico Yuk, PASS Business Analytics Conference, PASSBAC, Thomas LaRock


You may also like

April 9, 2011

How to Create a Rollover Effect in Excel: Execute a Macro When Your Mouse is over a Cell

October 26, 2014

Monte Carlo Simulation Formula in Excel – Tutorial and Download

September 17, 2012

The Excel Rollover Mini FAQ
{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Free 24 Excel Tips Guide

Discover the secrets to Excel efficiency with our free guide: '24 Proven Microsoft Excel Tips to Help You Save Time'

A humble gift from us to you, to make your Excel journey smoother and more productive. Grab your copy now and start mastering Excel like never before!

>