توضیحات
Language in Excel- Power Query is one component of the Power BI (Business Intelligence) product from Microsoft, and “M” is the name of the programming language created by it. Language in Excel- 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 Pivot, and is solely devoted to Power Query dashboarding and reporting.
About the Author
Ken Puls is the controller/director of IT at the Fairwinds Community & Resort on Vancouver Island, British Columbia. He also runs Excelguru Consulting Inc, a company dedicated to helping users get the most out of Microsoft Excel, and is a winner of the prestigious Microsoft MVP – Excel award. He lives in Vancouver. Miguel Escobar is an Excel MVP and a consultant and expert on business intelligence, PowerPivot, Excel, Power View, and SharePoint. He is the author of Fórmulas DAX para PowerPivot.
M Is for (Data) Monkey: A Guide to the M Language in Excel Power Query, it is wonderful !
Power Query، یکی از اجزای Power BI (Business Intelligence) ، محصولی از مایکروسافت است، و “M” نام زبان برنامه نویسی ایجاد شده توسط آن است. همانطور که متخصصان کسب و کار بیشتر از Power Pivot استفاده می کنند، و متوجه می شوند که مهارت های اکسل برای پاک کردن داده ها در Excel ندارند، نرم افزار Power Query این مشکل را حل می کند. این کتاب نشان می دهد که چگونه از ابزار Power Query برای جمع آوری داده های دشوار در Excel و Power Pivot استفاده کنید و صرفا به داشبورد Power Query و Reporting اختصاص یافته است.
کتاب را از گلوبایت کتاب دریافت نمایید.