PowerQuery course

PowerQuery course will help you make data manipulations faster than ever!

Course goals

Introduce the participants with the advanced options of the PowerQuery ETL (extract, transform, load) tool. PowerQuery is a standard tool for ETL which comes already installed with the Excel 2016 version. PowerQuery is also a part of the PowerBI tool.

Participants

This course is intended for all the participants who often have to process unstructured data from various different sources (.txt, .csv, Excel, web, SQL databases, etc.), and in that process, they need to refresh, filter, clean or change the structure of the data.

Notes

Course can be lectured through PowerBI or Excel interface. In case of using Excel option, participants need to have at least Excel 2016 installed or PowerQuery add-on in case of prior versions. It is advisable to use Excel 365 if possible.

Course content

• What is PowerQuery, the idea behind it and why to use it for data preparations?
• PowerBI desktop basics
• PowerBI web service basics

• Web
• Excel files
• CSV/Text files
• Folder
• Database (SQL)

• Appending Queries
• Merging Queries
• Query dependency view

• Data types
• Column operations - Splitting, Merging, Rearranging, Removing, Adding, Conditional columns
• Column transformations – Cleaning, Remove/Replace values or errors, Fill Down/Up…
• Filtering - Text filters, Numeric filters, Sorting
• Pivot vs Unpivot data
• Group By

• M language basics
• Structure of M language
• Parameters
• Creating functions
• Combining it all together

For more guidance about general course structures and ways of course handling please follow this link.

Course information
Course duration

8h

Course difficulty
basic to intermediate
Minimal attendees

3

Maximal attendees

25

Price per attendee (netto) *

230,00 €

Course first time held:
2017.

*Additional discount is offered for each new attendee. If you have more attendees to apply for the course, or you would like to combine multiple courses, please contact us through the form below. Based on your inquiry, we will send you a more personalized offer.

Lecturer

Krešimir Ledinski

More than 6 years of experience with PowerBI
Holds Microsoft MCSA Certificate in the field of BI reporting.
Learn more about Krešimir

Get a special quote for your group

By submitting a form you accept Exceed's Privacy Policy
+
GENERATED REPORTS
+
WORKSHOPS
+
YEARS OF EXPERIENCE
+
SATISFIED CLIENTS
Scroll to Top