Using Power BI Datasets to Create Excel Financials - DynamicsCon

Using Power BI Datasets to Create Excel Financials

Speaker

Clinton Saunders

Clinton Saunders

First Time DynamicsCon Presenter

Session Description

Ever wondered how to make Financial Reporting easier and more Dynamic? This session will introduce the concept of organised Power BI Datasets for reporting requirements i.e. Dimensions and Measures instead of Records and Fields. We will introduce the administration of these Datasets to manage Access Control and Refresh Schedules. Then I will show you how to use Powerful Excel features to create Dynamic Financial Reports: • Connecting to live Power BI Datasets • Pivot Tables • Use Powerful Formulas such as CUBESET, CUBEMEMBER and CUBEVALUE to calculate the numbers.

Session Track: Power Platform
Session Type: Functional
Content Level: Intermediate

DISCOVER ALL DYNAMICSCON EVENTS!

SEE WHAT'S HAPPENING, AND ON THE HORIZON, THIS YEAR AND BEYOND!

DynamicsCon LIVE, hosted by Dynamics User Group, returns May 13th-16th, 2024, in gorgeous Denver, Colorado!

DynamicsCon LIVE

DynamicsCon Virtual is back for its sixth event! Join us on Wednesday, November 13th, 2024!

DynamicsCon Virtual
Back to top