Power BI Tools Volume 4: Learning Power Query And Power Pivot For Excel Made Easy

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.

Dr. Indera E. Murphy is an author, educator and IT professional that has over 20 years of experience in the Information Technology field. She has held a variety of positions including technical writer, programmer, consultant, web designer, course developer and project leader. Indera has designed and developed software applications and web sites, as well as, manage technology driven projects in several industries. In addition to being an Executive Director and consultant, as an online adjunct professor, she has taught courses in a variety of areas including project management, technical writing, information processing, Access, HTML, Windows, Excel, Dreamweaver and critical thinking.