Modern methods of data cleaning, analysis, and visualization in Microsoft Excel are considered. Power Query tools for creating reproducible data preparation processes, Power Pivot tools for building relational models and configuring analytical metrics are described. Practical examples of using dynamic...
arrays, artificial intelligence-based functions, and integration with Python are provided. It shows how to create reports and analytical materials that were previously considered difficult to accomplish in Excel. The book is aimed at data specialists, business analysts, and Excel users interested in enhancing their capabilities
Modern methods of data cleaning, analysis, and visualization in Microsoft Excel are considered. Power Query tools for creating reproducible data preparation processes, Power Pivot tools for building relational models and configuring analytical metrics are described. Practical examples of using dynamic arrays, artificial intelligence-based functions, and integration with Python are provided. It shows how to create reports and analytical materials that were previously considered difficult to accomplish in Excel. The book is aimed at data specialists, business analysts, and Excel users interested in enhancing their capabilities
Be the first to know about our current discounts, offers and new products!
Check icon
You have added to your basket
Check icon
You have added to favourites
Sold out
The item is currently out of stock.
In stock
Available in warehouse. You will receive the exact delivery date from the operator after the order confirmation.
To order
The product is delivered directly from the publisher. The order processing time is up to 14 days, you will receive the exact delivery date from the operator after the order confirmation.
No circulation
Unfortunately, the print run of the book has ended, it is currently unavailable for order.