End-to-end data validation strategies in Microsoft Fabric (+ 3 DEMOS)

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

КОМЕНТАРІ • 81

  • @LearnMicrosoftFabric
    @LearnMicrosoftFabric  5 місяців тому +4

    If you found this video helpful, please LIKE and share with friends/ colleagues - THANK YOU! Also you can download the notebooks used in this tutorial (3 in total): www.skool.com/microsoft-fabric/classroom/d154aad4?md=7157c442fb334f1ca5dd05d35c63d61c

  • @alexrook5604
    @alexrook5604 3 місяці тому +4

    Medallion architecture ✅
    Data Validation ✅
    Well explained ✅
    You should be an MVP

  • @farzadsaedi1954
    @farzadsaedi1954 5 місяців тому +2

    your channel is the only source I use to learn Fabric. Thank you

  • @tech_explorer101
    @tech_explorer101 4 місяці тому +1

    ✅ great content on data validation!

  • @sandrojorgeoliveira175
    @sandrojorgeoliveira175 2 місяці тому

    Will, thank you for share your knowledgement!

  • @robertdavies4883
    @robertdavies4883 3 місяці тому

    ✅ a whole new level to enterprise data quality.

  • @rameshpaskarathas6512
    @rameshpaskarathas6512 4 місяці тому

    Brilliant video. I liked how you used the "gx lite" approach at each medallion layer to build out the validation steps. This really makes the implementation a no brainer and removes some of the complexity.

    • @LearnMicrosoftFabric
      @LearnMicrosoftFabric  4 місяці тому

      Thanks Ramesh 🙌🏽 Yes, GX can sometimes be “over-engineered” I think which puts off a lot of teams. Sometimes just a simple validation is what is required 👍

  • @guna24x7
    @guna24x7 Місяць тому

    It was insightful and provided a lot of valuable learning opportunities. Thank you for sharing your knowledge and expertise.Keep up the fantastic work!

  • @suneildham
    @suneildham 5 місяців тому +1

    Excellent content 👌

  • @1277marina1277
    @1277marina1277 5 місяців тому +1

    One of the best videos on the subject. Great job

  • @SumeshKashyap23
    @SumeshKashyap23 3 місяці тому

    The topic has been covered in a great detail .. thanks for creating such an elaborative video

  • @codescarsoftware8346
    @codescarsoftware8346 3 місяці тому

    Excelente contenido, he aprendido mucho el día de hoy ✅

  • @anitatrpenoska8739
    @anitatrpenoska8739 3 місяці тому

    Very helpful channel for learning Microsoft Fabric 🥇👍😊

  • @azwarmzafar
    @azwarmzafar 5 місяців тому

    I made it that far, and many thanks again and again for this great contents.

  • @Babayagaom
    @Babayagaom 5 місяців тому +1

    Your videos are so helpful .

  • @vibhatt2512
    @vibhatt2512 5 місяців тому

    Amazing work again!! I was looking for DQ options for a project and this video summed it all so well!! Thank you sharing the Notebooks.

    • @LearnMicrosoftFabric
      @LearnMicrosoftFabric  5 місяців тому

      No problem, glad you found the video and the notebooks useful 😊

  • @rasmusandreasson1548
    @rasmusandreasson1548 5 місяців тому +1

    Great content!!

  • @GarethNel
    @GarethNel 4 місяці тому

    Amazing content, really helpful on my Microsoft Fabric journey! Thank you!

  • @azizkatlane9027
    @azizkatlane9027 2 місяці тому

    Thanks Will , it was informative and simple .

  • @Nalaka-Wanniarachchi
    @Nalaka-Wanniarachchi 5 місяців тому +1

    Nice one.Interesting...

  • @KwabenaOwusu-fg2dn
    @KwabenaOwusu-fg2dn 4 місяці тому

    Excellent! William I would grateful if you expand a bit how treat great expectation results. I want struggling to create a database out of the JSON results

  • @ArletteSlachmuylder-bs8dk
    @ArletteSlachmuylder-bs8dk 4 місяці тому

    ✅ Very useful!

  • @Eklandasy
    @Eklandasy 5 місяців тому

    ✅ Great content!

  • @timbojj128
    @timbojj128 5 місяців тому

    ✅ super helpful, Will, thanks for this.

  • @carlosmiquel1813
    @carlosmiquel1813 5 місяців тому

    This was great stuff! Thanks!

  • @andreasratz3894
    @andreasratz3894 5 місяців тому

    Great Video! Even for a not so "deep techi" ;.-)

    • @LearnMicrosoftFabric
      @LearnMicrosoftFabric  5 місяців тому +1

      Thanks for watching! Hopefully not too many buzzwords 😂

  • @ProExcelTips
    @ProExcelTips 5 місяців тому

    Great content as usual!!!

  • @markburgess4440
    @markburgess4440 5 місяців тому

    ✅ Its already been said in a previous comment, but this really is the best resource I've found on this subject. 👍

  • @anitatrpenoska8739
    @anitatrpenoska8739 3 місяці тому

  • @Rothbardo
    @Rothbardo 5 місяців тому +1

    Are you on twitter as well?
    Great video

    • @LearnMicrosoftFabric
      @LearnMicrosoftFabric  5 місяців тому

      Thanks for watching! I am not on Twitter nope, just LinkedIn

    • @Rothbardo
      @Rothbardo 5 місяців тому

      @@LearnMicrosoftFabric what's your name on linkedIn?

  • @johnuzoma1823
    @johnuzoma1823 Місяць тому

    Thanks for the detailed training Will. Quick question: are validation notebooks also placed in a data pipeline? if yes, when organizing the data pipeline, is it recommended that the validation notebooks are executed before the actual cleansing notebooks?

    • @LearnMicrosoftFabric
      @LearnMicrosoftFabric  Місяць тому +1

      Hi, good question, different strategies exist depending on your use case/ priorities. Sometimes DQ checks might be done before you write new data to a location (to prevent poor quality data being used), other times it is written to a location, then DQ checks are done

    • @johnuzoma1823
      @johnuzoma1823 23 дні тому

      @@LearnMicrosoftFabric Thanks Will. Also, is there a way to generate data docs from MS Fabric? I mean the data docs provided by great expectations.

    • @LearnMicrosoftFabric
      @LearnMicrosoftFabric  22 дні тому

      @@johnuzoma1823 Yes! Although you'll have to use the Checkpoint functionality to generate Data Docs for your datasets/ Expectations! That is not shown in this video

    • @johnuzoma1823
      @johnuzoma1823 22 дні тому

      @@LearnMicrosoftFabric yes I tried using the checkpoint functionality. But fabric doesn't have a cmd terminal to mount the html data docs

    • @LearnMicrosoftFabric
      @LearnMicrosoftFabric  22 дні тому +1

      @@johnuzoma1823 Have you seen this video? ua-cam.com/video/jrcr28HGtEA/v-deo.html

  • @surendrag7537
    @surendrag7537 5 місяців тому

    👍

  • @shyamk136
    @shyamk136 5 місяців тому

  • @jaggyjut
    @jaggyjut 5 місяців тому

    Where does data quality solutions like informatica fit in pls?

    • @LearnMicrosoftFabric
      @LearnMicrosoftFabric  5 місяців тому +1

      Good point! I'm sure Informatica will produce integrations with Fabric, but it's not something I've looked at currently. You can read more here: now.informatica.com/idmc-microsoft-fabric.html
      The approach I outlined is based on open-source technologies

  • @soufianattar4554
    @soufianattar4554 5 місяців тому

  • @douglasspencer9819
    @douglasspencer9819 4 місяці тому

    Why spend more money on a product to do schema validation when you can create a pipeline that grabs the schema of our sources and then you can run an if condiition task that can evaluate the schema of your files\database table? I love throught process for data validation, but not pushing 3rd party products unnecessarily.

    • @LearnMicrosoftFabric
      @LearnMicrosoftFabric  4 місяці тому +2

      Hey, thanks for the comment! The approach I showed is based on a free, open-source Python library, Great Expectations (plus the other libraries I mentioned are also free). Most real-world use cases require a bit more than a binary if-statement 👍

    • @douglasspencer9819
      @douglasspencer9819 4 місяці тому

      @@LearnMicrosoftFabric Thanks for the quick response! I appreciate your feedback and will continue to watch your videos. I am quite curious of much fabric will be adopted. For now, I haven't seen much interest. doug

  • @kebincui
    @kebincui 5 місяців тому +1

    Excellent video ❤

  • @carlosnavia1361
    @carlosnavia1361 3 місяці тому

  • @branislavpoljasevic2866
    @branislavpoljasevic2866 5 місяців тому

  • @gerritvaneven2744
    @gerritvaneven2744 4 місяці тому

  • @wendyneedham3385
    @wendyneedham3385 5 місяців тому

  • @dicksonokorie7256
    @dicksonokorie7256 4 місяці тому +1