Power Query – Introduction - Revision history

Gpruszczynski1: /* Additional Exercise: Explore Other Data Sources */

2025-06-22T08:43:55Z

Additional Exercise: Explore Other Data Sources

← Older revision		Revision as of 08:43, 22 June 2025
Line 41:		Line 41:
	# Browse the full list: try connecting to:		# Browse the full list: try connecting to:
	#* Web (https://en.wikipedia.org/wiki/List_of_countries_and_dependencies_by_population)		#* Web (https://en.wikipedia.org/wiki/List_of_countries_and_dependencies_by_population)
	#* Blank Query		#* Blank Query \| Get Data → From Other Sources
	#* Recent Sources		#* Recent Sources
	# Discuss which sources may be useful in your work.		# Discuss which sources may be useful in your work.

Gpruszczynski1: /* Additional Exercise: Explore Other Data Sources */

2025-06-22T08:40:51Z

Additional Exercise: Explore Other Data Sources

← Older revision		Revision as of 08:40, 22 June 2025
Line 40:		Line 40:
	# In Excel → Data tab → '''Get Data'''		# In Excel → Data tab → '''Get Data'''
	# Browse the full list: try connecting to:		# Browse the full list: try connecting to:
	#* Web (~~you can cancel the prompt~~)		#* Web (https://en.wikipedia.org/wiki/List_of_countries_and_dependencies_by_population)
	#* Blank Query		#* Blank Query
	#* Recent Sources		#* Recent Sources

Gpruszczynski1 at 09:23, 19 June 2025

2025-06-19T09:23:26Z

← Older revision		Revision as of 09:23, 19 June 2025
Line 1:		Line 1:
	= Module 1: Introduction to Power Query =		= Module 1: Introduction to Power Query =

			== Objective ==
			Get familiar with the Power Query interface and understand what it can do.

			== Files Used ==
			* [[Media:Sales_January.xlsx\|Download Sales_January.xlsx]]

	== What is Power Query? ==		== What is Power Query? ==
Line 6:		Line 12:

	You can find Power Query in Excel 2016 and later, under the '''Data''' tab in the section called '''Get & Transform Data'''.		You can find Power Query in Excel 2016 and later, under the '''Data''' tab in the section called '''Get & Transform Data'''.

	~~== Why Use Power Query? ==~~
	* Automates repetitive data-cleaning tasks
	* Simplifies combining data from various sources
	* Eliminates the need for manual copy-pasting or complex formulas
	* Keeps a full record of all applied steps for transparency and easy modification

	== Where to Find It ==		== Where to Find It ==
	* 1. Open Microsoft Excel		'''Steps:'''
	* 2. Go to the '''Data''' tab		# Open Microsoft Excel
	* 3. Locate the '''Get & Transform Data''' group		# Go to the '''Data''' tab
	* 4. Click '''Get Data''' to begin importing		# Locate the '''Get & Transform Data''' group
			# Click '''Get Data''' to begin importing

	== Hands-on Exercise ==		== Hands-on Exercise: Opening Power Query ==
	'''Goal:''' Open Power Query Editor and explore its interface.		'''Goal:''' Open Power Query Editor and explore its interface.

	~~'''File needed:''' [[Media:Sales_January.xlsx\|Download Sales_January.xlsx]]~~

	'''Steps:'''		'''Steps:'''
	# ~~Open Excel and create~~ a new ~~blank~~ workbook		# Create a new Excel workbook
	# Go to the '''Data''' tab → '''Get Data''' → '''From File''' → '''From Workbook...'''		# Go to the '''Data''' tab → '''Get Data''' → '''From File''' → '''From Workbook...'''
	# Select the file ''Sales_January.xlsx'' and click ''Import''		# Select the file '''Sales_January.xlsx''' and click '''Import'''
	# In the Navigator window, select the worksheet and click '''Transform Data'''		# In the Navigator window, select the worksheet and click '''Transform Data'''
	# ~~The~~ Power Query Editor ~~will open~~		# In the Power Query Editor, explore:
	~~# Review the following interface components~~:		#* '''Query Pane''' – on the left, showing query name
	#* Query Pane (left~~): shows loaded queries (e.g.~~, ~~Sales_January)~~		#* '''Preview Grid''' – data preview in the middle
	#* Data Preview (center): preview ~~of your data table~~		#* '''Applied Steps''' – list of transformations on the right
	#* Applied Steps (right): list of transformations ~~applied to~~ the ~~data~~		#* '''Ribbon Tabs''' – Home, Transform, Add Column, View
	#* Ribbon Tabs: Home, Transform, Add Column, View

	== ~~Key Concepts~~ ==		== Additional Exercise: Explore Other Data Sources ==
	* '''~~Query~~:''' ~~A set of steps used to load and transform~~ data		'''Goal:''' Explore available data sources and create dummy connections.
	* '''Applied Steps:''' Each operation is recorded and ~~can be edited or deleted~~
	* '''Load vs. ~~Transform:''' You can either load data directly or open the editor to make changes first~~

			'''Steps:'''
			# In Excel → Data tab → '''Get Data'''
			# Browse the full list: try connecting to:
			#* Web (you can cancel the prompt)
			#* Blank Query
			#* Recent Sources
			# Discuss which sources may be useful in your work.

			== Extension: Enable and Explore Formula Bar ==
			Power Query has a powerful formula language (M). Let’s enable the formula bar.

			'''Steps:'''
			# In Power Query Editor, go to the '''View''' tab
			# Tick the checkbox for '''Formula Bar'''
			# Select a step in the Applied Steps list
			# Observe the M code being generated
			# Try editing a step manually (e.g., changing a column name)

	----		----


	Return to [[Power_Query_–_Basic\|Main Page]]		Return to [[Power_Query_–_Basic\|Main Page]]

