Quickly Learn Excel Power Query and Power Pivot with example

Focused View

Mohammad Parwez

1:42:51

120 View

1. Introduction

1. Introduction.mp4

01:10

2. What will you learn in this course

1.1 2016Jan1-2016Dec31CustomUnifiedTransaction.csv

1.2 2017Jan1-2017Dec31CustomUnifiedTransaction.csv

1.3 2018Jan1-2018Dec31CustomTransaction.csv

1.4 2018Jan1-2018Dec31CustomTransaction.csv

1.5 2019Jan1-2019Dec31CustomTransactionCA.csv

1.6 2019Jan1-2019Dec31CustomUnifiedTransaction.csv

1.7 2020Jan1-2020Dec31CustomUnifiedTransaction.csv

1.8 Power Query Template File.xlsx

1. What will you learn.mp4

01:15

3. Begin the course with a case study

1. Start with an example.mp4

12:29

2. Power Query - How to Import Data.mp4

08:37

3. Data Cleanup in Power Query.mp4

06:11

4. Data Model

1. Create a data model.mp4

09:28

5. Data Transformations

1. Data Transformations I.mp4

07:09

2. Advanced Data Transformations.mp4

14:10

3. Advanced Data Transformations III.mp4

05:45

6. Create Pivot Tables using Data Model

1. Create Pivot Table.mp4

06:03

2. Create Pivot Table II.mp4

06:57

3. Create Pivot Table III.mp4

10:00

7. Create Dashboard

1. Create Dashboard.mp4

13:37

Description

Learn more in 2 hours with a case study. Easy to follow and do along.

What You'll Learn?

Students new to power query but have working knowledge of excel can learn power query quickly
Use the capabilities of power query to design dashboard and templates
Learn and apply the concepts of power query and relational database in excel.
Student will be able to use this knowledge at their work or start as an excel freelancer

Who is this for?

Beginner Excel students

Students interested to learn and apply the power query and power pivot features of excel

What You Need to Know?

Working knowledge of MS Excel with version 2016 and newer.

More details

Description
Welcome to our Excel Power Query and Power Pivot course!

Are you tired of manually cleaning and transforming your data in Excel? Do you wish there was a better way to extract, transform, and load data from various sources? Look no further than our comprehensive course on Excel Power Query and Power Pivot.

Designed for students with basic Excel knowledge, this course provides an in-depth exploration of Power Query and Power Pivot tools that will increase your productivity, efficiency, and data analysis skills. You'll learn the ins and outs of Power Query and how to clean and transform diverse data sources to generate compelling reports.

In addition, we'll teach you how to create calculated columns, measures, and relationships while working with big data in Power Pivot. By the end of the course, you'll be able to generate interactive dashboards and advanced visualizations.

Here's an example of one of the features you'll master in the course: Suppose that you have sales data in different formats, such as CSV, Text, and Excel sheets. You need to analyze these data files together and produce a report. With Power Query, you can easily load these files into one table and apply relevant transformations and calculations, such as join, merge, split, filter, and group by. Then, you can load the transformed data into Power Pivot and build charts and pivot tables.

By enrolling in our Excel Power Query and Power Pivot course, you'll be equipped to tackle real-world data scenarios just like this one. Sign up today on Udemy and start taking advantage of the power of Microsoft Excel!

Who this course is for:
Beginner Excel students
Students interested to learn and apply the power query and power pivot features of excel

User Reviews

Rating

average 0

Total votes0

Focused display

This is Mohammad Parwez. I have over 15 years of experience in the Supply Chain Management are with a post graduation in Industrial Engineering. I have experience in multiple facets like Supply Chain Planning, Execution, Fulfillment, Procurement, Manufacturing and have developed multiple custom applications that supports these critical business functions with my team.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.