The key to successful reporting is the quality of data you’re working with. And while data has typically undergone cleansing and preparation before it gets to you, it’s not always organized in a way that suits practical business application. For example, the data may be organized by state, but you need to report it by sales region.
If you’re a Power BI author, Power Query Editor is your key to success in reporting. This self-service data prep tool will help you transform data into a format that aligns with business metrics.
In this on-demand webinar, watch demos of these data cleansing techniques
- Removing null values
- Removing columns
- Unpivoting data
- Add custom columns
- Merging queries
- Working with an M script
Don’t miss this introduction to Power Query Editor. Learn how to make data more efficient and create more accurate and better reporting.
Trainer and Consultant
Patrick has 20 years of experience in training, business intelligence and data analytics.Read more