2011 Was About Changing Your Mind

Girl looking at shoes and trying to decide2011 was about changing your mind. Radical decisions were made… and then changed.  Big decisions don’t just affect you, they affect everyone around you.  In the past these decisions were kept quiet until you were “sure.”

But not last year…

Why the change? What happened that caused this change?  Is it because:

  1. Companies are itching to “make something happen” in a down economy?
  2. Do we have management that’s lost its ability to make a decision?
  3. Are we getting to a point in business where we’re being transparent with our customers, and as a result we see what’s normally been discussed behind closed doors?

Here are a few examples to think about:

Netflix example:

In 2011 we saw Netflix change their mind.  First Netflix was going to split the business.  An announcement went out that saying they were going to take the “mail in DVD” and separate it from the “instant streaming to your device” business.  They planned on charging separately and having totally different websites to go to and charge your credit card twice.  http://blog.netflix.com/2011/09/explanation-and-some-reflections.html

This caused a huge uproar, including 5,000 comments on their blog.  One classic comment said something to the effect that, “you shouldn’t separate bread from a peanut butter and jelly sandwich because it’s a separate product… the whole is worth more than the sum of its parts.”  Netflix was smart enough to rethink the decision and they changed their minds and kept the business together.

http://blog.netflix.com/2011/10/dvds-will-be-staying-at-netflixcom.html

HP example:

HP announced it would not sell its computer business.  The new CEO had to make a decision quickly.  After looking at “the numbers” and other research, the computer business looked profitable.  So a decision was made.

http://www.zdnet.com/blog/btl/hp-were-keeping-the-pc-unit/62081?tag=nl.e539

Then HP changed its mind. The computer business was for sale.  Whether this was good decision or not, time will tell.  What is amazing is the quick change of mind, especially with all the impact a kind of decision like this would have.

http://online.wsj.com/article/SB10001424052970203687504577002144041676680.html

Conclusion:

Part of the reason things changed and then changed back is that we’re seeing everyone respond faster to new information.  In the past updates / polls / customer feedback took longer to get and analyze.  Now it can happen with a surveymonkey.com survey sent to Facebook.

Think of how quickly you can change a reporting to management. It’s a quick modification to a spreadsheet and an e-mail saying, “things have changed.”  Or if you’re thinking ahead a little more you’re doing things like:

  • Sending hyper links to the report, allowing you to change the report without sending an update
  • Sending people to a webpage that has the changes or disclaimers of the report

Now that I think about it, maybe 2011 wasn’t about changing your mind. It was about responding to information faster.

Do you have more examples?  Think there was a different reason?  Share your thoughts in the comments below.

Photo Credit: inafrenzy

Share
Posted in Best Practices, Purpose | Tagged , , , , , | Leave a comment

How to learn faster and get up to speed

We don’t focus on it.

Sometimes because we’re afraid, other times because we don’t know where to start.

If you come from the Information Systems (IS) side, it’s common.

If you came from the Business side, the idea of writing code sounds either daunting or frustrating.  Learning new programs and languages are common for developers, but for the Business Intelligence professional it’s something we may only dabble in.

We want to highlight an amazing tool for learning languages and programs and show you a specific example of how to use it.

The Amazing Tool

You’ve been checking out YouTube for years to see things like the Lassi Hurskainen Angry Birds or Jedi Kittens, but YouTube has another amazing side (one of many really) and that is that a bunch of education and learning videos are out there.

Real Life Example

I had to get up to speed on Microsoft’s Sql Server Integration Services (SSIS) and knew nothing about it. So I started searching out videos and YouTube and found Steve Fox making amazing videos.  After 2 hours of watching and doing, I was able to build my first package.  Thank you Steve!

Here’s a video that saved me hours of reading and researching:

How to build a simple SSIS package. Part 1 of 3.

Share
Posted in Best Practices, Video | Leave a comment

The First Rule When Networking With People

Picture of two people talkingMany times, people begin a project or a task without considering the purpose or desired outcome. From time to time, I will go to a fast-food restaurant. I realize that the food is generally not 100% organic. The menu does not have steak and lobster or fine wine. When I go to a fast food restaurant, I am not there for the excellent cuisine. I have one desired outcome – a full belly. More often than not, that is exactly what I get.

