The First Rule When Networking With People
Networking with people can be either a huge amount of time, a drain on the other person, or something mutually beneficial. Learn the first rule in networking to start things off right.
Author: Johnny
The most frustrating question you have to answer all the time
Business Intelligence is about making solutions and helping the company get smarter. When you’re asked, “what is that?”, you analyze how long you have with this person and their level of interest before you respond. Here are three responses based on time and level of interest.
For my birthday I want…
What if your boss asked you what you wanted for your birthday? It might be time to keep a list of business wishes, and work then into some goal setting process.
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.
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.
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.
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.
How to Count or Sort Rows by Color
If you’ve had a spreadsheet with many rows colored and other rows left uncolored, then you realize that there is no easy button to sort or count rows that have color. This can be a very time consuming process, unless you use Visual Basic. Here’s one solution that we’ve come up with.
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.
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..