Rating 4.45 out of 5 (20 ratings in Udemy)
What you'll 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.
- How to combine multiple data sources into a single solution (both with merging or appending tables)
- Understanding of M language and its most important building blocks …
Rating 4.45 out of 5 (20 ratings in Udemy)
What you'll 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.
- How to combine multiple data sources into a single solution (both with merging or appending tables)
- Understanding of M language and its most important building blocks (queries, parameters, functions)
- Techniques to utilize functions that can transform and clean hundreds of different sources, no matter how dirty the source data is.
DescriptionPower 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.