Gpruszczynski1 at 17:51, 18 June 2025

2025-06-18T17:51:12Z

← Older revision		Revision as of 17:51, 18 June 2025
Line 48:		Line 48:

	→ Continue to [[Power Query – Importing and Managing Data\|Module 2: Importing and Managing Data]].		→ Continue to [[Power Query – Importing and Managing Data\|Module 2: Importing and Managing Data]].

			* [[Power Query – Introduction\|Module 1: Introduction to Power Query]]
			* [[Power Query – Importing and Managing Data\|Module 2: Importing and Managing Data]]
			* [[Power Query – Data Transformation\|Module 3: Data Transformation Techniques]]
			* [[Power Query – Automation and Parameters\|Module 4: Automation and Parameters]]
			* [[Power Query – Power Pivot Overview\|Module 5: Power Pivot Overview]]
			* [[Power Query – Summary and Exercises\|Module 6: Summary and Final Exercises]]

Gpruszczynski1 at 17:47, 18 June 2025

2025-06-18T17:47:34Z

← Older revision		Revision as of 17:47, 18 June 2025
Line 47:		Line 47:
	Return to [[Power_Query_–_Basic\|Main Page]]		Return to [[Power_Query_–_Basic\|Main Page]]

	→ Continue to [[Power Query – Importing Data\|Module 2: Importing and Managing Data]]		→ Continue to [[Power Query – Importing and Managing Data\|Module 2: Importing and Managing Data]].

Gpruszczynski1 at 17:46, 18 June 2025

2025-06-18T17:46:27Z

← Older revision		Revision as of 17:46, 18 June 2025
Line 45:		Line 45:
	----		----

	Return to [[~~Power Query – Basic Level~~\|Main Page]]		Return to [[Power_Query_–_Basic\|Main Page]]

	→ Continue to [[Power Query – Importing Data\|Module 2: Importing and Managing Data]]		→ Continue to [[Power Query – Importing Data\|Module 2: Importing and Managing Data]]

Gpruszczynski1 at 17:42, 18 June 2025

2025-06-18T17:42:54Z

← Older revision		Revision as of 17:42, 18 June 2025
Line 43:		Line 43:


	→ ~~Ready for real data work?~~ Continue to [[Power Query – Importing ~~and Managing~~ Data\|Module 2: Importing and Managing Data]].		----

			Return to [[Power Query – Basic Level\|Main Page]]

			→ Continue to [[Power Query – Importing Data\|Module 2: Importing and Managing Data]]

Gpruszczynski1: /* Where to Find It */

