Quick Start Guide To Learning Power Query For Excel (Power BI Series) - Tapa blanda

Sinopsis

Power Query is a popular tool for Excel. It easy to learn. The Quick Start Guide To Learning Power Query For Excel book has been designed to have you using the software quickly, by teaching you the basics and more. Each chapter covers new concepts and has exercises to help reinforce the concepts. This book is based on Power Query for Excel 2016.

Power Query is used to automate the process of connecting to and cleaning data that needs to be imported. The data can come from a variety of sources, including spreadsheets, databases and web pages. This free, business intelligence tool provides functionality that Excel does not have.

After completing the exercises in this book, you will be able to perform the following tasks and more:

• Load data from a variety of sources into the data model, using Power Query
• Learn how to discover data needed for analysis and visualizations
• Use the Query Editor in Power Query to transform data
• Merge and append data
• Create custom columns and formulas

The Quick Start series of books are for people that are new to a software package and want to take it for a "test drive", as they say. The books in this series will show you how to use some of the most used features of the software, by completing the tasks in each exercise. Topics are explained as you go along, but not in-depth. You will cover enough of the software to know whether or not it will handle a large percent of your needs, without investing weeks of your time, trying to learn about a larger number of features and options. This book will get you up and running quickly, by teaching the basics, so that you can use the software.

"Sinopsis" puede pertenecer a otra edición de este libro.