Excel Business Intelligence Power Query

Focused View

Syed Nadeem

38:55

49 View

1. Excel Business Intelligence

1. Business Intelligence Introduction.mp4

03:15

2. Power of Excel after Business Intelligence.mp4

01:30

3. Data Connection and Source.mp4

01:03

4. Difference between Power Query and Excel.mp4

01:25

5. Power Query Editor.mp4

02:25

6. How Power Query Works.mp4

01:27

2. Power Query Deep Dive

1. Power Query - Deep Dive.mp4

01:41

2. Options for Loading data in Excel.mp4

04:23

3. General understanding of Editor.mp4

02:45

4. Difference between Data Transform and Add Column.mp4

02:15

5. Text and Number Query Editor Tools.mp4

03:17

6. Date Specific Query Editing Tools.mp4

01:50

7. Conditional Column with Power Query.mp4

03:04

8. Group and aggregate data.mp4

04:04

9. Merge Power Query.mp4

02:57

10. Append Power Query.mp4

01:34

Description

Complete Introduction to Power BI Query Editor

What You'll Learn?

You will learn how to use Power Query editor to perform various operations on a dataset.
You will be introduced to getting data from various sources and cleaning it up
You will learn how to transform and prepare data for Microsoft Excel using Power Query.
You will learn how to create and manage query groups.
You will learn how to merge and append queries.
You will learn how to create conditional columns.

Who is this for?

All professionals intend to learn about data management and analysis.

What You Need to Know?

Basic Knowledge of Spreadsheet

More details

Description
Power Query is a data transformation and data preparation engine that allows you to perform the extract, transform, and load processing of data. Power Query enables connectivity to a wide range of data sources, including data of all sizes and shapes, and provides consistency of experience and parity of query capabilities over all data sources.
Throughout the course, you will learn how to import data from various sources, transform it according to your requirements, and generate refined datasets within your workbook. Every change you make to the data is recorded as a step, allowing you to easily replicate the process in the future.
The key features of Power Query includes Data Loading, Data Preparation, Data Transformation and User Experience. If you desire to begin a career in data analysis, quantitative analysis, business intelligence, or other areas of finance, the Power Query Fundamentals course is designed to equip you with the necessary skills.
Whether you are a beginner or an experienced Excel user, the Power Query course is a must-have for anyone looking to enhance their data manipulation skills and become proficient in Power Query.

This tool really helps me to make my unique place in every place of work. Hope you will enjoy this learning!
Who this course is for:
All professionals intend to learn about data management and analysis.

User Reviews

Rating

average 0

Total votes0

Focused display

I'm Syed Nadeem, Strategic Finance Leader, over 20 years of global experience in different industries. I believe in value creation through business partnering and help organization in strategic decision making by providing valuable business insights. I help finance professionals on their career journey by exploring their real potential through One-on-One Online Career Coaching Sessions.Let's Connect!

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.