Demystifying [DAX] Evaluation Context (with Brian Grant)

Поделиться
HTML-код
  • Опубликовано: 2 авг 2024
  • “DAX Evaluation Context”, just the name alone strikes fear into the heart of even seasoned Power BI developers. The reality however, is that Evaluation Context in DAX isn’t hard to understand, it’s simply hard to describe. In this session Brian Grant will use a technique called "Formula Decomposition" to visually break down a big DAX formula into a chain of smaller, bit-sized sub-formulas; this in turn will create the platform needed for Brian to make the concepts of Evaluation Context both clear to understand and easy to remember.
    At the end of the presentation you will both have a clear idea of how to visualize Row and Filter Context, and also understand how the sub-formulas leverage these contexts to produce the answers you see on a Power BI page. Furthermore, the next time you look at a big intimidating DAX formula, you will know how to break it down into bite sized chunks so they can be understand one at a time.
    GUEST BIO (Brian Grant)👤
    Hailing from the East side of beautiful Portland Oregon, Brian is a Senior Business Analytics consultant with local data heroes Skypoint. Having spent his early years deep in the study of acting and screenwriting, he finally graduated Summa Cum Laude with a degree in Economics. His driving belief is that the biggest barrier most people face when learning technology isn't technology at all, but language. Taught the right way, most people can learn most things; helping people learn skills that are "too technical" for them is his greatest joy. He is the author of the Elements of DAX series on RUclips.
    RELATED CONTENT 🔗
    Blog -- briangrantbi.blog
    LinkedIn -- / brian-james-grant
    RUclips -- / @skypointcloud
    LET'S CONNECT! 🧑🏽‍🤝‍🧑🏽🌟
    -- / havensbi
    -- / reidhavens
    -- / havensconsulting
    CHECK OUT OUR MERCH STORE 👕
    -- havens-consulting.creator-spr...
    HAVENS CONSULTING PAGES 📄
    Home Page -- www.havensconsulting.net
    Blog -- www.havensconsulting.net/blog-...
    Blog Files -- www.havensconsulting.net/blog-...
    Files & Templates -- www.havensconsulting.net/files...
    Consulting Services -- www.havensconsulting.net/consu...
    Online Course -- www.havensconsulting.net/onli...
    Contact & Support -- www.havensconsulting.net/conta...
    EMAIL US AT 📧
    info@havensconsulting.net
    #PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #dax #powerquery #onelake #lakehouse #fabric #datawarehouse #evaluationcontext #filters
  • НаукаНаука

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

  • @JustRandomExplorer
    @JustRandomExplorer 6 месяцев назад

    Awesome video, Found Brian Grant via this video. Thanks Reid and Brian.

  • @rabihbadr54
    @rabihbadr54 6 месяцев назад +2

    This is probably the best evaluation context video on youtube.

  • @Aikibart
    @Aikibart 7 месяцев назад +1

    Seeing Brian's name was a nice blast to the past. Watching his power query video's on RUclips was what got me excited and what made me realize the power in Power Query. Had been following his RUclips channel since but there never was any movement. Happy to see there is a blog that has great content. Thank you both for sharing all this with the community!

  • @UlyssesHaq
    @UlyssesHaq 7 месяцев назад +1

    Watching this video is like listening to Jimi Hendrix, everytime you see it again, you discover something new... amazing!!

  • @alt-enter237
    @alt-enter237 7 месяцев назад +1

    Great job! I am teaching students beginning DAX right now and I will definitely be referring them to this video. I love the way you describe the temp tables and the list of filters. And I have mad respect for anyone who tries to use beginner friendly terminology. Very nicely done!

  • @kristinajensen711
    @kristinajensen711 6 месяцев назад

    Excellent presentation Brian. A million thank you-s for your empathy and willingness to not only teach but make students understand. Other instructors just show off and make you feel stupid (not on purpose) and give up. Wish I discovered you earlier, but I am glad I did, so I'm watching everything you have ever published😃

  • @kebincui
    @kebincui 7 месяцев назад +1

    Awesome explanation in bringing home the key concept of evaluation context, Thanks Brian and Reid👍

  • @ronnydegroeve213
    @ronnydegroeve213 7 месяцев назад +4

    Best explanation ever. ❤

  • @datareggibi
    @datareggibi 7 месяцев назад +2

    It was amazing, I want to rewatch it all again soon

  • @NirRobinson
    @NirRobinson 6 месяцев назад

    thanks for the presentation , clear , engage and funny
    is the ppt available online?
    thanks

    • @HavensConsulting
      @HavensConsulting  6 месяцев назад

      I shall ask Brian and get back to you :)

    • @HavensConsulting
      @HavensConsulting  6 месяцев назад

      Available now on my blog page :)
      www.havensconsulting.net/blog-and-media/demystifying-dax-evaluation-context

  • @NirRobinson
    @NirRobinson 6 месяцев назад

    in my opinion the music in the background is more annoying than helping
    i stop 3 times to check if this is outside of the presentation :-) just to understand it is part of the youtube

    • @HavensConsulting
      @HavensConsulting  6 месяцев назад

      Thanks for the feedback, it goes either way for people. Many like it, and a few don't :)
      I took a page from Guy in A Cube who always has soft background music playing, and that helps to fill in empty sound space if there's a technical issue or a delay for the presenter.