2025-06-18T17:37:14Z

Where to Find It

← Older revision		Revision as of 17:37, 18 June 2025
Line 14:		Line 14:

	== Where to Find It ==		== Where to Find It ==
	1. Open Microsoft Excel		* 1. Open Microsoft Excel
	2. Go to the '''Data''' tab		* 2. Go to the '''Data''' tab
	3. Locate the '''Get & Transform Data''' group		* 3. Locate the '''Get & Transform Data''' group
	4. Click '''Get Data''' to begin importing		* 4. Click '''Get Data''' to begin importing

	== Hands-on Exercise ==		== Hands-on Exercise ==

Gpruszczynski1 at 17:36, 18 June 2025

2025-06-18T17:36:33Z

← Older revision		Revision as of 17:36, 18 June 2025
Line 2:		Line 2:

	== What is Power Query? ==		== What is Power Query? ==
	Power Query is a data connection ~~technology that enables~~ you to ~~discover~~, ~~connect~~, ~~combine~~, and ~~refine~~ data ~~across a wide variety of~~ sources. ~~It is built into~~ Excel ~~(from version~~ 2016 ~~onward)~~ and ~~can be accessed through~~ the Data tab ~~under~~ the Get & Transform Data section.		Power Query is a data connection and transformation tool built into Microsoft Excel.
			It allows you to import, clean, reshape, and combine data from multiple sources.

			You can find Power Query in Excel 2016 and later, under the '''Data''' tab in the section called '''Get & Transform Data'''.

	== Why Use Power Query? ==		== Why Use Power Query? ==
	* Automates repetitive data-cleaning tasks		* Automates repetitive data-cleaning tasks
	* Simplifies combining data from ~~multiple~~ sources		* Simplifies combining data from various sources
	* ~~Reduces~~ the need for manual ~~formulas and~~ copy-pasting		* Eliminates the need for manual copy-pasting or complex formulas
	* ~~Improves reliability and traceability~~ of ~~data transformations~~		* Keeps a full record of all applied steps for transparency and easy modification

	~~== Real-World Examples ==~~
	* Importing monthly sales reports from multiple Excel files and combining them
	* Cleaning survey data by removing duplicates and ~~formatting columns~~
	* Merging customer data from a CSV file with transaction data from a database

	~~== How to Access Power Query in Excel ==~~
	~~1. Open Microsoft Excel.~~
	~~2. Go to the Data tab.~~
	~~3. Locate the Get & Transform Data section.~~

	~~From here, you can:~~		== Where to Find It ==
	* Import data from Excel~~, web, databases, and other formats~~.		1. Open Microsoft Excel
	* Launch the ~~Power Query Editor~~ to ~~shape your data.~~		2. Go to the '''Data''' tab
			3. Locate the '''Get & Transform Data''' group
			4. Click '''Get Data''' to begin importing

	== Hands-on Exercise ==		== Hands-on Exercise ==
	'''Goal:''' Open Power Query Editor and explore its interface.		'''Goal:''' Open Power Query Editor and explore its interface.

			'''File needed:''' [[Media:Sales_January.xlsx\|Download Sales_January.xlsx]]

	'''Steps:'''		'''Steps:'''
	# Open Excel and create a new blank workbook.		# Open Excel and create a new blank workbook
	# Go to the ''Data'' tab ~~and click on~~ ''Get Data > From Workbook''.		# Go to the '''Data''' tab → '''Get Data''' → '''From File''' → '''From Workbook...'''
	# Select ~~any Excel~~ file and ~~load a sheet with data.~~		# Select the file ''Sales_January.xlsx'' and click ''Import''
	# In the Navigator window, click ~~“Transform Data”.~~		# In the Navigator window, select the worksheet and click '''Transform Data'''
	# ~~Explore the~~ Power Query Editor ~~window – look at~~ the applied ~~steps~~, ~~preview area~~, and ~~ribbon~~.		# The Power Query Editor will open
			# Review the following interface components:
			#* Query Pane (left): shows loaded queries (e.g., Sales_January)
			#* Data Preview (center): preview of your data table
			#* Applied Steps (right): list of transformations applied to the data
			#* Ribbon Tabs: Home, Transform, Add Column, View

			== Key Concepts ==
			* '''Query:''' A set of steps used to load and transform data
			* '''Applied Steps:''' Each operation is recorded and can be edited or deleted
			* '''Load vs. Transform:''' You can either load data directly or open the editor to make changes first


	~~== Key Terms ==~~
	* '''Query''' – A set of steps that transform your data
	* '''Applied Steps''' – The list of transformations done on the data
	* '''Data Source''' – Where the original data comes from (Excel file, database, etc.)

	~~== Recap ==~~		→ Ready for real data work? Continue to [[Power Query – Importing and Managing Data\|Module 2: Importing and Managing Data]].
	~~In this module, you learned what~~ Power Query ~~is, how to access it,~~ and ~~why it's useful for data preparation~~ and ~~automation~~.

