Project Botticelli

Building Reports in Excel Purchase this course

21 December 2018 · 43 views

Power BI Course

Building Reports in Excel

There are two ways to connect Excel on the desktop up to data stored in Power BI: you can use the Analyse in Excel feature that was shown in an earlier section, or you can use the Power BI Publisher for Excel add-in which is probably easier to use for most users. Once you have created the connection you can use an Excel PivotTable to browse data in Power BI. PivotTables connected to Power BI data behave in a similar way to regular Excel PivotTables but there are also some useful new features such as Named Sets, Show Details. Slicers can be used as a way for users to filter the data that is shown.

The other ways to display Power BI data in Power BI is to use Excel Cube Formulas, which are well-suited for creating highly-structured reports (such as financial reports), or using Excel tables. Power View sheets are still available in Excel 2016 but they are deprecated and you should not encourage your users to use them. The 3D Maps functionality can be used to display data on a three dimensional map and there are various other Excel Add-ins and Apps that can be used to display data too.

Log in or purchase access below to the premium version of this content.

Purchase This Course or Full Access Subscription

Single Course

$250/once

Access this course for its lifetime*.
Purchase
Subscription Best Value

$480/year

Access all content on this site for 1 year.
Purchase
Group Purchase

from $480/year

For small business & enterprise.
Group Purchase

  • Redeem a prepaid code
  • Payment is instant and you will receive a tax invoice straight away.
  • Your satisfaction is paramount: we offer a no-quibble refund guarantee.

* We guarantee each course to be available for at least 2 years from today, unless marked above with a date as a Course Retiring.

Online Courses