 So an ultimate trick what's it? It is view relationships between queries How do you view relationships? We've done so many queries. What's the relationship between them? Let's have a look So view relationship within queries. How do we do that? So obviously I said view right? So it should be somewhere in view So if I go to view then you can see query dependencies so click on that and then you have this dialogue box Let me maximize it this dialogue box. I can zoom in a bit so you can see it So this is a mapping of all the queries you have so this is one source If I hover over it you see this is my source called Consolidate folder if you had watched all the videos From the beginning to the end you would see that we did a Consolidate folder and this is it here So this is just the direct link Then we had I did a lot of stuff with one One file called auto headings recon so it's a headings recon. We loaded we did summarize data with it We did auto headings recon. We duplicated it. We did a flash fill with it We did choose columns with it this auto recon number two We did profile with it. We created a table profile. So we use this quite a lot We can see the mapping of how we used it. What else did we use here is? Look up so this was look up if you remember the referee stuff We had results for our matches. We had the referees and then we did a look up So you see how nice and neat it is So if your queries are nice and neat like this, you can know what is depending on what so if I come and try and Delete this for example, it won't allow me to delete this query because look up is dependent on this So if I want to delete this I must delete this first, right? So that's how you use your query dependencies and that's how Power BI and Excel manage all these query dependencies. You can see the mapping. It almost looks like power pivot Yeah, probably what data model very cool, right? What's our last and last tip?