Participants will be introduced to two of the Excel Power BI tools. They will learn Power Query to pull data into Excel from many different data sources. Then, they will learn how to create Power Pivot Tables to summarize and analyze large chunks of data.
*Introduction to Excel Power BI
*The Power Query Tool
*The Power Pivot Tool
NCPMI Excel Analytics Session 10 recording
Excel Manual 10
Session 10 Exercise Files