Power Query/ Power BI

 

Tranining (Short Course 3 Days)

Date: April 14, 15, 16

Time: 1:00 to 3:00 p.m (2 hours)

Language: Myanmar

Classroom: https://classroom.google.com/c/NDgzOTg0MDYxNjAy?cjc=42h56ma

Interactive Visual: Google Meet or Microsoft Teams

Cost: Free of Charge

#Power #Query

I. Overview

-Data Connection Technology

-To Discover

-To Connect

-To Transform

-To Combine

-To Refine

-To Meet Your Analysis Needs

II. Use

A. In Excel

B. In Power BI

III. How Work

A. Search for Data Sources

B. Make Connections

C. Shape the Data

e.g--Remove Columns,

e.g--Change Data Type

e.g--Merge Tables

IV. How Get

-Excel 2010/2013 (Note: The Microsoft Power Query add-in for Excel 2010/2013 is no longer being updated by Microsoft. Please upgrade to a newer Excel version.)

Download>>https://www.microsoft.com/en-us/download/details.aspx?id=39379&WT.mc_id=Blog_PBI_Announce_DI

-Excel 2016/2019 and Office 365

-Data-->Get Data(Get & Transform Data ribbon group)  

Source>>https://support.microsoft.com/en-us/office/power-query-overview-and-learning-ed614c81-4b00-4291-bd3a-55d80767f81d?ui=en-us&rs=en-us&ad=us

Source>>https://support.microsoft.com/en-us/office/get-transform-in-excel-881c63c6-37c5-4ca2-b616-59e18d75b4de

https://www.facebook.com/ImproveOfficeSkill/posts/1496853973845719

Tutorial>>To Explain in the Training

-Where is Power Query (Create an advanced query (Power Query))

https://support.microsoft.com/en-us/office/create-an-advanced-query-power-query-9f08ceac-c949-4408-baff-6a7eaa183e11#ID0EAACAAA=Office_2010_%E2%80%93_2013

-Shape data (Power Query)

https://support.microsoft.com/en-us/office/shape-data-power-query-9b2dac2b-e13d-46a4-8940-7bc55f44597d

-Combine data from multiple data sources (Power Query)

https://support.microsoft.com/en-us/office/combine-data-from-multiple-data-sources-power-query-70cfe661-5a2a-4d9d-a4fe-586cc7878c7d

-Merge queries (Power Query)

https://support.microsoft.com/en-us/office/merge-queries-power-query-fd157620-5470-4c0f-b132-7ca2616d17f9

-Append queries (Power Query)

https://support.microsoft.com/en-us/office/append-queries-power-query-e42ca582-4f62-4a43-b37f-99e2b2a4813a

-create a query that imports data from a web page

https://support.microsoft.com/en-us/office/power-query-101-008b3f46-5b14-4f8b-9a07-d3da689091b5

Share This

Facebook

Twitter

Google+

LinkedIn

Related Posts