Power BI (including Power Query & Power Pivot) are the biggest Excel news items in the last 10 years. They give Excel users the power to draw information out of multiple sources, link it together then perform calculations on it that can then be sliced & diced any way you want.
This hands-on course is focused on real-world techniques utilising the amazing capabilities of Power Query, Power Pivot and Power BI. You will use Power Query to extract and shape data and then load it into Power Pivot. You will build a complex Power Pivot Model from scratch, write DAX formulas and set up interactive reports. You will get a more in-depth understanding of Power Query and Power Pivot reporting techniques
Join us at this 2-day workshop to get a hands-on experience on:
Principal Business Analyst and Chief Executive Officer
Jeff is the Principal and Founding Director of Access Analytic, a specialist consultancy that specialises in Power BI, data analytics, dashboards and financial modelling for clients worldwide.
His achievements have been recognised by his peers and he is a Fellow of both the Financial Services Institute of Australasia and the Australian Institute of Management.He is skilled in the development and maintenance of analytical tools and financial models for middle-market to large corporate transactions and clients, at all levels of complexity, in both domestic and international settings.