We study Power Query
Please sign in so that we can notify you about a reply
Power Query - a technology that allows you to connect with data sources, as well as transform and clear information for its further analysis. This book will teach you how to create interactive reports and dashboard through Excel and Power Bi using many data sources. You will learn about how to access Power Query from different versions of Microsoft Excel and how to install the Power Bi engine. The Power Pivot tool is also considered, special attention is paid to the difficulties that can occur with Excel users when cleaning data with its help. It is shown how Power Query levels the shortcomings characteristic of Power Pivot. In conclusion, the possibilities of language m are shown - its syntax and structure are considered by numerous examples.
After reading the book, you will learn how to automate reporting using Power Query and can convert raw data into valuable analytical information
After reading the book, you will learn how to automate reporting using Power Query and can convert raw data into valuable analytical information
Author:
Author:Fawks L., Sparrow U.
Cover:
Cover:Hard
Category:
- Category:Computer & Technology
Publication language:
Publication Language:Russian
Paper:
Paper:Offset
Age restrictions:
Age restrictions:16+
ISBN:
ISBN:978-5-97060-905-7
No reviews found