Power Query, Power View and Power Map 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 primarily for new users of Power Query, Power View or Power Map for Excel 2013. These free, business intelligence tools provide dashboard reporting and data analysis capabilities, as well as functionality that Excel does not have.
If you are looking for step-by-step instructions for one or all of these software packages, this is the book that you have been looking for. There are time saving tips, advice and humor to help you learn the advanced concepts. In a user-friendly way you will learn the following topics: How to import data into Power Query, use the Query Editor to create formulas and filter data for visualizations, user Power View to create reports and charts and much, much more.
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
- Create reports that display data that is filtered
- Use Power View to create a variety of chart styles, including bar, pie and scatter
- Add drill down and interactive functionality to charts
- Create maps in Power View and Power Map
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.
We also have a book for the latest version of these tools. See Power BI Tools Volume 3: Learning Power Query, Power View And Power Map For Excel Made Easy, ISBN 978-1-935208-28-0.
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.
