How will this course enhance my business analytics skills?

This course will significantly boost your business analytics capabilities by teaching you to automate data processes, perform complex financial analysis, and create compelling data visualizations. You'll learn to handle big data efficiently, making you a more effective data analyst.

What kind of data visualization projects will I create?

You will learn to create dynamic and interactive data visualizations and dashboards using Power BI, transforming raw data into actionable insights. This includes building reports that effectively communicate complex data analysis.

What will I get if I subscribe to this Specialization?

When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.

Is financial aid available?

Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.

Excel Power Tools for Data Analysis

Excel Power Tools for Data Analysis

This course is part of Excel Skills for Data Analytics and Visualization Specialization

Instructors: Nicky Bull

81,427 already enrolled

Included with Learn more

4 modules

Gain insight into a topic and learn the fundamentals.

1,349 reviews

Intermediate level

Recommended experience

Flexible schedule

2 weeks at 10 hours a week

Learn at your own pace

4 modules

Gain insight into a topic and learn the fundamentals.

1,349 reviews

Intermediate level

Recommended experience

Flexible schedule

2 weeks at 10 hours a week

Learn at your own pace

What you'll learn

Master Power Query to automate data import and transformation
Utilize Power Pivot and DAX for advanced data modeling and analytics
Create interactive reports and dashboards using Power BI
Handle large datasets efficiently, overcoming Excel's traditional limits

Skills you'll gain

Tools you'll learn

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

28 assignments

Taught in English

97%

Most learners liked this course

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Build your subject-matter expertise

This course is part of the Excel Skills for Data Analytics and Visualization Specialization

When you enroll in this course, you'll also be enrolled in this Specialization.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate

There are 4 modules in this course

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.

Ready to begin your data analysis journey? This module focuses on the crucial first steps: importing and combining data. This week, you will use Power Query to import data from multiple sources and explore different ways to combine datasets for analysis. You will learn how query relationships work and apply merge and append operations to prepare data efficiently for larger analytical workflows.

What's included

9 videos7 readings8 assignments

9 videosTotal 55 minutes

Week 1 Introduction4 minutes
Introduction to Power Query6 minutes
Get and transform data from Excel6 minutes
Get data from a database5 minutes
Get data from a folder8 minutes
Append queries with 2 datasets5 minutes
Append queries with 3 or more datasets7 minutes
Merge queries — Left Outer join6 minutes
Merge queries — Inner and Anti joins8 minutes

7 readingsTotal 90 minutes

Welcome to Excel Power Tools for Data Analysis15 minutes
Course goals and weekly learning objectives10 minutes
Important information about versions and regions10 minutes
Read me before you start: Quizzes and Navigation10 minutes
Download the Week 1 workbooks5 minutes
Week 1 Practice Challenge30 minutes
Week 1 Toolbox10 minutes

8 assignmentsTotal 80 minutes

Introduction to Power Query10 minutes
Get and transform data from Excel10 minutes
Get data from a database10 minutes
Get data from a folder10 minutes
Append queries with 2 datasets10 minutes
Append queries with 3 or more datasets10 minutes
Merge queries — Left Outer join10 minutes
Merge queries — Inner and Anti joins10 minutes

Welcome to the exciting world of data transformation! Building on your data import skills, this module dives into how you can reshape your data for analysis. This week, you will use Power Query Editor to clean, transform, and restructure datasets for more effective analysis. You will explore pivoting, unpivoting, grouping, column transformations, and query modifications using M language to prepare data for accurate reporting and decision-making.

What's included

7 videos4 readings6 assignments

7 videosTotal 51 minutes

Week 2 Introduction2 minutes
Applying transformations with the Query Editor8 minutes
Unpivoting data9 minutes
Pivoting data in the Query Editor4 minutes
Grouping data7 minutes
Working with columns in Office 36511 minutes
Working with columns in Excel 20169 minutes

4 readingsTotal 50 minutes

Download the Week 2 workbooks5 minutes
Working with columns — difference in versions5 minutes
Week 2 Practice Challenge30 minutes
Week 2 Toolbox10 minutes

6 assignmentsTotal 95 minutes

Applying transformations with the Query Editor10 minutes
Unpivoting data10 minutes
Pivoting data in the Query Editor10 minutes
Grouping data10 minutes
Working with columns10 minutes
Test your skills: Data Transformation with Power Query Editor45 minutes

