How to convert Flat Files to BEAUTIFUL Data Models + Best Practices // Beginners Guide to Power BI

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

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

  • @rollyv1687
    @rollyv1687 3 года назад +3

    Great. looking forward for a continuation of this video. most specially for those ship date, order date etc.

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

      Hi Jack, thanks for watching!
      If you're after how to handle multiple dates, I've covered it in this video ruclips.net/video/fOcgIuaJHEs/видео.html

  • @Mahesh717
    @Mahesh717 Год назад +3

    fact table contains foreign
    &
    dimensions tables contains primary key
    right ?

  • @DanielParejo90
    @DanielParejo90 2 года назад +1

    If you save those files as a Dataset and then refresh those files will the model remain the same? Or you need to manually adjust everything again? I am following your videos trying to automatize a report.

    • @SolutionsAbroad
      @SolutionsAbroad  2 года назад +2

      Hi Daniel, the model will stay the same! As long as your flat file stays in the same format, all you'll need to do next time is hit refresh and everything should work automatically!

  • @anjucaesar93
    @anjucaesar93 3 месяца назад

    Do you need to connect the date to the fact table 3 times?

  • @federicopastor9400
    @federicopastor9400 3 года назад +3

    Reference or Duplicate Queries, which is better?

    • @SolutionsAbroad
      @SolutionsAbroad  3 года назад +2

      Hi Federico, if you want multiple queries with dependencies to the original query, use reference.
      If you want to create a complete copy of the original, use duplicate
      Hope that helps!

  • @alulahabesha7207
    @alulahabesha7207 2 месяца назад

    Great

  • @rezahamzeh3736
    @rezahamzeh3736 2 года назад +1

    Thanks! It would be better to share the PowerBI or CSV file o let audiences participate in the learning process not just watch you!

  • @emilymalkin270
    @emilymalkin270 10 месяцев назад

    Perfect!❤

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

    awesome!

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

    Hey man, your channel is great but I want to tell you very honestly, I avoid watching it because of your throat swallowing sound. I just get grossed out by that sound. Maybe it doesn’t bother anyone else, but if there’s anything you can do to either edit it out, or use a different mic setup that doesn’t pick it up, I think it would really improve your videos. I really appreciate your work, and hope you know I am saying this just to give you helpful advice. Cheers!