Training
Duration: Mar 18 - Mar 21 (4 Days)
Time: 6:30 - 8:30 p.m (Myanmar Standard Time)
Place: Google Meet (Code will send to your email)
Language: Burmese (Myanmar)
Fees: Free of Charge
...................................
Registration:
https://forms.office.com/r/KQWYRzU9rm
Download Power BI Desktop:
Download Power BI Desktop from Official Microsoft Download Center
#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
Tutorial>>To Explain in the Training
-Where is Power Query (Create an advanced query (Power Query))
-Shape data (Power Query)
-Combine data from multiple data sources (Power Query)
-Merge queries (Power Query)
-Append queries (Power Query)
-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