Gpruszczynski1: Created page with "= Module 1: Introduction to Power Query = == What is Power Query? == Power Query is a data connection technology that enables you to discover, connect, combine, and refine data across a wide variety of sources. It is built into Excel (from version 2016 onward) and can be accessed through the Data tab under the Get & Transform Data section. == Why Use Power Query? == * Automates repetitive data-cleaning tasks * Simplifies combining data from multiple sources * R..."

2025-06-18T17:02:23Z

Created page with "= Module 1: Introduction to Power Query = == What is Power Query? == Power Query is a data connection technology that enables you to discover, connect, combine, and refine data across a wide variety of sources. It is built into Excel (from version 2016 onward) and can be accessed through the **Data** tab under the **Get & Transform Data** section. == Why Use Power Query? == * Automates repetitive data-cleaning tasks * Simplifies combining data from multiple sources * R..."

New page

= Module 1: Introduction to Power Query =

== What is Power Query? ==
Power Query is a data connection technology that enables you to discover, connect, combine, and refine data across a wide variety of sources. It is built into Excel (from version 2016 onward) and can be accessed through the **Data** tab under the **Get & Transform Data** section.

== Why Use Power Query? ==
* Automates repetitive data-cleaning tasks
* Simplifies combining data from multiple sources
* Reduces the need for manual formulas and copy-pasting
* Improves reliability and traceability of data transformations

== Real-World Examples ==
* Importing monthly sales reports from multiple Excel files and combining them
* Cleaning survey data by removing duplicates and formatting columns
* Merging customer data from a CSV file with transaction data from a database

== How to Access Power Query in Excel ==
1. Open Microsoft Excel.
2. Go to the **Data** tab.
3. Locate the **Get & Transform Data** section.

From here, you can:
* Import data from Excel, web, databases, and other formats.
* Launch the **Power Query Editor** to shape your data.

== Hands-on Exercise ==
'''Goal:''' Open Power Query Editor and explore its interface.

'''Steps:'''
# Open Excel and create a new blank workbook.
# Go to the ''Data'' tab and click on ''Get Data > From Workbook''.
# Select any Excel file and load a sheet with data.
# In the Navigator window, click “Transform Data”.
# Explore the Power Query Editor window – look at the applied steps, preview area, and ribbon.

== Key Terms ==
* '''Query''' – A set of steps that transform your data
* '''Applied Steps''' – The list of transformations done on the data
* '''Data Source''' – Where the original data comes from (Excel file, database, etc.)

== Recap ==
In this module, you learned what Power Query is, how to access it, and why it's useful for data preparation and automation.

← Older revision		Revision as of 17:51, 18 June 2025
Line 48:		Line 48:

	→ Continue to [[Power Query – Importing and Managing Data\|Module 2: Importing and Managing Data]].		→ Continue to [[Power Query – Importing and Managing Data\|Module 2: Importing and Managing Data]].

			* [[Power Query – Introduction\|Module 1: Introduction to Power Query]]
			* [[Power Query – Importing and Managing Data\|Module 2: Importing and Managing Data]]
			* [[Power Query – Data Transformation\|Module 3: Data Transformation Techniques]]
			* [[Power Query – Automation and Parameters\|Module 4: Automation and Parameters]]
			* [[Power Query – Power Pivot Overview\|Module 5: Power Pivot Overview]]
			* [[Power Query – Summary and Exercises\|Module 6: Summary and Final Exercises]]