Written BY Excel pros, FOR Excel pros, this book has been designed to guide you through learning how to master the new "Get and Transform" data experience in Excel. Released as a free add-in from Microsoft for Excel 2010 and 2013, Power Query technology is now built in to Excel 2016 and the Power BI Desktop application. This technology is a game changer, and will revolutionize the way you work with your data forever.
“M” is the name of the programming language used by Power Query. As more business intelligence pros begin using Power Pivot, they find that they do not have the Excel skills to clean the data in Excel; Power Query solves this problem. This book shows how to use the Power Query tool to get difficult data sets into both Excel and Power BI, and is solely devoted to Power Query dashboarding and reporting.
Format: PDF, ePub, and Mobi
Publisher: Holy Macro! Books (June 1, 2015)
All sales are final; no refunds on digital books are available.
Miguel Escobar is one of the founding partners of Skillwave.Training, and the principal of Powered Solutions, a Microsoft Gold Partner in Panama. Miguel is an Excel specialist turned Business Intelligence expert using the latest tools from Microsoft – Power BI. He is the co-author of M is for Data Monkey, a blogger, and a Youtuber of powerful Excel video Tricks. He has been recognized as a Microsoft MVP and is a Microsoft Certified Trainer (MCT).
Microsoft MVP, FCPA, FCMA
Ken Puls is one of the founding partners of Skillwave.Training, and the President and Chief Training Officer of Excelguru Consulting Inc. in Canada. He is a Chartered Professional Accountant, blogger, author, and trainer with over 20 years of business and IT experience. His passion lies in exploring tools to turn data into information, and teaching others how to use them. Ken is a Microsoft MVP and a leading expert in Excel, Power Query, and Power BI.
M is for Data Monkey (Digital)
Only verified customers who have purchased this product may leave a review.
Check out the other helpful reference materials we have available.