Ever hit Excel’s 1 million row limit? This module introduces the powerful Data Model in Excel, allowing you to analyze millions of rows of data, limited only by your computer’s memory. This week, you will build data models using Power Pivot and learn how relationships between tables support large-scale analysis. You will create measures using DAX, analyze data through PivotTables and cube functions, and visualize insights from complex datasets more effectively.

What's included

7 videos3 readings7 assignments

7 videosTotal 61 minutes

Week 3 Introduction7 minutes
Adding data to the Data Model8 minutes
Data Modelling9 minutes
Analysing data with Power Pivot9 minutes
Visualising data with Power Pivot and Cube Functions9 minutes
Introduction to DAX measures9 minutes
Applying Time Intelligence and CALCULATE9 minutes

3 readingsTotal 45 minutes

Download the Week 3 workbooks5 minutes
Week 3 Practice Challenge30 minutes
Week 3 Toolbox10 minutes

7 assignmentsTotal 125 minutes

Adding data to the Data Model10 minutes
Data Modelling10 minutes
Analysing data with Power Pivot10 minutes
Visualising data with Power Pivot and Cube Functions10 minutes
Introduction to DAX measures10 minutes
Applying Time Intelligence and CALCULATE30 minutes
Test your skills: Week 345 minutes

Get ready to elevate your data presentation! In this module, we transition from Excel to Power BI, Microsoft’s leading Business Intelligence tool. This week, you will create interactive Power BI reports and dashboards using data models, DAX calculations, and visualizations. You will also explore report-sharing options and learn how to transform analytical findings into compelling visual stories for business communication and decision-making.

What's included

7 videos3 readings7 assignments

7 videosTotal 85 minutes

Week 4 Introduction3 minutes
Introducing Power BI15 minutes
Adding a Calendar using DAX14 minutes
Creating a Power BI report15 minutes
Working with reports14 minutes
Adding time intelligence11 minutes
Sharing Power BI reports13 minutes

3 readingsTotal 45 minutes

Download the Week 4 workbooks5 minutes
Week 4 Practice Challenge30 minutes
Week 4 Toolbox10 minutes

7 assignmentsTotal 105 minutes

Introducing Power BI10 minutes
Adding a Calendar using DAX10 minutes
Creating a Power BI report10 minutes
Working with reports10 minutes
Adding time intelligence10 minutes
Sharing Power BI reports10 minutes
Test your skills: Week 445 minutes

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

Instructors

Instructor ratings

(512 ratings)

Nicky Bull

Macquarie University

27 Courses1,719,581 learners

Offered by

Macquarie University

Explore more from Business Essentials

Macquarie University
Excel Fundamentals for Data Analysis
Course
Macquarie University
Data Visualization in Excel
Course

Why people choose Coursera for their career

Felipe M.

Learner since 2018

"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021

"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Learner reviews

5 stars
87.32%
4 stars
10.97%
3 stars
1.40%
2 stars
0.07%
1 star
0.22%

Showing 3 of 1349

5.0

Reviewed on 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 on 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 on 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.

View more reviews

What brings you to Coursera today?

Start my career

Change my career

Grow in my current role

Explore topics outside of work

Unlock access to 10,000+ courses with a subscription
Advance your career with an online degree
Earn a degree from world-class universities - 100% online
Join over 4,700 global companies that choose Coursera for Business

Frequently asked questions

This course focuses on Power Query and Power Pivot tools available in Microsoft Excel for Windows (Excel 2016 and later), with Office 365 recommended for the best experience.

Power Query is not available for Excel for Mac.

You will gain expertise in Microsoft Excel's Power Query for data transformation, Power Pivot for advanced data modeling and analytics, and Power BI for creating interactive data visualizations and dashboards.

While this course is part of a Data Analytics Specialization, it is designed to build upon foundational Excel skills. Basic familiarity with Excel is recommended, but no advanced data analysis experience is strictly required to start learning these powerful tools.

To access course materials, assignments, and earn a Certificate, you'll need to purchase the Certificate experience when you enroll in a course. Eligible learners may also have the option to start with a Free Trial. Some courses may also offer a Full Course, No Certificate option. This lets you access course materials, submit required assessments, and receive a final grade, but you won't be able to earn or purchase a Certificate.