<img alt="" src="https://secure.intelligent-consortium.com/791393.png" style="display:none;">

I’ve Got the Power (Query)!


Have you seen Power BI reports and thought, “hey, I want that, but I’d prefer to work in Excel”? If so, you’ve come to the right place.

Power BI might get all the attention for creating visually impactful interactive reports these days, but did you know that the same data engine also lives in Excel?

That’s right. You, too, can create stunning reports, without Power BI, directly from your Excel spreadsheets, and I will show you how. In this session, I will show you how to use the Power Query function in Excel to refresh and dynamically report on data from your Business Central instance. You will be able to create visually stunning reports that better convey your data’s story and engage your viewers for better decision-making.

I’ll be covering:

  • exposing web services from Business Central
  • pulling them into Excel
  • transforming them
  • linking them together
  • and creating quick calculations (measures) in Power Pivot

About the Presenter

Ramin Marghi

Ramin Marghi

Senior Application Consultant

Ramin is a designated accountant (CPA) and has been using Microsoft Dynamics products since 2010. He spent the first four of those years on the client side as a NAV and GP user and has been on the partner side in the Dynamics NAV / Business Central channel since. He has a broad spectrum of skills, coding in C/AL and AL, leading support, leading an implementation team, as well as designing Power BI and Jet Reports.

Having been on the client side of the table, Ramin brings a unique perspective and empathy to the struggles that clients face when encountering any issues in their system that prevent them from doing their jobs. He always leads with a “people first” perspective and approaches clients with humor, compassion, and a willingness to listen to customers.