What happens when you work with someone who desires an outcome that opposes your own? At the very least, it can lead to frustration. If you go to a fast- food restaurant and you encounter an employee who desires only a paycheck, it is quite likely that the service you receive will be substandard. I am not suggesting for even a moment that employees should not seek a paycheck. In fact, my first job in high school was in the fast-food industry and I learned many valuable lessons. However, if an employee is focused only on a paycheck, then the only time he or she feels “successful” is payday. In the 1980′s when the minimum wage was only $3.50, the happiness of a restaurant paycheck was fleeting at best. Even though the wages have increased, the measure of happiness from a fast-food paycheck is just as temporary.

My experience working in a fast-food restaurant was mostly pleasant. As a high school student, I had three goals that kept me engaged. The paycheck was only one goal. This goal directly benefited two entities – first FICA and then me. Secondly, I wanted to help the business. My diligence helped the company to be more productive and profitable. They liked me so much that I quickly became the only one allowed to take out the trash – at least it seemed that way. Finally, I had a goal to serve the customers. I truly believed in the golden rule. If my friends stopped by to eat, I would gladly give them more food than they purchased. After all, that’s what I would want them to do for me.

Guilt Insurance

Even though I was slightly misguided, I was truly involved in mutually beneficial transactions. I have learned since the days of high school to grow beyond mutually beneficial deals. It was mutually beneficial to my friends and me to give away free food. I got the recognition I was seeking and they often returned the favor when I visited the restaurant on their shift. From the employer’s perspective, however, it was just plain stealing. I have adopted the philosophy taught by Napoleon Hill in his famous book, “Think and Grow Rich.” It says, “I will engage in no transaction that does not benefit all whom it affects.”

I call this Guilt Insurance. As long as I live by this philosophy, I sleep well at night. I never worry about remembering who heard my comments because I make an extra effort to exchange words that will benefit all whom they affect. In any business endeavor, there are three ways to weigh the benefits:

The Con

All for you and none for others. If you are short sighted, you may consider this to be the makings of a good deal. While I am highly in favor of getting a good deal, this scenario does not fit my description of one. In fact, this is the essence of what I call a genuine scam. One reason Ponzi schemes and pyramid schemes are harmful is that some of the unsuspecting “investors” are guaranteed a loss by definition. The money people receive comes from “investors” who are being cheated instead of from real profits. The hidden hook is greed that induces someone to throw away money in one of these scams. People who live this way are con artists.

The Victim

All for others and none for you. Some people are in the habit of contributing without expecting a benefit. Giving is an important part of life. The reality is, often times the donor does realize some benefit, even if it is not immediate or tangible. One example is a tax deduction for any monetary gifts. Other benefits may be emotional, such as a feeling of fulfillment or altruism. When you realize none of these benefits and the “benefits” go to others, you are commonly known as a victim. Some are victims by circumstance; others are victims by choice.

Win Win

Benefits for all involved. This is what Mr. Hill refers to in “Think and Grow Rich.” In this book, I refer to this as rule number one in networking.

If you are truly a Networker (not a con artist looking for victims) you will live by this creed; I will engage in no transaction that does not benefit all whom it affects. Seeking to benefit all parties involved allows you to network with confidence. You never think twice about asking for anything. You never hesitate to offer assistance. Deep down, you realize that if the person says yes to your proposed business connection, they will benefit as much as you do, if not more. I highly recommend this “Guilt Protection” to insure your network before you build it. This policy virtually guarantees your success.

Kenny Mitchell is our first guest post and is the co-founder of Real Skill Builders, a company that helps individuals and organizations to harness greater productivity through the understanding and application of fundamental success principles applicable in business and in life. Real Skill Builders delivers informative training workshops and lively keynote addresses for businesses and organizations. Learn more at http://www.realskillbuilders.com, call 866-389-0579 or email info@realskillbuilders.com
Photo Credit: The US National Archives
Share
Posted in Best Practices, Communication, Presentations | Leave a comment

The most frustrating question you have to answer all the time

Picture of a Business Intelligence Professional shaking handsWe hear this question all the time. We ask this question. And depending on the scenario it can be really hard to answer. What do you do?

