Power Bi tutor

I have worked with PowerBI previously and have a good understanding of the platform. I typically use excel to manipulate the data prior to uploading however recently I have gotten into more big data and this option is no longer valid. I need a tutor to show me how to query the data from within PowerBI including previous formulas such as Countifs.