Data is the Oil of the 21th century as The Economist once titled. In a perfect world this data is stored in the perfect data model, either on prem or in the cloud, nicely formed and ready to use. Right? But we live in a world that is far away from this. Data is everywhere. It is in SharPoint Lists, CSV Files, Excel Files, maybe in your System, maybe in another Application, even in your Active Directory. Often there are requirements to transform this data from one Data Storage to another just to sync data between different sources or just because the boss wants some Excel file (sigh). A big Data Transformation Solution like SSIS or Azure Data Factory might not always be the best solution to accomplish these tasks. Join german Data Platform MVP Frank Geisler in a demo centric session where he demonstrates how to transform data between different data sources with PowerShel, dbatools and ImprortExcel and do all this little transformations in the blink of an eye. And remember your Boss waiting on his Excel Sheet? Even this can be archeived easily through PowerShell!