Semantic Link 1 HOUR Tutorial - Microsoft Fabric

FREE 40-minute Fabric fundamentals course: www.skool.com/microsoft-fabri...
• Introduction to Semant... - also watch this previous video I did on Semantic Link.
Dive deep into the world of Semantic Link (sempy) in Microsoft Fabric in this comprehensive 1-hour workshop.
Explore user stories to grasp Semantic Link's real-world applications, understand every function it offers, and discover robust strategies and recipes for effective utilization.
I also talk through some important considerations to bare in mind before adopting Semantic Link.
Whether you're a business analyst, Power BI developer, or data scientist, this workshop is geared to equip you with the knowledge to harness the full potential of Semantic Link iwithin your organisations.
Got some other use cases that I didn't mention? I would love to hear them in the comments!
#microsoftfabric #semanticlink #datascience
0:00 Intro
1:25 Overview of 360 wheel
2:33 User stories
6:53 Every Sempy function explained
18:48 Using Spark
20:34 Implementation Strategies
21:18 Auto-document Power BI
23:53 Data validation: relationships
25:45 Data validation: dependencies
26:32 Model/ measure validation with Great Expectations
30:28 Write Audit Publish Power BI models + Deployment Pipelines
33:00 Data scientist workflow
36:30 Test-driven DAX Development
41:57 Consideration 1: Entrenching DAX
45:30 Consideration 2: Machine Learning pipeline
47:24 Consideration 3: Data limits
49:24 Final Thoughts
-BROWSE MY OTHER FABRIC PLAYLISTS- Learn Spark in Microsoft Fabric - kzbin.info?list... ENGINEERING kzbin.info?list... FABRIC PROJECT kzbin.info?list... TO MICROSOFT FABRIC kzbin.info?list... FACTORY • Data Factory (Microsof... -LINKEDIN- Not following the LinkedIn page yet? Here's the link: / --about WILL-- Hi, I'm Will! I'm hugely passionate about data and using it to create a better world. I currently work as a Consultant, focusing on Data Strategy, Data Engineering and Business Intelligence (within the Microsoft/Azure/Fabric environment). I have previously worked as a Data Scientist. I started Learn Microsoft Fabric to share my learnings on how Microsoft Fabric works and help you build your career and build meaningful things in Fabric. --SUBSCRIBE--Not subscribed yet? You should! There are lots of new videos in the pipeline covering all aspects of Microsoft Fabric.youtube.com/@learnmicrosoftfa...

[@AmritaOSullivan]

Absolutely fabulous video. There are so many new features being released it’s hard to gain a good understanding of use cases and an overall Birds Eye view. This video sets context, when, what, where, why, and how. Thanks so much!!! I’m all for other deep dive 360 videos!

[@LearnMicrosoftFabric]

Hey Amrita, thanks for the feedback!! I'm sure I'll be making a few more of these in the near future because, as you say, there are lots of new features coming out almost every week! Thanks for watching :)

[@LearnMicrosoftFabric]

Thanks for watching! Did I miss anything? What are your thoughts on Semantic Link? Also any feedback on the new ‘Feature360’ format would be appreciated! Have a great week 🙌

[@tech_explorer101]

Loved the Feature360 version of mapping out product exploration. Would be great if you followed up with other similar videos for new tools!

[@LearnMicrosoftFabric]

Glad you enjoyed! Which features would you like to see?

[@rameshpaskarathas6512]

Excellent video. I really liked how you covered various potential use cases of semantic link. Also appreciated the potential pitfalls of semantic link.

[@LearnMicrosoftFabric]

Glad you enjoyed Ramesh! Yeh semantic link is pretty awesome, and it's added even more new features since this video

[@LiseHolck]

I really like the deep dive approach 😊. Mayby follow up with example videos 🥰

[@LearnMicrosoftFabric]

Thanks for watching Lise and for the feedback! Yes I think I’ll cover some of the examples in more details in future videos 👌🙌

[@stevefox7469]

Great video. Lots of potential here.

[@LearnMicrosoftFabric]

Indeed! And even more functionality added to Semantic Link since I recorded this video, so thinking about recording an update video 🙌🏽

[@stevefox7469]

@@LearnMicrosoftFabric Yes, would be super keen for any additional content on Sempy / Semantic Link. A related question - do you feel Fabric notebooks are suitable for calling Power BI admin APIs at an enterpirse scale - to extract metadata to provide more information to run tests? Or does this type of "elastic"workload still belong in an environment such as Azure Functions? Your demos, have definitely started me thinking about opportunities to build out tooling for Power BI Dev Ops /Power BI CI/CD. Thanks again- this is some of the most though provoking content I have seen in a longtime.

[@topher60657]

Great video. I was wondering if this is possible or I was wondering how you would approach. I would like to leverage semantic link to take a snapshot of a DAX filter statement and save to csv or write to the lake house. Is this possible?

[@LearnMicrosoftFabric]

Yes, you can use the semantic link function execute_dax() to run a raw dax query on a semantic model. this will return a Fabric Dataframe which you can easily write to csv or save to a Lakehouse table 👍

[@crixcel8388]

Hi I am facing an issue that get_roles() is not giving expected results sometime , one of the roles which I created is coming up in the list , later when I created another role in the same dataset I am unable to see in while running the function , is there a delay in sempy of some hours post which the results get updated?

[@cuongnguyenlamquoc8967]

I try to figure out relationships of dataset ( it is in lakehouse) but can not print out by using code on notebook of MS Fabric because it said it can not find out any datasets. Have you got this issue before?

[@LearnMicrosoftFabric]

i have not no. but feel free to join our community Skool.com/Microsoft-fabric and post some screenshots of your code and the error 👍

[@TechnoSparkBigData]

you mentioned you created a video for great_expectation, can I get a link for that?

[@LearnMicrosoftFabric]

Sure, I've done a couple so far (more to follow): 1. kzbin.info/www/bejne/oKPGo2Vufayne6M 2. kzbin.info/www/bejne/rXLEqnZjf56Hqbc

[@PowerBIPalooza]

Very informative video. Just curious to know which tool are you using for this learning board. Thanks

[@LearnMicrosoftFabric]

Thanks, glad you found it informative! It's excalidraw

[@matiasrueda]

Hi you can share the link to de board ? I love your video

[@LearnMicrosoftFabric]

Hey yeh sure, I uploaded it to GitHub here: github.com/LearnMicrosoftFabric/KZbin/tree/main/semantic-link It's an excalidraw file, so you will need to go to Excalidraw.com to open (it's free)

[@matiasrueda]

thanks you are a genius, I learning a lot with your videos @@LearnMicrosoftFabric

[@LearnMicrosoftFabric]

@@matiasrueda thanks for watching!