Book Image

Microsoft Power BI Cookbook - Third Edition

By : Greg Deckler, Powell
Book Image

Microsoft Power BI Cookbook - Third Edition

By: Greg Deckler, Powell

Overview of this book

Since its first edition the Power BI Cookbook has been a best-selling resource for BI developers and data analysts to produce impactful, quality BI solutions. This new and updated edition retains the rigorous details and concepts readers of prior editions have enjoyed while also demonstrating powerful new capabilities and updated guidance aligned to the current state of the platform. In this book, with step-by-step instructions, you will learn to navigate the complexities of data integration and visualization in Power BI. From creating robust data models to implementing sophisticated reporting techniques, this Power BI book empowers you to make informed decisions based on actionable insights. It also introduces you to new capabilities such as Hybrid tables and scorecards, enhancing your ability to communicate and analyze business performance. It also expands and improvises on the core of the previous edition like parameterizing Power BI solutions, authoring reports, data intelligence, and integrating advanced analytics. This edition not only updates you on the latest features but also prepares you for future innovations with a preview of upcoming AI enhancements in Power BI. Whether you're refining your skills or aspiring to become an expert, this book is an invaluable resource for leveraging Power BI to its fullest potential
Table of Contents (16 chapters)
14
Other Books You May Enjoy
15
Index

Installing and Licensing Power BI Tools

Microsoft Power BI is a suite of business analytics tools and services that work together to access data sources, shape, analyze and visualize data, and share insights. Although not all the tools are required for every project or deployment of Power BI, synergies are available by utilizing the distinct features and use cases of multiple tools as part of integrated solutions, encompassing diverse data sources, rich data analytics, and visualization types.

In this chapter, we walk through the installation and configuration of the primary tools and services that business intelligence (BI) professionals utilize to design and develop Power BI content. This includes official Microsoft tools such as Power BI Desktop, Power BI Report Builder, SQL Server, the on-premises data gateway, and various third-party tools such as DAX Studio, ALM Toolkit, and Tabular Editor.

The recipes in this chapter are as follows:

  • Installing and configuring Power BI Desktop
  • Installing SQL Server and the AdventureWorks database
  • Installing and using Power BI Report Builder
  • Creating an on-premises data gateway
  • Installing additional tools
  • Thinking about licensing