Power BI Free Training (Power Query for Beginners) Class - 1

Basics of Power Query

In this class, we will learn how to extract data from various sources such as Excel, Text/CSV,  PDF, SQL Server, MS access and from the Web and  apply some basic Column and Row cleaning

Please Note Kindly Login to your laptop with Power BI, If you have not it. (Click Here to Download)  from Microsoft site it is freely available unlike Excel.

Extract, Pull or Connect to Data Source

This process is the first footsteps, it is a very easy procedure to connect data in Power Query. Just click to a new data source in Power Query. See images below

Power query saves the data source as a Query or Command (M language). we can extract more than one query in a report no matter whatever base source is.
and later we can append merge or combine it for desired results.

Combine File Query

Merge (Similar to Joins)

• Merge Query
• Merge Query as New

Append (Similar to Union)

• Append Query
• Append Query as New

Query Type

• Query as REFERENCE
• Query as Duplicate

Transform Data

Manage Column

• Work with column
• Add Column
• Remove Columns
• Concept of other columns

Working on Data Types

• Text (when no need to calculate)
• Number (calculation needed)
• Date 
• etc.

If you are not registered with us Click here to Register (FREE). Training link will be sent to registered mail Id with us