Excel 1: Modern ETL with Power Query in Excel
Interested in attending? Have a suggestion about running this event near you?
Register your interest now
Description
When Power BI was being designed, the developers created a tool for importing and manipulating data. They called this tool Power Query, and they integrated it into Microsoft Excel. Today, Power Query represents one of the most powerful and potentially valuable tools in your everyday spreadsheets. Topics include: Connecting to data sources with Power Query Cleaning improperly structured data Combining and comparing data tables Automating imports Adding data to the Data Model