Learn Power Query | 2. Power Pivot Basics, Inadequacies, and Data Management

Learn Power Query is available from: This is the “Code in Action” video for chapter 2 of Learn Power Query by Linda Foulkes, published by Packt. It includes the following topics: 00:11 Creating a pivot table 03:15 Creating a table in Excel 04:15 Adding tables to the data model 05:23 Creating relationships between tables 06:30 Creating a calculated column 07:52 Creating a calculated field 09:06 Creating a Power Pivot Table This book will take you on a Power Query journey starting with shortcomings of other tools with regard to data analysis and management. Then we will delve in-depth into the Power Query interface; how to connect, combine, and refine data with really powerful query tools and learn to use the Power Query M formula language which opens up a whole new world of data mashup. We will complete the journey by creating dashboards and multi-dimensional reports in Power Query Connect with Packt: Video created by Linda Foulkes