Overview of Excel Power Query & Power Pivot + Power BI
In this session, you’ll see how Excel’s Power Query and Power Pivot can help automate recurring Excel reports. Power Query enables you to get and transform the source data files, while Power Pivot enables you to organize multiple tables and write formulas. When used together, these tools help you prepare and update PivotTables and Pivot Charts efficiently. Plus, we’ll see that Microsoft delivers these tools outside Excel, in a standalone application called Power BI. At the end of the session, after building our reports in Excel, we’ll re-create them using Power BI. If your job requires you to build reports in Excel, you won’t want to miss this session as these tools are sure to save you time.