This course is essential for developing your data career
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.
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
This video contains a detailed example of how I used Power Query to create the data table.
If you're like me, you see tremendous value in developing your career in data analytics, big data and business intelligence. Companies need these skills more than ever.
But did you know . . .
** The hardest part of any useful business intelligence system is getting clean data **
This statement comes from my 20+ years of experience building data analytics systems at Fortune 500 companies. Let me share my secrets so you get much better at cleaning your analytics data.
My specialty is creating clean data using Excel Power Query and Power BI Query Editor for analysis and visualizations.
I love this topic . . . Learn from me.
> I read the software user manuals so you don't have to
> I enjoy teaching complex topics in a clear, simple manner
> I'm very involved in the analytics community as a member of Microsoft's Power BI User Panel, and a frequent speaker at Oracle analytics events
Courses like mine are not widely available so I decided to create one. Thanks to the internet, a global audience now shares this knowledge.
Take my courses and enter a community of like-minded people who want everyone to succeed. I will personally answer any question posted and provide frequent updates on what's happening in the Power Query and Power BI communities. There is so much value here and I encourage you to join.
** You can dramatically improve your data cleaning skills today **
What are you waiting for?