Power BI Tools Volume 4: Learning Power Query And Power Pivot For Excel Made Easy (Power BI Series) - Softcover

Inhaltsangabe

Power Query and Power Pivot are popular tools for Excel. They are easy to learn. This book will get you up and running quickly, by teaching you the basics and then progressing to advanced features. Each chapter covers new concepts and has exercises to help reinforce the concepts. This book is based on Power Query and Power Pivot 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. Power Pivot is used to create a data model once the data has been imported. These free, business intelligence tools provide 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 or to worksheets, using Power Query
• Learn how to discover data needed for analysis and visualizations
• Use the Query Editor in Power Query to transform data
• Load data into the data model using Power Pivot
• Create pivot tables and pivot charts
• Create KPI's and hierarchies
• Use date tables and summarize data in a pivot table

The topics covered in this book are the same as those covered in many 2 to 5 day classes, that can cost thousands of dollars. This book will get you up and running quickly, by teaching the basics, so that you can use the software. More topics are covered that build on the basics.

Die Inhaltsangabe kann sich auf eine andere Ausgabe dieses Titels beziehen.