This course presents five use cases for specific data issues a user may encounter in Power Query (Excel version). Through hands-on examples, users are guided through the process of overcoming each of these issues.Power Query is an "ETL" tool that extracts, transforms, and loads data. This tool has a user-friendly interface that enables the Excel...
This course introduces users to the Power Query Editor, using the Excel version of Power Query, and includes a hands-on transformation exercise using the editor. Power Query is an "ETL" tool that extracts, transforms, and loads data. This tool has a user-friendly interface that enables the Excel user to connect to data sets they previously...
Using a variety of hands-on exercises, this course enables users to learn how to add columns using Power Query (Excel version). Power Query is an "ETL" tool that extracts, transforms, and loads data. This tool has a user-friendly interface that enables the Excel user to connect to data sets they previously did not have access...
This one-hour course will focus primarily on Power Query, Power Pivot, and VLOOKUP skills. Users will learn how to join tables using various techniques and add-ons in Excel. Users will understand how to utilize the tools while maintaining data integrity. The majority of the course will focus on hands-on data exercises. Users will apply skills...
As the rewards from data continue to grow, companies must recognize the value of data to remain competitive in the current digital economy. Companies that use data in their business processes are outperforming those that do not. Data skills will become necessary in the next few years, and your employees will need them to perform...