18 Sep 2019
1:00 pm - 1:50 pm


Using Power Query to Drive your Dashboards

Every day, millions of Excel users manually pull data from some source location, manipulate that data, and integrate it into their reporting.  Power Query helps automate the cleansing and shaping of your data in preparation for your reporting models.  But Power Query can do more for your dashboards than you may have guessed.  In this session, you see how a few Power Query tricks can turn your dashboard into a real-time interactive solution.

Excel Can Do Even More than You Think: Empower your Reporting with GL Wands

In this changing financial environment, the importance of financial modelling is becoming more prevalent. Finance teams are looking for more strategic ways to evaluate the ever-increasing volumes of data they are faced with; but finding a good financial model that accesses your ERP data is a challenge. Learn how to build reports that allow for more strategic analysis of data, reduce spreadsheet errors, and increase report automation; accessing ERP data in real-time – all with a click of a button.