All posts by Brandi Wyche

More Excel Resources

If you are like me and plan to continue developing your excel skills even more, this website has some great advanced excel tutorials. For each of the monthly tutorials, there are 6 or 7 advanced tutorials like COUNTIFS, Duplicate removal, or bubble charts.

http://isaacgottlieb.com/tip-of-the-month

I found these tutorials on a comprehensive website called skilledup.com that has a lot of different resources that are worth checking out.

http://www.skilledup.com/learn/business-entrepreneurship/free-excel-tutorials/

From the skilledup.com website, I also found Excel Central and Chandoo especially helpful. Excel Central has great basic through advanced video tutorials and Chandoo is super easy to navigate.

Enjoy these resources for your continued excel development. 🙂

Brandi

Conducting Competitive Intelligence Market Research

As part of my MP project this semester, I am focused on learning how to conduct competitive intelligence market research and tips and tricks on how my work team and I can to do this more effectively and efficiently. On About.com, I came across a 7-step, detailed breakdown of how to conduct Market Intelligence Research. See below.

  1. Determine Your Research Objectives
    • First you must determine your primary and end goal based on audiences who will be utilizing the information
  2. Evaluate Existing CI Data Collection Strategies
  3. Determine CI Data Collection Strategies
  4. Set Up Access and Integration Systems
  5. Establish Analysis and Reporting Processes
  6. Plan Dissemination
Planning
    • Planning for getting your information to the correct audiences – for example, how often will you report?
  7. Write the Story
    • Most market research is best presented to audiences in the form of a story and to do so, your CI audiences should understand how the data was collected and be made confident of that data through corroboration processes.

These were some good tips that I have already started and will continue implementing with my team at work as we continue conducting market research.

http://marketresearch.about.com/od/market.research.techniques/ht/How-To-Conduct-Competitive-Intelligence.htm

The Top-Down Approach to Critical Thinking

In this article, which I found on Business Insider, the author discusses how to be a more effective critical thinker and problem solver. He speaks about how after obtaining a position as a strategy consultant after his MBA, he struggled to solve problems quickly and effectively for clients. A mentor then coached him to “START WITH THE ANSWERS.” This advice that was very foreign to the author at the time. He struggled with this concept but his mentor taught him how to start with the basic structure of a problem they were trying to solve and then develop some hypotheses around that problem based on any given knowledge or prior experience. Then they would put the hypotheses down into a structured diagram with answers that tie to the logic of the problem they were trying to solve. The mentor noted that once they knew the structure of the problem and the possible solutions, they could plan the data that proves or disproves their theories.

This immediately made me think of Issue Trees; a concept I struggled with when first presented to us by Professor Noonan in fall semester. I felt that I could not come up with possible solutions before knowing all of the facts or researching all of the relevant information I needed to try to find the solution. But the mentor in this article also makes a good point that the key to this top-down approach to critical thinking is to not be married to the original answer but by having an original hypothesis or hypotheses, one can begin to focus the data that one collects regarding the solution, as well as begin to socialize the “answers” to illicit feedback and reactions, which can help to hone in on a real and viable solution.

 

Read more: http://www.businessinsider.com/the-better-way-to-solve-problems-in-business-2010-7#ixzz37IYQ5WMo