Excel Power Tools for Data Analysis
Keep adding new skills with 10,000+ programs for $239 (usually $399). Save now.
Excel Power Tools for Data Analysis
This course is part of Excel Skills for Data Analytics and Visualization Specialization
78,517 already enrolled
Included with
Ask Coursera
1,331 reviews
Recommended experience
1,331 reviews
Recommended experience
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
See how employees at top companies are mastering in-demand skills
Build your subject-matter expertise
- 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 5 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.
Welcome to your journey into Excel Power Tools for Data Analysis! In this introductory module, you'll get a comprehensive overview of how Power Query, Power Pivot, and Power BI will revolutionize your data handling. You will learn to import and transform data efficiently, work with massive datasets, and create compelling interactive reports. This material will orient you to the course's structure and goals. We encourage you to reflect on your learning objectives and share them with your peers to maximize your experience.
What's included
3 readings
3 readings•Total 35 minutes
- Welcome to Excel Power Tools for Data Analysis•15 minutes
- Course goals and weekly learning objectives•10 minutes
- Important information about versions and regions•10 minutes
Ready to begin your data analysis journey? This module focuses on the crucial first steps: importing and combining data. You'll discover how to leverage Excel's powerful Get and Transform feature, also known as Power Query, to efficiently bring data from various sources into your workbook. Learn the different methods for combining datasets to meet your specific data analysis needs. To get the most out of this module, try importing data from a new source each week.
What's included
9 videos4 readings8 assignments
9 videos•Total 55 minutes
- Week 1 Introduction•4 minutes
- Introduction to Power Query•6 minutes
- Get and transform data from Excel•6 minutes
- Get data from a database•5 minutes
- Get data from a folder•8 minutes
- Append queries with 2 datasets•5 minutes
- Append queries with 3 or more datasets•7 minutes
- Merge queries — Left Outer join•6 minutes
- Merge queries — Inner and Anti joins•8 minutes
4 readings•Total 55 minutes
- Read me before you start: Quizzes and Navigation•10 minutes
- Download the Week 1 workbooks•5 minutes
- Week 1 Practice Challenge•30 minutes
- Week 1 Toolbox•10 minutes
8 assignments•Total 80 minutes
- Introduction to Power Query•10 minutes
- Get and transform data from Excel•10 minutes
- Get data from a database•10 minutes
- Get data from a folder•10 minutes
- Append queries with 2 datasets•10 minutes
- Append queries with 3 or more datasets•10 minutes
- Merge queries — Left Outer join•10 minutes
- Merge queries — Inner and Anti joins•10 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. You'll learn to pivot data between wide and long formats, group information, and split columns using Power Query's powerful features. These techniques are crucial for preparing your datasets for accurate and insightful analysis. To succeed, practice each transformation step as you learn.
What's included
7 videos4 readings6 assignments
7 videos•Total 51 minutes
- Week 2 Introduction•2 minutes
- Applying transformations with the Query Editor•8 minutes
- Unpivoting data•9 minutes
- Pivoting data in the Query Editor•4 minutes
- Grouping data•7 minutes
- Working with columns in Office 365•11 minutes
- Working with columns in Excel 2016•9 minutes
4 readings•Total 50 minutes
- Download the Week 2 workbooks•5 minutes
- Working with columns — difference in versions•5 minutes
- Week 2 Practice Challenge•30 minutes
- Week 2 Toolbox•10 minutes
6 assignments•Total 95 minutes
- Test your skills: Weeks 1 and 2•45 minutes
- Applying transformations with the Query Editor•10 minutes
- Unpivoting data•10 minutes
- Pivoting data in the Query Editor•10 minutes
- Grouping data•10 minutes
- Working with columns•10 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. You'll learn to define database-like relationships between tables and visualize your data using Power Pivot and advanced cube functions. Master creating dynamic PivotTables from these robust data models. For best results, practice building complex data relationships.
What's included
7 videos3 readings7 assignments
7 videos•Total 61 minutes
- Week 3 Introduction•7 minutes
- Adding data to the Data Model•8 minutes
- Data Modelling•9 minutes
- Analysing data with Power Pivot•9 minutes
- Visualising data with Power Pivot and Cube Functions•9 minutes
- Introduction to DAX measures•9 minutes
- Applying Time Intelligence and CALCULATE•9 minutes
3 readings•Total 45 minutes
- Download the Week 3 workbooks•5 minutes
- Week 3 Practice Challenge•30 minutes
- Week 3 Toolbox•10 minutes
7 assignments•Total 125 minutes
- Test your skills: Week 3•45 minutes
- Adding data to the Data Model•10 minutes
- Data Modelling•10 minutes
- Analysing data with Power Pivot•10 minutes
- Visualising data with Power Pivot and Cube Functions•10 minutes
- Introduction to DAX measures•10 minutes
- Applying Time Intelligence and CALCULATE•30 minutes
Get ready to elevate your data presentation! In this module, we transition from Excel to Power BI, Microsoft's leading Business Intelligence tool. You'll apply your foundational skills from Power Query and DAX to design and build dynamic, interactive reports and dashboards. Learn to transform raw data into compelling visual stories and share your insights effectively. To master Power BI, experiment with different visualization types for your data.
What's included
7 videos3 readings7 assignments
7 videos•Total 85 minutes
- Week 4 Introduction•3 minutes
- Introducing Power BI•15 minutes
- Adding a Calendar using DAX•14 minutes
- Creating a Power BI report•15 minutes
- Working with reports•14 minutes
- Adding time intelligence•11 minutes
- Sharing Power BI reports•13 minutes
3 readings•Total 45 minutes
- Download the Week 4 workbooks•5 minutes
- Week 4 Practice Challenge•30 minutes
- Week 4 Toolbox•10 minutes
7 assignments•Total 105 minutes
- Test your skills: Week 4•45 minutes
- Introducing Power BI•10 minutes
- Adding a Calendar using DAX•10 minutes
- Creating a Power BI report•10 minutes
- Working with reports•10 minutes
- Adding time intelligence•10 minutes
- Sharing Power BI reports•10 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
Offered by
Explore more from Business Essentials
- Status: Free TrialL
Logical Operations
Course
- Status: Free Trial
Specialization
- Status: Free TrialM
Macquarie University
Specialization
- Status: Free Trial
Course
Why people choose Coursera for their career
Learner reviews
- 5 stars
87.36%
- 4 stars
10.97%
- 3 stars
1.35%
- 2 stars
0.07%
- 1 star
0.22%
Showing 3 of 1331
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.
Reviewed on Oct 7, 2021
Very nice course. Learnt a lot. The instructors Nicky Bull and Dr Prashan S. M. Karunaratne were good. Helped me to develop my knowledge on excel.Thank YouMahesh Gokhale
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.
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.
More questions
Financial aid available,