Login

**Farid** · 07-05-2023, 12:52 PM

Published 11/2022| Video: h264, 1280x720 | Audio: AAC, 44.1 KHz Language: English | Size: 8.90 GB | Duration: 17h 52m

Most complete and comprehensive course in Power Query and M Language with hands on exercises and demos step-by-step.

What you'll learn
Understand Power Query and its components
Understand power query to connect and explore your data
How to Explore reshape and enrich your data
How to create calculated columns
How to Shape or transform data to match your data analysis requirements
How to Refresh a query to import the latest data into a table
How to Combine data from multiple data sources
How to Filter a table based on size, value, or condition
How to Sort a table ranked by a criteria, such as the alphabetical or numerical value of one or multiple columns, and by ascending or descending order.
How to Group rows in a table
How to Expand/Extend a column
How to Aggregate data from a column by group operation, including Sum, Count, Average, Min, and Max
How to Insert a custom column into a table - Insert an Index or Custom column
How to Combine multiple queries by merging or appending them
There is no coding required! Power Query allows you to do that but it's not necessary
Build complex and custom transformation
Write M code to add/delete/transform custom columns
Implement Best practice in Power Query and M language
Explore how the M language can be used to write your own customized solutions
Use custom functions to extend and enhance Power Query
Create your own formulas and functions to go beyond simple data imports
Gain effiiciency by reducing the time it takes to prepare data for analysis, and make informed decisions more quickly
Gain productivity by properly preparing data yourself, rather than relying on others to do it

Requirements
Microsoft Power BI Desktop (free download)
This course is designed for PC/Windows users (currently not available for Mac)
Your willingness to learn and grow
This is a Power Query and M Language Training for beginners to advanced

Description
Companies are gathering more and more data everyday. Skills in data analysis, business intelligence / business analytics are highly in demand in today's job market. Microsoft Power BI is an advanced yet easy to use self service Business Intelligence / business analytics tool for that. It is same business intelligence. tools used by professional analysts and data scientists. Therefore they rely heavily on data. Data driven decision making is the key to success for any business in the world of tomorrow.Imagine how much power you when you know how to clean big data. Microsoft included power query and M language Engine virtually in every data product. You will be very surprised that you did not learn this earlier.One of the advantages of technology and having the skill is the opportunity it offers to scale your business and career. To be more productive, you need to work smarter. With low-code/no-code tools Microsoft Power Query and M Language, you can extract data from different sources, clean, reshape, remove, prepare, generate new data mashup, append and merge data .This is the most comprehensive and complete course in power query. We are going to cover over hundreds of data transformations in this course. We are covering Power Query in depth in this course does. Absolutely no experience required in Power Query or M Language. We will start from the basics and gradually build up your knowledge. I will introduce you to some great features of Power query and M Language with hands on demos. after completing this course you be able to transform you data like DBAs and ETL Developers.You do not have to learn R or python anymore. I am going to teach you to become data scientist just learn power query and M because you already know how to clean data. You can follow along with the provided learning material on your own computer at your own pace. I will basically hold your hand and teach you everything step-by-step.Understand Power Query and its componentsUnderstand power query to connect and explore your dataHow to explore, reshape and enrich your dataHow to create calculated columnsHow to shape or transform data to match your data analysis requirements.How to refresh a query to import the latest data into a tableHow to combine data from multiple data sourcesHow to filter a table based on size, value, or condition.How to sort a table ranked by a criteria, such as the alphabetical or numerical value of one or multiple columns, and by ascending or descending order.How to group rows in a tableHow to expand/extend a columnHow to aggregate data from a column by group operation, including sum, count, average, min, and max.How to Insert a custom column into a table - Insert an Index or custom columnHow to Combine multiple queries by merging or appending them.There is no coding required! Power Query allows you to do that but it's not necessary.Build complex and custom transformationWrite M code to add/delete/transform custom columnsImplement best practice in Power Query and M languageThis Course Also Comes With:Lifetime access to all future updatesFast & friendly support in the Q&A sectionCustom notes, homework exercises, checklists, templates, course quizzes to help get results fasterUdemy certificate of completion ready for downloadA 30 days "no questions asked" money back guarantee!