Getting Started with Power Pivot in Excel [FULL COURSE] скачать в хорошем качестве

Getting Started with Power Pivot in Excel [FULL COURSE]

Power Pivot is an Excel feature (Windows only at the current time) that removes many of the limitations and frustrations associated with creating Pivot Tables. Using Power Pivot you can... Create Pivot Tables from multiple lists/tables without the need to combine them into a single list first (goodbye X/VLOOKUP and all the issues that it brings) Create Pivot Tables from large datasets without worrying about file size, performance or needing more rows than an Excel worksheet contains Create Pivot Tables from multiple data sources (Excel, database, text file, web-based content etc) Pivot Tables that are based on Power Pivot can also take advantage of the powerful DAX formula language that is used to create custom calculations Topics Covered: Importing data into Power Pivot - the why and how The importance of understanding The Data Model Creating Relationships Between Tables Creating Data Model/Power Pivot based Pivot Tables DAX Primer: Create a simple calculated column ⏱ Timestamps 00:00:00 Introduction 00:00:43 What is The Data Model? 00:06:36 Enabling Power Pivot 00:11:00 Loading Data into The Data Model 00:22:30 Create Relationships Between Tables 00:25:21 Create a Pivot Table from The Data Model 00:36:48 Create a Calculated Column using Power Pivot (DAX) 00:54:12 Create a Calculated Column using the Query Editor ✅ Want more FREE training? Why not check out my other tutorials and/or subscribe to my newsletter, both of which can be done at https://theexceltrainer.co.uk 🙋‍♂️ Let's connect on social Twitter:   / theexceltrainer   Facebook:   / theexceltrainer   LinkedIn:   / thomasmik   #excel #powerpivot #datamodel