Book Image

Microsoft Power BI Complete Reference

By : Devin Knight, Brian Knight, Mitchell Pearson, Manuel Quintana, Brett Powell
Book Image

Microsoft Power BI Complete Reference

By: Devin Knight, Brian Knight, Mitchell Pearson, Manuel Quintana, Brett Powell

Overview of this book

Microsoft Power BI Complete Reference Guide gets you started with business intelligence by showing you how to install the Power BI toolset, design effective data models, and build basic dashboards and visualizations that make your data come to life. In this Learning Path, you will learn to create powerful interactive reports by visualizing your data and learn visualization styles, tips and tricks to bring your data to life. You will be able to administer your organization's Power BI environment to create and share dashboards. You will also be able to streamline deployment by implementing security and regular data refreshes. Next, you will delve deeper into the nuances of Power BI and handling projects. You will get acquainted with planning a Power BI project, development, and distribution of content, and deployment. You will learn to connect and extract data from various sources to create robust datasets, reports, and dashboards. Additionally, you will learn how to format reports and apply custom visuals, animation and analytics to further refine your data. By the end of this Learning Path, you will learn to implement the various Power BI tools such as on-premises gateway together along with staging and securely distributing content via apps. This Learning Path includes content from the following Packt products: • Microsoft Power BI Quick Start Guide by Devin Knight et al. • Mastering Microsoft Power BI by Brett Powell
Table of Contents (25 chapters)
Title Page
About Packt


About the authors

Devin Knight a Microsoft Data Platform MVP and the Training Director at Pragmatic Works. At Pragmatic Works, Devin determines which courses are created, delivered, and updated for customers, including 10+ Power BI courses. This is the seventh SQL Server and Business Intelligence book that he has authored. Devin often speaks at conferences such as PASS Summit, PASS Business Analytics Conference, SQL Saturdays, and Code Camps. He is also a contributing member to several PASS Virtual Chapters. Making his home in Jacksonville, FL, Devin is the Vice President of the local Power BI User Group and SQL Server User Group (JSSUG). His personal blog can be found at Devin Knight's website.


Brian Knight is the owner and founder of Pragmatic Works, and is a serial entrepreneur, having also started up other companies. Brian is a contributing columnist at several technical magazines. He is the author of 16 technical books. Brian has spoken at conferences such as PASS Summit, SQL Connections, TechEd, SQLSaturdays, and Code Camps. He has received a number of awards from the State of Florida, from both the governor and press, including the Business Ambassador Award (governor) and Top CEO (Jacksonville Magazine). His blog can be found at Pragmatic Works website.

Thanks to everyone who made this book possible. As always, I owe a huge debt to my wife, Jenn, for putting up with my late nights, and to my children, Colton, Liam, Camille, and John, for being so patient with their tired dad who has always overextended himself. Finally, I would like to thank Shawn Trautman, my line dancing instructor. This will be the year that we complete the United Country Western Dance Council's goal of making line dancing a competitive sport worldwide.

Mitchell Pearson has worked for Pragmatic Works for six years as a Business Intelligence Consultant and Training Content manager. Mitchell has experience developing enterprise level BI Solutions using the full suite of products offered by Microsoft (SSRS, SSIS, SSAS, and Power BI). Mitchell is very active in the community presenting at local user groups, SQL Saturday events, PASS virtual chapters and giving free webinars for Pragmatic Works. He can also be found blogging at Mitchellsql website. Mitchell is also the president of the local Power BI User Group in Jacksonville, Florida. In his spare time, Mitchell spends his time with his wife and three kids. For fun, Mitchell enjoys playing tabletop games with friends.

I would like to thank God for the gifts and opportunities afforded me and most of all for sending his son Jesus Christ. I would like to thank my wife and children for their patience and support as I worked on this book. I would also like to thank Brian Knight for the opportunity to learn and grow in the field of Business Intelligence. Finally, I would like to thank Anthony Martin, Dustin Ryan, Bradley Schacht, Devin Knight, Jorge Segarra, and Bradley Ball, each one of these individuals have provided guidance and mentoring through the years and have had a profound impact on my career.


Manuel Quintana is a Training Content Manager at Pragmatic Works. Previously, he was a senior manager working in the hotel industry. He joined the Pragmatic Works team in 2014 with no knowledge in the Business Intelligence space, but now speaks at SQL Saturdays and SQL Server User Groups locally and virtually. He also teaches various BI technologies to many different Fortune 500 companies on behalf of Pragmatic Works. Since 2014, he has called Jacksonville home and before that Orlando, but he was born on the island of Puerto Rico and loves to go back and visit his family. When he isn't working on creating new content for Pragmatic Works, you can probably find him playing board games or watching competitive soccer matches.

Thank you to all my family and friends who support me in all of my endeavors. Special praise must be given to my wife for supporting me during late hours working and some weekends being dedicated to writing this book, without her I wouldn't be the person I am proud of being today. Also, I must say thank you to all my coworkers at Pragmatic Works; each one of them has mentored me in one way or another, and all my success can be traced back to them. I hope to make everyone mentioned here proud of what I have done and what I will achieve.

Brett Powell is the owner of Frontline Analytics, a data and analytics consulting firm and Microsoft Power BI partner. He has worked with Power BI technologies since they were first introduced with the Power Pivot add-in for Excel 2010 and has contributed to the design and delivery of Microsoft BI solutions across retail, manufacturing, finance, and professional services. He is also the author ofMicrosoft Power BI Cookbook and a regular speaker at Microsoft technology events such as the Power BI World Tour and the Data & BI Summit. He regularly shares technical tips and examples on his blog, Insight Quest, and is a co-organizer of the Boston BI User Group.  

I'd like to thank Packt for giving me this opportunity, the content and technical editing teams, and particularly Divya Poojari, acquisition editor, and Amrita Noronha, senior content development editor. As Power BI continues to evolve, it is necessary to be flexible with the outline and page counts, and I greatly appreciated this autonomy.

About the reviewers

Nick Lee is a Business Intelligence Consultant and trainer for Pragmatic Works' training team. He comes from a customer service background and has an ample amount of experience in presenting and interacting with large Organizations. His focus at Pragmatic Works is creating Power BI content and delivering Power BI classes to our customers.


Ruben Oliva Ramos is a computer engineer from Tecnologico of León Institute, with a master's degree in computer and electronics systems engineering and networking specialization from the University of Salle Bajio. He has more than 5 years' experience of developing web apps to control and monitor devices connected to Arduino and Raspberry Pi, using web frameworks and cloud services to build IoT applications. He has authored Raspberry Pi 3 Home Automation Projects, Internet of Things Programming with JavaScriptAdvanced Analytics with R and Tableau, and SciPy Recipes for Packt.



Packt is searching for authors like you

If you're interested in becoming an author for Packt, please visit and apply today. We have worked with thousands of developers and tech professionals, just like you, to help them share their insight with the global tech community. You can make a general application, apply for a specific hot topic that we are recruiting an author for, or submit your own idea.