Tag Archives: Business Intelligence

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. Here’s a video showing how to re-categorize the data quickly and easily. It uses a few formulas, and we have videos showing those in detail. Continue reading

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. I learned three things by Watching Criminal Minds. Keep files on people. Make notes during and after meetings. Track down all leads. Continue reading

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

OLAP – The Business Intelligence Podcast [BIP]

This podcast can be found in iTunes by searching for “Business Intelligence Podcast” in this 22 minute show we cover: How to better present your purpose by switching the order, how OLAP can unclutter your job, and how we saved someone’s life by figuring out how to count colored rows in Excel. Continue reading

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

Business Intelligence Professionals Are Like Batman

Business Intelligence Professionals Are Like superheroes because they want to keep their anonymity and they pass on their information for others to respond to. A good metaphor is Police Commissioner Gordon and Batman. Continue reading

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

The Art of Charting in Excel

As a Business Intelligence professional you need to know how to make a good chart in Excel. A good chart can “land” you the client, separate you from other vendors, or make your message to management extremely persuasive. This VIDEO shows you EXACTLY how to create good Microsoft Excel charts. Here is part 3 of a 3 part series on how to create compelling charts in Excel. Continue reading

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

Confounded new tool, Whippersnappers, and why the new Excel is great!

Change is hard for people. People spend over half of their energy just trying to keep things the same. Then came “the new” Excel. Here are our favorite new features.. Continue reading

Posted in Best Practices, Communication, Excel, Purpose | Tagged , , , , , , , , , | 2 Comments

Diminishing Returns – The Business Intelligence Podcast [BIP]

I had a rare opportunity to speak with and get an e-mail from my Internet Business guru. Business term “The Law of Diminishing Returns”. And companies around the world spend up to $100 billion a year to train employees in the skills they need to improve corporate performance… But training typically doesn’t have much impact.” Find out why this happens? Continue reading

Posted in Best Practices, Communication, Podcast | Tagged , , , , | 2 Comments

How to Create an Excel Chart that Amazes

A good chart can “land” you the client, separate you from other vendors, or make your message to management extremely persuasive. This VIDEO shows you EXACTLY how to create good Microsoft Excel charts. Here is part 2 of a 3 part series on how to create compelling charts in Excel. Continue reading

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

The best office holiday gift for your boss or coworker

The challenge was finding a gift that was not too showy, but would be remembered. Not too expensive, but display quality. After a lot of thoughtful research, I found a great gift… A pen. No, really, a very cool pen. For starters it’s historical. Pens were given by Presidents George Washington and Harry Truman and also used in Space. Continue reading

Posted in Best Practices, Communication, Presentations, Uncategorized | Tagged , , , , , , , , , , , , | 3 Comments

How to Create Compelling Charts in Excel

A good chart can “land” you the client, separate you from other vendors, or make your message to management extremely persuasive. This VIDEO shows you EXACTLY how to create good Microsoft Excel charts. Here is part 1 of a 3 part series on how to create compelling charts in Excel. Continue reading

Posted in Excel, Presentations, Video | Tagged , , , , , , , | 3 Comments