Data warehouse schema design - dimensional modeling and star schema

Поділитися
Вставка
  • Опубліковано 14 жов 2024

КОМЕНТАРІ • 35

  • @chenvili
    @chenvili 2 роки тому +4

    We had a course on DW last semester (in BGU) , I'm preparing for a Data Engeneering interview and I think I've learned more from this video than I did during the whole semester.

    • @snirdavid-dev8982
      @snirdavid-dev8982  2 роки тому +2

      Wow. Thank you. It is worth everything to me.

    • @chenvili
      @chenvili 2 роки тому +4

      @@snirdavid-dev8982 Just so you know, I got the job!
      I own most of it to you!

  • @stacyread8711
    @stacyread8711 2 роки тому +3

    This is lecture I wish my professor would have given! Thank you, Snir!

  • @jacksonmay153
    @jacksonmay153 2 роки тому

    i crammed this right before my data engineer interview thanks!!!! Everything you covered here was asked in some ways.

  • @yehuda4904
    @yehuda4904 2 роки тому +1

    very nice and more practical then what they show in class, Amazing !!!!

  • @paddywhack
    @paddywhack 3 роки тому +1

    Thanks, Snir. You covered a lot of ground in 30 minutes....but everything was clearly explained.

  • @yasithudawatte8924
    @yasithudawatte8924 Рік тому +1

    Thanks you. Well explained with appropriate examples. Keep up the good work.

  • @nomad7317
    @nomad7317 2 роки тому +1

    Great Video! Thank you so much! Taught me so much more than my university

  • @Alexmontoyaangel
    @Alexmontoyaangel 2 роки тому +2

    Thank you for the lecture.
    I am so confused; Dimensional modelling, Kimball modelling and Star scheme are the same or they have differences ?

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

    Hi, Thank you for the amazing video! Really insightful! I was wondering about one thing you mentioned in OLTP section about data being inconsistent. Aren't ACID properties used for that purpose so that data is always consistent in OLTP? Let me know what do you think.

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

    This was an amazing video. Thank you for the content!

  • @kevinliu9668
    @kevinliu9668 2 роки тому

    Well explain video with easy understanding examples. Thanks!

  • @conradblume4274
    @conradblume4274 3 роки тому +1

    Excellent, thank you for taking the time to make this video!!

  • @0x1f8b
    @0x1f8b 3 роки тому +1

    Thanks for the excellent video!
    With the advent of columnar database, power BI, tableau, are there any changes required in modelling techniques?

  • @tobyroy336
    @tobyroy336 2 роки тому

    this was really informative. Thank you so much

  • @chaosinorderrr
    @chaosinorderrr 3 роки тому +2

    Great video. One question: can you go the OLAP route and use that to design the schema for your primary data store for your application?

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

    Great tutorial

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

    Thank you for the great video!

  • @raunaqkoppikar1986
    @raunaqkoppikar1986 3 роки тому

    Awesome video... you covered many useful concepts in a clear and concise manner... Thank you 👍

  • @hydtechietalks3607
    @hydtechietalks3607 2 роки тому

    Thanks for the refresh!

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

    Could you make a demonstration in SSIS? Thank you a lot

  • @blerdijankoliqi3994
    @blerdijankoliqi3994 3 роки тому

    Such a great video! Helped me with my exam so much!

  • @ericka.montanez6821
    @ericka.montanez6821 3 роки тому

    Very insightful. Thank you!

  • @filetiktok9794
    @filetiktok9794 2 роки тому

    Do fact table need primary key?

  • @vamsikrish7406
    @vamsikrish7406 4 роки тому

    It is very much informational ! Thank You !

  • @lanreade3562
    @lanreade3562 3 роки тому

    OLTP is a relational system for day to day transaction.. I will say Bill Inmon normalization is the best method.

  • @zxcase0
    @zxcase0 3 роки тому

    Great explanation! Thank you!

  • @antonkostov1691
    @antonkostov1691 2 роки тому

    Good job! You are good.

  • @Agx21111
    @Agx21111 3 роки тому

    Very nice dude, ty for y our help

  • @QueenaJami
    @QueenaJami 2 роки тому

    Thank you!!!

  • @vasudevareddysudireddy8860
    @vasudevareddysudireddy8860 2 роки тому

    Super bro 👍👍👍

  • @rabanchikwanha5612
    @rabanchikwanha5612 3 роки тому

    thanks for the information, its good

  • @TheBansalvikas
    @TheBansalvikas 3 роки тому

    Are you Walter White Jr. ?

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

    Spin up an IDE and actually do something man ...