Startup Akademia
Startup Akademia
  • 377
  • 1 372 475
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/
Переглядів: 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...
How to Delete a Query in Power Query
Переглядів 4,4 тис.Рік тому
How to Delete a Query in Power Query
When starting a project is a bad idea?
Переглядів 246Рік тому
When starting a project is a bad idea?
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?
What is Project Scope?
Переглядів 442Рік тому
What is Project Scope?
How to copy a Power Query?
Переглядів 804Рік тому
How to copy a Power Query?
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
Normal Distribution explained
Переглядів 363Рік тому
Normal Distribution explained
How to define the problem in Six Sigma
Переглядів 1,2 тис.Рік тому
How to define the problem in Six Sigma

КОМЕНТАРІ

  • @KehindevictorAkinnawo
    @KehindevictorAkinnawo 2 дні тому

    @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

  • @heatherofficial5703
    @heatherofficial5703 10 днів тому

    here in 2024 tysm

  • @getfuckedbby
    @getfuckedbby 13 днів тому

    ye thanks dude

  • @shailensobhee6191
    @shailensobhee6191 13 днів тому

    Why is it that Excel doesn't do this automatically? The way it is "reversed" should have been the default way.

  • @harryg2354
    @harryg2354 18 днів тому

    Very useful - thank you!

  • @GGTanguera
    @GGTanguera 21 день тому

    Their business model is to acquire real estate by selling junk food.

  • @stevewages
    @stevewages Місяць тому

    That was really helpful

  • @ChimorikaShin
    @ChimorikaShin Місяць тому

    an example would help us to understand better 🙂

    • @StartupAkademia
      @StartupAkademia Місяць тому

      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

  • @tonypasma1707
    @tonypasma1707 Місяць тому

    ❤❤❤

  • @sebnemb935
    @sebnemb935 Місяць тому

    I really wonder who came up with the input output KPI lingo. I have a fundamental issue by calling something "output" but meaning "outcome".

  • @monde1250
    @monde1250 2 місяці тому

    This is wrong. Business analyst doesn’t have to be a project managemer infact thats a downgrade for them

  • @olwenpuralena4576
    @olwenpuralena4576 2 місяці тому

    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.

    • @StartupAkademia
      @StartupAkademia 2 місяці тому

      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

  • @nilashma1
    @nilashma1 2 місяці тому

    Thanks so much...

  • @sheeshneesh
    @sheeshneesh 2 місяці тому

    Very helpful.! Thanks!

  • @bsmo9148
    @bsmo9148 3 місяці тому

    "The guy cutting the cheese" :)

  • @brianoliver20
    @brianoliver20 3 місяці тому

    Awesome, thank you!!

  • @allbrightsolver
    @allbrightsolver 3 місяці тому

    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?

    • @StartupAkademia
      @StartupAkademia 3 місяці тому

      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!

  • @mohdahmedshaikh1635
    @mohdahmedshaikh1635 3 місяці тому

    Sir my f4 key is not working

    • @StartupAkademia
      @StartupAkademia 3 місяці тому

      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.

    • @ssami.1487
      @ssami.1487 Місяць тому

      Try press fn+f4 at the same time or try windows button+f4 at the same time

    • @incognito-by8js
      @incognito-by8js Місяць тому

      Tq❤ it helped keep😘​@@ssami.1487

    • @afrinjoha8027
      @afrinjoha8027 17 днів тому

      ​@@ssami.1487thanks

  • @AdebayoayomideMojisola-hi7iq
    @AdebayoayomideMojisola-hi7iq 5 місяців тому

    @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

  • @koalabear6576
    @koalabear6576 5 місяців тому

    It works awesome, thanks! :D

    • @StartupAkademia
      @StartupAkademia 5 місяців тому

      I'm happy to hear that. Have a great day!

  • @adegunloyerebecca2671
    @adegunloyerebecca2671 5 місяців тому

    @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

  • @onlyagreeingsometimes
    @onlyagreeingsometimes 5 місяців тому

    Uber and Doordash dont belong to McDonald's, but keep going this is interesting and did you do one for the franchises

    • @StartupAkademia
      @StartupAkademia 5 місяців тому

      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.

    • @onlyagreeingsometimes
      @onlyagreeingsometimes 5 місяців тому

      @StartupAkademia Thanks, I hope you do too and didn't take this to heart

  • @marcw.5492
    @marcw.5492 6 місяців тому

    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.

    • @StartupAkademia
      @StartupAkademia 5 місяців тому

      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

    • @marcw.5492
      @marcw.5492 5 місяців тому

      @@StartupAkademia I think the CACHE may be part of the issue... who knew ! thansk !

  • @AmandaLJ74
    @AmandaLJ74 6 місяців тому

    Concise and to the point - thank you!

    • @StartupAkademia
      @StartupAkademia 6 місяців тому

      Thanks for the nice words :) Take care

  • @ankurj9
    @ankurj9 6 місяців тому

    Thanks Asen.

    • @StartupAkademia
      @StartupAkademia 6 місяців тому

      I'm happy that you liked it! Take care

  • @Robylazarus
    @Robylazarus 6 місяців тому

    Brilliant video and very well described.....

    • @StartupAkademia
      @StartupAkademia 6 місяців тому

      Thanks for the nice words :) I'm happy you liked it. Take care

  • @dmccalldds
    @dmccalldds 7 місяців тому

    At 0:56 he selects all of the points and says,"You trazfirst the data points." ????? How did he select those?

    • @StartupAkademia
      @StartupAkademia 6 місяців тому

      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.

  • @JackLovo
    @JackLovo 7 місяців тому

    I need help on school scope statement

  • @larbikhelifa2119
    @larbikhelifa2119 8 місяців тому

    Value from cells option is missing??

    • @StartupAkademia
      @StartupAkademia 7 місяців тому

      Strange. what version of office or Excel you have?

  • @lois.5464
    @lois.5464 8 місяців тому

    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

  • @deepk82
    @deepk82 8 місяців тому

    Great video, just a suggestion - kindly zoom the video while recording. I had a hard time looking at the formula.

    • @StartupAkademia
      @StartupAkademia 8 місяців тому

      Thanks for the suggestion. I will zoom in next time! Take care.

    • @deepk82
      @deepk82 8 місяців тому

      @@StartupAkademia Thank you.

  • @michaelomosebi6374
    @michaelomosebi6374 8 місяців тому

    This was brief and helpful

    • @StartupAkademia
      @StartupAkademia 8 місяців тому

      Thanks for appreciating it :) Have a great day!

  • @masonzoller1163
    @masonzoller1163 9 місяців тому

    fantastic content

    • @StartupAkademia
      @StartupAkademia 8 місяців тому

      I'm happy to hear that you liked it :) Chek my other videos as well. Have a great day!

  • @OlpaMinistry
    @OlpaMinistry 9 місяців тому

    Informative

    • @StartupAkademia
      @StartupAkademia 9 місяців тому

      I'm happy to hear that. Have a great day!

  • @shadyr.khairy6611
    @shadyr.khairy6611 9 місяців тому

    thanks

  • @lukmanalghdamsi3189
    @lukmanalghdamsi3189 9 місяців тому

    my professor really doesn't like the triangles, he made the square where he added a new variables which is quality.

    • @StartupAkademia
      @StartupAkademia 9 місяців тому

      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!

    • @lukmanalghdamsi3189
      @lukmanalghdamsi3189 9 місяців тому

      @@StartupAkademia this is how i see it too. just shared my professor opinion. he teaches software engineering for computer science

    • @StartupAkademia
      @StartupAkademia 9 місяців тому

      @@lukmanalghdamsi3189 Probably he has a point. Although, I still don't know how he wants to measure

  • @paulinahagl1597
    @paulinahagl1597 10 місяців тому

    Thanks 😊

  • @akpeweeroh8942
    @akpeweeroh8942 10 місяців тому

    thank you just save me some stress now

  • @rengarajanalagar9126
    @rengarajanalagar9126 11 місяців тому

    Cant thank you enough for this trick :-)

    • @StartupAkademia
      @StartupAkademia 11 місяців тому

      Thanks for the nice words. Tha means a lot to me! Take care and have a great day!

  • @user-msprint_co_za
    @user-msprint_co_za 11 місяців тому

    Beautiful explanation but quote a challenge to explain further. wish you could've explain more.

    • @StartupAkademia
      @StartupAkademia 11 місяців тому

      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

  • @TheJesseLopez99
    @TheJesseLopez99 Рік тому

    Awesome thank you!!

    • @StartupAkademia
      @StartupAkademia Рік тому

      Thanks. I'm happy to hear that. It means a lot to me! Have a great day

  • @vivienleralu486
    @vivienleralu486 Рік тому

    you don't explain in which prioritiy you work ?

    • @StartupAkademia
      @StartupAkademia Рік тому

      Hi. At the end of the video, I show the lists of todos that I use

  • @HallingAdventures
    @HallingAdventures Рік тому

    Poifect. That helped a lot

    • @StartupAkademia
      @StartupAkademia Рік тому

      Thanks for the nice words. I'm happy to hear that!

  • @lal885
    @lal885 Рік тому

    Is there a production planning software that can do this?

    • @StartupAkademia
      @StartupAkademia Рік тому

      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)

  • @skater1291
    @skater1291 Рік тому

    Thank you!!

  • @kelllykelly1
    @kelllykelly1 Рік тому

    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.

    • @StartupAkademia
      @StartupAkademia Рік тому

      Thanks for the nice words. I am happy to hear that it helped save some time. Take care and have a great day!

  • @karimbarakat3681
    @karimbarakat3681 Рік тому

    Great thanks for your help, you saved a lot of time for me

    • @StartupAkademia
      @StartupAkademia Рік тому

      Thanks for the nice words. I am happy to hear that it helped save some time. Take care and have a great day!

  • @richardgordon
    @richardgordon Рік тому

    Thanks. That was a huge help!!

  • @bce6936
    @bce6936 Рік тому

    hi helo! is there a way to do this but with many graphs all at once or i have to go one by one?

    • @StartupAkademia
      @StartupAkademia Рік тому

      Hi. You have to go one by one. Excel treats every chart as a separate entity

    • @bce6936
      @bce6936 Рік тому

      @@StartupAkademia hi! Thank you for replying ☺️ guess now i have 400 graphs to sort

    • @StartupAkademia
      @StartupAkademia Рік тому

      @@bce6936 with so many graphs you may consider trying scripts or VBA to automate

  • @aditya3david
    @aditya3david Рік тому

    this is great

    • @StartupAkademia
      @StartupAkademia Рік тому

      Thanks. I am happy to hear that it helped! Take care