SQLBI
SQLBI
  • Видео 510
  • Просмотров 8 774 324
Using atomic design in report and model development
The ‘atomic design methodology’ is an approach to make Power BI development more efficient and repeatable.
Article and download: sql.bi/844648?aff=yt
How to learn DAX: www.sqlbi.com/guides/dax/?aff=yt
The definitive guide to DAX: www.sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt
Просмотров: 8 734

Видео

100K Subscribers - Thank you!
Просмотров 1,7 тыс.16 часов назад
Watch the unboxing of the 100k subscribers plaque we received from RUclips!
Filter context in DAX explained visually
Просмотров 14 тыс.14 дней назад
A visual representation of the filter context in DAX can help understand the conceptual model. Article and download: sql.bi/843174?aff=yt How to learn DAX: www.sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: www.sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt
Introducing the 3-30-300 rule for better reports
Просмотров 24 тыс.Месяц назад
A simple approach that you can apply to improve your reports and dashboards, not only in Power BI. Article and download: sql.bi/840130?aff=yt How to learn DAX: www.sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: www.sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt
Understanding apply semantics for window functions in DAX
Просмотров 6 тыс.Месяц назад
Apply semantics is a new way of computing table expressions when multiple rows are selected in DAX window functions. Article and download: sql.bi/836012?aff=yt How to learn DAX: www.sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: www.sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt
Writing DAX with ChatGPT-4o - Unplugged #58
Просмотров 19 тыс.Месяц назад
One year later, another special unplugged video where we write DAX measures with the new ChatGPT-4o! Previous video with ChatGPT-4: www.sqlbi.com/tv/writing-dax-with-chatgpt-4-unplugged-50/ Note: the first 20 seconds and the end of this video has a focus issue, sorry for that! Read more about the "unplugged" format: www.sqlbi.com/blog/marco/2021/01/09/the-unplugged-video-series-on-sqlbi-youtube...
Best practices for using KEEPFILTERS in DAX
Просмотров 9 тыс.Месяц назад
Best practices for deciding when to use (and when not to use) KEEPFILTERS in CALCULATE filter arguments. Article and download: sql.bi/837707?aff=yt How to learn DAX: www.sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: www.sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt
Comparing cumulative metrics for events with different start dates
Просмотров 8 тыс.2 месяца назад
How to compare time series that occur in different periods by standardizing the timelines to days since a specific event. Article and download: sql.bi/836030?aff=yt How to learn DAX: www.sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: www.sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt
Using EXPAND and COLLAPSE in visual calculations
Просмотров 4,7 тыс.2 месяца назад
See when EXPAND and COLLAPSE are required to obtain the correct result with visual calculations in Power BI. Article and download: sql.bi/833902?aff=yt How to learn DAX: www.sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: www.sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt
Use scatterplots to find details in Power BI reports
Просмотров 10 тыс.3 месяца назад
Bubble plot, quadrant plot, volcano plot, joint plot, swarm plot: they are all types of scatterplot visuals to make more effective #powerbi reports. Learn how to use them in this video from Kurt Buhler! Article and download: sql.bi/832967?aff=yt How to learn DAX: www.sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: www.sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt 00:...
Revolutionizing Power BI: Introducing the Ultimate Formula Language
Просмотров 10 тыс.3 месяца назад
Be the first to learn about the new #dax language extension, which will forever transform how we write #powerbi formulas for hierarchical calculations! Read the article: sql.bi/832843?aff=yt How to learn DAX: www.sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: www.sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt
Introducing EXPAND and COLLAPSE for visual calculations in Power BI
Просмотров 8 тыс.3 месяца назад
Introduction to the two basic visual context navigation functions in DAX: EXPAND and COLLAPSE. There functions are used in Power BI visual calculations. Article and download: sql.bi/833882?aff=yt How to learn DAX: www.sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: www.sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt
Vpax Obfuscator and DAX Optimizer - Unplugged #57
Просмотров 2,2 тыс.3 месяца назад
Vpax Obfuscator and DAX Optimizer - Unplugged #57
Introducing VISUAL SHAPE for visual calculations in Power BI
Просмотров 20 тыс.3 месяца назад
Introducing VISUAL SHAPE for visual calculations in Power BI
DAX Optimizer overview - Unplugged #56
Просмотров 8 тыс.3 месяца назад
DAX Optimizer overview - Unplugged #56
Improve data labels with format strings
Просмотров 8 тыс.4 месяца назад
Improve data labels with format strings
Introducing SQLBI Days
Просмотров 2,6 тыс.4 месяца назад
Introducing SQLBI Days
DAX limitations with row level security RLS
Просмотров 5 тыс.4 месяца назад
DAX limitations with row level security RLS
Optimizing time intelligence in DirectQuery
Просмотров 5 тыс.4 месяца назад
Optimizing time intelligence in DirectQuery
Differences between DATEADD and PARALLELPERIOD in DAX
Просмотров 7 тыс.5 месяцев назад
Differences between DATEADD and PARALLELPERIOD in DAX
Using tuple syntax in DAX expressions
Просмотров 8 тыс.5 месяцев назад
Using tuple syntax in DAX expressions
Circular dependencies and relationships - Unplugged #55
Просмотров 5 тыс.5 месяцев назад
Circular dependencies and relationships - Unplugged #55
Replacing relationships with join functions in DAX
Просмотров 11 тыс.6 месяцев назад
Replacing relationships with join functions in DAX
What happened in DAX in 2023
Просмотров 6 тыс.6 месяцев назад
What happened in DAX in 2023
Using join functions in DAX
Просмотров 10 тыс.6 месяцев назад
Using join functions in DAX
Preparing a data model for Sankey Charts in Power BI
Просмотров 15 тыс.7 месяцев назад
Preparing a data model for Sankey Charts in Power BI
Computing accurate percentages with row level security in Power BI
Просмотров 7 тыс.7 месяцев назад
Computing accurate percentages with row level security in Power BI
Unboxing DAX Query View in Power BI - Unplugged #54
Просмотров 33 тыс.7 месяцев назад
Unboxing DAX Query View in Power BI - Unplugged #54
Computing MTD, QTD, YTD in Power BI for the current period
Просмотров 17 тыс.7 месяцев назад
Computing MTD, QTD, YTD in Power BI for the current period
Optimizing callbacks in a SUMX iterator
Просмотров 6 тыс.8 месяцев назад
Optimizing callbacks in a SUMX iterator

