Fundamentals of Power Query
Learn how to extract and transform data using Power Query for Microsoft Excel with this free online course.Publisher: Jordan Goldmeier
CertificazioneView course modules
Are you tired of spending all day sorting through a huge number of worksheets to organize a significant amount of data? Would you prefer a superpower to make your job easier? You are in the right place if you have said yes to these two questions. This advanced Microsoft Excel course takes you through how Power Query, like Power Pivot and Power View, is part of the Power BI Suite. It begins by explaining the data manipulation techniques and the methods of fixing specific problems in the query table, such as changing the headers' names, filtering out null values, condensing three columns into one, removing a column, and saving the new file.
The next section of this Power BI training discusses the concept of M code and many Power Query features with their functionality, including Choose Column, Keep Rows, Remove Alternate Rows, Split Column, Merge Queries, Transform, Move, Format and others. Efficiency is crucial when working with large amounts of complex data and using some shorthand tips and codes included in the course instead of the usual tabs will allow you to speed up your work. Continuing with the efficiency theme, you will be taught how to quickly and easily know which functions to use without writing any code by using the Column from Example feature and the steps to give feedback to Microsoft about a range of topics.
The final part of the Power BI certification explains the details of merging data from multiple tables with different formats into a single sheet. The course discusses different files from external sources and how to import them into Power Query. Your learning concludes by comprehensively covering the procedure for constructing a relationship between two tables so that you can look up data and get matching results as well as how to combine multiple data from the same folder. This Power BI tutorial is perfect for anyone working with large sets of data in data science, data analytics or engineering and need to combine, interpret or process the data in different ways. What would usually take hours to do manually will take you no time by unlocking the features of Power BI’s Power Query function. Enrol in this in-depth course and discover the many dynamic data transformation tools in one convenient location.Inizio Corso Ora
By the end of this course, you will be able to:
- Discuss the history of the Microsoft Excel Power Query tool
- Explain the process of manipulating data with Power Query in Excel
- Summarize the steps for wrangling data to solve various problems
- Define the concept of M code
- Indicate the process of locating the M code
- Outline the Power Query features and items
- List the stages involved in merging several datasets from various systems
- Describe how to change the sample file
- Summarize the process of combining data from other folders
All Alison courses are free to study. To successfully complete a course you must score 80% or higher in each course assessments. Upon successful completion of a course, you can choose to make your achievement formal by purchasing an official Alison Diploma, Certificate or PDF.
Having an official Alison document is a great way to celebrate and share your success. It is:
- Ideal to include with CVs, job applications and portfolios
- A way to show your ability to learn and achieve high results