Book Image

Microsoft Power BI Cookbook

By : Author Test, Brett Powell
Book Image

Microsoft Power BI Cookbook

By: Author Test, Brett Powell

Overview of this book

Microsoft Power BI is a business intelligence and analytics platform consisting of applications and services designed to provide coherent, visual and interactive insights of data. This book will provide thorough, technical examples of using all primary Power BI tools and features as well as demonstrate high impact end-to-end solutions that leverage and integrate these technologies and services. Get familiar with Power BI development tools and services, go deep into the data connectivity and transformation, modeling, visualization and analytical capabilities of Power BI, and see Power BI’s functional programming languages of DAX and M come alive to deliver powerful solutions to address common, challenging scenarios in business intelligence. This book will excite and empower you to get more out of Power BI via detailed recipes, advanced design and development tips, and guidance on enhancing existing Power BI projects.
Table of Contents (14 chapters)

Conventions

In this book, you will find a number of text styles that distinguish between different kinds of information. Here are some examples of these styles and an explanation of their meaning. Code words in text, database table names, folder names, filenames, file extensions, pathnames, dummy URLs, user input, and Twitter handles are shown as follows: "Indicator columns, such as Weekday Indicator, Holiday Indicator, and Working Day Indicator."

A block of code is set as follows:

FALSE()
[Reseller Product Line] IN {"Mountain","Touring"}
[Sales Territory Group] = "Europe"

When we wish to draw your attention to a particular part of a code block, the relevant lines or items are set in bold:

Internet Net Sales (CY YTD) = CALCULATE([Internet Net Sales],
FILTER(ALL('Date'),'Date'[Calendar Year Status] = "Current Calendar Year" && 'Date'[Date] <= MAX('Date'[Date])))

New terms and important words are shown in bold. Words that you see on the screen, for example, in menus or dialog boxes, appear in the text like this: "Click on Save and then choose the new role from View as Roles on the Modeling tab"

Warnings or important notes appear like this.
Tips and tricks appear like this.