Book Image

Learn Power BI

By : Gregory Deckler
Book Image

Learn Power BI

By: Gregory Deckler

Overview of this book

To succeed in today's transforming business world, organizations need business intelligence capabilities to make smarter decisions faster than ever before. This Power BI book is an entry-level guide that will get you up and running with data modeling, visualization, and analytical techniques from scratch. You'll find this book handy if you want to get well-versed with the extensive Power BI ecosystem. You'll start by covering the basics of business intelligence and installing Power BI. You'll then learn the wide range of Power BI features to unlock business insights. As you progress, the book will take you through how to use Power Query to ingest, cleanse, and shape your data, and use Power BI DAX to create simple to complex calculations. You'll also be able to add a variety of interactive visualizations to your reports to bring your data to life. Finally, you'll gain hands-on experience in creating visually stunning reports that speak to business decision makers, and see how you can securely share these reports and collaborate with others. By the end of this book, you'll be ready to create simple, yet effective, BI reports and dashboards using the latest features of Power BI.
Table of Contents (16 chapters)
Title Page
Copyright and Credits

Installing and using data gateways

The on-premises data gateway, or simply data gateway, is a piece of software that's installed on an on-premises computer that provides a secure connection between local, on-premises data and a variety of services that reside in Microsoft's Azure cloud, including the Power BI Service. Once installed, the Service can use this gateway to refresh datasets that have been published to the Power BI Service, as shown in the following screenshot:

Figure 1  Data Gateway

There are two modes in which the gateway can operate, as follows:

  • Standard (previously called Enterprise)
  • Personal

The reason we install a gateway in one mode versus the other comes down to the scenario in which you plan to use the gateway. You would want to use the Standard (Enterprise) mode if the following applies:

  • You wish to use the gateway for ...