No.  That IS the question, “What do you do?”

For the Business Intelligence professional, you know what’s coming next, “What is that?” it’s either mixed with a smirk because it sounded like you were being evasive, or a doubtful look, because they think it’s some fancier way to say your job, like a custodial engineer or domestic manager of a small labor force. Either way, you analyze how long you have with this person and their level of interest before you respond. Here are three canned responses we suggest.

1. Interest level low and time is short

For this scenario you can say,

“It’s a combination of Marketing, Sales and Information Systems work… slightly geeky, but fun.”

Many of the terms are recognizable and while they may not “get it” they can at least put you into a box and walk away.

2. Interest level high and time is short

For this scenario you want to pontificate and tell them all about your projects and interactions with management and your ownership of processes, but there just isn’t time. We recommend something to this effect,

“It’s a mixture of working with other managers and people in the business to get information and help the company know what it’s doing and where it’s doing it. Think of it like a Special Ops team and fortune teller mixed.”

The last part will stick with them and it puts you in that position of smart and action oriented.

3. Interest level high and there’s some time

Obviously, this is our favorite scenario because we get to talk about ourselves. At this point, we will remind you that all conversations about work and your job are potential interviews either as a customer or possible employer, so don’t bore them. Lately we’ve noticed if you mention too many IS items, then they will quickly put you into a box “Oh, he does reporting and is a computer guy”. This may be okay for how you want to be portrayed, but Business Intelligence is about making solutions and helping the company get smarter. So in this scenario we usually will start with,

“it’s a good industry to be in, the real gist of this type of job is to make solutions for those in the company, for example…”

At this point list two of your favorite or recent projects. Then say,

“…there is an Information Systems (IS) bend to the role, but a lot of it is also making the company smarter, i.e. helping sales call on the right people, helping Marketing know what they are doing is affective and helping management make quick and informed decisions.”

If you go any further you’re monopolizing the conversation. Either turn the question to them, or ask what challenges they’ve been having in their business. If you have some solutions then go that route and make sure to get their business card. Always be networking…
Have you found a better phrasing for a Business Intelligence professional? We’d love to hear it, and will try it out at the next office party or afterhours event.

Photo Credit: buddawiggi

Share
Posted in Best Practices, Communication, Presentations | Leave a comment

For my birthday I want…

Children's Birthday

For my birthday I want an ERP license!!!

What if your boss asked you what you wanted for your birthday? And just like when your wife or parents ask, you know you’ll get something like it or the exact thing. In my family it’s been something I’ve worked to make an efficient process. I keep a list of items I’d like, but don’t plan on purchasing right away (nice to have but not needs) on my Evernote account. Then a week or so before I browse the list send an e-mail to my wife and parents.

But back to the question: what if your boss asked you? (Catch: it has to be something business related.)

  • Better support from Business Intelligence?
  • Software that isn’t buggy?
  • Workshifting?
  • Three monitors (everyone has two now…)?

It might be time to keep a list of business wishes, and work them into some goal setting process. What would be on your wish list?

Share
Posted in Best Practices, Communication, Purpose | 1 Comment

How to Create New Categories of Data

This happens all the time; you get a set of data and you realize that whatever category is there, is wrong.  If it’s regions, than there should be 5 regions instead of 8.  If it’s product categories, there’s supposed to be a different grouping.  And of course there are 10,000 rows of data that need changing.

To watch the video showing how to re-categorize the data quickly and easily, click here.

Share
Posted in Best Practices, Excel, Video | Tagged , , , , , , , , , , | Leave a comment

How CBS’s “Criminal Minds” can make you a better Business Intelligence Professional

Watching TV isn’t being lazy… it’s research.

How do you find the person you need to talk to?  What do you talk about with people you don’t meet very often?  How do you remember details that make a difference in getting meetings?  I learned three important techniques by watching Criminal Minds.

Want to be a better BIP? Watch Criminal Minds

1. Keep files on people.

“Office of Unfettered Omniscience – how may I help you, O fortunate one?” (Penelope)

Keep a file on the people you connect with. It is amazingly helpful to remember someone’s drink or food preferences, for example. If a year goes by and you haven’t connected with them, it show that extra bit of caring to suggest going out for a caramel latte instead of saying “let’s get coffee.”

