Create a BCG Matrix
ฝัง
- เผยแพร่เมื่อ 14 ต.ค. 2024
- If you've taken business class or familiar with management consulting strategies, you've probably come across this tool called a BCG Matrix. Also known as a growth-share matrix, the BCG matrix was created by Bruce Hendersen in the 70s (founder of Boston Consulting Group). It's a tool that helps you analyze companies or products based on a quadrant that shows growth rate and relative market share. You can actually create this fairly easily on Excel, so check out the video to learn how.
🔔 SUBSCRIBE to my channel ➜ goo.gl/wN3c3p
🏫 Excel Training ➜ www.exceltrain...
📚 Excel Books & Tech Gear ➜ www.amazon.com...
⚙️ Tools: Screencasting ➜ techsmith.z6rj...
⚙️ Tools: Microsoft Office ➜ microsoft.msaf...
⚙️ Tools: TubeBuddy ➜ www.tubebuddy....
📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!
🎁 If you find these videos useful and want to support my channel go to www.buymeacoff...
#excel
#msexcel
#doughexcel
~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
• Convert Table in a PDF...
~-~~-~~~-~~-~
That is massively helpful. I started using fancy bcg matrix, but what you are doing is way better.
Glad it helped!
Thanks, great memory refresher for my school project :)
Wow this massively helpful, i have gotten more knowledge with your explanation..
Thanks james rosita, glad it helped!
Very useful!!!!!!! Thank you so much! You save me on Marketing task!
Glad it was helpful!
Thanks for sharing! Very useful for my class!
Glad you liked!
thanks it's very useful for me.
How do you calculate relative market share and market share of largest competitor?
Why did you reverse the values? Please clarify, thanks.
Thanks so much for taking the time!
Hi Brittany Beaudoin, glad you liked it, thanks for commenting!
Thank you. It helped a lot.
Thanks CREATA CLASSES, glad it helped!
Yes yes , it indeed helped me real big time, thank you. cheers
Glad it helped!
Doug, thank you very much, your tutorial helps me a lot!
Thanks Eduardo Folly, glad it helped!
Thank you so much, this as really helpful
I don't know if you can do something like this for ADL MATRIX and SHELL/DPM MATRIX
Thank you
Hi Abiola Bose, Great suggestion...thanks for the comment!
This helps me much. Thank you so very much
You’re very welcome!
@@DougHExcel you kindly have helped many people concerning this. Thank you from Jakarta. 🙏🏽
Hi doug, you explained so well. I have done it...yahooo
Glad it helped!
Hi Doug, super helpful, thanks! Just a technical question: @4:14 you’ve got relative market share along the x-axis. Then at 9:30 when you are assigning axis labels, you put relative market share as the y-axis label. Is that right?
Good Job Doug!
Thanks!
Thx Doug ! Clear and useful
Thanks Doug....extremely helpful
thank you its a great help...but how to find revenue...is it from the industrial profitability >?
Great explication , Thank you ser
You are welcome
Thank you! Massive help with my assignment
very helpful, many thanks!
Glad it was helpful!
thx for the video, but how can we calculate the market share of the largest competitor?
Find the company total sales(revenue) and divided by the industry's total sales. Usually organizations have this data somewhere in research reports.
Very usefull video ! Is there any way to automatize the label from each product ? Cause im working on 50 products in the same time so ...
Thx for tips, i tryed with VBA but didn't work, I probably failed. Anyway thx for help
I have exactly the same problem. Unbelievable MS doesn't have a way to change the labels automatically in a series formed by (label, x, y, size)
Hi Dimitri Paris, thanks for the comment!
Thanks Doug..very helpful!!!
This is so helpful. Thank you so much!
Hi Amirah Nirwan...you're welcome, glad you liked!
Hi Thanks Doug H.
How do you calculate the market growth?
***** Thanks. It really helps me.
Hi everyone, I have some problems with this matrix, object at the intersection of the line. May be prefer assign this object to one sector? Who can help me?
Thank you very much!
You're welcome!
Thanks!
Thanks
You’re welcome!
Is there a way to match the formatting colour of the sphere to the cell where we have the name, my spheres are vey close together and difficult to distinguish. if i could auto colour them to match my product name it may make the cell more easy but I'm concerned I'll mix it up if i do it by hand. can it be done automatically
Yes but prolly with VBA
thanks for this
Welcome!
what is the equation to get the Relative Market Share?
very helpful, thanks. pls post more about EXCEL graphs :)
You made my day.... Great help.. Thanks
You’re welcome!
Thank you, i have a question, how do you calculated the Revenue ?
Hi kai yutaka, thanks for the comment! For Revenue, depending on your data, you'll have to pull that from either public source of the companies filings (SEC 10K) in the US or for equivalent government documents for non US companies.
Thank you very much for this great effort
Many thanks.. very useful :)
This is brilliant, thanks
thanks ! i have a question, what to do if the product circle falls in the middle of the graphic? means that assumely the middle point of market share is 1.5 and the market growth is 10... if my product has the same amount, what shall i do? thankyou
Hi Cynthia Tirtani, thanks for the comment!
Thanks a lot!
You're welcome! 别客气!
From where did you find the market growth
one ways is to get historical numbers from govt statistics and take a % from a organization historical number or jus find data from some consulting companies
Thanks for the video.. It's great!!
this saved me! thx
Thank you for your sharing
but how to calculate the largest competitor market share?
Hi MC James LI, thanks for the comment! Hi MC James LI, you're welcome!
How to calculate market growth?
Big Thankss!
it helped me but you didnt mentioned how to write low high in the corners???
those are text boxes that are added separately
thanks!
Welcome!
How is it possible that your market share is larger than the largest market share of competitors...
Good stuff!
Thanks Doug
great help!!
Thanks Maurice Baggen, glad it helped!
Thanks a lot!! This what a great help for my marketing courses!
Hi Qat M, glad you liked it, thanks for commenting!
@@DougHExcel very good video 👍🏻thanks a lot
thank you so much. It helps me! :)
Hi Roziana Rifa'e, you're welcome!
Amazing amazing. thumbs up!
Hi Saima iqbal, glad you liked it, thanks for commenting!
do you have videos for creating Grand strategy, IE matrix as well?
Nope, but maybe in the future...
How do we find the market growth
you'll have to find it from consulting org sources or based on past data do something like a regression analysis. See some forecast video for ideas here th-cam.com/users/DougHExcelsearch?query=forecast
@@DougHExcel thanks for the response. I saw a video where the market share was used to determine the growth in the market. The current year over previous year -1 *100.
How is the market growth calculated??
have to get the data of market share from period to period either the company or industry periodical that tracks it
thank you
how to get a mrket growth?
try to find it from consulting org sources or based on past data do something like a regression analysis. See some forecast video for ideas here th-cam.com/users/DougHExcelsearch?query=forecast
THANK YOOOUUUUU omg
You're Welcome!
Good Enough
Hi Shailendra Kumar, thanks for the comment!
LOL, until recently I hadn't realized that Mario updated his favorite way to tackle ED and it's a relief! Although what he previously suggested was pretty good, it was a real pain to follow... I just go'ogled the latest in Volpstein’s Thunderous Erections, it's so much easier and potent now!
안동대학교 화이팅
Hi 민유, 코멘트 주셔서 감사합니다!
Ga paham
Sorry, don’t understand the comment/ question...
@@DougHExcel The meaning is Don't understand. Because english and I don't understand about economi management. That's my language "Ga paham":)🙏🏻
Pfffffff... so adding the labels to each bubble is manual? Seriously?
That's no problem when you have only 4 bubbles. I came to this video for a way to add labels to a chart with over 90 values.
I really appreciate your tips, but I can't believe MS doesn't have a way to add labels directly to a bubble chart. Un-be-lie-va-ble
in Excel 2013, MSFT finally let you do it. Right click Add Data Labels and find the option to choose Values from Cells. Then select your descriptions from a range that is associated with the series.
That would be awesome... I'm using Excel 2016, I just don't find that option.
Let me see if I understand, I click on "Add Data Labels", and it gives me what is in the Y axis as label.
But then I don't find where can I tell Excel where to get the labels from
You won't believe this. This. is. not. available. in. Excel 2016. Damn you Microsoft.
In this article: peltiertech.com/apply-custom-data-labels-to-charted-points/ they explain what you said, but if I go to my Excel I see:
* Series Name
* X Value
* Y Value
* Show Leader Lines
* Legend Key
The "Value From Cells" is not an option in Excel 2016
OK, it is now. I swear the option wasn't avilable, in fact I was copying the screen to send a report to the tech-support guys, but since I had deleted the chart, I recreated it with the total confidence it wasn't going to work, and then it appeared.
Maybe sometimes ventilating in the Internet makes miracles????
Thank you, thank you very much
:-D
Thank you so much!
Thanks
Welcome!
Thank you so much , it really helps me.
Hi radinal hakam, you're welcome!
Thank you so much
Thank you so much !!!
You're Welcome!