Skip to content

Scripts for automating data extraction, transformation, and loading (ETL) tasks in Microsoft Excel and Power BI. These scripts simplify data manipulation and enhance productivity and collaboration.

Notifications You must be signed in to change notification settings

jasonmoll/Power-Query-Automations

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

9 Commits
 
 
 
 

Repository files navigation

Power Query Automations

Introduction

This repository contains a collection of Power Query (M language) scripts designed to automate data importation, transformation, and processing tasks. These scripts are optimized for versatility across various data sources and structures, making it easier to handle tasks ranging from simple data cleaning to complex data integration.

Prerequisites

Before you can use these Power Query scripts, you need:

  • Microsoft Excel or Power BI Desktop.
  • Basic understanding of the M language and data transformation concepts.

Repository Structure

  • /Scripts - Contains all Power Query scripts.
  • /Examples - Example data files and usage examples for the scripts.
  • /Docs - Documentation for understanding and extending the scripts.

Usage

To use the scripts in this repository:

  1. Clone the Repository: Clone this repository to your local machine or download the scripts individually.
  2. Open Your Microsoft Application: Open your data project in either Microsoft Excel or Power BI Desktop.
  3. Import Scripts: Load the .pq script files into your project through the Advanced Editor in Power Query Editor.
  4. Configure Parameters: Adjust the parameters in each script according to your data source and specific needs.
  5. Refresh Data: Execute the queries to transform your data accordingly.

License

This project is licensed under the MIT License - see the LICENSE file for details.

Support

If you encounter any problems or have queries about the scripts, please raise an issue in the repository.

About

Scripts for automating data extraction, transformation, and loading (ETL) tasks in Microsoft Excel and Power BI. These scripts simplify data manipulation and enhance productivity and collaboration.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published