- 377
- 1 372 475
Startup Akademia
United States
Приєднався 27 кві 2015
Startup Akademia helps management consultants and business analysts do their work fast and efficiently.
Subscribe to our channel to learn how more about:
1. How to define strategy and innovate your business model
2. How to create specific analysis in Excel
3. How to create presentations on the level of top management consultants
4. How to create financial models in Excel
Subscribe to our channel to learn how more about:
1. How to define strategy and innovate your business model
2. How to create specific analysis in Excel
3. How to create presentations on the level of top management consultants
4. How to create financial models in Excel
When do you create the Pitch Deck?
Let’s see why it is a good idea to create a pitch deck. This movie is a part of my online Investor Pitch Decks for Management Consultants: bit.ly/PitchDecksMC
Check also my other movies devoted to this topic:
1. How to create a presentation: badassconsultants.com/2018/08/24/how-to-create-a-great-management-consulting-presentation-in-practice/
2. Top Management Consulting Tools and Frameworks: badassconsultants.com/2018/11/21/top-management-consulting-techniques-tools-and-frameworks/
Check also my other movies devoted to this topic:
1. How to create a presentation: badassconsultants.com/2018/08/24/how-to-create-a-great-management-consulting-presentation-in-practice/
2. Top Management Consulting Tools and Frameworks: badassconsultants.com/2018/11/21/top-management-consulting-techniques-tools-and-frameworks/
Переглядів: 61
Відео
What is a Pitch Deck for Investors?
Переглядів 5914 днів тому
Let’s see what a Pitch Deck is and what purpose it serves. This movie a part of my online Investor Pitch Decks for Management Consultants: bit.ly/PitchDecksMC Check also my other movies devoted to this topic: 1. How to create a presentation: badassconsultants.com/2018/08/24/how-to-create-a-great-management-consulting-presentation-in-practice/ 2. Top Management Consulting Tools and Frameworks: b...
How to Fix the Healthcare System - Hacks to treat more patients.
Переглядів 1716 місяців тому
Let’s see how you can treat more patients in the Healthcare System. We will use some hacks that will improve the system. This movie is a part of my online course Essential Excel for Management Consultants available with a big discount: bit.ly/HealthcareSystemHacks Check also my other movies devoted to the sales and marketing: 1. Management Consulting Tools, Frameworks and Techniques: badasscons...
How to calculate weighted average in Excel - using SUMPRODUCT function
Переглядів 3288 місяців тому
Let’s see how you can use the SUMPRODUCT function to calculate the weighted average. This movie is a part of my online course Essential Excel for Management Consultants available with a big discount: bit.ly/EssentialExcelUA-cam Link to the file shown in the video: www.dropbox.com/scl/fi/dsutnyq2yt49ayxun3fjd/Sumproduct-function-Empty.xlsx?rlkey=bvprvvmu7rrvarg8nladhov5o&dl=0 Check also my other...
How to use SUMPRODUCT function - calculate revenues with 1 function in Excel
Переглядів 1098 місяців тому
Let’s see how you can use the SUMPRODUCT function. This movie is a part of my online course Essential Excel for Management Consultants available with a big discount: bit.ly/EssentialExcelUA-cam Link to the file shown in the video: www.dropbox.com/scl/fi/dsutnyq2yt49ayxun3fjd/Sumproduct-function-Empty.xlsx?rlkey=bvprvvmu7rrvarg8nladhov5o&dl=0 Check also my other movies devoted to the sales and m...
Financial Modeling in Excel - How to model revenues
Переглядів 1398 місяців тому
Let’s see how you can model the revenues of different firms in Excel. This movie is a part of my online course on financial modeling: bit.ly/FinacialModelsMC Access to the file shown in the movie: www.dropbox.com/scl/fi/xyq58lrukmjxq8w17dsqu/How-to-model-Revenues-v-4.xlsx?rlkey=fhrcc2ji7ksi903mdhunnumoy&dl=0 Check also my other movies: 1. Modeling Capex and Depreciation in Excel: ua-cam.com/vid...
Digital Transformation in Retail - How it is done
Переглядів 5699 місяців тому
Let’s see how digitalization is done in Retail. This movie is a part of my online Digital Transformation for Management Consultants: bit.ly/DigitalTransformationMC Check also other resources: 1. How to model in Excel Retail business: ua-cam.com/video/e_3HymWbj8w/v-deo.html 2. How to organize Performance Improvement Projects in Retail: ua-cam.com/video/yYTB45S1ovI/v-deo.html
Monthly Recurring Revenue (MRR) - What it is and how to use it
Переглядів 20610 місяців тому
This movie is a part of my online Subscription Business Models for Management Consultants: bit.ly/SubscriptionBusinessMC Check also other resources: 1. Drivers of Subscription Models: ua-cam.com/video/98r5hwvuC0U/v-deo.html 2. Examples of Subscription Models: ua-cam.com/video/m6UlzswofSw/v-deo.html 3. How to estimate CAC: ua-cam.com/video/W9066SyJW0g/v-deo.html 4. E-commerce financial model: ua...
Examples of Subscription Businesses
Переглядів 183Рік тому
This movie is a part of my online Subscription Business Models for Management Consultants: bit.ly/SubscriptionBusinessMC Check also other resources: 1. Drivers of Subscription Businesses: ua-cam.com/video/98r5hwvuC0U/v-deo.html 2. How to estimate CAC: ua-cam.com/video/W9066SyJW0g/v-deo.html 3. E-commerce financial model: ua-cam.com/video/NjQrW dfm0/v-deo.html 4. Retail financial model: ua-cam.c...
Drivers of Subscription Models
Переглядів 258Рік тому
Let's see what drives the subscription business models like SaaS business, Netflix, mobile phone operators. This movie is a part of my online Subscription Business Models for Management Consultants: bit.ly/SubscriptionBusinessMC Check also other resources: 1. How to estimate CAC: ua-cam.com/video/W9066SyJW0g/v-deo.html 2. E-commerce financial model: ua-cam.com/video/NjQrW dfm0/v-deo.html 3. Ret...
How to Increase the Customer Lifetime Value
Переглядів 358Рік тому
In this movie, I will show you some examples of how to increase the Customer Lifetime Value This movie is a part of my online E-commerce for Management Consultants: bit.ly/EcoomerceMC Check also other resources: 1. Customer Lifetime Value: ua-cam.com/video/Yjaee5klYi8/v-deo.html 2. How to estimate CAC: ua-cam.com/video/W9066SyJW0g/v-deo.html 3. Customer Acquisition Cost (CAC): ua-cam.com/video/...
Payback Period - What it is and how to calculate it
Переглядів 551Рік тому
In this movie, I will explain to you what we mean by Payback Period/Time This movie is a part of my online E-commerce for Management Consultants: bit.ly/EcoomerceMC Check also other resources: 1. Customer Lifetime Value: ua-cam.com/video/Yjaee5klYi8/v-deo.html 2. How to estimate CAC: ua-cam.com/video/W9066SyJW0g/v-deo.html 3. Customer Acquisition Cost (CAC): ua-cam.com/video/7G_Df-Ho7Rg/v-deo.h...
How to use ChatGPT for market research during consulting projects
Переглядів 1,7 тис.Рік тому
In this movie, I will explain how you can use the ChatGPT for analysis of competitors This movie is a part of my online Market Research for Management Consultants: Check also other resources: 1. How to conduct market research during consulting projects: badassconsultants.com/2019/02/19/how-to-conduct-market-research-during-consulting-projects/
What is Customer Lifetime Value (LTV or CLV) and how to calculate it
Переглядів 487Рік тому
In this movie, I will explain to what we mean by is Customer Lifetime Value This movie is a part of my online E-commerce for Management Consultants: bit.ly/EcoomerceMC Check also other resources: 1. How to estimate CAC: ua-cam.com/video/W9066SyJW0g/v-deo.html 2. Customer Acquisition Cost (CAC): ua-cam.com/video/7G_Df-Ho7Rg/v-deo.html 3. E-commerce financial model: ua-cam.com/video/NjQrW dfm0/v-...
Customer Acquisition Costs (CAC) - Definition and how to calculate them.
Переглядів 603Рік тому
In this movie, I will explain to you what we mean by Customer Acquisition Costs (CAC) This movie is a part of my online E-commerce for Management Consultants: bit.ly/EcoomerceMC Check also other resources: 1. How to estimate CAC: ua-cam.com/video/W9066SyJW0g/v-deo.html 2. E-commerce financial model: ua-cam.com/video/NjQrW dfm0/v-deo.html 3. Retail financial model: ua-cam.com/video/e_3HymWbj8w/v...
What is Agile? Agile vs Waterfall in Project Management.
Переглядів 630Рік тому
What is Agile? Agile vs Waterfall in Project Management.
How to Estimate Tasks Duration (Time) for Projects
Переглядів 4,3 тис.Рік тому
How to Estimate Tasks Duration (Time) for Projects
How to Clean Data in Excel, using Power Query
Переглядів 4,9 тис.Рік тому
How to Clean Data in Excel, using Power Query
How to Combine Data From Multiple Worksheets into a Single Worksheet in Excel using Power Query
Переглядів 722Рік тому
How to Combine Data From Multiple Worksheets into a Single Worksheet in Excel using Power Query
What is a Project? A guide for Management Consultants.
Переглядів 329Рік тому
What is a Project? A guide for Management Consultants.
What is a Milestone in Project Management?
Переглядів 1,9 тис.Рік тому
What is a Milestone in Project Management?
How to add a Column from Examples in Power Query/Excel without any formulas (AI elements in Excel)
Переглядів 404Рік тому
How to add a Column from Examples in Power Query/Excel without any formulas (AI elements in Excel)
How to add a Conditional Column in Power Query (like IF function in Excel)
Переглядів 725Рік тому
How to add a Conditional Column in Power Query (like IF function in Excel)
Unpivot Data in Excel (Convert columns to rows in Excel) using Power Query
Переглядів 3,5 тис.Рік тому
Unpivot Data in Excel (Convert columns to rows in Excel) using Power Query
How to define the problem in Six Sigma
Переглядів 1,2 тис.Рік тому
How to define the problem in Six Sigma
@StartupAkademia Dear Coach We hope this message finds you well. We are YAGI TEAM, and we recently had the pleasure of reviewing your course on Udemy. We were truly impressed by its quality and appeal, which we believe has significant potential for increased sales with the right promotional strategies. We would be delighted to discuss how we can assist you in elevating your course's profile and achieving the success it deserves. Best regards YAGI TEAM
here in 2024 tysm
ye thanks dude
Why is it that Excel doesn't do this automatically? The way it is "reversed" should have been the default way.
Very useful - thank you!
Their business model is to acquire real estate by selling junk food.
That was really helpful
an example would help us to understand better 🙂
Thanks. You have already 3 examples on the channel: Retail: ua-cam.com/video/qLyO9PLf9Wo/v-deo.htmlsi=gNDv3MUw0kXTKRcr FMCG:ua-cam.com/video/PfFDF6LRoBo/v-deo.htmlsi=64CwWimnFKxuceCO Logistics: ua-cam.com/video/xryyud190Yw/v-deo.htmlsi=3JiFeu3djXVSqk9d
❤❤❤
I really wonder who came up with the input output KPI lingo. I have a fundamental issue by calling something "output" but meaning "outcome".
This is wrong. Business analyst doesn’t have to be a project managemer infact thats a downgrade for them
2 min 20 looks like an attitudinal dataset e.g. based on a survey rather than a behavior. Not sure how you'd measure satisfaction without a survey.
Hi. Thanks for the question. If you want to do the behavioral segmentation, you usually have to have a direct access to customers e.g., software, retail, e-commerce, marketplace, and games, some types of hardware. This enables you not only to get data on the behavior but also you ask at-scale questions like how satisfied you are with the product. So you don't have to do a formal survey, you can just ask the customer how happy with the product the customer is
Thanks so much...
Very helpful.! Thanks!
"The guy cutting the cheese" :)
Awesome, thank you!!
Thanks. I was just enquiring if you can do the whit space analysis based on multiple products for the same with multiple products? And to add, how can I get such a whitespace analysis template?
Hi. You would have to make the analysis for each and every product or category of products separately. For various reasons, it may look different for every product. When it comes to templates. I recommend going to the course mentioned in the description. You have this analysis there as well as 10 different examples. Have a great day!
Sir my f4 key is not working
This may be caused by multiple things. Most likely you have some specific settings that don't allow you to use the F4 or simply the key does not work. I am afraid I cannot help you with that.
Try press fn+f4 at the same time or try windows button+f4 at the same time
Tq❤ it helped keep😘@@ssami.1487
@@ssami.1487thanks
@StartupAkademia I am delighted and well impressed with your Udemy course. We are committed to enhancing enrollments, garnering positive reviews, and maximizing revenue. I am eager to explore tailored strategies to further elevate the course. I look forward to discussing this exciting opportunity with you
It works awesome, thanks! :D
I'm happy to hear that. Have a great day!
@StartupAkademia Could we schedule a professional discussion regarding your Udemy course? Specifically, I'd like to explore strategies for increasing your sales by attracting genuine and engaged students who provide positive 5-star reviews. Are you available for a brief call @YAGI TEAM W.W
Uber and Doordash dont belong to McDonald's, but keep going this is interesting and did you do one for the franchises
Hi. Thanks for the comment. I did not say that they belong to McDonald's. What I meant is that they are used by McDondald's as sales channels that help increase sales beyond the reach of their restaurants. When it comes to the Franchisee we still did not do that. However, you can check the overview of the business models of Uber, Facebook, subscription businesses, Netflix, hotels, etc. Have a great day.
@StartupAkademia Thanks, I hope you do too and didn't take this to heart
thanks ! - I seem to continue to get errors saying certain tables or queries are not available - but do not show anywhere ? Further How can I changes the Query Connection to a new Query name ? Seems so simple - bu t this is why MS is so frustrating. I have been using Excel for more than 25 years.
Hi. About the first question I have no idea as I don't know what you did with the source data (e.g., you may have changed the name or displace the file with the source data). When it comes to changing a connection to a new query name you can simply copy the query in the menu on the right (this will copy the whole query) and change its name. Have a look at this around 3:00 at this video where I show how we change a connection into a pivot table: ua-cam.com/video/reKRH6fW1-U/v-deo.htmlsi=RBlnlKCs6HI0ednq&t=183 Check also the video where we show different ways to copy a query: ua-cam.com/video/Sey3uKR7J1M/v-deo.htmlsi=HbYzNUx257MTyyiL
@@StartupAkademia I think the CACHE may be part of the issue... who knew ! thansk !
Concise and to the point - thank you!
Thanks for the nice words :) Take care
Thanks Asen.
I'm happy that you liked it! Take care
Brilliant video and very well described.....
Thanks for the nice words :) I'm happy you liked it. Take care
At 0:56 he selects all of the points and says,"You trazfirst the data points." ????? How did he select those?
Hi. You just press on one of the data points to select them. Usually, as a default Excel will select the whole series of data. On the second click, Excel will limit the choice to only one specific data point.
I need help on school scope statement
I hope this video will help.
Value from cells option is missing??
Strange. what version of office or Excel you have?
Hello, I was wondering if I found the right maturities for this problem since I would need them to create the right constraints. An investment firm has $1 million to invest in four different options - stocks, bonds, certificates of deposit, and real estate. The firm wishes to determine the mix of investments that will maximize the cash value at the end of 6 years. Opportunities to invest in stocks and bonds will be available at the beginning of each of the next 6 years. Each dollar invested in stocks will return $1.20 (a profit of $0.20) 2 years later; the return can be immediately reinvested in any alternative. Each dollar invested in bonds will return $1.40 after 3 years and the return can be reinvested immediately. Opportunities to invest in certificates of deposit will be available only once at the beginning of the second year. Each dollar invested in certificates will return $1.80 four years later. Opportunities to invest in real estate will be available at the beginning of the fifth and sixth year. Each dollar invested will return $1.10 one year later. To minimize risk, the firm has decided to diversify its investments. The total amount invested in stocks cannot exceed 30% of total investments. The firm’s management wishes to determine the optimal mix of investments in the various alternatives that will maximize the amount of cash at the end of the sixth year. Below are the maturities I jotted down from what I gathered from the problem. Choice ROI Maturity Stocks 1.2 2 years Bonds 1.4 3 years CDs 1.8 4 years Real Estate 1.1 5 years Real Estate 1.1 6 years
Great video, just a suggestion - kindly zoom the video while recording. I had a hard time looking at the formula.
Thanks for the suggestion. I will zoom in next time! Take care.
@@StartupAkademia Thank you.
This was brief and helpful
Thanks for appreciating it :) Have a great day!
fantastic content
I'm happy to hear that you liked it :) Chek my other videos as well. Have a great day!
Informative
I'm happy to hear that. Have a great day!
thanks
my professor really doesn't like the triangles, he made the square where he added a new variables which is quality.
Interesting approach. The problem is how you measure it :) In a sense the quality is in the scope - you have to do what you promised to do, which also entails doing things at promised quality!
@@StartupAkademia this is how i see it too. just shared my professor opinion. he teaches software engineering for computer science
@@lukmanalghdamsi3189 Probably he has a point. Although, I still don't know how he wants to measure
Thanks 😊
thank you just save me some stress now
I'm happy to hear that :) Take care
Cant thank you enough for this trick :-)
Thanks for the nice words. Tha means a lot to me! Take care and have a great day!
Beautiful explanation but quote a challenge to explain further. wish you could've explain more.
Well. I am not sure what you want to know. If you have further questions please let me know. It will help us prepare content in the future. I recommend checking the post we did on segmentation: badassconsultants.com/2021/12/18/essential-segmentation-methods-for-management-consultants-business-analysts/ It should help you
Awesome thank you!!
Thanks. I'm happy to hear that. It means a lot to me! Have a great day
you don't explain in which prioritiy you work ?
Hi. At the end of the video, I show the lists of todos that I use
Poifect. That helped a lot
Thanks for the nice words. I'm happy to hear that!
Is there a production planning software that can do this?
Some ERP/MRP systems have a module that enables finding the optimal sequence, yet they are not usually good so Production Planners use for that in-house made solutions (quite often Excel-based)
Thank you!!
I'm happy to hear you liked it!
Thank you! I haven't had to do this in a while so it took me about 30 minutes before i came to youtube for help.
Thanks for the nice words. I am happy to hear that it helped save some time. Take care and have a great day!
Great thanks for your help, you saved a lot of time for me
Thanks for the nice words. I am happy to hear that it helped save some time. Take care and have a great day!
Thanks. That was a huge help!!
I'm happy to hear that. Have a great day
hi helo! is there a way to do this but with many graphs all at once or i have to go one by one?
Hi. You have to go one by one. Excel treats every chart as a separate entity
@@StartupAkademia hi! Thank you for replying ☺️ guess now i have 400 graphs to sort
@@bce6936 with so many graphs you may consider trying scripts or VBA to automate
this is great
Thanks. I am happy to hear that it helped! Take care