A common requirement when creating a data model is to transform the data after it is loaded from the source and before it is loaded into the data model. For example, you may need to group, pivot, replace, or expand the data. In a traditional data warehouse implementation this is performed using an ETL (Extraction, Transform and Load) tool such as SQL Server Integration Server (SSIS). While SSIS is a great tool for developers it is not meant for Business Analysts implementing self-service BI. To enable self-service ETL Microsoft has created a great tool – Power Query. Power Query lets the user create robust transformations using an intuitive interface and then loading the results into a Power Pivot Model. This session guides you through the process of using Power Query to extract, transform and load data into your data model from a variety of sources.
Dan Clark is a senior IT consultant specializing in .NET and SQL Server technology. For over a decade, he has been developing applications and training others to develop applications using Microsoft technologies. Dan has published several books and numerous articles on .NET programming. He is a regular speaker at various developer conferences and user group meetings, and he conducts workshops in object-oriented programming and database development.