Learn Power Query

Power Query is a data connection technology that allows you to connect, combine, and refine data from multiple sources to meet your business analysis requirements. With this Power Query book, you’ll be empowered to work with a variety of data sources to create interactive reports and dashboards using Excel and Power BI. This book covers the following exciting features: Convert worksheet data into a table format ready for query output Create a dynamic connection between an Access database and Excel workbook Reshape tabular data by altering rows, columns, and tables using various Power Query tools Create new columns automatically from filenames and sheet tabs, along with multiple Excel data files Streamline and automate reports from multiple sources Explore different customization options to get the most out of your dashboards Understand the difference between the DAX language and Power Query's M language