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: Power BI
Power BI
Status: Data Integration
Data Integration
Intermediate·Course·15 hours
Featured reviews
5.0
·Reviewed Sep 23, 2021
It'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!
5.0
·Reviewed Jun 2, 2023
Great 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, 2022
It 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, 2022
I 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, 2021
Great 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, 2025
Just 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, 2023
Very 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, 2021
Excellent 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, 2024
The 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, 2024
This 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, 2021
I 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, 2021
Enjoyed 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
All reviews
Showing: 20 of 355
All Learners
All Stars
Most Helpful
D
Daniel
3.0
·Reviewed May 21, 2021
Nicky is very good, but the practice assessments, quizzes, and final assessment should/could more accurately reflect the video content.
G
Greg
2.0
·Reviewed Sep 30, 2022
They never respond to questions.
They never fix problems even years later.
Excel links point to inaccessible university addresses.
The videos are long and verbose and deal with many superficial and cosmetic aspects - lightweight.
The PowerBI required for later sessions is unavailable with personal email address, no matter what they say.
They have not arranged with Microsoft for student access to the necessary Microsoft service.
The quizzes and assignments are lightweight to the extent of being trivial
The PowerBI Menus are out of date, causing great frustration and time-wasting
There is very little use of the important feature like DAX and M
Rated very poor - two stars is much more than I want to give, I am pretty angry about this low-level course.
T
Thanh
5.0
·Reviewed Apr 5, 2021
I 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!
A
Ali
5.0
·Reviewed Mar 21, 2021
Great content as usual, I hope to have more and more on data analysis, visualization and more in depth material about power BI.
Thank you so much
H
Héctor
5.0
·Reviewed May 4, 2021
I really enjoy this course, the whole program is great, I didn't expect to learn this much from Excel. Also, the teacher is amazing.
M
Miroslav
5.0
·Reviewed Jul 9, 2022
Great course! Absolutely recommend it. It is a must have knowledge for working with Excel. I found even just power query (get and transform) helps me tremendously in my everyday work and substitutes a lot of VLOOKUPS and INDEX & MATCHES that I had been using before. What is most important it is very easy to learn especially as it was presented in this course. PowerPivot and Power BI is an add on. I finished Excel for Bussiness specializationf from Macquarie University and I'am know finishing Excel Skills for Data Analytics and Visualization Specialization and I must say, for me, these courses were the best courses I have encountered in my online learning so far (and I did a lot of online courses).
I
Isaac
5.0
·Reviewed Aug 25, 2021
I sincerely want to appreciate Macquire University, this is the most practical course I have had in a long while. It was hands-on all through the stages of Data Analysis. I enjoyed it, and had renewed confidence in my excel skills. I initially planned to do only the course 1 seeing I had past knowledge on the subject matter. However, I enjoyed it so much I ended up completing the three. Thank you.
M
Michele
5.0
·Reviewed May 3, 2021
This course was fantastic. I learned more about Power Bi from this than I have from several other webinars presented by Microsoft and/or their partners. Being able to work along with the videos truly helps to reinforce all of the new concepts.
Y
YASH
5.0
·Reviewed Feb 2, 2022
It 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.
E
Eduardo
5.0
·Reviewed May 12, 2021
Excellent course. Well designed and presented. I can use the skills learned immediately in my new career as a Data Analyst.
M
Miloš
5.0
·Reviewed May 6, 2021
Professor is great! I like this course and I would definitely enroll in advance course if there would be one.
D
Douglas
5.0
·Reviewed Jul 2, 2021
This is an excellent course for those who would like to learn how to automate the process of retrieving, cleaning, and visualizing data using Excel. Those who are in management or are in the business/data analysis field will find this course particularly useful. The quality of the course from Macquarie, particularly from these two instructors, is the best that I have experienced.
R
RICARDO
5.0
·Reviewed Aug 31, 2021
I totally recommend this course to anyone who wants to master their Excel skills. I want to thank the instructors for developing this amazing course, now I feel more confident using Power Query, Power Pivot and Power BI which are very useful to perform complex data analysis. It really helped me be more competitive when applying for a job offer. Thank you!!!
B
Bilal
5.0
·Reviewed May 24, 2021
I have taken all three courses in this specialization and also the previous specialization Excel Skills for Business. I learned a lot from these two specializations. Both are very informative. I recommended these specializations to one who is looking to start his career in data analysis and visualization.
M
Marta
5.0
·Reviewed Jul 13, 2021
A very well paced intermediate course for Power BI professionals. Nicky is awesome! I'd love to find more classes shared by her. All the classes are accompanied with working docs and tools. I learned a lot from this course and hopefully will make a difference at my work!
N
Naglaa
5.0
·Reviewed Aug 18, 2021
Enjoyed 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
I
Irene
1.0
·Reviewed Feb 21, 2025
Un usuario con Mac no puede realizar el curso, deberían avisarlo antes de inscribirte.
M
Mohamed
5.0
·Reviewed Jul 4, 2023
The course is very powerful and has a great content , I really enjoyed the learning .
But , there is one issue at the specialization certificate that the description of the certificate contains to many objectives that i have learned at the course not the description for the degree as whole , also the tone directed to me as a trainee , so it will be a problem when i apply for a job and the recruiter read the objectives not the describtion for the degree .
M
Meike
5.0
·Reviewed Oct 28, 2022
Fantastic presentation on functionalities of the Power Tools! Especially the introduction to Power BI was very helpful but needed the base on Excel and the Power Pivot basics to be understood. Fantastic, I have never seen such a didactically brilliant course on a not very easy to understand (especially DAX) matter. Thank you for making my learning such a great experience! I will keep practising using the examples provided in the course.
V
Vikasa
5.0
·Reviewed May 14, 2023
I am happy to share that I completed one of the best course on data analytics from one of the topmost university in the world. This course is completely filled with knowledge ,spending every moment on this course will improve your skills. Heartfully I am thanking Mentors #NickyBull ,Course material and Content Creators, Graphic Editors of #macquarieuniversity for providing one of the best course on Data Analytics