Stepping beyond the Power Query User Interface

Stepping beyond the Power Query User Interface

Power Query is a Microsoft ETL tool for data transformation and data preparation. It is available in Excel, Power BI and other Microsoft products and provides the ability to connect to data sources, transform the data into correct structures and then load the data into the data model. This tool is a great improvement for the data analytics process because it gives a faster and easier approach to solve major business problems associated with messed data structures.

This course is for Power Query users that are interested in improving their knowledge about Power Query and the M Language. It starts with the basics of Power Query and soon upgrades to the advanced level of M scripting. It is ideal for those who want to understand the range of abilities of Power Query and learn how to use the most powerful data transformation tool. The course is a quick way to learn the main concepts of Power Query from novice to expert. As soon as you finish the course you will be familiar with the Power Query interface and feel comfortable using it. You will also get the advanced knowledge of the M Language that is the programming language of Power Query and you will be able to read it, write it or understand it.

If you need more assistance in training, feel free to check our website at exceed hr or our youtube channel Exceed Learning !

Become an advanced data analyst! Learn more about Power Query (including M) and take your knowledge to the next level!

Url: View Details

What you will learn

• Clear understanding when and where to use Power Query.
• How to clean and transform the most known types of data sources, accompanied by comprehending the logic behind connecting to any data source.
• Lots of simple and useful tricks to speed up data preparation.

Rating: 4.41667

Level: Intermediate Level

Duration: 8 hours

Instructor: Krešimir Ledinski