Power Query is a component of Excel and Power BI. It has a unique approach to preparing data that reduces manual manipulation and does not require learning to write code. This presentation will introduce you to Power Query and demonstrate how it can be used to transform data from many formats into a clean table structure useful in Microsoft Access. This will be a live demo packed with examples.
Ben Sacherich is a software developer from Pittsburgh, Pennsylvania with over 18 years of experience with VBA, Access, and Excel. He is a charter member of the international Professional Access Developer’s Unit, and attendee at multiple Portland International Database Conferences.