Your data career is in your hands. Stand out by making data transformations that are simple to use and quick. This lets companies make better business decisions, faster. People notice and it provides you with a solid career.
Microsoft has the best tool to do this. It’s called Excel Power Query. Want to use it like I do and improve your data career opportunities? This is the course you should have taken two years ago.
Introduce Yourself To Excel Power Query To Strengthen Your Data Analytics Career
Comments from students:
"Simple and to the point. If you're unsure of where to begin with Power Query, this is the course to take. Thank you!"
- Cynthia S.
"Bravo! I love every video in this course. Mr. Burke is a true teacher - He seems to know the learning pain points of students and then simplifies and arranges the lessons for maximum learning."
- Aisha I.
"Well summarized and articulate. Be sure to do the little exercises to fully grasp the concepts."
- Rudi P.
Become a more valuable professional. Spending less time manipulating data & more time analyzing it.
The explosion of data is changing the business world at an accelerating rate. Power Query is the perfect analytics tool for helping companies manage their data. Learning this awesome power is within everyone's reach. Let me prepare you for a career that will evolve as this new world evolves.
The career enhancing power of learning Power Query is amazing. It's time to see the tremendous benefits.
After this lesson, students will be able to identify and understand the purpose of the different sections of the Excel Power Query Ribbon.
After this lecture, students will be able to identify and understand how to use the 'Home' ribbon functions of the Power Query Editor.
After this lecture, students will be able to identify and understand how to use the 'Transform', 'Add Column' and 'View' ribbon functions of the Power Query Editor.
After this lecture, students will be able to install Power Query and perform updates whenever new versions become available.
After this lecture, students will be able to use Power Query's simple 'push-button' features to transform their data.
After this lecture, students will be able to use Power Query's more advanced formula features to transform their data.
After this lecture, students will be able to use create combine multiple queries into seamless Power Query's solutions.
After this lecture, students will understand how Power Query compares to other data transformation tools used by Finance and Accounting.
After this lecture, students will be able to understand the difference between Excel Power Query and Microsoft's other data transformation product called 'Power BI'.
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?