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 is a hands on course focussed on real world techniques utilizing the incredible 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 also learn advanced features of each to understand how to get the most from these tools.
We will be supplying laptops and it is important that attendees are confident with excel.
Download Flyer Here