Leveraging the Advanced Editor in Power Query to share cleaning routines
Leveraging the Advanced Editor in Power Query to share cleaning routines
When you work in a team but on solo projects you can find yourself with some advanced cleaning routines. These routines could likely be shared with others on the team to reduce the amount of cleaning that you do collectively for common projects. Learn how to leverage the advanced editor to share cleaning steps.
If you’re a data analyst, you’ve no doubt learned different skills, techniques, and tools pertaining to data. But sometimes it can be difficult to know when and why to apply these tools. In this weekly series, instructor Robin Hunt explains a new skill, secret, tip, technique, best practice, or golden piece of advice in each installment. Robin covers topics that can help you do your job better, such as joining data and data designs, privacy for data, transforming and cleaning data, and making data sets and visualizing data.
Note: Because this is an ongoing series, viewers will not receive a certificate of completion.