Revealed: Power Query Advanced Tips And Tricks
- 3 hours on-demand video
- 1 article
- 26 downloadable resources
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Get your team access to 4,000+ top Udemy courses anytime, anywhere.Try Udemy for Business
- Create data analytics like world-class companies
- Executive Case Study: you will clean, analyze and document a project data set ; includes video instructions and downloadable Excel file solutions to insure you're learning
- Write If-Then-Else statements within conditional columns and create embedded functions in custom columns
- Reference the Power Query Formula Language to find and use unique functions to transform your data
- Build using the 'M' language Advanced Editor and Query Manager to control your processes and work faster
- Strong desire to learn advanced Power Query data cleansing skills
- Basic knowledge of Power Query (have used it, even at a beginner level)
- Know your way around the Power Query ribbons and editor
3rd in my series of Udemy courses on mastering data cleaning in the age of big data
Every day is a training day for your next job opportunity. Prepare by making data transformations that are simple to use and quick. People notice, and you will have a solid career. Microsoft has the right tool for this. It’s called Excel Power Query. Want to use it like a pro?
Advanced Excel Power Query Will Strengthen Your Data Analytics Career
'Learn by doing' with downloadable exercise files, step-by-step video demonstrations and three-part 'Case Study' assignment that reinforces the knowledge you gained
Custom columns, the Power Query Formula Language (‘M’ code), embedded functions and much more
Dozens of tips & tricks focused on Power Query's best features
Control Your Data Instead Of Letting It Control You
I designed this course for data users of all levels. There is something here for everyone. We’ll solve some of the most common data cleansing problems encountered by data analysts. You’ll walk away with first-rate knowledge valued in the job market. It's essential for developing your data career.
Companies are moving to Excel Power Query for next generation data analysis power. Let me prepare you for the career that companies need.
By taking this course, you will say "Wow. It didn't know I could do that with Power Query!"
- Those who want to learn an in-demand business skill and increase their career opportunities
- Those who want to improve their data analytics and Power Query talents
- Those who are willing to try Power Query in new ways
Scenario: You are the lead sales analyst for DogCatSquirrel Inc. and just received an Excel file containing sales results for FY17 Q1 (Jan, Feb, Mar).
You must clean and analyze this data for two purposes:
1) bonus and commissions payments
2) to determine company performance during Q1
Note: to create 'State' column, use
- North = Michigan
- South = Georgia
- East = New York
- West = Oregon