5.0
Reviewed Sep 23, 2021It's really a interesting part to learn the Power query and power pivot and power BI, this will be really helpful for me to improve myself for my career. Thanks you!
Excel Power Tools for Data Analysis
Unlock the full potential of Excel for advanced data analysis with this four-week course. Designed for aspiring data analysts and business professionals, you'll master Microsoft's powerful tools: Power Query, Power Pivot, and Power BI. This program will transform your ability to handle, analyze, and visualize large datasets, moving beyond traditional spreadsheet limitations. By the end of this course, you will be able to: * Automate data import and transformation using Power Query. * Perform advanced data modeling and analytics with Power Pivot and DAX. * Create dynamic, interactive reports and dashboards in Power BI. * Efficiently manage and analyze millions of rows of data within Excel. To succeed, we recommend prior experience with Excel fundamentals and data visualization, ideally from our 'Data Analytics and Visualization' Specialization. This course is designed for Excel 2016 and later, with Office 365 recommended for optimal experience. Please note: Power Query, Power Pivot, and Power BI Desktop are Windows-only.
Status: Data Storytelling
Status: Data Wrangling
IntermediateCourse15 hours
Featured reviews
5.0
Reviewed Jun 2, 2023Great explanation of every detail throughout the course. But I thought I'd let you know that there is a typo in the answer for the achieved % target in the Week 2 Practice challenge.
5.0
Reviewed Feb 1, 2022It was a good experience of learning on course era which helped me a lot to improve my technical skills and also I would like to learn more courses on course era in future.
5.0
Reviewed Oct 31, 2022I have learned many useful subjects that I haven't ever thought that I'd learn. Thanks for all the instructors who were behind this great course
5.0
Reviewed Apr 25, 2021Great training with powerful video illustration. The course material (excel spreadsheet, data sets, PowerBI templates) are also very well articulated and prepared. Thanks very.
5.0
Reviewed Feb 25, 2025Just excellent, everything the practice challenge, the way of teaching, everything. Great for anyone who wants to learn Data Modelling and Power BI.
4.0
Reviewed Jun 22, 2023Very useful systematic teaching approach from pivot table->Power Query->Power Pivot->PowerBi. Step by step guidance with good explanation. Worth it.
5.0
Reviewed Nov 13, 2021Excellent training on Power BI, even though its only compressed into one course. Looking forward to more data analytics related courses by Macquarie University.
4.0
Reviewed Mar 28, 2024The course content was excellent however the rushed pace of the videos made it loose spontaneity and flow with constant stopping and rewinding non conducive to learning.
5.0
Reviewed Dec 31, 2024This is a very comprehensive and easy to follow course. The contents include many useful tips and interesting information on how to utilize Excel.
5.0
Reviewed Apr 4, 2021I love this program. It's concise and informative. I am equipped with general understanding on Excel, Power Pivot, Power Queries and Power BI. Highly recommended courses!
5.0
Reviewed Aug 17, 2021Enjoyed the course and the specialization, the instructors are the best, they facilitate the information. I've learned new skills. and the course is highly recommended. thank you