We respond to others that remember details.  Those details tell us the other person was listening to us when we were talking.  Mentioning those details can make a huge impression and helps your requests stand out.  Dentists and doctors do this.  They write down some facts about you in your file, and then when they meet with you they have something personal to talk about with you.  They do it because it really works.

2. Make notes during and after meetings.

“I don’t believe that intelligence can be accurately quantified, but I do have an IQ of 187, an eidetic memory, can read 20,000 words per minute…  Yes, I’m a genius.” (Reid)

I try to write notes after any meeting.  Jotting down preferences and facts (like four older siblings, drink preference, etc).  It does take a few minutes. Others may have moved on to other meetings, or gotten in their car and left the appointment.  But by staying and writing a few notes, you will have saved some critical facts and information that may have a lasting effect.

3. Track down all leads.

“ You’ve got a problem. Deadbolt’s the number one password crack-resistant software out there. You’re gonna have to get inside this guy’s head to get the password.” (Garcia)

“I thought I was calling the office of Supreme Genius.” (Morgan)

When someone mentions a person that may be able to help you or a person that could use your help… follow up on that lead.  I once followed four leads in a row.  I called one person, and we spoke for 10 minutes.  I asked them if there was someone else I should reach out to.  They gave me a name.  I found a number, called them, and we spoke for 10 minutes.  I did the same process over and, after four leads, I had a meeting scheduled with the last person. What was the conclusion? The last person offered me a job before I had even filled out an application.

If I would have stopped at the third lead, I wouldn’t have gotten the job.   Were the conversations with those first three contacts interesting? Not really.  It was more of an exercise in “finding the right person.”  But following up on all the leads produced a happy ending in about the length of an episode of “Criminal Minds.”

Photo Credit: Zap2it

Share
Posted in Best Practices, Communication | Tagged , , , , | Leave a comment

Checklist for Going on Vacation

picture of laptop at beach

Checklist for Going on Vacation

I had a week vacation coming and wasn’t sure “exactly” what week I was going to take. In the rush to get out of the office I didn’t cover everything I should have.  That following Monday, I missed a meeting and had my boss ask me about deadlines.  I and even had some colleagues from Scotland call me while I was making breakfast for my kids.  I realized that I should have had this checklist:

Checklist for Vacations
1.       Know what meetings you need to re-schedule
2.       Know what meetings you can cancel
3.       Turn on your out of office e-mail assistant
4.       Notify people who need to know you’re leaving
5.       Forward your phone to your cell phone

1. Re-Schedule Meetings
Look through your meetings and look at who is attending.  If there are major projects or major “players” attending the meeting, you should reschedule the meeting.  You don’t have to offer an explanation.  “I’m on vacation this week” is not necessary.  You can just say, “Due to schedule conflicts, I’m moving this meeting.”  Or just leave it at “Rescheduling.”  It’s up to you how much you want your personal life involved at work.

2. Cancel Meetings
It’s going to be crazy enough when you get back.  You don’t have to reschedule every meeting.  Some can be deleted.  Realize the importance of your time and priorities when you get back.  Think to yourself, “What absolutely has to get done when I get back?”  If it doesn’t pass that test, then cancel the meeting.

3. Out Of Office E-mail Assistant
This is a checklist.  We all know to do this, but we forget.  So here are a few items to include in your out of office.

  • When you will be back
  • Whom to contact in your absence
  • What to do in an emergency

4. Notify People
Even if you have your out of office e-mail set, you still need to contact a list of people who need to know you’re leaving.  Do it in one e-mail or make the e-mail up and send it to each person separately.  Either way, you have to notify some people.  Here’s a brief list that you can customize:

  • You boss will need the reminder
  • Anyone you listed in your out of office e-mail
  • Major stakeholders of projects you’re working on
  • Anyone depending on a deadline you’re going to miss

