Calculate Days Of Zero Stock - Inventory Management Insights w/Power BI

Поделиться
HTML-код
  • Опубликовано: 18 ноя 2024

Комментарии • 23

  • @EnterpriseDNA
    @EnterpriseDNA  4 года назад

    ***** Learning Power BI? *****
    FREE COURSE - Ultimate Beginners Guide To Power BI - portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
    FREE COURSE - Ultimate Beginners Guide To DAX - portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
    FREE - 60 Page DAX Reference Guide Download - enterprisedna.co/dax-formula-reference-guide-download
    FREE - Power BI Resources - enterprisedna.co/power-bi-resources
    Enterprise DNA Membership - enterprisedna.co/membership
    Enterprise DNA Online - portal.enterprisedna.co/
    Enterprise DNA Events - enterprisedna.co/enterprise-dna-events-page/
    ***** Related Links *****
    Inventory Management Insights with Power BI: Comparing Stock To Sales - blog.enterprisedna.co/advanced-budgeting-insights-in-power-bi-free-training-workshop/
    Power BI Mobile Reporting Tips and Techniques - blog.enterprisedna.co/mobile-reporting-tip-techniques-for-power-bi/
    The Importance Of Creating Compelling Power BI Visualizations - blog.enterprisedna.co/the-importance-of-creating-compelling-visuals-reports-in-power-bi/
    ***** Related Course Modules *****
    Dashboarding & Data Visualization Intensive - portal.enterprisedna.co/p/dashboarding-and-data-visualisation-intensive
    Power BI Resources - portal.enterprisedna.co/p/power-bi-resources
    Scenario Method Workshops - portal.enterprisedna.co/p/scenario-method-workshops
    ***** Related Support Forum Posts *****
    Inventory Management - forum.enterprisedna.co/t/inventory-managment/829
    Inventory Management [Shortage Report] - forum.enterprisedna.co/t/inventory-management-shortage-report/629
    Inventory Management Stock Turnover - forum.enterprisedna.co/t/inventory-management-stock-turnover/1075
    For more inventory management support queries to review see here - forum.enterprisedna.co/search?q=inventory%20management

  • @FullMoonHatch
    @FullMoonHatch Год назад +1

    You helped me solve a problem Ive been working on for hours. Thank you!

    • @EnterpriseDNA
      @EnterpriseDNA  Год назад

      Hi Life2Liv, glad that this video is of help! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!

  • @Soulenergy31
    @Soulenergy31 5 лет назад +1

    great job on this visualization Sam!!

  • @Victor-ol1lo
    @Victor-ol1lo 5 лет назад +1

    Awsome solution !! Thanks for sharing with us !!

  • @marcosjosetiburciorodrigue3369
    @marcosjosetiburciorodrigue3369 4 года назад +1

    Thanks GOD I found this videos!

  • @NL-tq1yr
    @NL-tq1yr 5 лет назад +1

    Wont values return only the existing date according to the filtered product on the product slicer?
    If so a date may be skiped if it has no entry fir the specific product. So maybe you should have used ALL?
    Plus why use addcolumns if you can just go with filter( crossjoin , measure> 0 && notblank) ?

  • @christertvedt
    @christertvedt 3 года назад +1

    Hi, great video! I am trying to run this approach on a dataset of 2,6 million rows (3 500 unique sales locations) and run out of memory. Any way to easily optimize this measure?

    • @EnterpriseDNA
      @EnterpriseDNA  3 года назад

      Hello Christer Tvedt,
      thank you for posting your query onto our channel.
      Well for optimization we need to look at your data structure and working of the PBIX file and than only we can judge and provide you the results in terms of optimization.
      Recently, we started an initiative onto our Community Forum where members can provide their PBIX files by highlighting the formula that needs to be optimized and our expert team will look into this. We're providing a link of that post.
      Also you can reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner.
      Hoping you find this useful and meets your requirements that you've been looking for.
      Happy Learning!!!
      forum.enterprisedna.co/t/introducing-a-new-enterprise-dna-initiative-optimization-lab/14821
      forum.enterprisedna.co/

  • @MarkCBB86
    @MarkCBB86 5 лет назад +1

    Awesome Video, thank you for sharing

  • @jryan2119
    @jryan2119 4 года назад

    Great!! Can I please get raw data or key measure method regarding inventory management?

    • @EnterpriseDNA
      @EnterpriseDNA  4 года назад +1

      Hey J, See here for some ideas on this - blog.enterprisedna.co/?s=Inventory+Management. You'll find downloadable options at the bottom of the blog post to access the data files.
      P.S. All pbix files can be found in 'Mini Series' modules at Enterprise DNA Online - portal.enterprisedna.co/
      All the best,
      Enterprise DNA

  • @efficiencydna897
    @efficiencydna897 5 лет назад +1

    great video,thanks

  • @daominhtri2249
    @daominhtri2249 5 лет назад

    Hi Sam, How if there are more than one period out of stock and I just want to count number of days of the first period.

  • @sebastienschoonjans9727
    @sebastienschoonjans9727 2 года назад

    If there was 1 item in stock but before the left side of the slicer, is it taken into account?

    • @EnterpriseDNA
      @EnterpriseDNA  2 года назад

      Hello Sébastien,
      Thank you for posting your query onto our channel. We really appreciate you taking your valuable time to post it.
      Well, your query is not understandable to us here. We request you to please write back to us again by elaborating your query in a more specified manner so that we can assist you.
      For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well.
      Hoping you find this useful. Subscribe to our RUclips channel so that you don't miss out on any updates pertaining to the Power BI. You can also join our Power BI group on LinkedIn to receive latest updates on Power BI.
      Cheers,
      Enterprise DNA
      forum.enterprisedna.co/
      ruclips.net/channel/UCy2rBgj4M1tzK-urTZ28zcA
      www.linkedin.com/groups/12004506/

  • @sauravsinha6939
    @sauravsinha6939 Год назад

    how to get this Power Bi pbix file ?

  • @walidkhlil2872
    @walidkhlil2872 5 лет назад +2

    Great

  • @jafarhussain6606
    @jafarhussain6606 2 года назад

    Hello , Please provide the sample data sets

    • @EnterpriseDNA
      @EnterpriseDNA  2 года назад

      Hi Jafar, Thanks for posting your comment in the video. All pbix file/datasets/resource files are available for download in the Enterprise DNA Online, which is accessible via Membership. Check out the link below. Thanks!
      portal.enterprisedna.co/

  • @oscarfigueroa9968
    @oscarfigueroa9968 3 года назад

    Great!! Could you share the pbix file please?

    • @EnterpriseDNA
      @EnterpriseDNA  3 года назад

      Hi oscar figueroa, thanks for posting your comment in the video. All pbix file/datasets are available for download in the Enterprise DNA Online, which is accessible via Membership. Find link below. Thanks!
      portal.enterprisedna.co

    • @oscarfigueroa9968
      @oscarfigueroa9968 3 года назад

      @@EnterpriseDNA can't find it, could you share the direct link to the course?