Excel Business Intelligence Power Query

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.

Requirements

Basic Knowledge of Spreadsheet

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!

Overview

Section 1: Excel Business Intelligence

Lecture 1 Business Intelligence Introduction

Lecture 2 Power of Excel after Business Intelligence

Lecture 3 Data Connection and Source

Lecture 4 Difference between Power Query and Excel

Lecture 5 Power Query Editor

Lecture 6 How Power Query Works

Section 2: Power Query Deep Dive

Lecture 7 Power Query - Deep Dive

Lecture 8 Options for Loading data in Excel

Lecture 9 General understanding of Editor

Lecture 10 Difference between Data Transform and Add Column

Lecture 11 Text and Number Query Editor Tools

Lecture 12 Date Specific Query Editing Tools

Lecture 13 Conditional Column with Power Query

Lecture 14 Group and aggregate data

Lecture 15 Merge Power Query

Lecture 16 Append Power Query

All professionals intend to learn about data management and analysis.