5. Forward Your Cell phone
This is more of a philosophical choice for you.  But most companies have a tech support group that can set up this option for you.  Any call that goes to your work phone can be forwarded to your cell phone.  Getting a voice mail box of 50 items when you get back is enough to make you just ignore them all.  If the calls go to your phone you have the choice ignore or take them.  Usually these calls will be short and you’ll save yourself a bunch of useless work when you get back.  I say “useless” because people will call you, leave a message, and then send you an e-mail realize you’re on vacation and then figure it out themselves.  This leaves you with a pile of follow up items that were all canceled.  Take the call, tell them you’re on vacation and everyone moves on.

If you have more items that need to be added, please share in the comments.

Photo credit: Spree2010

Share
Posted in Best Practices | 10 Comments

OLAP – The Business Intelligence Podcast [BIP]

(File size: 21Mbs, Show Length: 23 minutes)

Awesome theme show music by: Matt West – “Let’s Move”

Show Notes:

Found Our Purpose at TED
TED video by Simon Sinek: How great leaders inspire action.  How you present information to reach different parts of the brain first.  What is the purpose of www.getreporthelp.com?


OLAP (Online Analytical Processing

What is the definition of OLAP? What OLAP does for a business and the mindset of OLAP and how that can unclutter your job.

Count Colored Rows

Figuring out how many rows are colored on an Excel spreadsheet can be unbelievably frustrating.  This video shows you how to do it and save you hours of aggravation.  @Pilchy was ready to put a shotgun to his head because of this problem… I guess you could say we saved his life.

Questions or comments for this, or the next show? Is there a reporting emergency?  Or have you always wondered if there was a better way of doing something?  Share with the group in the comments below!

Share
Posted in Best Practices, Excel, Podcast, Presentations, Purpose | Tagged , , , , , , , , , , , | Leave a comment

Business Intelligence Professionals Are Like Batman

I made some slides for a sales summit and received a lot of positive feedback. In fact, the sales manager owes me lunch. But something happened at the meeting that broke an unspoken rule…. they gave me credit on stage.

From the Shadows…
Our work is best done in the shadows. We help a business use and depend on numbers so that they don’t have to make decisions based simply on a “gut feeling.”  We make the information accessible and digestible.  Making a manager shine or saving the company money can be very powerful, but getting open credit is much like having a board member of Wayne Incorporated telling the shareholders that Bruce Wayne is Batman.

At the last moment…
Giving vital information to a manager instead of publishing it yourself creates a safety net.  Batman doesn’t go public with information.   Batman brings information to Commissioner Gordon who then decides what to do with the information.  Commission Gordon never says, “Batman said we should do….”  He makes the decision and responds.  Having another person validate and respond in context of the situation creates a safety net that can save you at the last moment.

The manager may have more information or can connect the information you provide to some other situation in the company.  This will help validate your work and keeps those in charge in the position of knowing the best way to handle the situation.

Once when I published a report showing the ROI on a promotion, the results were not what I expected.  The manager quickly defended the promotion and began to cast doubt on the research.  The next time I did an analysis, I went to the manager with my findings first.  I asked him to put it in context with the other activities of the business, and the result was that he “owned” the findings and presented them.  FYI… in both situations the ROI was negative.

In this example, my safety net was there because I asked the manager to take my information and present it.  That allowed him to check it with the rest of the activities of the business.  If there had been a problem with the information or a flaw in the logic based on some business changes, my safety net would have caught me at the last moment.

Suddenly out of nowhere…

When you’ve earned credibility, managers will respond when you bring up something “from out of nowhere.”  When Batman tells Commissioner Gordon to get a warrant or check someone out, it carries clout. This is because Batman has a track record of delivering the right information at the right time.  This credibility allows him the option to ask for special assistance from Commissioner Gordon.  If the paper boy tells Commissioner Gordon the same information, he may take it or leave it.

If you are short on work, a public announcement may drum up some new customers. But this will mean that you will be doing work that you didn’t ask for. You want to work on things that you are passionate about. You want to focus on things that make a huge benefit to the company. Batman doesn’t give out speeding tickets. He’s looking and working on the big issues. If he were putting tickets on parked cars, he wouldn’t be keeping Gotham safe.

My hope is that those who heard my name didn’t write it down.  If there’s no written documentation, I at least have plausible deniability.

Photo Credit: imdb

Share
Posted in Best Practices, Communication, Presentations | Tagged , , , , , , , , , | 2 Comments