Tag Archives: Reporting

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

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

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

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

How to Deal with Emergency Reporting Needs… All The Time

I received this e-mail from a Sales Director: “I’m outside this customer’s office, and I have a presentation to make in 10 minutes. Can you make me a couple of slides showing revenue and units for the past 12 months?” Yes, that really happened. Continue reading

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

How to survive the New Year

It’s time to recharge the batteries, do a little site maintenance, and prepare for the exciting New Year. What do you do to reward yourself for a great year of hard work, share with the community? Continue reading

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