Комментарии

  • @llewellynholtshausen4761
    @llewellynholtshausen4761 2 дня назад

    Is this functionality possible when not connected via Analyze in Excel? In otherwords if I build a PowerPivot model in Excel, sourcing data from say Azure SQL, and I load all my tables in the Power Pivot model and create relationships, measures etc. Will it allow me to customize the drill-down details for a Power Pivot Table? If not in this way, is there another way which this can be done?

    • @SQLBI
      @SQLBI День назад

      No you cannot - the model in Power Pivot does not allow that. You should be the model in either Power BI or Analysis Services.

  • @user-xf1uh4ro2z
    @user-xf1uh4ro2z 2 дня назад

    Thank you very much. Great explanation. Simple and capacious.👍

  • @Gooodies
    @Gooodies 2 дня назад

    Very well deserving 🎉🎉🎉🎉

  • @user-ze4xc6tu4f
    @user-ze4xc6tu4f 2 дня назад

    I want to see this guy smile😂

  • @id_analytics
    @id_analytics 2 дня назад

    congrats guys

  • @user-ze4xc6tu4f
    @user-ze4xc6tu4f 2 дня назад

    So cute😂 🎉

  • @joaoteixeira7378
    @joaoteixeira7378 2 дня назад

    Congrats! I learn a lot from you guys!

  • @notoriousft
    @notoriousft 2 дня назад

    Congratulations guys.

  • @NestorAdrianzen
    @NestorAdrianzen 2 дня назад

    That’s awesome. You reminded me of myself when I used to get a new toy 😅 Cheers!

  • @juanortega4963
    @juanortega4963 2 дня назад

    AMAZING! THANKS

  • @thasr81
    @thasr81 2 дня назад

    Awesome application of Brad Frost's principles! As another Atomic Design fan, it I great to see more people embracing what webdesign has to teach us in the data field. Outstanding video. - T, from Data Rocks.

  • @Adrian-jg1pg
    @Adrian-jg1pg 2 дня назад

    Great tips, grazie Kurt ! You bring SQLBI to a whole new level 👌😊

  • @ajaaskelainen
    @ajaaskelainen 3 дня назад

    Thank you, Jesus 👋

  • @adithyavk4820
    @adithyavk4820 3 дня назад

    Amazing content. I have a doubt here. What if select a color and then try to change the Name. What will happen to the selected color value? Say the present name does not purchase that particular color. Thank you!

  • @jay6817
    @jay6817 3 дня назад

    "And that is totally insane" 😂

  • @lmblancoancos
    @lmblancoancos 3 дня назад

    Congratulations boys 🥇👏 now to the next 100K 😀

  • @TheLahtMan
    @TheLahtMan 3 дня назад

    Loving this!

  • @tinaflemons263
    @tinaflemons263 3 дня назад

    Congratulations

  • @thenoobinvestor1220
    @thenoobinvestor1220 3 дня назад

    wait a minute... how did you get the Create A Jupyter Notebook external tool in your Power BI?!

  • @mohsenabdelbaset
    @mohsenabdelbaset 3 дня назад

    Congratulations SQLBI guys, very happy for you 🎉❤

  • @nickukragan7228
    @nickukragan7228 3 дня назад

    Top content, as usual.

  • @lnlarxg
    @lnlarxg 3 дня назад

    Ciao Friends, You deserve it x100. Your contents are superb.

  • @bkundrat
    @bkundrat 3 дня назад

    This is excellent. I would assume that the PBIP format and scripting could help overcome the limitations you pointed out when using the visualization library approach via a PBIX copy/paste?

    • @KurtBuhler
      @KurtBuhler 3 дня назад

      Yes, eventually, this will be key.

  • @omidmehdi
    @omidmehdi 4 дня назад

    You know DAX better than Microsoft 😮

  • @mariabardales
    @mariabardales 4 дня назад

    Hello, thank you for the video, how have you calculated forecast measure?

  • @andreadelpilarhuertas2291
    @andreadelpilarhuertas2291 4 дня назад

    Great, thank you

  • @parthasarathy5742
    @parthasarathy5742 4 дня назад

    Hi, In this solution, suppose if we have multiple tables in the report. if we select the "others" in a table , the other table which displays all the product category names is not getting filtered. Is there a solution for this situation?

  • @maxatilla4886
    @maxatilla4886 4 дня назад

    very helpful ! Would like to learn how to use the tabular editor

    • @SQLBI
      @SQLBI 3 дня назад

      The Tabular Editor documentation has a lot of videos (and all the basic features are also in the free Tabular Editor 2 version): docs.tabulareditor.com/onboarding/index.html

  • @Gerschk
    @Gerschk 4 дня назад

    WAIT UNTIL THE END LOL🤭

  • @gvitullib
    @gvitullib 4 дня назад

    Congratulations Maestros!! Well deserved this Milestone.

  • @gvitullib
    @gvitullib 4 дня назад

    Good video. Part 17:19 was also very instructive.

  • @poorak3
    @poorak3 4 дня назад

    Great video! Helped me a lot. Thank you!

  • @oconnorra
    @oconnorra 4 дня назад

    Stay on until the end for a great demo of how it all comes together :)

  • @leppyr64
    @leppyr64 4 дня назад

    That ending. That's how I feel when I go back and look at models I created in the past. 😁

  • @sheilahart7528
    @sheilahart7528 4 дня назад

    Great methodology! Love the ending!🙂

  • @tiendinh7185
    @tiendinh7185 4 дня назад

    Lol, congratulations!🎉

  • @ngoduyvu
    @ngoduyvu 4 дня назад

    Interesting concept

  • @Milhouse77BS
    @Milhouse77BS 4 дня назад

    When I heard “atomic” I thought of dimensional design principle of bringing in data at the most detailed level. Transaction level instead of aggregation at Day level. Let’s see.

    • @KurtBuhler
      @KurtBuhler 4 дня назад

      It's based upon a known methodology from UI/UX, whereby something complex is made by combining simple building blocks that you can apply as components to new solutions in a modular way.

  • @workstuff5253
    @workstuff5253 4 дня назад

    I'm excited for this series of videos! Thanks again.

  • @baskis69
    @baskis69 4 дня назад

    Enhorabuena a todo el equipo...Gracias por compartir un contenido de tanta calidad¡¡

  • @amyperalt
    @amyperalt 4 дня назад

    This way is not working for 3 different slicers, Is there any other way to use OR clause with 3 different date filters/slicers

  • @mathew9665
    @mathew9665 4 дня назад

    Great video and communicated well - love the D&D books and dragon (right hand side) and Dax book on the left - lol ending

    • @leppyr64
      @leppyr64 4 дня назад

      Kurt is the Data Goblin after all. 💚

  • @giampaolopitzalis1117
    @giampaolopitzalis1117 4 дня назад

    Which function did youtube use to count them? COUNT(), COUNTROWS(), DISTINCTCOUNT(), DISTINCTCOUNTNOBLANK() or what? 🙂

  • @mathew9665
    @mathew9665 4 дня назад

    lol love the video, and alberto's jumping up and down - very well done chaps

  • @adnanazadZR49
    @adnanazadZR49 4 дня назад

    This is golden!🎉

  • @workstuff5253
    @workstuff5253 4 дня назад

    Hang it in your lounge. I assume you guys live together - right? 🤣 Congrats BTW!!

    • @SQLBI
      @SQLBI 4 дня назад

      Absolutely no! :)

  • @vilmarsantos3419
    @vilmarsantos3419 4 дня назад

    Parabéns, Marco e Alberto, por alcançarem 100 mil inscritos no RUclips! Vocês decodificaram o algoritmo do sucesso com a mesma maestria com que desvendam DAX e Power BI👏

  • @kunwang2279
    @kunwang2279 4 дня назад

    Congratulations, you definitely deserve it

  • @Fernando_Calero
    @Fernando_Calero 4 дня назад

    Congratulations, felicitazioni!

  • @DIGITAL_COOKING
    @DIGITAL_COOKING 4 дня назад

    What was my rank 🤔, i don't remember but I 'm sure I was from the early one. Yes! I'm from the Veterans 🙂👍 like you guys even i still struggling with DAX😅