 Make sure you know it in depth. What's the next step? Next step is automate reports with power pivot and DAX So saying if it's not in Excel in Excel, it's not Excel. So just saying just reminding you there, right? Automate reports with power pivot and DAX. Let me jump to Excel to show you what I mean So what do we mean by automate reports with power pivot and DAX? Now it comes back to this, right? This is the fundamentals of Excel I said Excel is an analysis tool. That means analysts are mainly what you use Excel for analysis If you're in Excel, you're an analyst whether you like to call yourself an analyst or not You're just become an analyst if you're in HR. Yeah, HR analyst. So use Excel for past and use Excel for future Here we're saying automate your reports with power pivot and DAX. So in reporting, I told you there are only three things you need So you need data sheet control sheet report sheet So when you're using power pivot power pivot, what does that mean? Power pivot simply means it's it's a tool That allows you to connect to multiple data sources And then you now do your reporting from those multiple data sources, right? So you could connect to data in SAP connect to data in text file connect to data in folder At the end of the day, you're going to bring all of this and build something called a data model So we're now kind of extending from just a data sheet, which is the simple old school way of doing reporting Where you just get a sheet and then oops, sorry one second. You load data Okay, so you just get a sheet for example and then you load data into the sheet and then use that for your reporting That's fine But what about if your data is not just in one place? Maybe a data is here. There's another data somewhere else Well, if you're loading data your data has to follow seven golden rules You could go check out our youtube channel deep brown consulting for more about seven golden rules But when you want to extend your reporting and make it really industry enterprise scale reporting You need to have this tool called power pivot. This is it up here power pivot This is a magic box This extends your usability of excel by allowing you to build Something called a data model. So if you look at it, I'm hovering over it. What's it saying? It says go to the Power pivot window go to the power pivot window to load and prepare data or continue working on data already added to this workbook. So Manage you go there and build it. I'm not going to show you that we have some videos on youtube You could go watch those how to use power pivot, but just take it like it's a sequel as an sql Based tool that allows you to connect to multiple data sources and then build your reporting So it's it's really the efficient way to go Yeah power pivot now. So it's a data model How do you get power pivot? Well one you need to have certain versions of excel to have this Anytime you see professional plus in your excel, then you most likely have power pivot So if I go to file what you could do is go to file Then you go to account Then you go to account you'll be able to read what version of excel you have. So here I have microsoft office 365 pro plus So this pro that pro that's professional plus. So some of you may have um excel 2013 or microsoft office 2013 Professional plus you may have microsoft 2016 professional plus just make sure you have professional plus or pro plus in your name Once you have pro plus that means you have power pivot Okay And this is the best way to do reporting simple as that now power pivot uses its own language So excel's language is what you know, I can go to excel and say equals to v look up and this excel's language Power pivot has its own language and it's called dax So power pivot's language is dax. So you need to know power pivots All right, and you need to know its language called dax, which is data analysis expressions So these are skills you need You desperately need so that is your add more to the skills. So that is your tip I think that was tip three or four. I think let's let's get back to our Let's get back to our tips