Book Image

Learn Power BI - Second Edition

By : Gregory Deckler
5 (1)
Book Image

Learn Power BI - Second Edition

5 (1)
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 updated second edition of Learn Power BI takes you on a journey of data exploration and discovery, using Microsoft Power BI to ingest, cleanse, and organize data in order to unlock key business insights that can then be shared with others. This newly revised and expanded edition of Learn Power BI covers all of the latest features and interface changes and takes you through the fundamentals of business intelligence projects, how to deploy, adopt, and govern Power BI within your organization, and how to leverage your knowledge in the marketplace and broader ecosystem that is Power BI. As you progress, you will learn how to ingest, cleanse, and transform your data into stunning visualizations, reports, and dashboards that speak to business decision-makers. By the end of this Power BI book, you will be fully prepared to be the data analysis hero of your organization – or even start a new career as a business intelligence professional.
Table of Contents (19 chapters)
1
Section 1:The Basics
4
Section 2:The Desktop
10
Section 3:The Service
15
Section 4:The Future

Generating data

Power BI Desktop is all about connecting to data, modeling that data, and then visualizing that data. Therefore, it makes sense that you cannot really do much within Power BI without data.

So, in order to get started, we are going to create some data to familiarize you with basic operations within the desktop.

Creating a calculated table

First, we will create a calculated table as follows:

  1. While in Report view, click on the Modeling tab.
  2. Choose New Table from the Calculations section of the ribbon. The formula bar will appear with the words Table =, and the cursor will become active within the formula bar.
  3. Type the following formula into the formula bar, replacing the existing text in its entirety:
    Calendar = CALENDAR( DATE(2017 ,1 ,1), DATE(2019 ,12 ,31) )

The preceding and subsequent formulas in this book are created and tested for the English language version of Windows and Power BI Desktop. Different language settings for Windows or...