Custom Functions in Power Query

Develop best practices in connecting, combining and refining data sources to effectively provide automated and high-quality data for reporting and analysis.

1 hours
2 videos
3 exercises
55 xp

Let’s create your free account

OR

By continuing, you accept our Enterprise DNA Terms & Conditions , our Privacy & Cookie Policy and that your data is stored.

If you have an account Login here

Trusted by 220,000+ people worldwide.

coca-cola-logouniliver-logonhs-logonestle-logoatt-logoanglo-logomackinsey-logoalbemarle-logojonson-logopanasonic-logo

In this tutorial, we cover important features of Power Query, including how to search for data sources, connect them, and shape data to meet your Power BI needs. By using the techniques showcased in this course, you will be able to save time through automation of various task and perform various complex data cleansing activities. 

What our

Students Say
Curriculum
1

Custom Functions in Power Query


Your

Instructor
Empty image or helper icon

Melissa de Korte

Enterprise DNA Expert

  • Skilled in ETL and Modelling. Delivered practical Power Query solutions in both Excel and Power BI. 
  • Expertise in analysing business process data. Delivering, deploying and supporting Power BI solutions throughout the organisation. 
  • All-round Power platform enthusiast. 

Frequently Asked

Questions

Recommended

Courses
Course Cover: VBA Automation Techniques for Businesses
beginner
Total points: 200 XP 1 hours

VBA Automation Techniques for Businesses

EXPERIMENTAL: This course teaches valuable Microsoft VBA automation techniques that optimize business processes, leading to increased productivity and efficiency.
Tools
Excel
Skills
Process Automation
App Development
EDNA Experts
EDNA Experts
See details
Course Cover: SQL Fundamentals for Financial Analysis
beginner
Total points: 212 XP 1 hours

SQL Fundamentals for Financial Analysis

EXPERIMENTAL: A comprehensive course providing financial professionals with the fundamentals of SQL and its application in financial analysis.
Tools
SQL
Skills
Data Analysis
EDNA Experts
EDNA Experts
See details
Course Cover: Integration, Analytics, and Governance for MS Fabric
intermediate
Total points: 752 XP 7 hours

Integration, Analytics, and Governance for MS Fabric

Advance your data strategy with Microsoft Fabric and Azure. Discover how to optimize workspaces, develop effective pipelines, and manage data flows for enhanced security and governance.
Tools
Other Tools
Henry Habib
Henry Habib
See details

Get full access to unparalleled

training & skill-building resources
power-bi-custom-visuals

FOR INDIVIDUALS

Enterprise DNA

For Individuals

Empowering the most valuable data analysts to expand their analytical thinking and insight generation possibilities.

Learn More

FOR BUSINESS

Enterprise DNA

For Business

Training, tools, and guidance to unify and upskill the data analysts in your workplace.

Learn More
power-bi-custom-visuals