SKILLSHARE ULTIMATE EXCEL COURSE 13 INTRODUCTION TO THE DATA MODEL AND POWERPIVOT-iLLiTERATE
Submitted by milohaze on Fri, 04/26/2019 - 16:02
Category:
Genre:
This class is #13 in a series called the Ultimate Excel Course.
In this class you will be introduced to the Data Model and PowerPivot in Excel. This is an extremely powerful area of modern Excel.
This class is for people who work with large volumes of data and need to perform powerful analysis.
This is a huge area of Excel so this class serves as an introduction and insight into this feature. It will enable you to understand what it is and how it may benefit you.
In the class we import some data from a csv file into the data model using Power Query. This file contains over 100,000 rows of data. We then create relationships from it to 3 other tables.
Then we create a PivotTable from multiple tables of data in the model. Next we look at enabling the PowerPivot add-in and demonstrate some basic examples of DAX formulas.
In this class you will be introduced to the Data Model and PowerPivot in Excel. This is an extremely powerful area of modern Excel.
This class is for people who work with large volumes of data and need to perform powerful analysis.
This is a huge area of Excel so this class serves as an introduction and insight into this feature. It will enable you to understand what it is and how it may benefit you.
In the class we import some data from a csv file into the data model using Power Query. This file contains over 100,000 rows of data. We then create relationships from it to 3 other tables.
Then we create a PivotTable from multiple tables of data in the model. Next we look at enabling the PowerPivot add-in and demonstrate some basic examples of DAX formulas.